<insert id="insertFiles" parameterType="java.util.List" useGeneratedKeys="true" keyColumn="id" keyProperty="fileId" >
insert into files_info (id,name,addUser,addDate,remark,company,status)values
<foreach collection ="list" item="item" separator="," index="index" >
(default,#{item.fileName},#{addUser},#{addDate},#{item.fileRemark},#{company},0)
</foreach >
</insert >
```'
int insertFiles(@Param("list")List<FileJsonParam> file, @Param("addUser")Integer user,@Param("addDate")Date date, @Param("company") Integer c);
pojo:
public class FileJsonParam {
private Integer fileId;
private String fileName;
private String fileRemark;
public FileJsonParam(Integer fileId, String fileName, String fileRemark) {
this.fileId = fileId;
this.fileName = fileName;
this.fileRemark = fileRemark;
}
public FileJsonParam() {
}
public Integer getFileId() {
return fileId;
}
public void setFileId(Integer fileId) {
this.fileId = fileId;
}
public String getFileName() {
return fileName;
}
public void setFileName(String fileName) {
this.fileName = fileName;
}
public String getFileRemark() {
return fileRemark;
}
public void setFileRemark(String fileRemark) {
this.fileRemark = fileRemark;
}
@Override
public String toString() {
return "FileJsonParam{" +
"fileId=" + fileId +
", fileName='" + fileName + '\'' +
", fileRemark='" + fileRemark + '\'' +
'}';
}
}
批量插入返回主键
最新推荐文章于 2024-04-13 11:21:59 发布