对java翻页查询代码的封装（jsp+struts+spring）

1.page对象：用于对翻页信息的封装

public class Pages {
 
 /**
  * 当前页
  */
 private  int currentPage = 1;
 @SuppressWarnings("unused")
 /**
  * 总页数
  */
 private  int maxPage = 0;
 /**
  * 每页记录数
  */
 private  int pageSize = GlobalConfigContaint.getPageSize();
 /**
  * 总记录数
  */
 private  int maxSize = 0;

 /**
  * 构造Pages对象
  * @param currentPage 当前页
  */
 public Pages(int currentPage){
  this.currentPage = currentPage==0?1:currentPage;
 }
 /**
  * 构造Pages对象
  * @param currentPage
  * @param pageSize
  */
 public Pages(int currentPage,int pageSize){
  this.currentPage = currentPage==0?1:currentPage;
  this.pageSize = pageSize;
 }
 
 public int getCurrentPage() {
  return currentPage == 0?1:currentPage;
 }

 public void setCurrentPage(int currentPage) {
  this.currentPage = currentPage == 0?1:currentPage;
 }

 public int getMaxPage() {
  return (maxSize+pageSize-1)/pageSize;
 }

 public void setMaxPage(int maxPage) {
  this.maxPage = maxPage;
 }

 public int getPageSize() {
  return pageSize;
 }

 public void setPageSize(int pageSize) {
  this.pageSize = pageSize;
 }

 public int getMaxSize() {
  return maxSize;
 }

 public void setMaxSize(int maxSize) {
  this.maxSize = maxSize;
 }
 /**
  * 分页包装语句
  * @param sql
  * @return
  */
 public  String fenYeSQL(String sql){
  int start = (currentPage-1)*pageSize;
  int end = currentPage*pageSize;
  String str = "select * from (select t1.*,rownum r from (select t.* from ("+sql+") t where rownum<="+end+" ) t1) t2 where t2.r>"+start;
  return str;
 }
 /**
  * 获取总记录数包装语句
  * @param sql
  * @return
  */
 public String maxSizeSQL(String sql){
  return "select count(*) from ("+sql+")";
 }

 public Pages() {
 }

}

 

2.PageSession类：对页面查询信息的处理

 

/**
 * 翻页帮助类
 * @author mz
 *
 */
public class PageSession {
 
 private String requestUri;
 
 public PageSession(HttpServletRequest request){
  this.requestUri = request.getRequestURI() + "?method=" + request.getParameter("method");
 }

 private Pages page = new Pages();
 /**
  * 查询参数集合
  */
 Map<String,String> conditions = new HashMap<String,String>();

 public Map<String, String> getConditions() {
  return conditions;
 }

 public void setConditions(Map<String, String> conditions) {
  this.conditions = conditions;
 }

 public String getRequestUri() {
  return requestUri;
 }

 public void setRequestUri(String requestUri) {
  this.requestUri = requestUri;
 }
 
 public Pages getPage() {
  return page;
 }

 public void setPage(Pages page) {
  this.page = page;
 }

 /**
  * 初始化分页
  * @param request
  * @param keys 查询参数
  * @param keys 查询参数值
  */
 public static PageSession initPageSession(HttpServletRequest request,String[] keys){
  PageSession pageSession = null;
  boolean valueIsNull  = false;
  //从request中获得参数值
  String[] values = new String[keys.length];
  for (int i=0;i<values.length;i++) {
   values[i] = request.getParameter(keys[i]);
   if(values[i] == null){
    values[i] = "";
    valueIsNull = true;
   }
  }
  
  //如果为空则表示：点击翻页或初次请求action
  if(valueIsNull){
   pageSession = (PageSession)request.getSession().getAttribute("pageSession");
   //判断是否为同一个请求action
   if(pageSession != null && pageSession.getRequestUri().indexOf(request.getRequestURI() + "?method=" + request.getParameter("method")) != -1){
    for (int i=0;i<values.length;i++) {
     values[i] = pageSession.getConditions().get(keys[i]);
    }
   }else{
    pageSession = new PageSession(request);
   }
  }else{
   pageSession = new PageSession(request);
   //点击查询
   for (int i=0;i<values.length;i++) {
    pageSession.getConditions().put(keys[i], values[i]);
   }
  }
  
  if(request.getParameter("currentPage") != null){
   pageSession.page.setCurrentPage(DataUtils.getInt(request.getParameter("currentPage")));
  }
  request.setAttribute("page",pageSession.page);
  request.getSession().setAttribute("pageSession",pageSession);
  return pageSession;
 }
}

 

3.jsp翻页代码：

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="gb2312"%>
<%@ taglib prefix="c" uri="/WEB-INF/c.tld"%>
<div class="split_page">
 共${(page.maxPage==0)? 1 : page.maxPage}页&nbsp;当前第${page.currentPage}页&nbsp;
<c:if test="${page!=null}">
    <c:if test="${page.maxPage == 1 || page.maxPage == 0}">
            首页&nbsp;|&nbsp;上一页&nbsp;|&nbsp;下一页&nbsp;|&nbsp;尾页
    </c:if>
 <c:if test="${page.currentPage>1&&page.currentPage<page.maxPage&&page.maxSize!=0}">
   <a href="${pageSession.requestUri }&currentPage=1">首页</a>&nbsp;|&nbsp;  
  <a href="${pageSession.requestUri }&currentPage=${page.currentPage-1}">上一页</a>&nbsp;|&nbsp;
  <a href="${pageSession.requestUri }&currentPage=${page.currentPage+1}">下一页</a>&nbsp;|&nbsp;
  <a href="${pageSession.requestUri }&currentPage=${page.maxPage}">尾页</a>
 </c:if> 
 <c:if test="${page.currentPage<=1&&page.maxPage!=1&&page.maxSize!=0}">
  首页&nbsp;|&nbsp;上一页&nbsp;|&nbsp;
  <a href="${pageSession.requestUri }&currentPage=${page.currentPage+1}">下一页</a>&nbsp;|&nbsp;
  <a href="${pageSession.requestUri }&currentPage=${page.maxPage}">尾页</a>
 </c:if> 
 <c:if test="${page.currentPage>=page.maxPage&&page.maxPage!=1&&page.maxSize!=0}">
  <a href="${pageSession.requestUri }&currentPage=1">首页</a>&nbsp;|&nbsp;
  <a href="${pageSession.requestUri }&currentPage=${page.currentPage-1}">上一页</a>&nbsp;|&nbsp;
  下一页&nbsp;|&nbsp;尾页
 </c:if>     
</c:if>
</div>

 

使用方法：

以上3个类在使用中均不用做修改,约束：（只支持struts的DispatchAction，且struts配置文件中 parameter="method"）

 

只需在action中添加如下代码：

CardBiz cardBiz = (CardBizImpl)this.getService("cardBiz");
  String[] keys = {"organizeId","status","startTime","endTime"};
  PageSession pageSession = PageSession.initPageSession(request,keys);
  //获得查询参数值
  String organizeId = pageSession.getConditions().get("organizeId");
  String status = pageSession.getConditions().get("status");
  String startTime = pageSession.getConditions().get("startTime");
  String endTime = pageSession.getConditions().get("endTime");
  Map<String,Object> conditionMap = new HashMap<String,Object>();
  conditionMap.put("organizeId", DataUtils.getInt(organizeId));
  conditionMap.put("status", DataUtils.getInt(status));
  conditionMap.put("startTime", startTime);
  conditionMap.put("endTime", endTime);

  //分页查询数据（在查询数据时可使用Pages对象的fenYeSQL，maxSizeSQL方法）
  List<CardMO> cardMoList = cardBiz.findMosRukuList(pageSession.getPage(),conditionMap);
  request.setAttribute("cardMoList",cardMoList);