JPA子查询

       if(queryRecruitSignUpReq.getClassType()!=null){
                    Subquery<RecruitPlan> subquery = criteriaQuery.subquery(RecruitPlan.class);
                    Root<RecruitPlan> subRoot = subquery.from(RecruitPlan.class);
                    Predicate[] subArr = new Predicate[2];
                    subArr[0] = criteriaBuilder.equal(subRoot.get("classType"),queryRecruitSignUpReq.getClassType());
                    subArr[1] = criteriaBuilder.equal(subRoot.get("id"),root.get("planId"));
                    Predicate predicate = criteriaBuilder.exists(subquery.select(subRoot.get("id"))
                            .where(subArr));
                    predicates.add(predicate);
                }

关于JPA在进行关联查询时，

@JoinColumn与数据库字段重复无法使用，进行关联时字段值为空

转用子查询