<!--批量插入-->

     <insert id="batchSave" parameterType="java.util.List">
insert into storage_logistic ( plant_name, location, change_time, num, ebeln, ebelp, zid_po, bwart, elikz, mblnr )
VALUES
<foreach collection="list" item="itm" separator=",">
(#{itm.plant_name},#{itm.location},#{itm.change_time},#{itm.num},#{itm.ebeln},#{itm.ebelp},#{itm.zid_po},#{itm.bwart},#{itm.elikz},#{itm.mblnr})
</foreach>
<selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="storage_id">
select LAST_INSERT_ID();
</selectKey>
</insert>
public int batchSave(List<StorageLogisticVo> storagelogisticvo) {
int num = storageLogisticMapper.batchSave(storagelogisticvo);
return num;
}
04-24 16:56