MySQL： Select ... from ...where ...order by...limit start,pageNum

例：比如从  取  个数据 select * from table limit ,

String sql = "select * from addressbook where limit "+(currentPage-)*pageRecord +","+pageRecord +"";

//select * from 表名 【条件】limit M,N;

//M为从第几个记录开始，比如每页显示条记录，第二页就必须从第条记录开始

//N每页读几个数据

Oracle：select * from (select rownum,name from table where rownum <= endIndex ) where rownum > startIndex

例：例如从表 Sys_option(主键为 sys_id)中从  条记录还是检索  条记录，语句如下： SELECT * FROM (SELECT ROWNUM R,t1.* From Sys_option t1 where rownum <=  ) t2 Where t2.R > ;

String sqls = "select * from ( select rownum rn,t.* from addressbook t where rownum <= "+currentPage*pageRecord+" ) where rownum > "+(currentPage -)*pageRecord;