MySql插入数据获取自增主键

 Mapper文件配置： 查询语句

<!-- useGeneratedKeys获取到插入数据的自增主键 -->
    <insert id="insert" useGeneratedKeys="true" keyProperty="id">
        insert into books(book_name,book_author,book_price,book_desc)
        values(#{bookName},#{bookAuthor},#{bookPrice},#{bookDesc});
    </insert>

Controller层代码

@RequestMapping("/add")
    public ResultVO add(Book book){
        int isSave = bookService.save(book);
        if (isSave > 0){
            return new ResultVO(0,"插入成功",book);
        }else {
            return new ResultVO(100,"插入失败",null);
        }
    }

 插入数据

http://localhost:8080/book/add?bookName=单独等待&bookAuthor=欣喜&bookPrice=10.0&bookDesc=hehe

 前端收到数据

{
    "code": 0,
    "msg": "插入成功",
    "data": {
        "id": 36,
        "bookName": "单独等待",
        "bookAuthor": "欣喜",
        "bookPrice": 10.0,
        "bookDesc": "hehe"
    }
}