List分组，Mybatis分批插入，防止Sql语句超出长度

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37

@Test
public void test() {
List<String> list = new ArrayList<>();
for (int i = 0; i < 10000; i++) {
list.add("hh");
}
System.out.println("===" + list.size());
if (list.size() <= 1000) {
} else {
int times = (int) Math.ceil(list.size() / 1000);
int end = list.size();
for (int i = 0; i <= times; i++) {
System.out.println("分批插入：" + i);
if (list.size() % 10 == 0) {
if (i == times) {
break;
}
List<String> sublist = list.subList(i * 1000, Math.min((i + 1) * 1000, list.size() - 1));
System.out.println("第一个参数==" + i * 1000);
System.out.println("第二个参数==" + Math.min((i + 1) * 1000, list.size() - 1));
System.out.println("==:" + sublist.size());
} else {
if (i != times) {
List<String> sublist = list.subList(i * 1000, Math.min((i + 1) * 1000, list.size() - 1));
System.out.println("第一个参数==" + i * 1000);
System.out.println("第二个参数==" + Math.min((i + 1) * 1000, list.size() - 1));
System.out.println("==:" + sublist.size());
} else {
System.out.println("第一个参数==" + i * 1000);
System.out.println("第二个参数==" + end);
List<String> sublist = list.subList(i * 1000,end);
System.out.println("最后=="+sublist.size());
}
}
}
}