记一次选择手写批量新增弃用mybatis plus自带批操作
service层
if (h.size() > 0 && h.size() < 500) {
hService.insertBatch(h);
} else {
int index = h.size()/500;
for (int i = 0; i <= index && index != 0; i++) {
baseMapper.insertBatch(h.stream().skip(i*500).limit(500).collect(Collectors.toList()));
}
}
mapper层
<insert id="insertBatch">
insert into t
(ID,MBMC)
values
<foreach collection="list" item="l" separator=",">
(#{l.id},#{l.mbmc})
</foreach>
</insert>