oracle分頁語句

標籤：

以Student表為例進行分頁純sql分頁

 SELECT * FROM (       SELECT ROWNUM,A.* FROM (            SELECT *            FROM STUDENT ORDER BY createTime DESC       )A WHERE ROWNUM <= 10 )  WHERE ROWNUM >=1;

mybatis分頁

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" ><sqlMap namespace="student"><typeAlias alias="Student" type="com.bobo.code.model.Student" /><select id="select" resultClass="Student">SELECT * FROM(SELECT  A.*,ROWNUM FROM (SELECT * FROMSTUDENT) AWHERE  <![CDATA[ ROWNUM <=  #minRownnum#]]>)WHERE  <![CDATA[ROWNUM >=   #maxRownum#]]></select><select id="count" resultClass="java.lang.Integer">SELECT count(*) FROM STUDENT</select></sqlMap>

　　

queryMap.put("minRownnum", (pageNumber - 1)*Pager.DEFAULT_PAGE_SIZE +1);//oracle rownum起queryMap.put("maxRownum", pageNumber * Pager.DEFAULT_PAGE_SIZE );//oracle rownum止

　　

開發過程異常無法轉換為內部表示

當Student的屬性id 為Integer,和資料庫中的欄位ID為VARCHAR2 導致不對應會取不出資料

oracle分頁語句