mybatis 批量更新多个属性

最新推荐文章于 2025-09-15 03:45:15 发布

原创最新推荐文章于 2025-09-15 03:45:15 发布 · 1.2k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis 批量更新

mybatis 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一种使用MyBatis批量更新物流记录状态和追踪信息的方法，通过传递物流记录列表，可以高效地更新数据库中对应的记录状态和物流详情。

/**
 * 批量修改物流状态和物流踪迹
 *
 * @param recordList List
 * @return Integer
 */
Integer updateStatusBatch(@Param("recordList") List<LogisticsRecordDO> recordList);



<update id="updateStatusBatch">
    UPDATE dm_logistics_record
    <trim prefix="set" suffixOverrides=",">
        <trim prefix="delivery_status =case" suffix="end,">
            <foreach collection="recordList" item="recordDo" index="index">
                <if test="recordDo.deliveryStatus!=null">
                    when record_Id=#{recordDo.recordId} then
                    #{recordDo.deliveryStatus}
                </if>
            </foreach>
        </trim>
        <trim prefix="trans_info =case" suffix="end,">
            <foreach collection="recordList" item="recordDo" index="index">
                <if test="recordDo.transInfo!=null">
                    when record_Id=#{recordDo.recordId} then #{recordDo.transInfo}
                </if>
            </foreach>
        </trim>
    </trim>
    where record_id in
    <foreach collection="recordList" item="recordDo" open="(" close=")"
             separator=",">
        #{recordDo.recordId, jdbcType=BIGINT}
    </foreach>
</update>