Mybatis学习--批量update语句

<!-- 批量更新购物车中商品购买数量 --><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>

从下面这篇文章学习到的:

点击打开链接