接口实现类:
int taxLen = testList.size();//获取执行总数量
int increment = 10;
int c = taxLen % 10 == 0 ? taxLen / 10 : taxLen / 10 + 1;
for (int i = 0; i < c ; i++) {
int subLen = c - i == 1 ? taxLen : (i + 1) * increment;
//批量新增清单历史
testMapper.test(testList.subList(i * increment, subLen));
}
Mapper层:
void test(@Param("list") List<Map<String,Object>> test);
mybatis:
<insert id="test">
insert into testTable(test)
values
<foreach collection="list" item="i" separator=",">
(#{i.test})
</foreach>
</insert>