Spring Boot JPA Specification Example

📖 Information

• This Spring Boot application showcases the integration of Spring Data JPA Specifications for dynamic and fine-grained querying of employee records.
• The implemented features include processes such as listing, filtering, and retrieving employee records based on various criteria using specifications.
• Specifications are employed to construct flexible queries, enabling the application to efficiently retrieve specific sets of employees based on dynamic conditions.

Explore Rest APIs

Method	Url	Description	Request Body
GET	/api/v1/employees/getEmployees	Get Employees	ListEmployeeRequest	Info
GET	/api/v1/employees/getEmployees	Get Employees By FirstName	ListEmployeeRequest	Info
GET	/api/v1/employees/getEmployees	Get Employees By Keyword	ListEmployeeRequest	Info
GET	/api/v1/employees/getEmployees	Get Employees By Department Name	ListEmployeeRequest	Info
GET	/api/v1/employees/getEmployees	Get Employees By Birthday At	ListEmployeeRequest	Info
GET	/api/v1/employees/getEmployees	Get Employees By Birthday After	ListEmployeeRequest	Info
GET	/api/v1/employees/getEmployees	Get Employees By Birthday Before	ListEmployeeRequest	Info
GET	/api/v1/employees/getEmployees	Get Employees By Birthday Between	ListEmployeeRequest	Info

Request with Request Body

Get Employees

    http://localhost:8080/api/v1/employees/getEmployees
    
    {
        "filter":{}
    }
    

Get Employees By FirstName

    http://localhost:8080/api/v1/employees/getEmployees
    
    {
        "filter":{
            "firstName":"Stormy"
        }
    }
    

Get Employees By Keyword

    http://localhost:8080/api/v1/employees/getEmployees
    
    {
        "filter": {
            "keyword": "Mitchell"
        }
    }
    

Get Employees By Department Name

    http://localhost:8080/api/v1/employees/getEmployees
    
    {
        "filter": {
            "firstName": "Domonique",
            "departmentName": "Public Safety"
        }
    }
    

Get Employees By Birthday At

    http://localhost:8080/api/v1/employees/getEmployees
    
    {
        "filter": {
            "birthdayDate": {
            "birthdayDateFirst": "1984-10-04",
                "dateComparison": "AT"
            }
        }
    }

    

Get Employees By Birthday After

    http://localhost:8080/api/v1/employees/getEmployees
    
    {
        "filter": {
            "birthdayDate": {
            "birthdayDateFirst": "1994-01-13",
                "dateComparison": "AFTER"
            }
        }
    }

    

Get Employees By Birthday Before

    http://localhost:8080/api/v1/employees/getEmployees
    
    {
        "filter": {
            "birthdayDate": {
            "birthdayDateFirst": "1994-01-13",
                "dateComparison": "BEFORE"
            }
        }
    }

    

Get Employees By Birthday Between

    http://localhost:8080/api/v1/employees/getEmployees
    
    {
        "filter": {
            "birthdayDate": {
              "birthdayDateFirst": "1981-07-28",
              "birthdayDateSecond": "1982-07-20",
                "dateComparison": "BETWEEN"
            }
        }
    }

    

Technologies

---

• Java 17
• Spring Boot 3.0
• Restful API
• Lombok
• Maven
• Postman
• Faker
• Spring Boot Devtools

Maven Run

To build and run the application with Maven, please follow the directions shown below;

$ cd jpaspecification
$ mvn clean install
$ mvn spring-boot:run

Screenshots

Screenshots

Click here to show the screenshots of project

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Contributors

• Sercan Noyan Germiyanoğlu