Spring boot jpa search criteria example

This tutorial will teach how to make a search criteria using Spring boot Application. In this tutorial explain simple example of search. Enter the Employee Id on the input field click search button relevant employee name will be displayed on the below input filed.

Domain

First you must Create the package com.example.SearchEmployee.domain inside the package you have to create the class.

Employee.java

@Entity
public class Employee {
 
 @Id
    @GeneratedValue(strategy= GenerationType.IDENTITY)
    private Long id;
    private String ename;
    private int mobile;
    private int salary;

    public Employee() {
 
 }
 public Employee(Long id, String ename, int mobile, int salary) {
 
  this.id = id;
  this.ename = ename;
  this.mobile = mobile;
  this.salary = salary;
 }

 
 public Long getId() {
  return id;
 }
 public void setId(Long id) {
  this.id = id;
 }
 public String getEname() {
  return ename;
 }
 public void setEname(String ename) {
  this.ename = ename;
 }
 public int getMobile() {
  return mobile;
 }
 public void setMobile(int mobile) {
  this.mobile = mobile;
 }
 public int getSalary() {
  return salary;
 }
 public void setSalary(int salary) {
  this.salary = salary;
 }

 @Override
 public String toString() {
  return "Employee [id=" + id + ", ename=" + ename + ", mobile=" + mobile + ", salary=" + salary + "]";
 }
}

after that you have to Create the package com.example.SearchEmployee.Controller . inside the package you have to create the class

EmployeeController .java

@Controller
public class EmployeeContoller {
 
    @Autowired
    private EmployeeService service;

    @GetMapping("/")
    public String add(Model model) {
     List<Employee> listemployee = service.listAll();
        model.addAttribute("employee", new Employee());
        return "index";
    }

    
    @PostMapping("/search")
     public String doSearchEmployee(@ModelAttribute("employeeSearchFormData") Employee formData, Model model) {
            Employee emp = service.get(formData.getId());
            model.addAttribute("employee", emp);
            return "index";            
     }

}

First you must Create the package com.example.SearchEmployee.Service . inside the package you have to create the class

EmployeeService.java

@Service
public class EmployeeService {
 
 
 @Autowired
    private EmployeeRepository repo;
 
 public List<Employee> listAll() {
        return repo.findAll();
    }
     
    
     
    public Employee get(long id) {
        return repo.findById(id).get();
    }

}

First you must Create the package com.example.SearchEmployee.Repository inside the package you have to create the Interface here.

EmployeeRepository.java

@Repository
public interface EmployeeRepository extends JpaRepository<Employee, Long>{

}

After that you must set database path and project configuration in application.properties file.

spring.datasource.url=jdbc:mysql://localhost:3306/gcompany?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
server.error.whitelabel.enabled=false
server.port=8020
spring.datasource.username=root
spring.datasource.password=

spring.jpa.open-in-view=false
spring.thymeleaf.cache=false

Inside the Templete Folder Create the page index.

index.html

<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>

   <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootswatch/4.5.2/cosmo/bootstrap.min.css" />
   <script src= "https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js" ></script>

</head>
<body>
<div align="center">

    <h1>Search Employee</h1>
    <br />
     <div class="col-sm-4">
     
 <form action="#" th:action="@{/search}" th:object="${employee}" method="post">
        <div alight="left">
            <tr>
                <label class="form-label" >Employee ID</label>
                <td>
                    <input type="text" th:field="*{id}" class="form-control" placeholder="Employee ID" />
                </td>
            </tr>
        </div>   

            <br>
            <tr>
            <td colspan="2"><button type="submit" class="btn btn-info">Search</button> </td>
            </tr>
            
            
            <div alight="left">
            <tr>
                <label class="form-label" >Employee Name</label>
                <td>   
                    <input type="text" th:field="${employee.ename}" class="form-control" placeholder="Employee Name" />
                </td>
            </tr>
         </div>   
    </form>
</div>
</body>
</html>