错误代码:

在这里插入图片描述

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

为开发者提供学习成长、分享交流、生态实践、资源工具等服务,帮助开发者快速成长。

更多推荐