测试实体类:
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());
}
结果: