java实现批量插入数据代码示例

在实际开发中，经常需要批量插入数据，常见的是使用mybatis foreach 插入的方式，
1.常见的mybatis foreach

<insert id="insertBatch"  parameterType="java.util.List">
		insert into  CODEINFO (CODE_TYPE, CODE, MEAN, STATE, SORT_ID)
		values
		<foreach collection ="records" item="item" separator =",">
			(#{item.codeType}, #{item.code},
			 #{item.remark},  #{item.state}, #{item.sortId})
		</foreach >
	</insert>

2.类似的mapper方法

int insertBatch(@Param("records") List<MemberPrice> records);

3.业务层代码，数据组装

package com.atguigu.common.utils;

import com.atguigu.common.to.MemberPrice;
import org.springframework.util.CollectionUtils;

import java.util.List;

/**
 * @Author mischen
 * @Description java实现批量插入数据
 * @Date 2023/11/15 08:17
 * @Version 1.0
 */
public class BatchInsertDemo {

    public static void main(String[] args) {

    }

    public void addCouponCode(List<MemberPrice> lists){
        if (CollectionUtils.isEmpty(lists)) {
            return;
        }
        int numPerTimes = 500;
        if (lists.size() <= numPerTimes) {
            batchAdd(lists); //直接插入少于500条lists
        } else {
            //获取总数量
            int maxIndex = lists.size();
            //计算页数
            int maxTimes = maxIndex / numPerTimes;
            maxTimes += (maxIndex % numPerTimes) > 0 ? 1 : 0;
            int currentTimes = 0;
            while (currentTimes < maxTimes) {
                int fromIndex = numPerTimes * currentTimes;
                int toIndex = fromIndex + numPerTimes;
                toIndex = toIndex > maxIndex ? maxIndex : toIndex;
                List<MemberPrice> subList = lists.subList(fromIndex, toIndex);
                //这里是循环插入500条lists
                batchAdd(subList); //这里是去真正操作数据库的逻辑
                currentTimes++;
            }
        }
    }
    mybatis插入,可根据业务自行修改
    public void batchAdd(List<MemberPrice> lists) {
        if (CollectionUtils.isEmpty(lists)){

        }
    }

}