- 原生的批量插入数据 ,dao与service自己补充
List<Integer> originalList = new ArrayList<>();
//partitionSize,表示一个分片的大小
int partitionSize=1000;
List<List<Integer>> partitionList;
//这里用的commons.collection4
partitionList = ListUtils.partition(originalList, partitionSize);
for (List<Integer> item : partitionList) {
userService.saveBatch(item);
}
- xml
<insert id="saveBatch">
INSERT INTO user (name, age) VALUES
<foreach collection="list" separator="," item="item">
(#{item.name},#{item.age})
</foreach>
</insert>