mybatis批量插入oracle数据

1
2
3
4
5
6
7
8
9
10
11
12
<insert id="insertBatch" parameterType="java.util.List">
insert into REPORT_CARD_NAMELIST_STATISTIC (
STATISTIC_TIME, GRAY_NAMELIST_CARD_NO, RELATE_CARD_NO, MER_CODE, SUCC_TRANS_AMOUNT, TRANS_AMOUNT, SUCC_TRANS_NUM , TRANS_NUM, STATISTIC_TYPE)
<foreach collection="list" item="item" index="index" separator="union all">
(
select
#{item.statisticTime}, #{item.grayNamelistCardNo}, #{item.relateCardNo} ,#{item.merCode,jdbcType=VARCHAR},
#{item.succTransAmount}, #{item.transAmount}, #{item.succTransNum} ,#{item.transNum} ,#{item.statisticType}
from dual
)
</foreach>
</insert>

参考文献