/jpaspecification

Spring Boot JPA Specification Example

Primary LanguageJava

Spring Boot JPA Specification Example

Main Information

📖 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