我的RESTAPI将空数据提供给MySQL

Question

我不熟悉RESTAPI和Spring Boot。我一直在尝试使用存储员工数据的STS和MySQL创建RESTAPI。

一切似乎都很好，但是当我在Postman中发布数据时，空的行存储在MySQL和body中。

//My employee class in the model 
package com.example.SpringBootApplicationProject.model;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

import lombok.Data;

//We need to make this simple Employee class to JPA annotation
@Data
@Entity
@Table(name="employees")
public class Employee {
    
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private long id;
    
    @Column(name = "first_name")
    private String firstName;
    
    @Column(name = "last_name")
    private String lastName;
    
    @Column(name = "email")
    private String email;
    
    @Column(name = "salary")
    private long salary;

}

//员工控制器类

package com.example.SpringBootApplicationProject.controller;

import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.example.SpringBootApplicationProject.model.Employee;
import com.example.SpringBootApplicationProject.service.EmployeeService;

@RestController
@RequestMapping("/api/employees")
public class EmployeeController {
    
    private EmployeeService employeeService;

    public EmployeeController(EmployeeService employeeService) {
        super();
        this.employeeService = employeeService;
    }
    
    //Build employee REST API
    @PostMapping
    public ResponseEntity<Employee> saveEmployee(@RequestBody Employee employee){
        return new ResponseEntity<Employee>(employeeService.saveEmployee(employee), HttpStatus.CREATED);
    }
}

//员工存储库类

package com.example.SpringBootApplicationProject.repository;

import org.springframework.data.jpa.repository.JpaRepository;

import com.example.SpringBootApplicationProject.model.Employee;

//This is an interface. 
//JPA repository automatically provides @Repository
public interface EmployeeRepository extends JpaRepository<Employee, Long>{
//public interface EmployeeRepository extends JpaRepository<Employee, Long>{

    //Employee save(Employee employee);

}

//员工服务类

package com.example.SpringBootApplicationProject.service;

import com.example.SpringBootApplicationProject.model.Employee;

public interface EmployeeService 
{
    Employee saveEmployee(Employee employee);

}

//员工服务Impl

package com.example.SpringBootApplicationProject.service.impl;

import org.springframework.stereotype.Service;

import com.example.SpringBootApplicationProject.model.Employee;
import com.example.SpringBootApplicationProject.repository.EmployeeRepository;
import com.example.SpringBootApplicationProject.service.EmployeeService;

@Service
public class EmployeeServiceImpl implements EmployeeService{
    private EmployeeRepository  employeeRepository;
    
    public EmployeeServiceImpl(EmployeeRepository employeeRepository) {
        
        super();
        this.employeeRepository = employeeRepository;
    }


    @Override
    public Employee saveEmployee(Employee employee) {
        return employeeRepository.save(employee);
    }

}
Postman blank data[MySQL Empty DB][1]

Answer 1

你不能给任何url在Put映射和没有保存数据你直接把保存功能在响应实体而返回数据。您必须先保存数据并返回该实体。下面是修改过的代码。

@RestController
@RequestMapping("/api/employees")
public class EmployeeController {
    @Autowired
    private EmployeeService employeeService;
    
    @PostMapping("/employee")
    public ResponseEntity<Employee> saveEmployee(@RequestBody Employee employee){
        employeeService.saveEmployee(employee);
        return new ResponseEntity.ok(employee);
    }
}