請問怎么讓下面的修改語句連起來執(zhí)行，或者說在mybatis里怎么根據(jù)多個(gè)條件的不同值循環(huán)修改表中的數(shù)據(jù)？UPDATE erp_goods_stock_info ??? SET goods_num = goods_num - 2 ?? ?WHERE stock_key = 'SHK2kgdqJodlFGFNKgF' ?? ?AND goods_key = 'GDo1Xgageof3WPFyAg'?? ?UPDATE erp_goods_stock_info ??? SET ? goods_num = goods_num - 1 WHERE stock_key = 'SHK2kgdqJodlFGFNKgF' ? AND goods_key = 'GDTJDvqhfyElnJ5uzO'
2 回答
qq_大力_9
TA貢獻(xiàn)1條經(jīng)驗(yàn) 獲得超0個(gè)贊
<update id="batchUpdate" parameterType="java.util.List">
? ? update demo_table
? ? set field1 =
? ? <foreach collection="list" item="item" open="case " close=" end">
? ? when field2 = #{item.value2} AND field3 = #{item.value3} then #{item.value1}
? ? </foreach>
? ? <where>
? ? <foreach collection="list" item="item" open="( " separator=") or (" close=" )">
? ? field2 = #{item.value2} AND field3 = #{item.value3}
? ? </foreach>
? ? </where>
</update>
添加回答
舉報(bào)
0/150
提交
取消