SSH分页查询留言记录 Dao层: /** * 分页查询全部留言 */ public List<Ly> getMessageByPaging(int currentPage,int pageSize){ Session session=this.getHibernateTemplate().getSessionFactory().openSession(); Query query=session.createQuery("from Ly "); int startRow=(currentPage-1)*pageSize; query.setFirstResult(startRow); query.setMaxResults(pageSize); List<Ly> message=query.list(); session.close(); return message; } /** * 得到留言总数 */ public int getTotle(){ List<Ly> message=this.getHibernateTemplate().find("from Ly"); return message.size(); } /** * 分页查询指定课程留言 */ public List<Ly> getMessageByCoursePaging(int courseId,int currentPage,int pageSize){ Session session=this.getHibernateTemplate().getSessionFactory().openSession(); Query query=session.createQuery("from Ly as a where a.kcId.id=?"); query.setParameter(0, courseId); int startRow=(currentPage-1)*pageSize; query.setFirstResult(startRow); query.setMaxResults(pageSize); List<Ly> message=query.list(); session.close(); return message; } /** * 获取指定课程留言总数 */ public int getTotleByCourse(int courseId){ List<Ly> mesByCourse = this.getHibernateTemplate().find("from Ly as a where a.kcId.id=?",courseId); return mesByCourse.size(); } Service层: /** * 分页查询 */ public List<Ly> getMessageByPaging(int currentPage,int pageSize){ return lyDao.getMessageByPaging(currentPage, pageSize); } /** * 得到留言总数 */ public int getTotal(){ return lyDao.getTotle(); } /** * 分页查询指定课程留言 */ public List<Ly> getMesByCoursePaging(int courseId,int currentPage,int pageSize){ return lyDao.getMessageByCoursePaging(courseId, currentPage, pageSize); } /** * 得到指定课程留言总数 */ public int getTotalByCourse(int courseId){ return lyDao.getTotleByCourse(courseId); } Action层: private int currentPage; private int totalPage; private int totalSize; private int pageSize = 10; /** * 获得全部留言分页实现 * @return */ public String browsePaging() { if(currentPage==0){ currentPage = 1; } totalSize=messageService.getTotal(); int mod = totalSize%pageSize; if(mod==0){ totalPage = totalSize/pageSize; }else totalPage = totalSize/pageSize+1; setGetMessage(messageService.getMessageByPaging(currentPage, pageSize)); return "success"; } /** * 保存留言后分页实现 */ public String saveMessagePaging(){ if(currentPage==0){ currentPage = 1; } totalSize=messageService.getTotalByCourse(courseId); int mod = totalSize%pageSize; if(mod==0){ totalPage = totalSize/pageSize; }else totalPage = totalSize/pageSize+1; setGetMessage(messageService.getMesByCoursePaging(courseId, currentPage, pageSize)); return "success"; } JSP页面: <!--全部留言--> <center>当前是第${currentPage}页,共有${totalPage}页 <a href="browsePaging.action?currentPage=1" >首页</a> <s:if test="%{currentPage>1}"><a href="browsePaging.action?currentPage=${currentPage-1}" >上一页</a> <a href="browsePaging.action?currentPage=${currentPage-1}" >${currentPage-1}</a></s:if> <a href="browsePaging.action?currentPage=${currentPage}" >${currentPage}</a> <s:if test="%{totalPage>currentPage}"><a href="browsePaging.action?currentPage=${currentPage+1}" >${currentPage+1}</a> <a href="browsePaging.action?currentPage=${currentPage+1}" >下一页</a></s:if> <a href="browsePaging.action?currentPage=${totalPage}" >尾页</a></center> <!--根据课程得到的留言--> <center> 当前是第${currentPage}页,共有${totalPage}页 <a href="saveMessagePaging.action?currentPage=1&courseId=${courseId}" >首页</a> <s:if test="%{currentPage>1}"><a href="saveMessagePaging.action?currentPage=${currentPage-1}&courseId=${courseId}" >上一页</a> <a href="saveMessagePaging.action?currentPage=${currentPage-1}&courseId=${courseId}" >${currentPage-1}</a></s:if> <a href="saveMessagePaging.action?currentPage=${currentPage}&courseId=${courseId}" >${currentPage}</a> <s:if test="%{totalPage>currentPage}"><a href="saveMessagePaging.action?currentPage=${currentPage+1}&courseId=${courseId}" >${currentPage+1}</a> <a href="saveMessagePaging.action?currentPage=${currentPage+1}&courseId=${courseId}" >下一页</a></s:if> <a href="saveMessagePaging.action?currentPage=${totalPage}&courseId=${courseId}" >尾页</a> </center>
SSH 分页方法一,基于struts2
转载本文章为转载内容,我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题,欢迎原作者联系我们进行内容更正或删除文章。
下一篇:s2sh整合(详细版)
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
SSH 分页方法一,基于struts2
SSH分页查询留言记录 Dao层:/
分页查询 hibernate 分页 -
struts2实现分页
参考别人的基础上,实现自己项目的分页1.页面:page.jsp引入到其他列表页面中
struts javascript null function string -
Struts2实现简单分页
Struts2+mysql实现简单分页
java struts2.0 分页 struts html -
struts2入门(一)struts2初识
Struts 2 概述 Struts 2是Struts的下一代产品,是在 struts 1和We开,所以Struts...
java spring struts2 大数据 maven