mybatis orcale 返回自增序列主键

<insert id="insertSelective" parameterType="info.ycl.ucode.model.oracle.UcodeRule" >
  <selectKey keyProperty="id" order="AFTER" resultType="java.lang.Long">
   select T_UCODE_RULE_SEQ.currval from dual  
</selectKey>

  insert into T_UCODE_RULE
  <trim prefix="(" suffix=")" suffixOverrides="," >
      ID,
    <if test="providerId != null" >
      PROVIDER_ID,
    </if>
  </trim>
  <trim prefix="values (" suffix=")" suffixOverrides="," >
    T_UCODE_RULE_SEQ.nextval,
    <if test="providerId != null" >
      #{providerId,jdbcType=DECIMAL},
    </if>
  </trim>
</insert>

 

 

<selectKey keyProperty="id" order="AFTER" resultType="java.lang.Long">

select T_UCODE_RULE_SEQ.currval from dual

</selectKey>