批量更新
<!-- 批量更新购物车 -->
<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> -->
<!-- <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>
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&characterEncoding=utf-8&allowMultiQueries=true