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

2025-03-30 06:16:25
推荐回答(2个)
回答1:

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

对应的mapper.xml文件中






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



(#{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})



]]>

回答2:

这个有问题,输入参数没加进去。paremeterclass = "com...class"