日期:2014-05-17 浏览次数:20788 次
<!-- 批量插入 -->
<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>