<!-- 批量更新购物车中商品购买数量 -->
<update id="updateShoppingCartCount" parameterType="list">
update tbl_shopping_cart
<trim prefix="set" suffixOverrides=",">
<trim prefix="purchaseCount =case" suffix="end,">
<foreach collection="list" item="i" index="index">
<if test="i.purchaseCount!=null">
when id=#{i.id} then #{i.purchaseCount}
</if>
</foreach>
</trim>
</trim>
where
<foreach collection="list" separator="or" item="i" index="index" >
id=#{i.id}
</foreach>
and status = "0"
</update>
从下面这篇文章学习到的: