Question

springmv+mybatis怎样实现分段批量插入数据

Answer 1

额 mybatis只是 sql的拼接啊，你原生sql怎么插入 这个就怎么插入啊，无法在java控制分段调用 mybatis的批量插入，而mybatis

方法一：
<insert id="insertbatch" parameterType="java.util.List">
  <selectKey keyProperty="fetchTime" order="BEFORE"
  resultType="java.lang.String">
  SELECT CURRENT_TIMESTAMP()
  </selectKey>
  insert into kangaiduoyaodian ( depart1, depart2, product_name,
  generic_name, img, product_specification, unit,
  approval_certificate, manufacturer, marketPrice, vipPrice,
  website, fetch_time, productdesc ) values
  <foreach collection="list" item="item" index="index"
  separator=",">
  ( #{item.depart1}, #{item.depart2}, #{item.productName},
  #{item.genericName}, #{item.img},
  #{item.productSpecification}, #{item.unit},
  #{item.approvalCertificate}, #{item.manufacturer},
  #{item.marketprice}, #{item.vipprice}, #{item.website},
  #{fetchTime}, #{item.productdesc} )
  </foreach>
  </insert>
方法二：
<insert id="batchInsertB2B" parameterType="ArrayList">
insert into xxxxtable(hkgs,hkgsjsda,office,asdf,ddd,ffff,supfullName,classtype,agent_type,remark)
<foreach collection="list" item="item" index="index" separator="union all">
select #{item.hkgs,jdbcType=VARCHAR},
#{item.hkgsjsda,jdbcType=VARCHAR},
#{item.office,jdbcType=VARCHAR},
#{item.asdf,jdbcType=VARCHAR},
#{item.ddd,jdbcType=VARCHAR},
#{item.ffff,jdbcType=VARCHAR},
#{item.supfullName,jdbcType=VARCHAR},0,0,
#{item.remark,jdbcType=VARCHAR} from dual
</foreach>
</insert>