mysql 批量新增

<insert id="insertInfoBatch" parameterType="java.util.List" >
  insert into up_company_needs_ledger (needsid, nname, npapers,
  naddress, nretype, ncontacts,
  nphone, ndelstatus, naddstatus,
  ntime, npersion)
  values
  <foreach collection="needsList" item="item" index="index" separator=",">
   (#{item.needsid,jdbcType=INTEGER}, #{item.nname,jdbcType=VARCHAR}, #{item.npapers,jdbcType=VARCHAR},
  #{item.naddress,jdbcType=VARCHAR}, #{item.nretype,jdbcType=VARCHAR}, #{item.ncontacts,jdbcType=VARCHAR},
  #{item.nphone,jdbcType=VARCHAR}, #{item.ndelstatus,jdbcType=VARCHAR}, #{item.naddstatus,jdbcType=VARCHAR},
  #{item.ntime,jdbcType=TIMESTAMP}, #{item.npersion,jdbcType=VARCHAR})
  </foreach>
</insert>

注释

needsList　　传过来的集合对象

item　　遍历的集合中的每个对象