领悟:实例化在遍历的里面和外面,效果是不一样的,如果实例化在遍历的外面,如下代码:
/**
*多个行政班合成一个上课班,返回该上课班Id
*
*@paramclassIds多个行政班Id
*@return上课班Id
*@author严文文
*@since2.0.022018-11-1016:10:18
*/
@Override
public String insertTeachClassIdByClassIds(List<String>classIds){
AdmTeachClassEntity admTeachClassEntity=new AdmTeachClassEntity();
List<AdmTeachClassEntity> admTeachClassEntityList=new ArrayList<>();
String teachClassId=BaseUuidUtils.base58Uuid();
List<String>classIdList=classIds.stream().collect(Collectors.toList());
classIdList.forEach(e->{
admTeachClassEntity.setId(BaseUuidUtils.base58Uuid());
admTeachClassEntity.setOperator("大米时代");
admTeachClassEntity.setTeachClassId(teachClassId);
admTeachClassEntity.setClassId(e);
admTeachClassEntity.setIsDelete(0);
admTeachClassEntityList.add(admTeachClassEntity);
});
intsize=admTeachClassDao.insertAll(admTeachClassEntityList);
if(size>0){
returnteachClassId;
}else{
return"多个行政班合成一个上课班失败";
}
}
效果如图:
你会发现插入的数据是一样的,所以这个导致id冲突,报错提示如下:
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'Vje3gjJ9TvCwbHkwszL24S' for key 'PRIMARY'
; Duplicate entry 'Vje3gjJ9TvCwbHkwszL24S' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'Vje3gjJ9TvCwbHkwszL24S' for key 'PRIMARY'] with root cause
提示主键冲突
但是如果换成如下代码
/
**
*多个行政班合成一个上课班,返回该上课班Id
*
*@paramclassIds多个行政班Id
*@return上课班Id
*@author严文文
*@since2.0.022018-11-1016:10:18
*/
@Override
publicStringinsertTeachClassIdByClassIds(List<String>classIds){
List<AdmTeachClassEntity>admTeachClassEntityList=newArrayList<>();
StringteachClassId=BaseUuidUtils.base58Uuid();
List<String>classIdList=classIds.stream().collect(Collectors.toList());
classIdList.forEach(e->{
AdmTeachClassEntityadmTeachClassEntity=newAdmTeachClassEntity();
admTeachClassEntity.setId(BaseUuidUtils.base58Uuid());
admTeachClassEntity.setOperator("大米时代");
admTeachClassEntity.setTeachClassId(teachClassId);
admTeachClassEntity.setClassId(e);
admTeachClassEntity.setIsDelete(0);
admTeachClassEntityList.add(admTeachClassEntity);
});
intsize=admTeachClassDao.insertAll(admTeachClassEntityList);
if(size>0){
returnteachClassId;
}else{
return"多个行政班合成一个上课班失败";
}
}
最后插入数据成功!
解析错误:当实例化在遍历的外面时,第二次生成的对象会覆盖第一次生成的对象,结果两次插入相同的数据,导致主键冲突,当实例化在便利的外面时,两次生成的对象是不相同的,所以能插入成功.