SpringBoot整合SpringDataJpa 之 PagingAndSortingRepository

PagingAndSortingRepository接口继承了CrudRepository接口，提供了分页与排序的操作。

示例： 准备工作：

实体类：

@Entity
@Table(name = "tb_dept")
public class Dept {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Integer deptno;

    @Column
    private String dname;

    @Column
    private String loc;

    //……getter/setter、默认构造方法、全参构造方法
}

第一步：创建Maven项目，添加依赖：

    org.springframework.boot
    spring-boot-starter-data-jpa


    mysql
    mysql-connector-java
    runtime


    org.springframework.boot
    spring-boot-starter-test
    test


    junit
    junit
    4.12
    test

第二步：修改application.yml：

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/db_test?useSSL=false&serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=UTF8&autoReconnect=true&failOverReadOnly=false
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver
  jpa:
    hibernate:
      ddl-auto: update
    properties:
      hibernate:
        enable_lazy_load_no_trans: true
    show-sql: true

第三步：编写接口DeptDao.java：

public interface DeptDao extends PagingAndSortingRepository {

}

第四步：提供测试代码：

@RunWith(SpringRunner.class)
@SpringBootTest
@EnableAutoConfiguration
public class DeptDaoTest {
    @Autowired
    private DeptDao deptDao;

    @Test
    public void testPagingAndSortingRepositorySort() {
        //Order	定义了排序规则
        Sort.Order order = new Sort.Order(Sort.Direction.DESC, "id");
        //Sort对象封装了排序规则
        Sort sort = Sort.by(Sort.Direction.DESC, "loc");
        List list = (List) deptDao.findAll(sort);
        for (Dept dept : list) {
            System.out.println(dept);
        }
    }

    @Test
    public void testPagingAndSortingRepositoryPaging() {
        //Pageable:封装了分页的参数，当前页，煤业显示的条数。注意：它的当前页是从0开始
        //PageRequest(page,size):page表示当前页，size表示每页显示多少条
        Pageable pageable = PageRequest.of(1, 2);
        Page page = deptDao.findAll(pageable);
        System.out.println("数据的总条数：" + page.getTotalElements());
        System.out.println("总页数：" + page.getTotalPages());
        List list = page.getContent();
        for (Dept dept : list) {
            System.out.println(dept);
        }
    }

    @Test
    public void testPagingAndSortingRepositorySortAndPaging() {
        Sort sort = Sort.by(Sort.Direction.DESC, "deptno");
        Pageable pageable = PageRequest.of(0, 2, sort);
        Page page = deptDao.findAll(pageable);
        System.out.println("数据的总条数：" + page.getTotalElements());
        System.out.println("总页数：" + page.getTotalPages());
        List list = page.getContent();
        for (Dept dept : list) {
            System.out.println(dept);
        }
    }
}