在Spring Data JPA中创建分页 [英] Creating Pagination in Spring Data JPA

问题描述

我正在尝试在Spring Data JPA中实现分页功能.我引用此博客我的控制器包含以下代码:

I am trying to implement pagination feature in Spring Data JPA. I am referring this Blog My Controller contains following code :

 @RequestMapping(value="/organizationData", method = RequestMethod.GET)
  public String list(Pageable pageable, Model model){
    Page<Organization> members = this.OrganizationRepository.findAll(pageable);
    model.addAttribute("members", members.getContent());
    float nrOfPages = members.getTotalPages();
    model.addAttribute("maxPages", nrOfPages);
    return "members/list"; 
  }

我的DAO正在关注:

@Query(value="select m from Member m", countQuery="select count(m) from Member m")
  Page<Organization> findMembers(Pageable pageable);

我能够显示前20条记录，如何显示接下来的20条记录?还有其他我可以参考的分页示例吗?

I am able to show first 20 records, how do I show next 20??? Is there any other pagination example that I can refer??

推荐答案

上周我也遇到了类似的问题，但是找不到它，所以我将直接回答.

I've seen similar problem last week, but can't find it so I'll answer directly.

您的问题是指定参数的时间太晚. Pageable 的工作方式如下:创建具有某些属性的 Pageable 对象.您至少可以指定:

Your problem is that you specify the parameters too late. Pageable works the following way: you create Pageable object with certain properties. You can at least specify:

1. 页面大小
2. 页码，
3. 排序.

所以我们假设我们有:

PageRequest p = new PageRequest(2, 20);

上面传递给查询的内容将过滤结果，因此仅返回从21日到40日的结果.

the above passed to the query will filter the results so only results from 21th to 40th will be returned.

您不对结果应用 Pageable .您将其与查询一起传递.

You don't apply Pageable on result. You pass it with the query.

构造函数已被弃用.使用 Pageable pageable = PageRequest.of(2，20);

Constructors of PageRequest are deprecated. Use Pageable pageable = PageRequest.of(2, 20);

这篇关于在Spring Data JPA中创建分页的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！