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>
|
近期评论