分页设计与实现

一、首先写出DAO层的获取分页数据方法

@SuppressWarnings("unchecked") @Transactional(readOnly=true,propagation=Propagation.NOT_SUPPORTED) public <T> QueryResult<T> getScrollData(Class<T> entityClass, int firstindex,int maxresult,String wherejpql,Object[] queryParams,LinkedHashMap<String,String> order) { QueryResult<T> qr=new QueryResult<T>(); String entityName=getEntityName(entityClass); Query query=em.createQuery("select o from "+entityName+" o "+(wherejpql==null ? "" :"where "+wherejpql)+buildOrderby(order)); setQueryParams(query, queryParams); if(firstindex!=-1 && maxresult!=-1){ query.setFirstResult(firstindex); query.setMaxResults(maxresult); } qr.setResultlist(query.getResultList()); query=em.createQuery("select count(o) from "+entityName+" o "+(wherejpql==null ? "" :"where "+wherejpql)); setQueryParams(query, queryParams); qr.setTotalrecord((Long)query.getSingleResult()); return qr; } @Transactional(readOnly=true,propagation=Propagation.NOT_SUPPORTED) public <T> QueryResult<T> getScrollData(Class<T> entityClass, int firstindex, int maxresult, LinkedHashMap<String, String> order) { return getScrollData(entityClass, firstindex, maxresult,null, null, order); } @Transactional(readOnly=true,propagation=Propagation.NOT_SUPPORTED) public <T> QueryResult<T> getScrollData(Class<T> entityClass, int firstindex, int maxresult, String wherejpql, Object[] queryParams) { return getScrollData(entityClass, firstindex, maxresult,wherejpql, queryParams, null); } @Transactional(readOnly=true,propagation=Propagation.NOT_SUPPORTED) public <T> QueryResult<T> getScrollData(Class<T> entityClass, int firstindex, int maxresult) { return getScrollData(entityClass, firstindex, maxresult,null, null, null); } @Transactional(readOnly=true,propagation=Propagation.NOT_SUPPORTED) public <T> QueryResult<T> getScrollData(Class<T> entityClass) { return getScrollData(entityClass,-1, -1); } /** * 组装order by 语句 * @param order * @return example:order by o.key1 desc,o.key2 asc */ protected String buildOrderby(LinkedHashMap<String,String> order){ StringBuffer orderby=new StringBuffer(""); if(order!=null && order.size()>0){ orderby.append(" order by "); for(String key:order.keySet()){ orderby.append("o.").append(key).append(" ").append(order.get(key)).append(","); } orderby.deleteCharAt(orderby.length()-1); } return orderby.toString(); } /** * * @param query * @param queryParams */ protected void setQueryParams(Query query,Object[] queryParams){ if(queryParams!=null && queryParams.length>0){ for(int i=0;i<queryParams.length;i++){ query.setParameter(i+1,queryParams[i]); } } } /** * 获取实体名称 * @param <T> * @param entityClass 实体类 * @return */ protected <T> String getEntityName(Class<T> entityClass){ String entityName=entityClass.getSimpleName(); Entity entity=entityClass.getAnnotation(Entity.class); if(entity.name()!=null && entity.name().length()>0){ entityName=entity.name(); } return entityName; } }

二、写控制层Action

public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { BuyerForm formbean=(BuyerForm)form; LinkedHashMap<String,String> order=new LinkedHashMap<String, String>(); order.put("regTime", "desc"); /** * 定义一个PageView对象，传入每页记录数12，和当前第几页 * 得到开始记录索引 */ PageView<Brand> pv=new PageView<Brand>(12,formbean.getPage()); /** * 调用业务层的查询语句得到记录。 */ QueryResult<Buyer> qr=buyerService.getScrollData(Buyer.class,pv.getFirstResult(), pv.getMaxresult(),order); /** * 调用PageView中一set方法,得到总记录数和总记录。 * 至此完成了页面所需的一切数据的需要。 */ pv.setQueryResult(qr); request.setAttribute("pageView", pv); return mapping.findForward("list"); }

三、由此Action知道必须要定义一个类：PageView，此类用来封闭查询到的分页相关数据的信息。

      下面来看一下这个类的设计：

package cn.yang.bean; import java.util.List; import cn.yang.bean.product.ProductType; public class PageView<T>{ /*分页数据*/ private List<T> records; /*页码开始索引和结束索引*/ private PageIndex pageIndex; /*总页数*/ private long totalpage=1; /*每页显示的记录数*/ private int maxresult=12; /*当前页*/ private int currentpage=1; /*总记录数*/ private long totalrecord; /*开始查询第几个记录*/ private int firstResult; public int getFirstResult() { return firstResult; } public PageView(int maxresult, int currentpage) { this.maxresult = maxresult; this.currentpage = currentpage; this.firstResult=(currentpage-1)*maxresult; } public long getTotalrecord() { return totalrecord; } public void setQueryResult(QueryResult queryResult){ setTotalrecord(queryResult.getTotalrecord()); setRecords(queryResult.getResultlist()); } public void setTotalrecord(long totalrecord) { this.totalrecord = totalrecord; //System.out.println("*********"+this.totalrecord); } public List<T> getRecords() { return records; } public void setRecords(List<T> list) { this.records = list; this.totalpage=totalrecord%maxresult==0?totalrecord/maxresult:totalrecord/maxresult+1; if(totalpage==0) totalpage=1; this.pageIndex=WebTool.getPageIndex(maxresult, currentpage, totalpage); } public PageIndex getPageIndex() { return pageIndex; } public long getTotalpage() { return totalpage; } public int getMaxresult() { return maxresult; } public int getCurrentpage() { return currentpage; } }

通过此类就能获得分页页面所需的所有数据；包括总页码、起始页、结束页、List集合的数据。

其中还有一个类WebTool，此类用以获取起始页与结束页的页码，其代码如下所示：

public class WebTool { public static PageIndex getPageIndex(int maxresult,int currentpage,long totalpage){ long startindex=0; long endindex=0; if(currentpage+maxresult/2<totalpage){ if(currentpage>maxresult/2){ startindex=maxresult%2==0 ? currentpage-maxresult/2+1 : currentpage-maxresult/2; endindex=currentpage+maxresult/2; }else{ startindex=1; endindex=maxresult<totalpage ? maxresult : totalpage; } }else{ startindex=totalpage-maxresult<0 ? 1 : totalpage-maxresult+1; endindex=totalpage; } return new PageIndex(startindex,endindex); } /* public static PageIndex getPageIndex(long viewPageCount,int currentPage,long totalpage){ long startindex=currentPage-(viewPageCount%2==0 ? viewPageCount/2-1 :viewPageCount/2); long endindex=currentPage+viewPageCount/2; if(startindex<1){ startindex=1; endindex=totalpage>viewPageCount ? viewPageCount :totalpage; } if(endindex>totalpage){ endindex=totalpage; startindex=totalpage-viewPageCount<0 ? 1 :totalpage-viewPageCount+1; } return new PageIndex(startindex,endindex); }*/ }

至此分页所需数据已全部获得，剩下的任务就是前端页面的设计，在此不做介绍。