--mybatis 批量插入数据

--1、Oracle（需要测试下是否支持MySQL）

< insert id ="insertBatch" parameterType="List" >

    insert into REAL_DATA_HW( M_LINE_NO,M_TIME,HW_NUM, VOL_A,VOL_B,VOL_C )

    < foreach collection ="list" item ="item" index ="index" separator ="union all">

     select    #{obj.M_LINE_NO,jdbcType= VARCHAR },to_date(#{obj.M_TIME ,jdbcType= VARCHAR },'yyyy-MM-dd hh24:mi:ss'),#{obj.HW_NUM , jdbcType=DOUBLE },

       #{obj.VOL_A ,jdbcType= DOUBLE },#{obj.VOL_B ,jdbcType= DOUBLE },#{obj.VOL_C ,jdbcType= DOUBLE } from dual

    </ foreach >

</ insert >

--2、MySQL

< insert id ="insertBatch" parameterType="List" >

<![CDATA[

    insert into REAL_DATA_HW( M_LINE_NO,M_TIME,HW_NUM, VOL_A,VOL_B,VOL_C )

    values

]]>

    < foreach collection ="list" item ="item" index ="index" separator =",">

       ( #{obj.M_LINE_NO},to_date(#{obj.M_TIME},'yyyy-MM-dd hh24:mi:ss'),#{obj.HW_NUM},

       #{obj.VOL_A},#{obj.VOL_B},#{obj.VOL_C} )

    </ foreach >

</ insert >