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


    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>

    如上中的selectKey中的写法即可,然后就可以在action中使用了

  • 相关阅读:
    洞察僵尸网络的4条关键线索,你知道吗?
    数据即服务(DaaS)的好处和趋势
    AIOT:什么是智联网,它是未来吗?
    渐变略过效果
    页面头部banner动画效果
    小三角
    监测屏幕宽度
    开关效果
    高级轮播
    手机端跳转页面指定楼层
  • 原文地址:https://www.cnblogs.com/xh_Blog/p/9394578.html
Copyright © 2020-2023  润新知