Oracle结合Mybatis实现取表的10条数据

<select id="selectStudent" parameterType="hashmap" resultMap="BaseResultMap">

  select *

  from (

  select rownum rn, A.* from student A

  where STATUS = '99'

  and score <![CDATA[>]]> #{scores,jdbcType=INTEGER})

  where rn <![CDATA[<=]]> #{number,jdbcType=INTEGER}

 </select>

<select id="getCode" resultType="java.lang.String">

  select 'TRD'||to_char(sysdate,'yyyymmdd')||lpad(to_char(SQ_ORD_PURCHASE_ID.nextval), 5, '0') code from dual

</select>

<select id="getCode" resultType="java.lang.String" useCache="false" flushCache="false">

select 'TRD'||to_char(sysdate,'yyyymmdd')||lpad(to_char(SQ_ORD_PURCHASE_ID.nextval), 5, '0') code from dual

</select>