三大框架分页.doc

三大框架分页的实现：DAO里写法：/查出页面要显示的字段 -分页代码 页面上的查询全部public List page(Integer pageno) / TODO Auto-generated method stublog.debug(find TblNewsclass instance);try String sql = select new TblNews(id,title,pubdate,status) from TblNews;Query query = getHibernateTemplate().getSessionFactory().getCurrentSession().createQuery(sql);query.setFirstResult(pageno);query.setMaxResults(3); /设置每页显示的条数List result = query.list();log.debug(delete successful);return result; catch (RuntimeException re) log.error(delete failed, re);throw re;public Integer getRows() /查询出数据库里的条数/ TODO Auto-generated method stublog.debug(find TblNewsclass instance);try String sql = select count(*) from TblNews;Query query = getHibernateTemplate().getSessionFactory().getCurrentSession().createQuery(sql);List list = query.list();log.debug(delete successful);return (Long)list.get(0).intValue(); catch (RuntimeException re) log.error(delete failed, re);throw re;Action里的代码实现：private Integer totalElements;/总记录数private Integer pageNow=1;/当前页private Integer pageSize=3;/当前页面的记录数private Integer pageCount;/总页数private Integer no;上面就个成员变量再给个set（）get（）方法；/查询全部public String findAll()throws ExceptionList list = newsService.page(getRowsno(); /参数是算出的页面的总条数 if(list.size()!=0)ActionContext.getContext().put(news,list);return findAllSuccess;else return ERROR;/分页算法public Integer getRowsno()Integer totalElements = newsService.getRows(); pageCount = (totalElements + pageSize - 1) / pageSize;/计算出总页数 if(pageNow pageCount) pageNow = pageCount; no = (pageNow -1)*pageSize;/实际的记录开始数return no;Jsp页