Spring MVC pagination and sorting

Question

I am trying to implement pagination and sorting in spring MVC. As per my understanding, we can use PagingAndSortingRepository or JpaRepository for same(http://springinpractice.com/2012/05/11/pagination-and-sorting-with-spring-data-jpa).

But both these use the default findAll method to do so.

I wish to create my own method and execute a custom query and perform the pagination as well as sorting on that(lets say search by category name and sort by creation date). I am not sure how to do this by using PagingAndSortingRepository or JpaRepository.

It will be great if I can have some sort of guidance to achieve this.

Thanks in advance.

I don't see a question here....

ChiefTwoPencils
– ChiefTwoPencils

2015-08-25 02:30:51 +00:00
Commented Aug 25, 2015 at 2:30 — ChiefTwoPencils
– ChiefTwoPencils, Commented Aug 25, 2015 at 2:30
@ChiefTwoPencils I have updated/edited the question

Balwinder Singh
– Balwinder Singh

2015-08-25 02:38:47 +00:00
Commented Aug 25, 2015 at 2:38 — Balwinder Singh
– Balwinder Singh, Commented Aug 25, 2015 at 2:38

Ferdinand Neman · Accepted Answer · 2015-08-25 03:51:37Z

1

With JPA you can do many combination of queries just by specifying method signatures. Please consult http://docs.spring.io/spring-data/jpa/docs/1.4.3.RELEASE/reference/html/jpa.repositories.html

In your repository interface you can

List<Person> findAll(); // this is standard
List<Person> findById(String id); // looking person that have specific Id
List<Person> findByNameLike(String name); // you can put the name "foo%"

If you want pagination and sorting...

Page<Person> findByNameLike(String name, PageRequest pageRequest);

And you use it like

int page = 0; // first page
int size = 10; // show 10 result max per page
Page personPage = repo.findByNameLike("A%", new PageRequest(page,size,Sort.Direction.ASC, "birthDate"));  // pagination for person with name, page 0, 10 item per page, and sorted by the person.birthDate.

Good luck

edited Aug 25, 2015 at 3:51

answered Aug 25, 2015 at 2:49

Ferdinand Neman

7003 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Balwinder Singh Over a year ago

Thanks for the explanation. Can you please share detailed tutorial for same?

Ferdinand Neman Over a year ago

You can see this documentation docs.spring.io/spring-data/data-jpa/docs/1.0.0.M1/reference/… Comes from this stackoverflow.com/questions/14120153/… Its pretty straight forward

Collectives™ on Stack Overflow

Spring MVC pagination and sorting

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related