使用page项来分页.docVIP

使用Page来分页.txt遇事潇洒一点，看世糊涂一点。相亲是经销，恋爱叫直销，抛绣球招亲则为围标。没有准备请不要开始，没有能力请不要承诺。爱情这东西，没得到可能是缺憾，不表白就会有遗憾，可是如果自不量力，就只能抱憾了。public Page getStudentList(String page) {ResultSet rst = null; ArrayList list = new ArrayList(); int pageNum; if (page == null || page.equals()) pageNum = 1; else pageNum = Integer.parseInt(page);p.setRowsPerPage(6); //每页显示6行 String s1 = select top + pageNum * p.getRowsPerPage() + * from table where ;String s2 = select count(*) from table where ...; pstmt = conn.prepareStatement(s2); rst = pstmt.executeQuery();if (rst.next()) p.setMaxRowCount(rst.getInt(1)); //取得一共的行数 pstmt = null; rst = null; pstmt = conn.prepareStatement(s1, ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); rst = pstmt.executeQuery();int i = (pageNum - 1) * p.getRowsPerPage(); // if (i != 0) rst.absolute(i); while (rst.next()) {...list.add(...);} p.setCurPage(pageNum); //第几页 p.setList(list);//list p.setMaxPage();//最大页数return p; } 特殊用法： public Page searchGroup(Group group, int pageSize) throws DaoException {Page page = new Page();try {Session session = HibernateUtil.currentSession();HibernateUtil.beginTransaction();Example exampleGroup = Example.create(group);exampleGroup.ignoreCase().enableLike(MatchMode.ANYWHERE);//exampleGroup.excludeZeroes();Criteria criteria = session.createCriteria(Group.class).add(exampleGroup).addOrder(Order.asc(groupCreateDate));List list = criteria.list();page.setMaxRowCount(list.size());//page.setRowsPerPage(2);page.setMaxPage();page.setFormName(groupInfoForm);Debug.println(记录的总页数为： + page.getMaxPage());//判断如果分页数大于最大页数，则将页数设置为第一页if (pageSize page.getMaxPage() || pageSize 0) {Debug.println(警告：请求的分页数 +pageSize + 大于该记录的总页数 +page.getMaxPage() + 或者小于 0 ，请求的页数将置为 1 。);pageSize = 1;}//设置当前页数page.setCurPage(pageSize);list = criteria.setMaxResults(page.getRowsPerPage()).setFirstResult((pageSize - 1) * page.getRowsPerPage()).list();page.setList(list);HibernateUmitTransaction();} catch (HibernateException ex) {Hibernat