错误代码:

在这里插入图片描述

Caused by: java.lang.IllegalStateException: 
Type handler was null on parameter mapping for property '__frch_item_0'. 
It was either not specified and/or 
could not be found for the javaType (com.x.x.x.x.entity.x) : jdbcType (null) combination

业务描述:批量删除

错误代码

	List<ParkingAudit> list = parkingAuditService.list(
	new LambdaQueryWrapper<ParkingAudit>().eq(ParkingAudit::getParkingAreaId, id));
	if(CollUtil.isNotEmpty(list)){
	   boolean b = parkingAuditService.removeByIds(list);
	   if(b){
	       log.info("删除成功 ={}", JSON.toJSONString(list));
	   }
	}

原因分析

看源代码,需要一个的是一个id集合list,而不是对象集合

	public boolean removeByIds(Collection<? extends Serializable> idList) {
	   return SqlHelper.delBool(this.baseMapper.deleteBatchIds(idList));
	}

正确代码:将id循环处理存入新的list

	List<ParkingAudit> list = parkingAuditService.list(
	new LambdaQueryWrapper<ParkingAudit>().eq(ParkingAudit::getParkingAreaId, id));
	if(CollUtil.isNotEmpty(list)){
	   List<Integer> idsList = new ArrayList<>();
	   list.forEach( u -> {
	       idsList.add(u.getId());
	   });
	   boolean b = parkingAuditService.removeByIds(idsList);
	   if(b){
	       log.info("删除成功 ={}", JSON.toJSONString(list));
	   }
	}
Logo

华为开发者空间,是为全球开发者打造的专属开发空间,汇聚了华为优质开发资源及工具,致力于让每一位开发者拥有一台云主机,基于华为根生态开发、创新。

更多推荐