ssh实现分页显示

1.后台数据的读取

用hibernate的criteria 跟据设定查询条件，初始位置，读取数量每次从数据库读取一定量的数据供前台显示，自己写了一段

 

public ResultSet getScrollData(Integer eventType, String bikeid, int firstIndex, int pageSize) { ResultSet result = new ResultSet(); try { Criteria criteria = getSession().createCriteria( we.wine.persistence.domain.Event.class); // 设置条件 criteria.add(Expression.eq("eventype.id", eventType)); if (bikeid != null) { criteria.add(Expression.eq("code", bikeid)); } int totalCount = ((Integer) criteria.setProjection( Projections.rowCount()).uniqueResult()).intValue(); //总数据量 criteria.setProjection(null); List items = criteria.setFirstResult(firstIndex).setMaxResults( pageSize).list(); //设置读取的最大值 int totalNumber; if (totalCount <= pageSize) { totalNumber = 1; } else if (totalCount % pageSize != 0) { totalNumber = totalCount / pageSize + 1; } else totalNumber = totalCount / pageSize; result.setList(items); result.setTotalNumber(totalNumber); } catch (RuntimeException re) { log.error("get failed", re); throw re; } return result; }

这样读取，在多次查询后，系统将会崩溃，所有的Action都不能起作用。 失败~~~~~~~~~~

处理方法有：1.在每次查询后，关闭session ，但这样做hibernate的懒加载就不能用了，会报session已关闭的错误，不用懒加载，自己写sql辛苦，不行！！放弃。

     2.在web.xml中配置过滤器

   <filter>
   <filter-name>hibernateFilter</filter-name>
   <filter-class>
    org.springframework.orm.hibernate3.support.OpenSessionInViewFilter
   </filter-class>
   <init-param>
    <param-name>singleSession</param-name>
    <param-value>true</param-value>
   </init-param>
  </filter>
  <filter-mapping>
   <filter-name>hibernateFilter</filter-name>
   <url-pattern>*.do</url-pattern>
  </filter-mapping>

 

这样就解决了问题， 但是此时必须要为DAO配置spring事务，spring事务的配置可以参考后面文章 “spring事务配置” 不然执行添加、删除操作会出错。

 

 2.struts 中action的处理

 public class CheckMaintainAction extends DispatchAction { /* * Generated Methods */ private IHandleBroBikeService handleBroBikeServ; private int currentpage = 1; private int pageSize = 10; private String bikeid = null; public IHandleBroBikeService getHandleBroBikeServ() { return handleBroBikeServ; } public void setHandleBroBikeServ(IHandleBroBikeService handleBroBikeServ) { this.handleBroBikeServ = handleBroBikeServ; } public ActionForward search(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { // TODO Auto-generated method stub CheckMaintainForm checkForm = (CheckMaintainForm) form; HttpSession session = request.getSession(); currentpage=1; if (!checkForm.getBikeid().equals("")) { bikeid = checkForm.getBikeid(); } else { bikeid = null; } int firstIndex=(currentpage-1)*pageSize; ResultSet result = handleBroBikeServ.getEventPageData(bikeid, firstIndex, pageSize); request.setAttribute("currentpage", new Integer(currentpage)); session.setAttribute("totalpage", new Integer(result.getTotalNumber())); request.setAttribute("eventlist", result.getList()); return mapping.findForward("success"); } /** * * @param mapping * @param form * @param request * @param response * @return */ public ActionForward change(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { // TODO Auto-generated method stub CheckMaintainForm checkForm = (CheckMaintainForm) form; HttpSession session = request.getSession(); int totalpage = ((Integer) session.getAttribute("totalpage")) .intValue(); if (checkForm.getTextfield() != null) { int page = checkForm.getTextfield().intValue(); if (page > totalpage) { currentpage = totalpage; } else if (page < 1) { currentpage = 1; } else currentpage = page; } int firstIndex = (currentpage - 1) * pageSize; if (checkForm.getBikeid() != null && !checkForm.getBikeid().trim().equals("")) { bikeid = checkForm.getBikeid(); } ResultSet result = handleBroBikeServ.getEventPageData(bikeid, firstIndex, pageSize); request.setAttribute("currentpage", new Integer(currentpage)); session.setAttribute("totalpage", new Integer(result.getTotalNumber())); request.setAttribute("eventlist", result.getList()); return mapping.findForward("success"); } /** * * @param mapping * @param form * @param request * @param response * @return */ public ActionForward page(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { // TODO Auto-generated method stub HttpSession session = request.getSession(); int totalpage = ((Integer) session.getAttribute("totalpage")) .intValue(); if (request.getParameter("action") != null) { if (request.getParameter("action").equals("first")) { currentpage = 1; } else if (request.getParameter("action").equals("last")) { currentpage = totalpage; } else if (request.getParameter("action").equals("next")) { if (currentpage < totalpage) currentpage++; else currentpage = totalpage; } else { if (currentpage > 1) currentpage--; else currentpage = 1; } } int firstIndex = (currentpage - 1) * pageSize; ResultSet result = handleBroBikeServ.getEventPageData(bikeid, firstIndex, pageSize); request.setAttribute("currentpage", new Integer(currentpage)); session.setAttribute("totalpage", new Integer(result.getTotalNumber())); request.setAttribute("eventlist", result.getList()); return mapping.findForward("success"); } }

 

 

 3.前台显示

 

部分代码

  <logic:notEmpty name="eventlist"> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td> <table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#a8c7ce" οnmοuseοver="changeto()" οnmοuseοut="changeback()"> <tr> <td width="10%" height="20" bgcolor="d3eaef"><div align="center"><span class="STYLE10">自行车编号</span></div></td> <td width="15%" height="20" bgcolor="d3eaef"><div align="center"><span class="STYLE10">故障日期</span></div></td> <td width="14%" height="20" bgcolor="d3eaef"><div align="center"><span class="STYLE10">事件优先级</span></div></td> <td width="16%" height="20" bgcolor="d3eaef"><div align="center"><span class="STYLE10">责任人</span></div></td> <td width="27%" height="20" bgcolor="d3eaef"><div align="center"><span class="STYLE10">详细描述</span></div></td> </tr> <logic:notEmpty name="eventlist"> <logic:iterate id="event" name="eventlist" type="we.wine.persistence.domain.Event"> <tr> <td height="20" bgcolor="#FFFFFF"><div align="center"><span class="STYLE19"><bean:write name="event" property="code"/> </span></div></td> <td height="20" bgcolor="#FFFFFF"><div align="center"><bean:write name="event" property="time"/></div></td> <td height="20" bgcolor="#FFFFFF"><div align="center"><bean:write name="event" property="level.name"/> </div></td> <td height="20" bgcolor="#FFFFFF"><div align="center"><bean:write name="event" property="employeeId"/></div></td> <td height="20" bgcolor="#FFFFFF"><div align="center"><bean:write name="event" property="description"/></div></td> </tr> </logic:iterate> </logic:notEmpty> </table> </td> </tr> <tr> <td height="30"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="33%"><div align="left"><span class="STYLE22">    当前第<strong><%=request.getAttribute("currentpage") %></strong> 页，共 <strong><%=session.getAttribute("totalpage") %> 页</span></div></td> <td width="67%"><table width="312" border="0" align="right" cellpadding="0" cellspacing="0"> <tr> <td width="49"> <div align="center"> <a href='<html:rewrite action="/checkMaintain"></a>?method=page&action=first'> <img src="pic/main_54.gif" mce_src="pic/main_54.gif" width="40" height="15" /></a> </div> </td> <td width="49"> <div align="center"> <a href='<html:rewrite action="/checkMaintain"></a>?method=page&action=previous'><img src="pic/main_56.gif" mce_src="pic/main_56.gif" width="45" height="15" /></a> </div> </td> <td width="49"> <div align="center"> <a href='<html:rewrite action="/checkMaintain"></a>?method=page&action=next'><img src="pic/main_58.gif" mce_src="pic/main_58.gif" width="45" height="15" /></a> </div> </td> <td width="49"> <div align="center"> <a href='<html:rewrite action="/checkMaintain"></a>?method=page&action=last'><img src="pic/main_60.gif" mce_src="pic/main_60.gif" width="40" height="15" /></a> </div> </td> <td width="80" class="STYLE22"><div align="center">转到</div></td> <td width="22"> <div align="center"> <html:text property="textfield" style="width:30px"></html:text> </div> </td> <td width="22" class="STYLE22"><div align="center">页</div></td> <td width="35"><input type="submit" value="转" onClick="method.value='change'"></input> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </logic:notEmpty>

 

发现还是不错滴\(^o^)/~