mybatis根据list查询，更新，删除

批量查询，根据list条件

<select id="queryStkbalseList" resultMap="BaseResultMapVO">
         select
        <include refid="Base_Column_List"/>
        from cc_stkbale stkbale
        <where>
            <foreach collection="stkbalseDTOS" item="record" separator=" or ">
                (stkbale.ORG_ID=#{record.orgId} and stkbale.MANAGER_NO=#{record.managerNo} and
                stkbale.BUNDLE_NO=#{record.bundleNo})
            </foreach>
        </where>
</select>

批量更新，id不同，值不同

<update id="updateXsSalesRemarkPriceByList" parameterType="java.util.List">
	<foreach collection="list" item="item" index="index" open="" close="" separator=";">
		UPDATE xs_sales_item
		<set>
			remark_price= #{item.remarkPrice,jdbcType=DECIMAL},
			price= #{item.price,jdbcType=DECIMAL}
		</set>
		<where>
			sales_item_no = #{item.salesItemNo,jdbcType=VARCHAR}
		</where>
	</foreach>
</update>

根据ids查询

<select id="querySaleItemDataByIds"
		resultType="com.mountslink.platform.components.sale.sale.vo.SalesExamRegisterVo">
	select
	price_tax as salePrice,
	cg_price as purchasePrice,
	sales_item_no as salesItemNo
	from xs_sales_item
	<where>
		id in
		<foreach collection="ids" item="id" separator="," open="(" close=")">
			#{id}
		</foreach>
		and status != '00'
	</where>
</select>

最后

以上就是整齐大雁为你收集整理的mybatis根据list查询，更新，删除的全部内容，希望文章能够帮你解决mybatis根据list查询，更新，删除所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。