JPA复杂查询条件构造(两种写法)

    private Specification<Users> getSpecification(){
        return (Specification<Users>)(root, query, criteriaBuilder)->{
            List<Predicate> predicates = new ArrayList<>();
            Predicate gtId = criteriaBuilder.gt(root.get("id"), 1);
            predicates.add(gtId);
            Predicate equalName = criteriaBuilder.equal(root.get("name"), "张三");
            predicates.add(equalName);
            return criteriaBuilder.and(predicates.toArray(new Predicate[0]));
        };
    }



    private Specification<Users> getSpecification2(){
        Specification<Users> usersSpecification = new Specification<Users>() {
            @Override
            public Predicate toPredicate(Root root, CriteriaQuery criteriaQuery, CriteriaBuilder criteriaBuilder) {
                List<Predicate> predicates = new ArrayList<>();
                predicates.add(criteriaBuilder.equal(root.get("name"),"张三"));
                predicates.add(criteriaBuilder.gt(root.get("id"),1));
                predicates.add(criteriaBuilder.between(root.get("id"),"2021-11-02","2021-10-12"));
                return criteriaBuilder.and(predicates.toArray(new Predicate[0]));
            }
        };
        return usersSpecification;
    }