Spring boot jpa search criteria example

Posted on June 30, 2021

7 min read

2,718

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 + "]";
	}
}

@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";            
     }

}

@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();
    }

}

@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>{

}

@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

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>

<!DOCTYPE html>

<html>

<head>

<title>Insert title here</title>

</head>

<body>

<h1>Search Employee</h1>

<br />

<tr>

<label class="form-label" >Employee ID</label>

<td>

</td>

</tr>

</div>

<br>

<tr>

<td colspan="2"><button type="submit" class="btn btn-info">Search</button> </td>

</tr>

<tr>

<label class="form-label" >Employee Name</label>

<td>

</td>

</tr>

</div>

</form>

</div>

</body>

</html>

Spring boot jpa search criteria example

Domain

Employee.java

i have attached the video link below. which will do this tutorials step by step.

Create Maven project in Intellij

Django Vue.js Full Stack App

Django React Full Stack Project

Create Maven project in Intellij

Hibernate crud tutorial create delete update search

Hibernate Tutorial Introduction IntelliJ IDEA

Leave a Reply Cancel reply

Check Also

Create Maven project in Intellij

Recent Posts