在数据库批量保存大数组的时候,拼接的sql比较长,或者查找使用in的时候,需要把大数组拆分多个小数组,分批保存或拼接
核心方法:
/**
* 拆分大列表非多个小列表
* @param bigList 待拆分单的大对象列表
* @param subListSize 拆分的小列表长度
* @param <T> 返回类型
* @return
*/
public static <T> List<List<T>> splitBigList(List bigList,int subListSize){
assert Objects.nonNull(bigList):"待拆分的列表是null";
assert subListSize>0:"拆分的小列表长度必须大于0";
List<List<T>> splitList = new ArrayList<>();
int length = bigList.size();
int count = 1;
for (int i = 0; i < length; i += subListSize) {
int to = count*subListSize < length ? count*subListSize : length;
List<T> dataList = bigList.subList(i,to);
splitList.add(dataList);
count++;
}
return splitList;
}
完整使用示例:
public class Main {
class Item{
private String name;
private Integer age;
Item(){}
Item(String name,Integer age){
this.name = name;
this.age = age;
}
public String getName() {
return name;
}
public Integer getAge() {
return age;
}
}
/**
* 拆分大列表非多个小列表
* @param bigList 待拆分单的大对象列表
* @param subListSize 拆分的小列表长度
* @param <T> 返回类型
* @return
*/
public static <T> List<List<T>> splitBigList(List bigList,int subListSize){
assert Objects.nonNull(bigList):"待拆分的列表是null";
assert subListSize>0:"拆分的小列表长度必须大于0";
List<List<T>> splitList = new ArrayList<>();
int length = bigList.size();
int count = 1;
for (int i = 0; i < length; i += subListSize) {
int to = count*subListSize < length ? count*subListSize : length;
List<T> dataList = bigList.subList(i,to);
splitList.add(dataList);
count++;
}
return splitList;
}
@Test
public void testSplit() {
List<Item> list = new ArrayList<>();
for (int i=0;i<10;i++){
Item a = new Item("a"+i, i);
list.add(a);
}
System.err.println("拆分前的大列表:"+JSON.toJSONString(list));
List<List<Item>> lists = splitBigList(list, 3);
int count=1;
for (List<Item> items : lists) {
System.err.println("拆分后的小列表"+count+":"+JSON.toJSONString(items));
count++;
}
}
}
运行结果
拆分前的大列表:[{"age":0,"name":"a0"},{"age":1,"name":"a1"},{"age":2,"name":"a2"},{"age":3,"name":"a3"},{"age":4,"name":"a4"},{"age":5,"name":"a5"},{"age":6,"name":"a6"},{"age":7,"name":"a7"},{"age":8,"name":"a8"},{"age":9,"name":"a9"}]
拆分后的小列表1:[{"age":0,"name":"a0"},{"age":1,"name":"a1"},{"age":2,"name":"a2"}]
拆分后的小列表2:[{"age":3,"name":"a3"},{"age":4,"name":"a4"},{"age":5,"name":"a5"}]
拆分后的小列表3:[{"age":6,"name":"a6"},{"age":7,"name":"a7"},{"age":8,"name":"a8"}]
拆分后的小列表4:[{"age":9,"name":"a9"}]