问题描述
- jpa的关联条件查询问题
-
我在dao里是这样写的:
public interface IMarpripInfoDao extends
PagingAndSortingRepository,
JpaSpecificationExecutor {
@Query("select t from IcisMarpripinfo t where t.id not in"
+ " (select e.id from IcisMarpripinfo e, EcpsEntyearexaminfo y"
+ " where y.ancheyear=:year and e.id = y.marprid ) and t.entname like '%:name%' and t.regno like '%:num%' ")
public Page findInfo(
@Param("year") BigDecimal ancheyear,
@Param("name") String entname, @Param("num") String regno,
Pageable pageable);
}可是当前台的查询条件传到后台时,老是报 org.hibernate.QueryParameterException: could not locate named parameter [name]; nested exception is java.lang.IllegalArgumentException: org.hibernate.QueryParameterException: could not locate named parameter [name] 不知道有没有大牛能帮我解答一下,万分感谢!
解决方案
我用的是注解版的jpa额,你这个不会,应该是参数没有识别出来,你用?占位符试一下,。
时间: 2024-09-01 08:47:55