jpa知识点

最新推荐文章于 2024-07-20 23:43:31 发布

The_Best_Hacker

最新推荐文章于 2024-07-20 23:43:31 发布

阅读量849

点赞数

分类专栏： Jpa 文章标签：分页

本文链接：https://blog.csdn.net/The_Best_Hacker/article/details/120650995

版权

Jpa 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

本文介绍了Spring Data JPA中PageRequest的使用，通过of()方法实现分页和多条件排序。示例代码展示了如何构建Pageable对象进行排序，并提供了@Query注解的countQuery用法，用于获取分页查询的总条数。同时，详细解释了countQuery必须与查询条件保持一致的原则。

摘要由CSDN通过智能技术生成

1.分页

public static PageRequest of(int page, int size, Direction direction, String... properties) {
        return of(page, size, Sort.by(direction, properties));
    }



官方API说明: since 2.0, use of(...) instead,2.0版本后,使用 of(...) 方法代替 PageRequest(...)构造器

官方地址：https://docs.spring.io/spring-data/commons/docs/current/api/org/springframework/data/domain/PageRequest.html

支持多条件排序的，比如Pageable page = PageRequest.of(1, 10, Sort.Direction.DESC, "id","name",...);

private Pageable buildPageable(Param param) {
        //param pageNo,pageSize,sortOrder,sortField
        // 添加一个名为sort的field并根据他排序，用于把负数数据始终排在最后面
        String sortField = "sort";
        Sort sort = Sort.by(Direction.ASC, sortField);
        sort = sort.and(Sort.by(Constants.ACS.equals(param.getSortOrder()) ? Direction.ASC : Direction.DESC,param.getSortField()));
        // 处理分页
        Pageable pageable= PageRequest.of(param.getPageNo() - 1, param.getPageSize(), sort);
       
        return pageable;
    }

2.@Query之countQuery

@Query(value = "select * from "
            + "(select *, 1 as sort from student_task where data_type = ?1 and value >= 0 union "
            + "select *, 2 as sort from student_task where data_type = ?1 and value < 0) A",
            countQuery = "select count(*) from "
                    + "(select *, 1 as sort from student_task where data_type = ?1 and value >= 0 union "
                    + "select *, 2 as sort from student_task where data_type = ?1 and value < 0) A",
            nativeQuery = true)
    Page<StudentTask> queryStudentTaskList(String dataType, Pageable page);

countQuery 就是分页的总条数，后面的条件需跟value的where条件保持一致。