Spring Data JPA自定义查询，分页，排序

来源：互联网发布：尤伦斯艺术商店淘宝编辑：程序博客网时间：2024/05/19 02:25

1，自定义的repository 需要继承这2个接口

public interface AdviceClassRepository extends JpaRepository<AdviceClass,Long>,JpaSpecificationExecutor<AdviceClass> {}

JpaRepository作用：支持基本的增删改查和排序功能
JpaSpecificationExecutor作用：支持自定义查询和分页及排序

下面2个示例展示自定义查询

public Page<AdviceClass> findAll(AdviceClass adviceClass, PageRequest pageRequest) {        /*Sort sort = new Sort(Sort.Direction.ASC, "orderNumber","id");//这里是用POJO的属性，不是表里面*///        Pageable pageable = new PageRequest(pageRequest.getPageNumber(),pageRequest.getPageSize(), new Sort(Sort.Direction.ASC, new String[]{"orderNumber"}));        return  adviceClassRepository.findAll(Specifications.where(new Specification<AdviceClass>() {                    @Override                    public Predicate toPredicate(Root<AdviceClass> root, CriteriaQuery<?> query, CriteriaBuilder cb) {                        Predicate predicate=cb.conjunction();                        if(adviceClass!=null){                            if(StringUtils.isNotBlank(adviceClass.getAdviceName())){                                predicate.getExpressions().add(cb.like(root.<String>get("adviceName"),"%"+StringUtils.trim(adviceClass.getAdviceName())+"%"));                            }                            if(adviceClass.getActive()!=null){                                predicate.getExpressions().add(cb.equal(root.<Short>get("active"), adviceClass.getActive()));                            }                            if(StringUtils.isNotBlank(adviceClass.getRemark())){                                predicate.getExpressions().add(cb.like(root.<String>get("remark"),"%"+StringUtils.trim(adviceClass.getRemark())+"%"));                            }                        }                        return predicate;                    }                }),pageRequest);    }//注意下pageRequest的分页对象，第一页是page=0

阅读全文

0 0