mysql 批量新增

標籤：log   int   param   foreach   contact   div   phone   address   ret   

<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　　遍曆的集合中的每個對象

mysql 批量新增