转载自:https://blog.csdn.net/aklin47/article/details/81026930
<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>