Mybatis注解式写法自动返回自增id到实体上

测试实体类：

import lombok.Data;
@Data
public class User {
    private Integer id;
    private String name;

}

mapper接口：

@Mapper
@Repository
public interface UserMapper {

    @Insert("insert into user(id,name) values(NULL,#{name})")
    @Options(useGeneratedKeys = true, keyProperty = "id", keyColumn = "id")
    void save(User user);
}

通过@Options注解把自增的id回填到User中

测试类：

@Test
public void saveUser(){
    User user = new User();
    user.setName("测试");
    System.out.println("增加前id="+user.getId());
    userMapper.save(user);
    System.out.println("增加后id="+user.getId());
}

结果：