Pagination and Sorting Spring Data JPA

1. What is Pagination and Sorting?

Pagination is the process of splitting the content into small chunks from the large data set.

Sorting is a mechanism to arrange the data either ascending or descending by a given field.

The ascending sorting means basically alphabetically sorting the data from A to Z and descending sorting means alphabetically sorting the data from Z-A.

In this post, we will create a simple GET API using Spring Boot which implements Pagination and Sorting.

2. Create Spring Boot Project

If you don’t know how to create a Spring Boot project then you can refer to my previous post Create Spring Boot project using Spring Initialzer where I have written about it in detail.

3. Maven Dependency


In the dependency section, We’ve included h2database which is a in-memory database and if you want to use other databases like MySQL you can add mysql-connector dependency. The example we are going to implement will work for other databases as well. The only thing is to add a new dependency and configure its details in the file accordingly.

4. Create Classes and Interfaces.

4.1 Employee Entity

package com.codersathi.entity;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

public class Employee {
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	private Long id;
	private String name;
	private String address;

	public Long getId() {
		return id;

	public void setId(Long id) { = id;

	public String getName() {
		return name;

	public void setName(String name) { = name;

	public String getAddress() {
		return address;

	public void setAddress(String address) {
		this.address = address;


4.2 Employee Repository

package com.codersathi.repository;


import com.codersathi.entity.Employee;

public interface EmployeeRepository extends JpaRepository<Employee, Long> {


4.3. Employee Response DTO

package com.codersathi.dto;

import java.util.List;
import com.codersathi.entity.Employee;

public class EmployeeResponseDto {

	private long total;
	private List<Employee> employees;

	public long getTotal() {
		return total;

	public void setTotal(long total) { = total;

	public List<Employee> getEmployees() {
		return employees;

	public void setEmployees(List<Employee> employees) {
		this.employees = employees;


4.4. Employee Service

package com.codersathi.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.codersathi.dto.EmployeeResponseDto;
import com.codersathi.entity.Employee;
import com.codersathi.repository.EmployeeRepository;

public class EmployeeService {

	private EmployeeRepository employeeRepository;

	public EmployeeResponseDto getEmployees(Pageable pageable) {
		Page<Employee> page = employeeRepository.findAll(pageable);
		EmployeeResponseDto response = new EmployeeResponseDto();
		return response;

4.5. Employee Controller

package com.codersathi.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.codersathi.dto.EmployeeResponseDto;
import com.codersathi.service.EmployeeService;

public class EmployeeController {

	private EmployeeService employeeService;
	public EmployeeResponseDto getEmplloyees(Pageable pageable) {
		return employeeService.getEmployees(pageable);

4.6 File

The file should be created automatically while generating the project using Spring Initializer. The configuration details for h2-database is:




# This can be optional.

4.7 data.sql File

The data.sql file will be loaded automatically by spring boot itself. Hence, create it inside src/main/resources directory and add the following query so that the query will be executed during application startup.

create table employee (id bigint generated by default as identity, address varchar(255), name varchar(255), primary key (id));

insert into employee (name, address) values ('Radha Krishnan', 'Kathmandu'); 
insert into employee (name, address) values ('Pankaj', 'Pokhara'); 

The above query will first create an employee table and inserts two records.

5. Test

Now, the time is to test our application by starting it. Go and find the main class of your project and start it.

Since we have defined server.port 8080 in file. Now, we can fetch all data.

5.1 Fetch All Data



spring data jpa pagination and sorting all data
In this output, we can see that there are two employees.

There are two employees in our database. Now, let’s fetch only one data using the following URL:

5.2 Fetch Paginated Data



spring data jpa pagination and sorting paginated data
In this output, we can see that there are two employees but it displays only one employee because in the URL we’ve given size=1 and page =0. Which basically means to return 1 data from page 0.

5.3 Fetch Data Using Sorting



In this output, we can see that the data is sorted by name. You can compare this data with output in 5.1 where we haven’t implemented sorting.

6. Conclusion

In this post, we learned to implement pagination and sorting in the Spring Data JPA using Spring Boot.

Important Note

The value for the sort key should match the exact database column and the sorting order value should be either asc or desc.

You can find the complete example code in the Github repository.

Leave a Reply

Inline Feedbacks
View all comments
Would love your thoughts, please comment.x