• 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中使用了

  • 相关阅读:
    js中“==”与“===”区别
    java中的除法及求余运算特殊性。
    oracle数据库查询历史某一时刻的表数据
    Java多线程总结(转载)
    I/O之Writer-Reader
    I/O之File
    MYSQL之內链接 左链接 右链接 区别
    ubuntu下编译boost
    linux下编译安装boost库
    搭建无线弱网测试环境
  • 原文地址:https://www.cnblogs.com/xh_Blog/p/9394578.html
Copyright © 2020-2023  润新知