jpa多条件查询

Sort sort=new Sort(Sort.Direction.ASC, "id");排序

PageRequest pr=new PageRequest(page-1, rows,sort);分页

Page<Zsstuimformation> stu=studao.findAll(new Specification<Zsstuimformation>() {

@Override
public Predicate toPredicate(Root<Zsstuimformation> root, CriteriaQuery<?> cq, CriteriaBuilder cb) {
List<Predicate> predicates = new ArrayList<>();

if(!StringUtils.isEmpty(stuName)){
Path<String> namePath = root.get("stuName");
predicates.add(cb.like(namePath, "%"+stuName+"%"));模糊查询
}

if(!StringUtils.isEmpty(account)){
Path<String> namePath = root.join("zssigns").get("login").get("id");主表里的外键为List  zssigns时要用join
predicates.add(cb.equal(namePath, account));
}
if(!StringUtils.isEmpty(isqianyue)){
Path<Integer> namePath =root.get("id");
if(isqianyue==1){
predicates.add(cb.equal(namePath,root.join("zssigns").get("zsstuimformation").get("id")));主表id和外表id相等
}else if(isqianyue==2){
List<Integer> value = sdao.getSytuId();外表所有的主表id
predicates.add(cb.not(namePath.in(value)));not in查询(查询主表id不在外表里的数据)
}
}
cq.where(predicates.toArray(new Predicate[]{}));
return null;
}
}, pr);