首先定义一个包含分页相关信息的分页类PageResultSet类： package cn.tutorinfo.pagination;import java.util.List;/** *该类描述了一个分页数据集 list中是查询的数据集合 ,pageInfo则描述了附加的页相关的信息 */public class PageResultSetT {private ListT list; /
首先定义一个包含分页相关信息的分页类PageResultSet类：
package cn.tutorinfo.pagination;import java.util.List;/** *该类描述了一个分页数据集 list中是查询的数据集合 ,pageInfo则描述了附加的页相关的信息*/public class PageResultSet<T> { private List<T> list; //当前页的数据信息 private PageInfo pageInfo; //当前页的信息 public List<T> getList() { return list; } public void setList(List<T> list) { this.list = list; } public PageInfo getPageInfo() { return pageInfo; } public void setPageInfo(PageInfo pageInfo) { this.pageInfo = pageInfo; }}其中关于页的信息类PageInfo 定义如下：
package cn.tutorinfo.pagination;/** * 该类描述了分页记录集中的关于页的信息 */public class PageInfo { private int totalRow; //总共记录数 private int totalPage; //总共页数 private int currentPage = 1; //当前页，默认为1 private int pageSize = 20; //页的大小 private boolean hasPrevious; private boolean hasNext; private boolean bof; private boolean eof; /* * 构造方法 @param totalRow 总记录数 @param pageSize 页的大小 @param page 页码 */ public PageInfo(int totalRow, int pageSize, int page) { this.totalRow = totalRow; this.pageSize = pageSize; // 根据页大小和总记录数计算出总页数 this.totalPage = countTotalPage(this.pageSize, this.totalRow); // 修正当前页 setCurrentPage(page); init(); } public int getTotalPage() { return totalPage; } public int getCurrentPage() { return this.currentPage; } // 修正计算当前页 public void setCurrentPage(int currentPage) { if(currentPage>this.totalPage){ this.currentPage=this.totalPage; }else if (currentPage<1){ this.currentPage=1; } else{ this.currentPage=currentPage; } } // 获取分页大小 public int getPageSize() { return pageSize; } // 设置分页大小 public void setPageSize(int pageSize) { this.pageSize = pageSize; } // 获取当前页记录的开始索引 public int getBeginIndex() { int beginIndex = (currentPage - 1) * pageSize; // 索引下标从0开始 return beginIndex; } // 计算总页数 public int countTotalPage(int pageSize, int totalRow) { int totalPage = totalRow % pageSize == 0 ? totalRow / pageSize : totalRow / pageSize + 1; return totalPage; } // 返回下一页的页码 public int getNextPage() { if (currentPage + 1 >= this.totalPage) { // 如果当前页已经是最后页 则返回最大页 return this.totalPage; } return currentPage + 1; } // 返回前一页的页码 public int getPreviousPage() { if (currentPage - 1 <= 1) { return 1; } else { return currentPage - 1; } } public boolean isHasPrevious() { return hasPrevious; } public boolean isHasNext() { return hasNext; } public boolean isBof() { return bof; } public boolean isEof() { return eof; } public boolean hasNext() { return currentPage < this.totalPage; } public boolean hasPrevious() { return currentPage > 1; } public boolean isFirst() { return currentPage == 1; } public boolean isLast() { return currentPage >= this.totalPage; } // 初始化信息 private void init() { this.hasNext = hasNext(); this.hasPrevious = hasPrevious(); this.bof = isFirst(); this.eof = isLast(); }}Dao接口层代码：
package cn.tutorinfo.dao; import java.util.List;import cn.tutorinfo.domain.Teacher;public interface TeacherDao { //分页查询显示 public List<Teacher> queryByPage(String hql,int beginIndex,int pageSize); //查询的结果记录总数 public int queryRowCount(final String hql);} DAO实现层代码：
/* * 分页查询显示 * @param hql查询的的hql语句 * @param beginIndex 查询记录的起始索引位置 * @param pageSize 一次查询记录个数 * @return List<Teacher> */ @SuppressWarnings("unchecked") public List<Teacher> queryByPage(String hql, int beginIndex, int pageSize) { Session session = HibernateSessionFactory.getSessionFactory().getCurrentSession(); Transaction transaction = null; try { transaction = session.beginTransaction(); Query query = session.createQuery(hql); query.setFirstResult(beginIndex); query.setMaxResults(pageSize); List<Teacher> list = query.list(); transaction.commit(); return list; } catch (Exception e) { if (null != transaction) { transaction.rollback(); e.printStackTrace(); } } return null; } / / 查询指定HQL的结果记录总数 public int queryRowCount(final String hql) { Session session=HibernateSessionFactory.getSessionFactory().getCurrentSession(); Transaction transaction=null; try{ transaction=session.beginTransaction(); Query query=session.createQuery(hql); int result=query.list().size(); //计算个数 transaction.commit(); return result; }catch (Exception e){ if (null!=transaction){ transaction.rollback(); e.printStackTrace(); } } return 0; }
业务逻辑层接口：
package cn.tutorinfo.service;import java.util.List; import cn.tutorinfo.domain.Teacher; import cn.tutorinfo.pagination.PageResultSet; public interface TeacherService { /* * @param pagesize 每页大小 * @param page 要显示数据的页 * @return 包含结果集和分页信息的数据集 */ public PageResultSet<Teacher> queryByPage(int pageSize,int Page); }
业务逻辑实现类：
//分页获取记录值 public PageResultSet<Teacher> queryByPage(int pageSize, int page) { String hql = "From Teacher"; //查询HQL语句 int totalRow = teacherDao.queryRowCount(hql); // 计算总记录个数 PageInfo pageinfo = new PageInfo(totalRow, pageSize, page); //获取该页的记录 List<Teacher> list = teacherDao.queryByPage(hql, pageinfo.getBeginIndex(), pageinfo.getPageSize()); PageResultSet<Teacher> pageResultSet = new PageResultSet<Teacher>(); pageResultSet.setList(list); pageResultSet.setPageInfo(pageinfo); return pageResultSet; }
struts2 的action中调用业务逻辑实现类来获取页的信息:
package cn.tutorinfo.struts;import cn.tutorinfo.domain.Teacher; import cn.tutorinfo.pagination.PageResultSet; import cn.tutorinfo.service.TeacherService; import com.opensymphony.xwork2.ActionSupport; public class ListTeacherAction extends ActionSupport { private static final long serialVersionUID = -7735757614996395820L; private int page; //接受传递的页码参数 private PageResultSet<Teacher> pageResultSet; private TeacherService service; // 业务逻辑组件类由Spring注入 public int getPage() { return page; } public void setPage(int page) { this.page = page; } public PageResultSet<Teacher> getPageResultSet() { return pageResultSet; } public void setPageResultSet(PageResultSet<Teacher> pageResultSet) { this.pageResultSet = pageResultSet; } public void setService(TeacherService service) { this.service = service; } @Override public String execute() throws Exception { this.pageResultSet = service.queryByPage(15,page); // 显示第page页，显示15条记录 return SUCCESS; } } 业务逻辑实现类中的Dao和Action中的业务逻辑组件类都由spring注入.
okay,以上基本完成.前台jsp页面来显示经过action处理后的分页信息：
<!--正文标题的内容--> <tr> <td> <table width="100%" border="0" cellspacing="1" cellpadding="0" class="thin"> <thead> <tr> <th width="5%"><input type="checkbox" name="checkedAll" id="checkedAll"/></th> <th width="5%">编号</th> <th width="20%">讲师姓名</th> <th width="10%">性别</th> <th width="20%">讲师类别</th> <th widht="20%">讲师介绍</th> <th width="20%">基本操作</th> </tr> </thead> <tbody> <s:iterator value="#request.pageResultSet.list" id="teacher"> <tr> <td><input type="checkbox" name="teacherid" id="teacherid" value="${teacher.id}" /></td> <td><s:property value="#teacher.id" /></td> <td><s:property value="#teacher.name" /></td> <td><s:property value="#teacher.sex" /></td> <td><s:property value="#teacher.teacherType.teacherType" /></td> <td>讲师详细介绍</td> <td><a href="/course/admin/editTeacher.action?id=${teacher.id}">修改</a> | <a href="/course/admin/deleteTeacher.action?id=${teacher.id}" onclick="javascript:return del()">删除 </a></td> </tr> </s:iterator> </tbody> </table> </td> </tr> <!--分页信息显示--> <tr> <td> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="line_table"> <tr> <td align="left">选择： 全选 - 反选 - 不选 </td> <td align="right"> 页码: <s:property value="pageResultSet.pageInfo.currentPage" /> / <s:property value="pageResultSet.pageInfo.totalPage"/> <s:if test="pageResultSet.pageInfo.bof"> 首页 第一页 </s:if> <s:else> <a href="listTeacher.action?page=1">首页</a> <a href="listTeacher.action?page=<s:property value="pageResultSet.pageInfo.currentPage-1"/>">上一页</a> </s:else> <s:if test="pageResultSet.pageInfo.eof"> 下一页 末页 </s:if> <s:else> <a href="listTeacher.action?page=<s:property value="pageResultSet.pageInfo.currentPage+1"/>">下一页</a> <a href="listTeacher.action?page=<s:property value="pageResultSet.pageInfo.totalPage"/>">末页</a> </s:else> </td> </tr> </table> </td> </tr>
调用: http://localhost:8080/appName/listTeacher.action?page=2
则显示所有教师信息中的第二页中的全部数据
扫一扫
1576
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
