Mybaits批量插入

原创已于 2025-09-12 16:11:33 修改 · 108 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #服务器 #linux

于 2025-09-12 14:26:31 首次发布

<update id="updateBatchSomeColumnById">
    UPDATE budget_plan_summary_editable
    SET
    amount = CASE id
    <foreach collection="list" item="item" separator=" ">
        WHEN #{item.id} THEN #{item.amount}
    </foreach>
    ELSE amount
    END
    WHERE id IN
    <foreach collection="list" item="item" open="(" separator="," close=")">
        #{item.id}
    </foreach>
</update>

    void insertBatchSomeColumn(List<BudgetPlanSummaryEditableEntity> addList) {
        if (CollUtil.isNotEmpty(addList)) {
            int batchSize = 30;
            for (int i = 0; i < addList.size(); i += batchSize) {
                int end = Math.min(i + batchSize, addList.size());
                List<BudgetPlanSummaryEditableEntity> batch = addList.subList(i, end);
                baseMapper.insertBatchSomeColumn(batch);
            }
        }
    }



package com.budget.common.mybatis.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import java.util.Collection;

public interface MyBaseMapper<T> extends BaseMapper<T> {
    int insertBatchSomeColumn(Collection<T> var1);
}

https://blog.youkuaiyun.com/java_beautiful/article/details/148691160