mybatis 批量修改

最新推荐文章于 2024-07-24 17:29:42 发布

虫二HLX

最新推荐文章于 2024-07-24 17:29:42 发布

阅读量537

点赞数 1

分类专栏：框架文章标签： mybatis 批量修改

本文链接：https://blog.csdn.net/HLX12345678/article/details/81190649

版权

框架专栏收录该内容

1 篇文章 0 订阅

订阅专栏

     <update id="updateKszdy" parameterType="com.jykj.yxxt.api.model.zsgl.importksxxb.Ksxxb">
    update t_ks_ksxxb
    set
    <foreach collection="list" item="item" index="index"
        separator=" " open="" close="">
        <if test="item.zdy1!=null">
        <if test="index == 0">
        zdy1 = case ksid
        </if>
        when #{item.ksid} then #{item.zdy1}
        <if test="index==list.size()-1">
        end
        </if>
        </if>
    </foreach>
    <foreach collection="list" item="item" index="index"
        separator=" " open="" close="">
         <if test="item.zdy1!=null and item.zdy2!=null">
         <if test="index == 0">
        ,zdy2= case ksid
        </if>
         when #{item.ksid} then #{item.zdy2}
        <if test="index==list.size()-1">
        end
        </if>
        </if>
         <if test="item.zdy1==null and item.zdy2!=null">
         <if test="index == 0">
        zdy2= case ksid
        </if>
         when #{item.ksid} then #{item.zdy2}
         <if test="index==list.size()-1">
         end
        </if>
        </if>
    </foreach>
    <foreach collection="list" item="item" index="index"
        separator=" " open="" close="">
         <if test="(item.zdy1!=null or item.zdy2!=null) and item.zdy3!=null">
          <if test="index == 0">
        ,zdy3= case ksid
        </if>
         when #{item.ksid} then #{item.zdy3}
        <if test="index==list.size()-1">
        end
        </if>
        </if>
        <if test="item.zdy1==null and item.zdy2==null and item.zdy3!=null">
        <if test="index == 0">
        zdy3= case ksid
        </if>
         when #{item.ksid} then #{item.zdy3}
       <if test="index==list.size()-1">
        end
        </if>
        </if>
    </foreach>
    where ksid in
    <foreach collection="list" index="index" item="item"
        separator="," open="(" close=")">
        #{item.ksid,jdbcType=BIGINT}
    </foreach>
</update>