mybatis多条件循环修改

Question

请问怎么让下面的修改语句连起来执行，或者说在mybatis里怎么根据多个条件的不同值循环修改表中的数据？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'

Answer 1

1. <update id="batchUpdate" parameterType="java.util.List">

2.     update demo_table

3.     set field1 =

4.     <foreach collection="list" item="item" open="case " close=" end">

5.     when field2 = #{item.value2} AND field3 = #{item.value3} then #{item.value1}

6.     </foreach>

7.     <where>

8.     <foreach collection="list" item="item" open="( " separator=") or (" close=" )">

9.     field2 = #{item.value2} AND field3 = #{item.value3}

10.     </foreach>

11.     </where>

12. </update>