Question

请教mysql spring mvc +mybatis中批量插入的问题

Answer 1

dao实现文件中函数:
@Override
public int insertContentList(
List<PubFieldContentEntity> list) {
Map<String, Object> params = createMap();
params.put("list", list);
return this.insert("insertContentList", params);
}

对应的mapper.xml文件中

<!-- 批量插入 -->

<insert id="insertContentList" useGeneratedKeys="true" keyProperty="id">

<![CDATA[

insert into tableContent(pubId,integrant,ownContentName,dateLine,pubFieldContentName,suffix,modifyTime,deleteTime,compareType,pubContentIndex,multiple,isInput,pubFieldTitle) values

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

(#{item.pubId},#{item.integrant},#{item.ownContentName},unix_timestamp(),#{item.pubFieldContentName},#{item.suffix},unix_timestamp(),#{item.deleteTime},#{item.compareType},#{item.pubContentIndex},#{item.multiple},#{item.isInput},#{item.pubFieldTitle})

</foreach>

]]>

</insert>