CODEWITHSUNDEEP
javaspringspring-bootspring-dataspring-data-jpa
Tejas
Tejas

Reputation: 279

Creating Pagination in 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"; 
  }

My DAO is following :

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

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

Upvotes: 25

Views: 66191

Answers (4)

Tiago PC
Tiago PC

Reputation: 129

You can use Page, List or Slice.

If you dont need the number of pages, and only need to know if the next page exists, use Slice, since it does not do the "count" query:

  for (int i = 0;  ; i++) { 
     Slice<Organization> pageOrganization = organizationRepository.find(PageRequest.of(0, 100));        
    
    
     List<Organization> organizationList = pageOrganization.getContent();
     for (Organization org : organizationList) {
           // code
     }
    
    if (!pageOrganization.hasNext()) {
        break;
    }   
}

Upvotes: 1

blessy kiran00
blessy kiran00

Reputation: 1

Pageable object by default comes with size 20, page 0, and unsorted So if you want the next page in front end the url can be sent with query params page, size,sort and these u can test it on postman.

Upvotes: 0

xenteros
xenteros

Reputation: 15852

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

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. Page size,
  2. Page number,
  3. Sorting.

So let's assume that we have:

PageRequest p = new PageRequest(2, 20);

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

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

Edit:

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

Upvotes: 38

snowfox
snowfox

Reputation: 2098

The constructors of Pageable are deprecated, use of() instead:

Pageable pageable = PageRequest.of(0, 20);

Upvotes: 53

Related Questions