spring-data-jpa(分页、排序、分组)

上一篇：单表增删改查
插入七条数据

服务实现层
sql：每页两条数据,第一页,按name倒序排序

    @Override
    public Page findBySpecification() {
        Specification specification = new Specification() {
            @SneakyThrows
            @Override
            public Predicate toPredicate(Root root, CriteriaQuery query, CriteriaBuilder criteriaBuilder) {
                Predicate condition = null;
                return condition;
            }
        };
        Sort sort = Sort.by(Sort.Direction.DESC, "name");
        Pageable pageable = PageRequest.of(0, 2, sort);
        return customerDao.findAll(specification, pageable);
    }

Controller层

@Transactional
    @Rollback(value = false)
    @RequestMapping("queryBySpecification")
    Page queryBySpecification() {
        return customerImpl.findBySpecification();
    }

浏览器查找
http://localhost:8080/customer/queryBySpecification
结果

分组
目标sql

select * from