spring boot插入insert数据后获取插入后的ID值方法

spring boot插入insert数据后获取插入后的ID值方法

在/resources/mapper中创建DishMapper.xml

1. <?xml version="1.0" encoding="UTF-8" ?>
   
2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
   
3.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
   
4. <mapper namespace="com.sky.mapper.DishMapper">
   
5. 
   
6.     <insert id="insert" useGeneratedKeys="true" keyProperty="id">
   
7.         insert into dish (name, category_id, price, image, description, create_time, update_time, create_user,update_user, status)
   
8.         values (#{name}, #{categoryId}, #{price}, #{image}, #{description}, #{createTime}, #{updateTime}, #{createUser}, #{updateUser}, #{status})
   
9.     </insert>
   
10. </mapper>

复制代码

useGeneratedKeys="true" keyProperty="id"

1. //向菜品表插入1条数据
   
2.         dishMapper.insert(dish);//后绪步骤实现
   
3. 
   
4.         //获取insert语句生成的主键值
   
5.         Long dishId = dish.getId();

复制代码