\n2. Example of Spring Rest, Spring Data JPA, and H2 to create restful services endpoints with Spring Boot<\/strong>
\n3. Using Swagger to test the Restful endpoints<\/strong><\/p>\n
1. Configuring Spring Rest, Spring Data JPA and H2 in Spring Boot<\/h2>\n
Go to https:\/\/start.spring.io\/<\/a>\u00a0and create a project with name springRestAndDataJpaWithSpringBoot and with following dependencies :<\/p>\n – Web<\/p>\n – JPA<\/p>\n – H2<\/p>\n Note: <\/b>If you are not familiar\u00a0with creating Spring Boot project with Spring Initializer, I would recommend following\u00a0one of my previous posts, How to Create Spring Boot Project with Spring Initializer<\/a>\u00a0where I have explained in detail,how we can create a Spring Boot project using Spring Initializer.<\/p>\n In this example, We are going to create Rest endpoints to:<\/p>\n – Create Employee resource<\/strong><\/p>\n – Retrieve List of Employees<\/strong><\/p>\n – Retrieve Employee<\/strong><\/p>\n – Update Employee resource<\/strong><\/p>\n – Delete Employee resource<\/strong><\/p>\n Following is the FINAL<\/b> directory structure of the project :<\/p>\n Let us see the various classes and interfaces that we need to create.<\/p>\n Export project springRestAndDataJpaWithSpringBoot (that you created via Spring Initializer)from your directory to Eclipse.<\/p>\n Open Pom.xml.It should have all the dependencies that you added from spring initializer website along with some default dependencies.<\/p>\n Also, I have manually added dependencies to enable Swagger. Swagger is basically used to test rest endpoints.<\/p>\n Spring boot has created a java file with name SpringRestAndDataJpaWithSpringBootApplication automatically. This class is used to launch a Spring Boot application. We need to do following in this class :<\/p>\n We already added dependencies for Swagger in the Pom.xml.Along with that to enable swagger in Spring boot, we need to put the @EnableSwagger2 annotation on the top of <\/p>\n – Tell Spring Boot which packages to scan to consider beans to be managed by Spring<\/strong><\/p>\n We need to use @ComponentScan(basePackages = “nl.blogspot.javasolutionsguide.springRestAndDataJpaWithSpringBoot”)\u00a0on top of\u00a0SpringRestAndDataJpaWithSpringBootApplication class.<\/p>\n Create Employee entity<\/p>\n Create Rest Controller with all operations.<\/p>\n Create Service interface with methods required to retrieve the list of employees, one employee, save employee in the database, delete an employee and update and employee. Create Implementation class for the interface created in Step 6<\/p>\n Create a repository class, which will extend Spring data JPA JpaRepository and hence will provide the methods to perform CRUD operations out of the box.<\/p>\n Enable the H2 database web console by adding the following lines in the application.properties file<\/p>\n Spring Boot will automatically take care of the creation of the datasource for H2 database,however we can mnaully configure datasource as well in the application.properties file as following :<\/p>\n With this you are done with creation of your restful API using Spring Rest,spring data JPA with h2 database.<\/p>\n Now you just need to run your\u00a0SpringRestAndDataJpaWithSpringBootApplication.java class and it will make sure that it will build your code, package your code in the jar and deploy it onto the embedded tomcat server.<\/p>\n Open H2 database console by hitting following URL<\/p>\n It will show you the following screen :<\/p>\n Click on the Connect button and it will connect you to the H2 database. and you can see that the EMPLOYEE table has been created, but there is no data in this table, which is as we expected.<\/p>\n To test your rest endpoints, hit the Swagger URL follows :<\/p>\n It will open the following page<\/p>\n Click on the employee-rest-controller link. It will show you the supported operations by this controller as follows:<\/p>\n Now we can see five endpoints in the above screenshot. We will test them one by one.<\/p>\n The first thing we need to do is to create a resource in the database.for that we will use POST operation and use \/api\/employees endpoint.<\/p>\n Click on the saveEmployee and fill all the required data that we need to create a resource and then click on “try it out”\u00a0button.<\/p>\n This is how your request and response will look like<\/p>\n As you can see that the response code is 200, which means SUCCESS and hence our record should have been created in the H2 database.<\/p>\n Let us check that.<\/p>\n Open H2 web console and query the EMPLOYEE table and you can see the record that we pushed from Swagger UI.<\/p>\n Similarly, Insert one more employee from Swagger UI with the following data :<\/p>\n Query database again and you will see two records in the database as follows :<\/p>\n Now as we have already inserted two records\u00a0 in the database, we will try to retrieve these records with the help of GET operation and using \/api\/employees endpoint as follows :<\/p>\n Click on the getEmployees and then as we want to retrieve the list of all employees, we need not pass any parameter.<\/p>\n Hence Just click on “try it out” button and you will get a list of employees in the response.<\/p>\n Next, we will retrieve only one employee on the basis of input employeeId using GET operation. We will pass employeeId to the rest endpoint \/api\/employees\/{employeeId}.<\/p>\n Click on the getEmployee and fill employeeId as 1, which means that we want to retrieve employee with employeeId 1.<\/p>\n Click on try it out button and you will see data of employee with employeeId 1 in the response as follows :<\/p>\n Next, we will test the update employee rest endpoint using PUT operation and by using \/api\/employees\/{employeeId} endpoint.<\/p>\n Click on the updateEmployee link. Paste one of the employee json\u00a0and put corresponding employeeId as follows :<\/p>\n Click on “Try it out” button and you will see following response with response code 200(SUCCESS).<\/p>\n Verify updated record with updated salary to 3000 from 1000 in the EMPLOYEE table in H2 database for employee with employeeId 1.<\/p>\n Next, we will test the delete Employee rest endpoint using DELETE operation and be using \/api\/employees\/{employeeId} endpoint.<\/p>\n Click on deteleEmployee link and fill employeeId 1, which means that we want to delete employee with employeeId 1.<\/p>\n Click on “try it out” button and you will get response code 200, which means the request is successfully processed.<\/p>\n Let us verify if an employee with employeeId 1 has been successfully deleted from the database by opening H2 console and querying database.<\/p>\n As we can see above that we have the only employee with employeeId 2 in the EMPLOYEE table, hence employee with employeeId 1 has been successfully deleted.<\/p>\n So in the above post, we saw how we can create restful API using Spring rest, Spring Data JPA and H2 database with Spring Boot.<\/p>\n We need to:<\/strong><\/p>\n – Create Spring Boot project from spring Initializer with required dependencies.<\/p>\n – Enable swagger support by adding additional dependencies in POM.xml and adding annotation in the spring boot application class.<\/p>\n – Enable the H2 database by adding necessary properties in the application.properties.<\/p>\n – Write Rest Controller, Service, repository\u00a0and entity to work upon.<\/p>\n – Start Spring boot application, which will be automatically deployed to an embedded server.<\/p>\n – Test the rest endpoints using Swagger UI and verify data in the H2 database using the H2 console.<\/p>\n Thanks for reading. Share it with someone you think it might be helpful.<\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-25-at-6.16.29-PM.png\")
<\/a><\/p>\n2. Example of Spring Rest, Spring Data JPA, and H2 to create restful services endpoints with Spring Boot<\/h2>\n
![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-21-at-9.09.56-PM.png\")
<\/a><\/p>\nStep 1<\/h3>\n
Step 2<\/h3>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n\r\n<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\r\nxsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\r\n\r\n<modelVersion>4.0.0<\/modelVersion>\r\n<groupId>nl.blogspot.javasolutionsguide<\/groupId>\r\n<artifactId>springRestAndDataJpaWithSpringBoot<\/artifactId>\r\n<version>0.0.1-SNAPSHOT<\/version>\r\n<packaging>jar<\/packaging>\r\n<name>springRestAndDataJpaWithSpringBoot<\/name>\r\n\r\n<description>Demo project for Spring Boot<\/description>\r\n\r\n<parent>\r\n<groupId>org.springframework.boot<\/groupId>\r\n<artifactId>spring-boot-starter-parent<\/artifactId>\r\n<version>2.0.3.RELEASE<\/version>\r\n<relativePath\/> <!-- lookup parent from repository -->\r\n<\/parent>\r\n\r\n<properties>\r\n<project.build.sourceEncoding>UTF-8<\/project.build.sourceEncoding>\r\n<project.reporting.outputEncoding>UTF-8<\/project.reporting.outputEncoding>\r\n<java.version>1.8<\/java.version>\r\n<\/properties>\r\n\r\n<dependencies>\r\n\r\n<dependency>\r\n<groupId>org.springframework.boot<\/groupId>\r\n<artifactId>spring-boot-starter-data-jpa<\/artifactId>\r\n<\/dependency>\r\n\r\n<dependency>\r\n<groupId>org.springframework.boot<\/groupId>\r\n<artifactId>spring-boot-starter-data-rest<\/artifactId>\r\n<\/dependency>\r\n\r\n<dependency>\r\n<groupId>com.h2database<\/groupId>\r\n<artifactId>h2<\/artifactId>\r\n<scope>runtime<\/scope>\r\n<\/dependency>\r\n\r\n<dependency>\r\n<groupId>org.springframework.boot<\/groupId>\r\n<artifactId>spring-boot-starter-test<\/artifactId>\r\n<scope>test<\/scope>\r\n<\/dependency>\r\n\r\n<dependency>\r\n<groupId>io.springfox<\/groupId>\r\n<artifactId>springfox-swagger2<\/artifactId>\r\n<version>2.7.0<\/version>\r\n<\/dependency>\r\n\r\n\r\n<dependency>\r\n<groupId>io.springfox<\/groupId>\r\n<artifactId>springfox-swagger-ui<\/artifactId>\r\n<version>2.7.0<\/version>\r\n<\/dependency>\r\n\r\n<\/dependencies>\r\n\r\n<build>\r\n\r\n<plugins>\r\n <plugin>\r\n <groupId>org.springframework.boot<\/groupId>\r\n <artifactId>spring-boot-maven-plugin<\/artifactId>\r\n <\/plugin>\r\n<\/plugins>\r\n\r\n<\/build>\r\n\r\n<\/project><\/pre>\n
Step 3<\/h3>\n
– Enable swagger<\/h4>\n
\nSpringRestAndDataJpaWithSpringBootApplication class.<\/p>\nStep 4<\/h3>\n
package nl.blogspot.javasolutionsguide.springRestAndDataJpaWithSpringBoot.entity;\r\n\r\nimport javax.persistence.Column;\r\nimport javax.persistence.Entity;\r\nimport javax.persistence.GeneratedValue;\r\nimport javax.persistence.GenerationType;\r\nimport javax.persistence.Id;\r\nimport javax.persistence.Table;\r\n\r\n\/**\r\n\u00a0* @author JavaSolutionsGuide\r\n\u00a0*\r\n\u00a0*\/\r\n@Entity\r\n@Table(name=\"EMPLOYEE\")\r\npublic class Employee {\r\n \r\n @Id\r\n @GeneratedValue(strategy= GenerationType.IDENTITY)\r\n private Long id;\r\n \r\n @Column(name=\"EMPLOYEE_NAME\")\r\n private String name;\r\n \r\n @Column(name=\"EMPLOYEE_SALARY\")\r\n private Integer salary;\r\n \r\n @Column(name=\"DEPARTMENT\")\r\n private String department;\r\n\r\n public Long getId() {\r\n return id;\r\n }\r\n\r\n public void setId(Long id) {\r\n this.id = id;\r\n }\r\n\r\n public String getName() {\r\n return name;\r\n }\r\n\r\n public void setName(String name) {\r\n this.name = name;\r\n }\r\n\r\n public Integer getSalary() {\r\n return salary;\r\n }\r\n\r\n public void setSalary(Integer salary) {\r\n this.salary = salary;\r\n }\r\n\r\n public String getDepartment() {\r\n return department;\r\n }\r\n\r\n public void setDepartment(String department) {\r\n this.department = department;\r\n }\r\n}<\/pre>\nStep 5<\/h3>\n
package nl.blogspot.javasolutionsguide.springRestAndDataJpaWithSpringBoot.controller;\r\n\r\nimport java.util.List;\r\nimport org.springframework.beans.factory.annotation.Autowired;\r\nimport org.springframework.web.bind.annotation.DeleteMapping;\r\nimport org.springframework.web.bind.annotation.GetMapping;\r\nimport org.springframework.web.bind.annotation.PathVariable;\r\nimport org.springframework.web.bind.annotation.PostMapping;\r\nimport org.springframework.web.bind.annotation.PutMapping;\r\nimport org.springframework.web.bind.annotation.RequestBody;\r\nimport org.springframework.web.bind.annotation.RestController;\r\nimport nl.blogspot.javasolutionsguide.springRestAndDataJpaWithSpringBoot.entity.Employee;\r\nimport nl.blogspot.javasolutionsguide.springRestAndDataJpaWithSpringBoot.service.EmployeeService;\r\n\r\n\/**\r\n\u00a0* @author JavaSolutionsGuide\r\n\u00a0*\r\n\u00a0*\/\r\n@RestController\r\npublic class EmployeeRestController {\r\n \r\n @Autowired\r\n private EmployeeService employeeService;\r\n \r\n public void setEmployeeService(EmployeeService employeeService) {\r\n this.employeeService = employeeService;\r\n }\r\n\r\n @GetMapping(\"\/api\/employees\")\r\n public List<Employee> getEmployees() {\r\n List<Employee> employees = employeeService.retrieveEmployees();\r\n return employees;\r\n }\r\n \r\n @GetMapping(\"\/api\/employees\/{employeeId}\")\r\n public Employee getEmployee(@PathVariable(name=\"employeeId\")Long employeeId) {\r\n return employeeService.getEmployee(employeeId);\r\n }\r\n \r\n @PostMapping(\"\/api\/employees\")\r\n public void saveEmployee(Employee employee){\r\n employeeService.saveEmployee(employee);\r\n System.out.println(\"Employee Saved Successfully\");\r\n }\r\n \r\n @DeleteMapping(\"\/api\/employees\/{employeeId}\")\r\n public void deleteEmployee(@PathVariable(name=\"employeeId\")Long employeeId){\r\n employeeService.deleteEmployee(employeeId);\r\n System.out.println(\"Employee Deleted Successfully\");\r\n }\r\n \r\n @PutMapping(\"\/api\/employees\/{employeeId}\")\r\n public void updateEmployee(@RequestBody Employee employee,\r\n @PathVariable(name=\"employeeId\")Long employeeId){\r\n Employee emp = employeeService.getEmployee(employeeId);\r\n if(emp != null){\r\n employeeService.updateEmployee(employee);\r\n }\r\n \r\n }\r\n\r\n}<\/pre>\nStep 6<\/h3>\n
package nl.blogspot.javasolutionsguide.springRestAndDataJpaWithSpringBoot.service;\r\n\r\nimport java.util.List;\r\n\r\nimport nl.blogspot.javasolutionsguide.springRestAndDataJpaWithSpringBoot.entity.Employee;\r\n\r\n\/**\r\n\u00a0* @author JavaSolutionsGuide\r\n\u00a0*\r\n\u00a0*\/\r\npublic interface EmployeeService {\r\n public List<Employee> retrieveEmployees();\r\n \r\n public Employee getEmployee(Long employeeId);\r\n \r\n public void saveEmployee(Employee employee);\r\n \r\n public void deleteEmployee(Long employeeId);\r\n \r\n public void updateEmployee(Employee employee);\r\n}<\/pre>\nStep 7<\/h3>\n
package nl.blogspot.javasolutionsguide.springRestAndDataJpaWithSpringBoot.service.impl;\r\n\r\nimport java.util.List;\r\nimport java.util.Optional;\r\nimport org.springframework.beans.factory.annotation.Autowired;\r\nimport org.springframework.stereotype.Service;\r\nimport nl.blogspot.javasolutionsguide.springRestAndDataJpaWithSpringBoot.entity.Employee;\r\nimport nl.blogspot.javasolutionsguide.springRestAndDataJpaWithSpringBoot.repository.EmployeeRepository;\r\nimport nl.blogspot.javasolutionsguide.springRestAndDataJpaWithSpringBoot.service.EmployeeService;\r\n\r\n\/**\r\n\u00a0* @author JavaSolutionsGuide\r\n\u00a0*\r\n\u00a0*\/\r\n@Service\r\npublic class EmployeeServiceImpl implements EmployeeService{\r\n\r\n @Autowired\r\n private EmployeeRepository employeeRepository;\r\n\r\n public void setEmployeeRepository(EmployeeRepository employeeRepository) {\r\n this.employeeRepository = employeeRepository;\r\n }\r\n \r\n public List<Employee> retrieveEmployees() {\r\n List<Employee> employees = employeeRepository.findAll();\r\n return employees;\r\n }\r\n \r\n public Employee getEmployee(Long employeeId) {\r\n Optional<Employee> optEmp = employeeRepository.findById(employeeId);\r\n return optEmp.get();\r\n }\r\n \r\n public void saveEmployee(Employee employee){\r\n employeeRepository.save(employee);\r\n }\r\n \r\n public void deleteEmployee(Long employeeId){\r\n employeeRepository.deleteById(employeeId);\r\n }\r\n \r\n public void updateEmployee(Employee employee) {\r\n employeeRepository.save(employee);\r\n }\r\n}<\/pre>\nStep 8<\/h3>\n
package nl.blogspot.javasolutionsguide.springRestAndDataJpaWithSpringBoot.repository;\r\n\r\nimport org.springframework.data.jpa.repository.JpaRepository;\r\nimport org.springframework.stereotype.Repository;\r\n\r\nimport nl.blogspot.javasolutionsguide.springRestAndDataJpaWithSpringBoot.entity.Employee;\r\n\r\n@Repository\r\npublic interface EmployeeRepository extends JpaRepository<Employee,Long>{\r\n\r\n}<\/pre>\nStep 9<\/h3>\n
spring.h2.console.enabled=true<\/pre>\n
spring.h2.console.path=\/h2<\/pre>\n
spring.datasource.url=jdbc:h2:file:~\/test<\/pre>\n
spring.datasource.username=sa<\/pre>\n
spring.datasource.password=spring.datasource.driver-class-name=org.h2.Driver<\/pre>\n
Step 10<\/h3>\n
Step 11<\/h3>\n
http:\/\/localhost:8080\/h2\/<\/pre>\n
![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-21-at-10.28.57-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-25-at-7.33.20-PM.png\")
<\/a><\/p>\n3. Using Swagger to test the Restful endpoints<\/h2>\n
http:\/\/localhost:8080\/swagger-ui.html<\/pre>\n
![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-21-at-10.20.40-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-2.19.33-PM.png\")
<\/a><\/p>\nSave Employee – \/api\/employees<\/h3>\n
![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-12.42.10-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-12.48.27-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-21-at-10.26.43-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-21-at-10.33.20-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-12.50.53-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-12.52.19-PM.png\")
<\/a><\/p>\nGet Employees -\/api\/employees<\/h3>\n
![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-12.53.21-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-12.55.52-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-12.59.00-PM.png\")
<\/a><\/p>\nGet Employee\u00a0– <\/b>\/api\/employees\/{employeeId}<\/h3>\n
![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-1.01.13-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-1.05.01-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-1.07.17-PM.png\")
<\/a><\/p>\nUpdate Employee –\u00a0\/api\/employees\/{employeeId}<\/h3>\n
![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-2.21.08-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-2.24.40-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-2.25.55-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-2.27.33-PM.png\")
<\/a><\/p>\nDelete Employee –\u00a0– <\/b>\/api\/employees\/{employeeId}<\/h3>\n
![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-1.13.45-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-1.15.06-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-1.16.50-PM.png\")
<\/a><\/p>\n![\"Restful](\"http:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/08\/Screen-Shot-2018-08-26-at-1.18.27-PM.png\")
<\/a><\/p>\nSummary<\/h2>\n