mybatis插入值的时候返回对象的主键值

原创

永夜不落 2022-07-20 11:45:56 博主文章分类：MyBatis ©著作权

文章标签 ide vim 文章分类 后端开发

©著作权归作者所有：来自51CTO博客作者永夜不落的原创作品，请联系作者获取转载授权，否则将追究法律责任

mapping文件：

<insert id="insert" parameterType="com.vimtech.bms.business.riskprojectapproval.domain.RiskProjectApproval" >
    insert into WF_RISK_PROJECT_APPROVAL (RISKTGID, PROJID, CREATEDATE, 
      UPDATEDATE, STATUS, CONCLUSION, 
      CREATOR, RISKTYPE, APPLYTYPE, 
      ISCOMPENSATORY)
    values (#{risktgid,jdbcType=NUMERIC}, #{projid,jdbcType=NUMERIC}, #{createdate,jdbcType=TIMESTAMP}, 
      #{updatedate,jdbcType=TIMESTAMP}, #{status,jdbcType=INTEGER}, #{conclusion,jdbcType=VARCHAR}, 
      #{creator,jdbcType=VARCHAR}, #{risktype,jdbcType=INTEGER}, #{applytype,jdbcType=INTEGER}, 
      #{iscompensatory,jdbcType=INTEGER})
      <selectKey resultType="long" keyProperty="risktgid">
        SELECT @@IDENTITY AS RISKTGID
      </selectKey>
  </insert>
  <insert id="insertSelective" parameterType="com.vimtech.bms.business.riskprojectapproval.domain.RiskProjectApproval" >
    insert into WF_RISK_PROJECT_APPROVAL
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="risktgid != null" >
        RISKTGID,
      </if>
      <if test="projid != null" >
        PROJID,
      </if>
      <if test="createdate != null" >
        CREATEDATE,
      </if>
      <if test="updatedate != null" >
        UPDATEDATE,
      </if>
      <if test="status != null" >
        STATUS,
      </if>
      <if test="conclusion != null" >
        CONCLUSION,
      </if>
      <if test="creator != null" >
        CREATOR,
      </if>
      <if test="risktype != null" >
        RISKTYPE,
      </if>
      <if test="applytype != null" >
        APPLYTYPE,
      </if>
      <if test="iscompensatory != null" >
        ISCOMPENSATORY,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="risktgid != null" >
        #{risktgid,jdbcType=NUMERIC},
      </if>
      <if test="projid != null" >
        #{projid,jdbcType=NUMERIC},
      </if>
      <if test="createdate != null" >
        #{createdate,jdbcType=TIMESTAMP},
      </if>
      <if test="updatedate != null" >
        #{updatedate,jdbcType=TIMESTAMP},
      </if>
      <if test="status != null" >
        #{status,jdbcType=INTEGER},
      </if>
      <if test="conclusion != null" >
        #{conclusion,jdbcType=VARCHAR},
      </if>
      <if test="creator != null" >
        #{creator,jdbcType=VARCHAR},
      </if>
      <if test="risktype != null" >
        #{risktype,jdbcType=INTEGER},
      </if>
      <if test="applytype != null" >
        #{applytype,jdbcType=INTEGER},
      </if>
      <if test="iscompensatory != null" >
        #{iscompensatory,jdbcType=INTEGER},
      </if>
    </trim>
    <selectKey resultType="long" keyProperty="risktgid">
          SELECT @@IDENTITY AS RISKTGID
    </selectKey>
  </insert>