MyBatis 新增数据成功返回自增主键ID值

最新推荐文章于 2024-08-12 06:00:00 发布

@不白

最新推荐文章于 2024-08-12 06:00:00 发布

阅读量1.2w

点赞数 3

本文链接：https://blog.csdn.net/qq_39726772/article/details/85225856

版权

MySQL 同时被 2 个专栏收录

5 篇文章 0 订阅

订阅专栏

SpringMVC

5 篇文章 0 订阅

订阅专栏

实现：自增ID值将返回到 Commodity（对应 parameterType="com.ljw.po.Commodity"）新增对象的 commodityId（对于 keyProperty="commodityId"）字段

方式一：添加 useGeneratedKeys="true" keyProperty="commodityId"

  <insert id="insertSelective" parameterType="com.ljw.po.Commodity" useGeneratedKeys="true" keyProperty="commodityId">
    insert into commodity
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="commodityCategoryId != null">
        commodity_category_id,
      </if>
      <if test="commodityName != null">
        commodity_name,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="commodityCategoryId != null">
        #{commodityCategoryId,jdbcType=INTEGER},
      </if>
      <if test="commodityName != null">
        #{commodityName,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>

方式二：查询最后自增ID映射到 commodityId 列

<insert id="insertSelective" parameterType="com.ljw.po.Commodity">
    insert into commodity
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="commodityCategoryId != null">
        commodity_category_id,
      </if>
      <if test="commodityName != null">
        commodity_name,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="commodityCategoryId != null">
        #{commodityCategoryId,jdbcType=INTEGER},
      </if>
      <if test="commodityName != null">
        #{commodityName,jdbcType=VARCHAR},
      </if>
    </trim>
    <!-- 关键代码 -->
    <selectKey keyProperty="commodityId" resultType="java.lang.Integer">
      select LAST_INSERT_ID() as commodityId
     </selectKey>
  </insert>