oracle批量插入 要把传入list 当作 select from dual
list分组 然后批量insert
List<List<Tbk>> parts = Lists.partition(bkList, 300);
parts.forEach(xkSeatArrangeMapper::insertTbk);
<insert id="insertTbk" parameterType="list">
insert into t_bk(kjh,kdh,kch,zwh,zkzh,kcdm,bprq,kszid)
select a.* from (
<foreach collection="list" item="item" index="index" separator="union all">select #{item.kjh}
,#{item.kdh},#{item.kch},#{item.zwh},#{item.zkzh},#{item.kcdm},sysdate,#{item.kszid} from dual
</foreach>
) a
</insert>
in 操作
List<List<String>> list = Lists.partition(notGroupedKjhList, 300);
list.forEach(a -> tdKcMapper.updateByKjhs(kszid, a));
update t_bm b set kszid = #{kszid} where b.ksdm = 83 and b.bkkldm != 0 a