mybatis新增后返回主键

短命女 2022-01-31 03:51 282阅读 0赞

使用selectKey  
  
SelectKey在Mybatis中是为了解决Insert数据时不支持主键自动生成的问题，他可以很随意的设置生成主键的方式。  
  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hoY2NjY2ho_size_16_color_FFFFFF_t_70][]  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hoY2NjY2ho_size_16_color_FFFFFF_t_70 1][]

<insert id="insertSelective" parameterType="com.xxx.dao.webdb.model.ApayTxnLog">
      insert into T_APAY_TXN_LOG
      <trim prefix="(" suffix=")" suffixOverrides=",">
        <if test="rowId != null">
          ROW_ID,
        </if>
        <if test="fyDate != null">
          FY_DATE,
        </if>
        <if test="fySsn != null">
          FY_SSN,
        </if>
        <if test="merId != null">
          MER_ID,
        </if>
        <if test="orderId != null">
          ORDER_ID,
        </if>
    
      </trim>
      <trim prefix="values (" suffix=")" suffixOverrides=",">
        <if test="rowId != null">
          #{rowId,jdbcType=INTEGER},
        </if>
        <if test="fyDate != null">
          #{fyDate,jdbcType=CHAR},
        </if>
        <if test="fySsn != null">
          #{fySsn,jdbcType=CHAR},
        </if>
        <if test="merId != null">
          #{merId,jdbcType=CHAR},
        </if>
        <if test="orderId != null">
          #{orderId,jdbcType=VARCHAR},
        </if>
      </trim>
      <selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="rowId">
        SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM.SYSDUMMY1
      </selectKey>
    </insert>

参考

[https://blog.csdn.net/weixin\_43611145/article/details/86594218][https_blog.csdn.net_weixin_43611145_article_details_86594218]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hoY2NjY2ho_size_16_color_FFFFFF_t_70]: /images/20220131/f51afb9f02144c8ab0226798e709891d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hoY2NjY2ho_size_16_color_FFFFFF_t_70 1]: /images/20220131/84a9c32efbc7464ab264ef8f6221052a.png
[https_blog.csdn.net_weixin_43611145_article_details_86594218]: https://blog.csdn.net/weixin_43611145/article/details/86594218