Spring Data JPA: How to update a model elegantly?

Question

1. My Model is like this:

   @Entity
   @Table(name = "user")
   public class User {
   
       @Id
       @GeneratedValue(strategy = GenerationType.AUTO)
       private Long id;
   
       @Column(name="email")
       private String email;
   
       @Column(name = "weblink")
       private String webLink;
   
       //getter & setter
   }
   

2. we collect form or mobile data via http request, and springmvc will make these data to a Model like user.

   for example, I have a request like this:

   http://localhost:8080/update?id=1919&[email protected]

3. in contoller, the request url and its paramters will be automaticlly trans to a User object.

   @RequestMapping(method = RequestMethod.GET, value = "/update0")
   public User update(@ModelAttribute("User") User user){
   
       System.out.println(user.getId());
       System.out.println(user.getEmail());
       System.out.println(user.getWebLink());
   
       return userRepository.save(test);
   }
   

4. if I have a record in mysql which id is 1919, and the columns (id, email, weblik) are all have values.

   as you see, the user object which passed by web or mobile have two properties

   http://localhost:8080/update?id=1919&[email protected]

   id and email have values and weblink do not have.

   So, if i execute save method, the columns email will be updated to [email protected], and the weblik field will also be updated to NULL, but I don't want to update this field, I just want to update email field.

5. I have two ways to fix the problem, but all of them are not elegant.

   5.1 load user object first and update

   User userExist = userRepository.findOne(user.getId());
   userExist.setEmail(user.getEmail());
   
   //or using 
   //BeanUtil.copyProprty(formDto,modle)
   
   userRepository.save();
   

   5.2 using @DynamicUpdate, but its not working.

   Is there other way to update the User Model and do not do some extra work.

   Thanks in advance.

Answer 1

The easiest way is an appropriately set up controller method:

@RequestMapping(value = "/users/{user}", method = RequestMethod.PATCH)
public … updateUser(@ModelAttribute User user) { … }

According to the reference documentation when this method is called the following steps happen:

1. An instance of User needs to be obtained. This basically requires a Converter from String to User to be registered with Spring MVC to convert the path segment extracted from the URI template into a User. If you're e.g. using Spring Data and enable its web support as described in its reference documentation, this will work out of the box.
2. After the existing instance was obtained, request data will be bound to the existing object.
3. The bound object will be handed into the method.

Additional hints

• Don't use GET as HTTP method for updates. GET is defined to be a safe operation (no side effects), which an update is not. PATCH is the correct method here as it's defined to allow partial updates to an existing resource.
• To submit form data into PUT and PATCH requests, you need to register an HttpPutFormContentFilter with the application as described here. I filed an issue with Spring Boot to register that by default.