<insert id="batchInsert" useGeneratedKeys="true" keyProperty="id" >
INSERT INTO `tb1`
(`batch_id`,`order_id`,`type`,`mode`,`status`,`real_total`,`scan_total`,`abnormal_total`,`scan_time`,`scan_by`,`eid`,`oid`,`cid`)
VALUES
<foreach collection="list" item="item" index="index" separator=",">
(#{item.batchId},#{item.orderId},#{item.type},#{item.mode},#{item.status},#{item.realTotal},#{item.scanTotal},#{item.abnormalTotal},#{item.scanTime},#{item.scanBy},#{item.eid},#{item.oid},#{item.cid})
</foreach>
</insert>
mybatis 3.31
collection="list"是有必要的,不然会报一些问题