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
