先定义一个sql
最好写好排序规则
比如
sql = select * from student order by age
“SELECT * FROM ( SELECT A.*,ROWNUM RN FROM (” + sql + ") A WHERE ROWNUM <= " + pageIndex * pageSize + " ) WHERE RN > " +(pageIndex- 1) * pageSize
先定义一个sql
最好写好排序规则
比如
sql = select * from student order by age
“SELECT * FROM ( SELECT A.*,ROWNUM RN FROM (” + sql + ") A WHERE ROWNUM <= " + pageIndex * pageSize + " ) WHERE RN > " +(pageIndex- 1) * pageSize