myBaits使用@Insert注解插入数据获取主键ID小记

keyProperty ：对象属性、keyColumn ：主键列、useGeneratedKeys ：是否自动获取主键

@Insert("INSERT INTO t_user(fuserName,fpassWord,fdate) VALUES(#{userName}, #{password}, #{dateTime})")
    @Options(keyProperty = "id",keyColumn = "fid",useGeneratedKeys = true)
    int insert(User user);

保存后通过对象获取id

@ResponseBody
    @RequestMapping(value = "insertUser")
    public int insertUser(@RequestBody User user) {
        user.setDateTime(new Date());
        userService.insert(user);
        return user.getId();
    }