<insert id="insertList" parameterType="java.util.List">
insert into transfer_accdetail
(batch_no,merbillno,outips_accno,inips_accno,ipsbillno,ipsdotime,ips_trdamt,trd_status)
values
<foreach collection="list" item="item" index="index" separator="," >
(#{item.batchNo},#{item.merBillNo},#{item.outIpsAcctNo},#{item.inIpsAcctNo},#{item.ipsBillNo},#{item.ipsDoTime},#{item.ipsTrdAmt},#{item.trdStatus})
</foreach>
</insert>
mybaits批量插入
最新推荐文章于 2024-04-13 21:32:22 发布