Mybaits 批量操作

批量插入

<insert id="insertBatch">    insert into    table(id,name1,name2,name3)    values    <foreach collection="entities" item="item" index="index"        separator=",">        (#{item.id,jdbcType=VARCHAR},        #{item.name1,jdbcType=VARCHAR},        #{item.name2,jdbcType=VARCHAR},        #{item.name3,jdbcType=VARCHAR})    </foreach></insert>

批量插入非重复内容

<insert id="batchInsert">    insert into tableName(id,name1,name12) values     <foreach collection="adReportDataList" item="item" index="index" separator=",">        (#{item.id,jdbcType=VARCHAR},        #{item.name1,jdbcType=VARCHAR},        #{item.name2,jdbcType=VARCHAR})     </foreach>    ON DUPLICATE KEY UPDATE name1=values(name1),name2=values(name2)</insert>