java+oracle+sql+分页

http://www.cnblogs.com/scy251147/archive/2011/04/16/2018296.html 存储过程分页

 

String sql = "select name, birthdate, age, phone, adress from (select A.*,rownum rn from (select * from employee)A where rownum <= "+up.getCurPage()*up.getMaxNumber()+") where rn >= "+(up.getCurPage() - 1)*up.getMaxNumber()+"";

up.getCurPage()--当前页，up.getMaxNumber()--每页做大条数

up--分页类
  Session session = this.getHibernateTemplate().getSessionFactory().openSession();
  Query query = session.createSQLQuery(sql);
  List employeeList = query.list();
  return employeeList;