MybatisPlus 使用 saveOrUpdate 详解
一、遇见的问题
报错信息:
com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: error: can not execute. because can not find column for id from entity!
就是这个mybatisPlus不能找到哪个是主键字段,因为这个saveOrUpdate默认是根据主键执行操作的!
解决方法:需要在原本的实体类的主键头上,打个@TableId,已经主键自动递增。
@TableId(value = "subject_Code", type = IdType.AUTO)
private long id;
二、saveOrUpdate
// 根据updateWrapper尝试更新,否继续执行saveOrUpdate(T)方法
boolean saveOrUpdate(T entity, Wrapper<T> updateWrapper);
public Response addWareHouse(@RequestBody List<GosInventoryDeviceRelationDTO> deviceRelationDTOList) {
if (CollectionUtils.isEmpty(deviceRelationDTOList)) {
throw new BizServiceException(ServiceErrorEnum.PARA_ERROR);
}
for (GosInventoryDeviceRelationDTO gosInventoryDeviceRelationDTO : deviceRelationDTOList) {
GosInventoryDeviceRelation gosInventoryDeviceRelation = new GosInventoryDeviceRelation();
BeanUtils.copyProperties(gosInventoryDeviceRelationDTO, gosInventoryDeviceRelation);
deviceRelationService.saveOrUpdate(gosInventoryDeviceRelation,new LambdaQueryWrapper<GosInventoryDeviceRelation>().eq(GosInventoryDeviceRelation::getDeviceOnlyCode, gosInventoryDeviceRelation.getDeviceOnlyCode()));
}
return Response.ok(InventoryConstants.SUCCESS);
}