Spring Boot 和 H2 - 新增記錄

現在讓我們更新到目前為止建立的專案來準備一個完整的新增記錄 API 並進行測試。

更新服務

// Use repository.save() to persist Employee entity in database
public void saveOrUpdate(Employee employee) {
   repository.save(employee);
}

EmployeeService

package com.tutorialspoint.service;

import java.util.ArrayList;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.tutorialspoint.entity.Employee;
import com.tutorialspoint.repository.EmployeeRepository;

@Service
public class EmployeeService {
   @Autowired
   EmployeeRepository repository;
   
   // To be implemented
   public Employee getEmployeeById(int id) {
      return null;
   }
   
   // To be implemented
   public List<Employee> getAllEmployees(){
      return null;
   }
   
   // Create/Update an Employee
   public void saveOrUpdate(Employee employee) {
      repository.save(employee);
   }
   
   // To be implemented
   public void deleteEmployeeById(int id) {
   }
}

更新控制器

// Use service.saveOrUpdate() to persist Employee entity in database
@PostMapping("/employee")
public void addEmployee(@RequestBody Employee employee) {
   employeeService.saveOrUpdate(employee);   
}

EmployeeController

package com.tutorialspoint.controller;

import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.tutorialspoint.entity.Employee;
import com.tutorialspoint.service.EmployeeService;

@RestController
@RequestMapping(path = "/emp")
public class EmployeeController {
   @Autowired
   EmployeeService employeeService;
   
   // To be implemented
   @GetMapping("/employees")
   public List<Employee> getAllEmployees(){
      return null;
   }
   
   // To be implemented
   @GetMapping("/employee/{id}")
   public Employee getEmployee(@PathVariable("id") int id) {
      return null;;
   }
   
   // To be implemented
   @DeleteMapping("/employee/{id}")
   public void deleteEmployee(@PathVariable("id") int id) {
   }
   
   // Create an employee
   @PostMapping("/employee")
   public void addEmployee(@RequestBody Employee employee) {
      employeeService.saveOrUpdate(employee);   
   }
   
   // To be implemented
   @PutMapping("/employee")
   public void updateEmployee(@RequestBody Employee employee) {
   }	
}

執行應用程式

在 Eclipse 中，執行在 應用程式設定 期間準備的員工應用程式配置

Eclipse 控制檯將顯示類似的輸出。

[INFO] Scanning for projects...
...
2024-08-20T17:12:31.294+05:30  INFO 8844 --- [springboot-h2] [  restartedMain] o.s.b.d.a.OptionalLiveReloadServer       : LiveReload server is running on port 35729
2024-08-20T17:12:31.307+05:30  INFO 8844 --- [springboot-h2] [  restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port 8080 (http) with context path '/'
2024-08-20T17:12:31.310+05:30  INFO 8844 --- [springboot-h2] [  restartedMain] c.t.s.SpringbootH2Application            : Started SpringbootH2Application in 0.474 seconds (process running for 722.918)

伺服器啟動並執行後，使用 Postman 發出 POST 請求−

在 POSTMAN 中設定以下引數。

• HTTP 方法 − POST

• URL − https://:8080/emp/employee

• BODY − Employee JSON

{  
   "id": "1",  
   "age": "35",  
   "name": "Julie",  
   "email": "julie@gmail.com"  
}   

單擊發送按鈕並檢查響應狀態是否為 OK。

現在開啟 H2 控制檯並使用以下查詢驗證插入的記錄−

Select * from Employee;

它應顯示以下結果−