工具类
package com.yxsd.cnooc.data.common.util;
import java.util.ArrayList;
import java.util.List;
/**
* 数据库操作工具类
*/
public class SqlUtils {
/**
* 分段阈值
*/
private static final Integer SEGMENTED_THRESHOLD = 1000;
/**
* 单条数据记录数
*/
private static final Integer NUMBER_OF_SINGLE_RECORDS = 500;
/**
* 分段插入数据库
*/
public static <T> List<List<T>> segmentedInsert(List<T> tList) {
List<List<T>> result = new ArrayList<>();
if (tList.size() >= SEGMENTED_THRESHOLD) {
int times = (int) Math.ceil(tList.size() / NUMBER_OF_SINGLE_RECORDS.doubleValue());
for (int i = 0; i < times; i++) {
result.add(tList.subList(i * NUMBER_OF_SINGLE_RECORDS, Math.min((i + 1) * NUMBER_OF_SINGLE_RECORDS, tList.size())));
}
} else {
result.add(tList);
}
return result;
}
/**
* 自定义分段数量
*/
public static <T> List<List<T>> segmentedInsert(List<T> tList, Integer segments) {
List<List<T>> result = new ArrayList<>();
if (tList.size() >= SEGMENTED_THRESHOLD) {
int times = (int) Math.ceil(tList.size() / segments.doubleValue());
for (int i = 0; i < times; i++) {
result.add(tList.subList(i * segments, Math.min((i + 1) * segments, tList.size())));
}
} else {
result.add(tList);
}
return result;
}
}
使用
// 对list集合拆分 并插入数据库
List<List<Student>> lists = SqlUtils.segmentedInsert(pkList);
for (List<Student> listTemp : lists) {
studentMapper.saveStudentList(listTemp);
}