{"id":7873,"date":"2013-01-31T10:00:15","date_gmt":"2013-01-31T08:00:15","guid":{"rendered":"http:\/\/www.javacodegeeks.com\/?p=7873"},"modified":"2013-01-30T21:46:13","modified_gmt":"2013-01-30T19:46:13","slug":"spring-data-jpa-and-pagination","status":"publish","type":"post","link":"https:\/\/www.javacodegeeks.com\/2013\/01\/spring-data-jpa-and-pagination.html","title":{"rendered":"Spring Data JPA and pagination"},"content":{"rendered":"

Let us start with the classic JPA way to support pagination. Consider a simple domain class – A ‘Member’ with attributes first name, last name. To support pagination on a list of members, the JPA way is to support a finder which takes in the offset of the first result(firstResult) and the size of the result(maxResults) to retrieve, this way:
\n 
\n 
\n 
\n 
\n 
\n 
\n <\/p>\n

import java.util.List;\r\n\r\nimport javax.persistence.TypedQuery;\r\n\r\nimport org.springframework.stereotype.Repository;\r\n\r\nimport mvcsample.domain.Member;\r\n\r\n@Repository\r\npublic class JpaMemberDao extends JpaDao<Long, Member> implements MemberDao{\r\n\r\n public JpaMemberDao(){\r\n  super(Member.class);\r\n }\r\n @Override\r\n public List<Member> findAll(int firstResult, int maxResults) {\r\n  TypedQuery<Member> query = this.entityManager.createQuery('select m from Member m', Member.class);\r\n  return query.setFirstResult(firstResult).setMaxResults(maxResults).getResultList();\r\n }\r\n\r\n @Override\r\n public Long countMembers() {\r\n  TypedQuery<Long> query = this.entityManager.createQuery('select count(m) from Member m', Long.class);\r\n  return query.getSingleResult();\r\n }\r\n}<\/pre>\n
An additional API which returns the count of the records is needed to determine the number of pages for the list of entity, as shown above. Given this API, two parameters are typically required from the UI:<\/p>\n