基于Mybatis和MySQL的批量更新操作

最新推荐文章于 2025-08-07 16:49:30 发布

原创最新推荐文章于 2025-08-07 16:49:30 发布 · 222 阅读

CC 4.0 BY-SA版权

本文详细介绍了如何在Mybatis框架下实现与MySQL数据库的批量更新操作，通过实例代码展示了具体的步骤和注意事项，帮助开发者提升数据库操作效率。

@Mapper
public interface BaseInfoMapper extends BaseMapper<BaseInfo> {
    int updateBatch(@Param("list") List<BaseInfo> list);
}

<update id="updateBatch">
    update base_info
    <trim prefix="set" suffixOverrides=",">
      <trim prefix="location_code = case " suffix="end,">
        <foreach collection="list" item="i" index="index">
          <if test="i.locationCode != null">
            when id = #{i.id}
            then #{i.locationCode}
          </if>
        </foreach>
      </trim>
      <trim prefix="org_full_name = case " suffix="end,">
        <foreach collection="list" item="i" index="index">
          <if test="i.orgFullName != null">
            when id = #{i.id}
            then #{i.orgFullName}
          </if>
        </foreach>
      </trim>
      <trim prefix="org_short_name = case " suffix="end,">
        <foreach collection="list" item="i" index="index">
          <if test="i.orgShortName != null">
            when id = #{i.id}
            then #{i.orgShortName}
          </if>
        </foreach>
      </trim>
      <trim prefix="shop_status = case " suffix="end,">
        <foreach collection="list" item="i" index="index">
          <if test="i.shopStatus != null">
            when id = #{i.id}
            then #{i.shopStatus}
          </if>
        </foreach>
      </trim>
    where id in
    <foreach collection="list" item="i" open="(" separator="," close=")" index="index" >
      #{i.id}
    </foreach>
  </update>