mybatis添加后返回主键

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

Mr_ZhangAdd

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

阅读量614

点赞数 1

分类专栏： Mybatis

本文链接：https://blog.csdn.net/Mr_ZhangAdd/article/details/86702248

版权

Mybatis 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

useGeneratedKeys="true" keyProperty="mediaId"【实体中的属性】 keyColumn="media_id"【数据库中的字段】

<insert id="insertSelective" useGeneratedKeys="true" keyProperty="mediaId" keyColumn="media_id" parameterType="com.bfc.boperation.model.po.Media">
    insert into bfc_media
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="mediaId != null">
        media_id,
      </if>
      <if test="packageId != null">
        package_id,
      </if>
      <if test="userId != null">
        user_id,
      </if>
      <if test="showOrder != null">
        show_order,
      </if>
      <if test="mediaUrl != null">
        media_url,
      </if>
      <if test="mediaThumbUrl != null">
        media_thumb_url,
      </if>
      <if test="mediaDate != null">
        media_date,
      </if>
      <if test="mediaDevice != null">
        media_device,
      </if>
      <if test="mediaTitle != null">
        media_title,
      </if>
      <if test="mediaDesc != null">
        media_desc,
      </if>
      <if test="mediaIndex != null">
        media_index,
      </if>
      <if test="mediaType != null">
        media_type,
      </if>
      <if test="status != null">
        status,
      </if>
      <if test="createDate != null">
        create_date,
      </if>
      <if test="lastUpdateDate != null">
        last_update_date,
      </if>
      <if test="visible != null">
        visible,
      </if>
      <if test="channel != null">
        channel,
      </if>
      <if test="mediaOriginName != null">
        media_origin_name,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="mediaId != null">
        #{mediaId,jdbcType=BIGINT},
      </if>
      <if test="packageId != null">
        #{packageId,jdbcType=BIGINT},
      </if>
      <if test="userId != null">
        #{userId,jdbcType=BIGINT},
      </if>
      <if test="showOrder != null">
        #{showOrder,jdbcType=INTEGER},
      </if>
      <if test="mediaUrl != null">
        #{mediaUrl,jdbcType=VARCHAR},
      </if>
      <if test="mediaThumbUrl != null">
        #{mediaThumbUrl,jdbcType=VARCHAR},
      </if>
      <if test="mediaDate != null">
        #{mediaDate,jdbcType=TIMESTAMP},
      </if>
      <if test="mediaDevice != null">
        #{mediaDevice,jdbcType=VARCHAR},
      </if>
      <if test="mediaTitle != null">
        #{mediaTitle,jdbcType=VARCHAR},
      </if>
      <if test="mediaDesc != null">
        #{mediaDesc,jdbcType=VARCHAR},
      </if>
      <if test="mediaIndex != null">
        #{mediaIndex,jdbcType=INTEGER},
      </if>
      <if test="mediaType != null">
        #{mediaType,jdbcType=INTEGER},
      </if>
      <if test="status != null">
        #{status,jdbcType=INTEGER},
      </if>
      <if test="createDate != null">
        #{createDate,jdbcType=TIMESTAMP},
      </if>
      <if test="lastUpdateDate != null">
        #{lastUpdateDate,jdbcType=TIMESTAMP},
      </if>
      <if test="visible != null">
        #{visible,jdbcType=INTEGER},
      </if>
      <if test="channel != null">
        #{channel,jdbcType=INTEGER},
      </if>
      <if test="mediaOriginName != null">
        #{mediaOriginName,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>