在实际开发中,经常需要批量插入数据,常见的是使用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)){
}
}
}