<insert id="testBatch" parameterType="java.util.List" >
insert into T_AUTO_FUNDOUT_ORDER (
<include refid="batch_Column_List"/>
)
<foreach collection="list" item="item" index="index" separator="union all">
(SELECT #{item.outerTradeNo},#{item.authOrderNo},#{item.amount},#{item.bankCardInfo} FROM DUAL)
</foreach>
</insert>
insert into T_AUTO_FUNDOUT_ORDER (
<include refid="batch_Column_List"/>
)
<foreach collection="list" item="item" index="index" separator="union all">
(SELECT #{item.outerTradeNo},#{item.authOrderNo},#{item.amount},#{item.bankCardInfo} FROM DUAL)
</foreach>
</insert>
扫一扫
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
