oracle分页语句解释,oracle分页语句

以Student表为例进行分页

纯sql分页

SELECT * FROM (

SELECT ROWNUM,A.* FROM (

SELECT *

FROM STUDENT ORDER BY createTime DESC

)A WHERE ROWNUM <= 10 )

WHERE ROWNUM >=1;

mybatis分页

SELECT * FROM

(

SELECT A.*,ROWNUM FROM

(SELECT * FROMSTUDENT) A

WHERE

)

WHERE = #maxRownum#]]>

SELECT count(*) FROM STUDENT

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 导致不对应会取不出数据

原文：http://www.cnblogs.com/whatlonelytear/p/4848552.html