插入数据后查询最新一条生成的Id

最新推荐文章于 2024-09-27 00:45:01 发布

zw_l

最新推荐文章于 2024-09-27 00:45:01 发布

阅读量401

点赞数 3

文章标签： java mybatis 数据库

本文链接：https://blog.csdn.net/weixin_44953786/article/details/136162546

版权

<insert id="insertSelective" parameterType="com.slzx.finance.entities.FinanceTradeOrder" useGeneratedKeys="true"
        keyProperty="tradeOrderId">
    <selectKey keyProperty="tradeOrderId" resultType="Long" order="AFTER">
        select LAST_INSERT_ID()
    </selectKey>
    insert into finance_trade_order
    <trim prefix="(" suffix=")" suffixOverrides=",">
        <if test="tradeOrderId != null">
            trade_order_id,
        </if>
        <if test="orderId != null">
            order_id,
        </if>
        <if test="tradeType != null">
            trade_type,
        </if>
        <if test="createTime != null">
            create_time,
        </if>
        <if test="updateTime != null">
            update_time,
        </if>
        <if test="orderType != null">
            order_type,
        </if>
        <if test="remarks != null">
            remarks,
        </if>
        <if test="state != null">
            state,
        </if>
        <if test="userId != null">
            user_id,
        </if>
        <if test="money != null">
            money,
        </if>
        <if test="tradeNo != null">
            trade_no,
        </if>
        <if test="depositType != null">
            deposit_type,
        </if>
        <if test="merchantNo != null">
            merchant_no,
        </if>
        <if test="outRequestNo != null">
            out_request_no,
        </if>
        <if test="userType != null">
            user_type,
        </if>
        <if test="createUser != null">
            create_user,
        </if>
        <if test="updateUser != null">
            update_user,
        </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
        <if test="tradeOrderId != null">
            #{tradeOrderId,jdbcType=INTEGER},
        </if>
        <if test="orderId != null">
            #{orderId,jdbcType=VARCHAR},
        </if>
        <if test="tradeType != null">
            #{tradeType,jdbcType=INTEGER},
        </if>
        <if test="createTime != null">
            #{createTime,jdbcType=TIMESTAMP},
        </if>
        <if test="updateTime != null">
            #{updateTime,jdbcType=TIMESTAMP},
        </if>
        <if test="orderType != null">
            #{orderType,jdbcType=BIGINT},
        </if>
        <if test="remarks != null">
            #{remarks,jdbcType=VARCHAR},
        </if>
        <if test="state != null">
            #{state,jdbcType=INTEGER},
        </if>
        <if test="userId != null">
            #{userId,jdbcType=BIGINT},
        </if>
        <if test="money != null">
            #{money,jdbcType=DECIMAL},
        </if>
        <if test="tradeNo != null">
            #{tradeNo,jdbcType=VARCHAR},
        </if>
        <if test="depositType != null">
            #{depositType,jdbcType=INTEGER},
        </if>
        <if test="merchantNo != null">
            #{merchantNo,jdbcType=VARCHAR},
        </if>
        <if test="outRequestNo != null">
            #{outRequestNo,jdbcType=VARCHAR},
        </if>
        <if test="userType != null">
            #{userType,jdbcType=INTEGER},
        </if>
        <if test="createUser != null">
            #{createUser,jdbcType=VARCHAR},
        </if>
        <if test="updateUser != null">
            #{updateUser,jdbcType=VARCHAR},
        </if>
    </trim>
</insert>