JPA的复杂查询Specification

JPA的复杂查询Specification

使用SpringDataJPA做复杂查询的时候 需要在实体的repository中继承一个

public interface NurseForumRepository extends BaseRepository<NurseForum,String>, JpaSpecificationExecutor<NurseForum>

在业务逻辑service层中

PageRequest page = PageRequest.of(0, 2, Sort.by(Sort.Direction.DESC, “createDate”));

​ //使用specification复杂查询

​ Page pageInfo = nurseForumRepository.findAll(new Specification() {

​ @Override

public Predicate toPredicate(Root root, CriteriaQuery<?> criteriaQuery, CriteriaBuilder criteriaBuilder) {

​ List conditionList = new ArrayList<>();

​ conditionList.add(criteriaBuilder.equal(root.get(“status”).as(Byte.class), StatusEnum.OK.getCode()));

​ Predicate[] predicates = new Predicate[conditionList.size()];

​ return criteriaQuery.where(conditionList.toArray(predicates)).getRestriction();<