oracle数据库、主键自增长、返回生成的主键

 

 

springmvc框架，oracle数据库，主键自增长，返回生成的主键：

1. oracle数据库建立序列
2. mybatis的sql语句
3. keyProperty="id"为返回的主键
4. 脑子犯抽了，java.lang.Long写成了java.lang. bigdecimal，调了半天，晕死

​
<insert id="insertSelective"   parameterType="com.msunsoft.model.MisQian" >
		<selectKey resultType="java.lang.Long" order="BEFORE" keyProperty="id">
	   		SELECT S_MIS_QIAN.Nextval as id from DUAL
   		</selectKey>
    insert into MIS_QIAN
    <trim prefix="(" suffix=")" suffixOverrides="," >
        <if test="id != null" >
		ID,
      </if>
      <if test="isCode != null" >
        IS_CODE,
      </if>
      <if test="isName != null" >
        IS_NAME,
      </if>
      <if test="hosCode != null" >
        HOS_CODE,
      </if>
      <if test="hosName != null" >
        HOS_NAME,
      </if>
      <if test="qianMoney != null" >
        QIAN_MONEY,
      </if>
      <if test="year != null" >
        YEAR,
      </if>
      <if test="examStatus != null" >
        EXAM_STATUS,
      </if>
      <if test="rejectReason != null" >
        REJECT_REASON,
      </if>
      <if test="repayStatus != null" >
        REPAY_STATUS,
      </if>
      <if test="remark != null" >
        REMARK,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
    <if test="id != null" >
       #{id,jdbcType=DECIMAL},
      </if>
      <if test="isCode != null" >
        #{isCode,jdbcType=DECIMAL},
      </if>
      <if test="isName != null" >
        #{isName,jdbcType=VARCHAR},
      </if>
      <if test="hosCode != null" >
        #{hosCode,jdbcType=DECIMAL},
      </if>
      <if test="hosName != null" >
        #{hosName,jdbcType=VARCHAR},
      </if>
      <if test="qianMoney != null" >
        #{qianMoney,jdbcType=DECIMAL},
      </if>
      <if test="year != null" >
        #{year,jdbcType=VARCHAR},
      </if>
      <if test="examStatus != null" >
        #{examStatus,jdbcType=VARCHAR},
      </if>
      <if test="rejectReason != null" >
        #{rejectReason,jdbcType=VARCHAR},
      </if>
      <if test="repayStatus != null" >
        #{repayStatus,jdbcType=VARCHAR},
      </if>
      <if test="remark != null" >
        #{remark,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>

​