MyBatis实现批量插入数据,多重forEach循环

MyBatis实现批量插入数据,多重forEach循环

目录批量插入数据,多重forEach循环下面是一个实际应用mybatis insert foreach项目场景

批量插入数据,多重forEach循环

在业务开发过程中，遇到批量插入时，需要进行多重forEach循环的情况。

下面是一个实际应用

public class SysRoleData extends DataEntity {

private static final long serialVersionUID = 1L;

private String kind; //类别（1：按部门2：按角色）

private String roleId; // role_id

private String roleName; //角色名称

private String officeId; //office_id

private String officeName; //部门名称

private String type; // 1.品牌 2.品类 3.品牌&品类

private String dataId; // 数据ID品牌

private String dataName; //数据名称品牌

private String dataIds; // 数据ID品类

private String dataNames; //数据名称品类

private String groupNo; //分组标识

private String useable; //是否可用(1:可用,0:不可用）

private String remarks; //备注

private List officeIdList = Lists.newArrayList();

private List roleIdList = Lists.newArrayList();

private List dataList = Lists.newArrayList();

public SysRoleData() {

super();

}

public SysRoleData(String id){

super(id);

}

public String getKind() {

return kind;

}

public void setKind(String kind) {

this.kind = kind;

}

@Length(min=0, max=45, message="role_id长度必须介于 0 和 45 之间")

public String getRoleId() {

return roleId;

}

public void setRoleId(String roleId) {

this.roleId = roleId;

}

public String getRoleName() {

return roleName;

}

public void setRoleName(String roleName) {

this.roleName = roleName;

}

public String getOfficeName() {

return officeName;

}

public void setOfficeName(String officeName) {

this.officeName = officeName;

}

@Length(min=0, max=45, message="office_id长度必须介于 0 和 45 之间")

public String getOfficeId() {

return officeId;

}

public void setOfficeId(String officeId) {

this.officeId = officeId;

}

@Length(min=0, max=4, message="品类长度必须介于 0 和 45 之间")

public String getType() {

return type;

}

public void setType(String type) {

this.type = type;

}

@NotNull

public String getDataId() {

return dataId;

}

public void setDataId(String dataId) {

this.dataId = dataId;

}

public String getDataName() {

return dataName;

}

public void setDataName(String dataName) {

this.dataName = dataName;

}

public String getDataIds() {

return dataIds;

}

public void setDataIds(String dataIds) {

this.dataIds = dataIds;

}

public String getDataNames() {

return dataNames;

}

public void setDataNames(String dataNames) {

this.dataNames = dataNames;

}

public String getUseable() {

return useable;

}

public void setUseable(String useable) {

this.useable = useable;

}

public String getRemarks() {

return remarks;

}

public void setRemarks(String remarks) {

this.remarks = remarks;

}

public List getDataList() {

return dataList;

}

public void setDataList(List dataList) {

this.dataList = dataList;

}

public List getOfficeIdList() {

return officeIdList;

}

public void setOfficeIdList(List officeIdList) {

this.officeIdList = officeIdList;

}

public List getRoleIdList() {

return roleIdList;

}

public void setRoleIdList(List roleIdList) {

this.roleIdList = roleIdList;

}

public String getGroupNo() {

return groupNo;

}

public void setGroupNo(String groupNo) {

this.groupNo = groupNo;

}

}

如上所示为一个实体类，会有dataList和roleIdList或officeIdList，在批量插入时从而形成多重循环。

上图为列表页面，

上图为添加页面。部门名称和品牌，品类名称支持多选，而在保存时，需要将其拆分保存。在查询时通过group_concat函数进行聚合展示在列表页面。

故在批量插入数据时：

INSERT INTO sys_role_data(

kind,

role_id,

office_id,

type,

data_id,

data_name,

group_no,

useable,

remarks,

create_date,

create_by,

update_date,

update_by

)VALUES

(

#{kind},

null,

#{officeId},

#{type},

#{data.id},

#{data.name},

#{groupNo},

#{useable},

#{remarks},

#{createDate},

#{createBy.id},

#{updateDate},

#{updateBy.id}

)

(

#{kind},

#{roleId},

null,

#{type},

#{data.id},

#{data.name},

#{groupNo},

#{useable},

#{remarks},

#{createDate},

#{createBy.id},

#{updateDate},

#{updateBy.id}

)

由上面sql可以看出，根据kind不同，进行相应的双重forEach循环插入数据。

mybatis insert foreach

项目场景

报错 ，找不到参数

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter ‘statusInfoId’ not found. Available parameters are [collection, list]

@Mapper

public interface PatrolRecordMapper extends BaseMapper {

int insertList(@Param(value = "list") List list);

}

mapper 换了很多种写法

insert into patrol_record(status_infgztvkUYo_id,route_id,place_name,patrol_time,

patrol_user,patrol_class,`status`)

VALUES

(patrolRecord.#{statusInfoId},

patrolRecord.#{routeId},

patrolRecord.#{placeName},

patrolRecord.#{patrolTime},

patrolRecord.#{patrolUser},

patrolRecord.#{patrolClass},

patrolRecord.#{status})

mapper

insert into patrol_record(status_info_id,route_id,place_name,patrol_time,

patrol_user,patrol_class,`status`)

VALUES

open="(" separator="," close=")">

list.#{statusInfoId},

list.#{routeId},

list.#{placeName},

list.#{patrolTime},

list.#{patrolUser},

list.#{patrolClass},

list.#{status}

open="(" separator="," close=")">

list.#{statusInfoId},

list.#{routeId},

list.#{placeName},

list.#{patrolTime},

list.#{patrolUser},

list.#{patrolClass},

list.#{status}

最后应该这么写才对 ： mapper

insert into patrol_record(status_info_id,route_id,place_name,patrol_time,

patrol_user,patrol_class,`status`)

VALUES

(

#{patrolRecord.statusInfoId},

#{patrolRecord.routeId},

#{patrolRecord.placeName},

#{patrolRecord.patrolTime},

#{patrolRecord.patrolUser},

#{patrolRecord.patrolClass},

#{patrolRecord.status})

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。