mybatis批量更新

最新推荐文章于 2024-08-20 21:03:21 发布

暗香浮动，月黑风高

最新推荐文章于 2024-08-20 21:03:21 发布

阅读量151

点赞数

分类专栏： mysql mybatis

本文链接：https://blog.csdn.net/xfy18317776108/article/details/87978007

版权

mysql 同时被 2 个专栏收录

18 篇文章 0 订阅

订阅专栏

mybatis

6 篇文章 0 订阅

订阅专栏

跨表更新，但是是根据主表的参数条件更新子表信息，两表关系是一对多

<update id="editAllRecord" parameterType="java.util.List">
  update operator_record oe
  LEFT JOIN device_record dr ON dr.record_id = oe.record_id and dr.function_type = 1
  <trim prefix="set" suffixOverrides=",">

    <trim prefix="operator_record =case" suffix="end,">
      <foreach collection="list" item="cs" index="index">
        <if test="cs.pictureUrl !=null and !cs.pictureUrl.equals('') ">
          when dr.fingerprint_id = #{cs.fingerprintId} AND dr.operator_id = #{cs.operatorId} and dr.device_id  = #{cs.deviceId} and dr.function_type = 1 then  #{cs.pictureUrl,jdbcType=VARCHAR}
        </if>
      </foreach>
    </trim>

  </trim>
  where
  oe.operator_type = 1 and
  dr.record_id in
  <foreach collection="list" index="index" item="cs" separator="),(" open="((" close="))">
      SELECT record_id FROM device_record WHERE fingerprint_id =#{cs.fingerprintId}
    AND operator_id = #{cs.operatorId} and device_id = #{cs.deviceId} and function_type = 1
  </foreach>
</update>