批量更新实战 框架spring mybatis 和MySQL

批量更新

<!-- 批量更新购物车 -->

<update id="updateCartList" parameterType="java.util.List">
<!-- <foreach item="item" index="index" collection="list" separator=";"> -->
<!-- UPDATE cart -->
<!-- <set>count=#{item.count}</set> -->
<!-- <where>id=#{item.id} -->
<!-- </where> -->
<!-- </foreach> -->

<!-- 以上写法报错，换成下面的写法就OK了  -->
update cart set
count=
<foreach collection="list" item="item" index="index"
separator=" " open="case id" close="end">
when #{item.id}
then #{item.count}
</foreach>

where id in
<foreach collection="list" index="index" item="item"
separator="," open="(" close=")">
#{item.id}
</foreach>
</update>

有时需要添加URL配置：

url=jdbc:mysql://192.168.1.199:3306/temp?

useUnicode=true&amp;characterEncoding=utf-8&amp;allowMultiQueries=true