mybaits批量插入

    xiaoxiao2022-06-23  19

    <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>
    转载请注明原文地址: https://ju.6miu.com/read-1123122.html

    最新回复(0)