<insert id="insterOutMaterials" useGeneratedKeys="true" keyProperty="id">
INSERT INTO base_storage_outrecord_flow (mid,code,num,warehouse,ctime,batch,orderid,unit,orderno,type,isborrow,createuserid,cfree1,cfree2,cfree3,unittype)
VALUES
<foreach collection="storageOutrecords" item="item" index="index" separator=";">
((SELECT id FROM base_material WHERE code = #{item.code}),#{item.code},#{item.num},#{item.warehouse},GETDATE(),#{item.batch},#{item.orderno},#{item.unit},#{item.orderno},#{item.type},#{item.isborrow},#{item.createuserid},#{item.cfree1},#{item.cfree2},#{item.cfree3},#{item.unittype});
</foreach>
</insert>
用上useGeneratedKeys=“true” keyProperty=“id” 即可