使用SpringRESTController和SpringDataJPA仅更新从@RequestBody传递的实体属性

Question

如何使用Spring Rest Controller和Spring Data JPA仅更新从@刚体传递的实体属性？

员工实体：

@Entity
@Table(name = "employee")
@DynamicUpdate
public class Employee {
    @Id
    @Column(name = "employee_id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer employeeId;

    @Column(name = "employee_name")
    private String employeeName;

    @Column(name = "employee_desgn")
    private String employeeDesgn;

    @Column(name = "employee_email")
    private String employeeEmail;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "company_id", referencedColumnName = "company_id")
    private Company company;
}

服务类方法：

public Employee updateEmployee(Employee employee) {
    return employeeRepository.save(employee);
}

请求体：

{
    "employeeId":4,
    "employeeName":"Paul",
    "employeeDesgn":"Lead"
}

Hibernate更新查询：

update employee set company_id=?, employee_desgn=?, employee_name=? where employee_id=?

Spring Data JPA正在尝试将company_id设置为空以进行更新，即使我没有将其传递给请求体？但是如果我从数据库中得到实体，使用employee_id传递，然后如果我试图保存（），那么它的工作正常。

我想只更新通过请求体传递的实体属性。如何处理这种场景？

Answer 1

在另一个问题中，我使用apache commons的BeanUtils提出了一个解决方案：

public class NullAwareBeanUtilsBean extends BeanUtilsBean {
    @Override
    public void copyProperty(Object dest, String name, Object value) throws IllegalAccessException, InvocationTargetException {
        if (value == null)
            return;
        super.copyProperty(dest, name, value);
    }
}

您可以使用以下内容更新对象：

BeanUtilsBean notNull = new NullAwareBeanUtilsBean();
notNull.copyProperties(destObj, origObj);

这是我最初的回答

Answer 2

您可以按id查找员工，并仅填充这些值。下面是一个例子。

public Employee updateEmployee(Employee employee) {
    Employee emp = employeeRepository.findOne(employee.getEmployeeId());

    emp.setEmployeeName(employee.getEmployeeName());
    emp.setEmployeeDesgn(employee.getEmployeeDesgn());

    employeeRepository.save(emp);
}

仅更改员工姓名和员工设计。