mybaitis批量更新_mybaitis 批量更新 replay-CSDN博客

本文链接：https://blog.csdn.net/damoneric_guo/article/details/76144400

1、穿值list，批量处理

       UPDATE 表名
       <trim prefix="set" suffixOverrides=",">
           STATE=1,REPAY_STATE=3,--更新统一的数据
           <trim prefix="REPAY_DATE =case" suffix="end,">
               <foreach collection="list" item="i" index="index">
                   when IID=#{i.iid}
                   then #{i.repayDate}
               </foreach>
           </trim> --更新不同的数据
       </trim>
       WHERE
       <foreach collection="list" item="i" index="index" separator="or">
           IID=#{i.iid}
       </foreach>
   </update>

2、穿值map,批量处理

   Map<String, Object> map = new HashMap<String, Object>();
               map.put("lid", lid);
               map.put("list", list);

   <update id="updateB" parameterType="java.util.Map" >
       UPDATE 表名
          <trim prefix="set" suffixOverrides=",">

            <trim prefix="字段名 =case" suffix="end,">
            <foreach collection="list" item="item" index="index">
             when LID = #{lid} AND indexs = #{item.indexs}
             then #{item.shouldInterest}
            </foreach>
           </trim> --更新不同的数据
           <trim prefix="SHOULD_TIME =case" suffix="end,">
            <foreach collection="list" item="item" index="index">
             when LID = #{lid} AND indexs = #{item.indexs}
             then #{item.shouldTime}
            </foreach>
           </trim> --更新不同的数据
          </trim>
          where
          <foreach collection="list" item="item" index="index" separator="or">
               LID = #{lid} AND indexs = #{item.indexs}
          </foreach>
   </update>