数据库分页

1. 数据库分页：
  mysql:
       select * from A limit startRow,endRow
   oracle:
        select b.* from (select a.*,rownum as linenum from (select * from A)        a where rownum<= endRow) b where linenum >= startRow
  
Hibernate分页
Query q = session.createQuery("from Cat as c");;  
q.setFirstResult(20000);;  
q.setMaxResults(100);;  
List l = q.list();;