批量更新第一种方式
update IVMP_DEVICE_TYPE_AISLE set
AISLE_TYPE =
<foreach collection="list" index="index" item="item" open="case" close="end">
when AISLE_ID = #{item.aisleId,jdbcType=VARCHAR}
then #{item.aisleType,jdbcType=VARCHAR}
</foreach>
where AISLE_ID in
<foreach collection="list" index="index" item="item" open="(" close=")" separator=",">
#{item.aisleId,jdbcType=VARCHAR}
</foreach>
批量更新第二种方式
<foreach collection="list" index="index" item="item" separator=";">
update IVMP_DEVICE_TYPE_AISLE
set
AISLE_TYPE=#{item.aisleType,jdbcType=VARCHAR}
where AISLE_ID=#{item.aisleId,jdbcType=VARCHAR}
</foreach>