SSM下的分页

爱被打了一巴掌 2021-09-26 06:38 469阅读 0赞

页面：list.jsp

  1. <%@ page language="java" pageEncoding="UTF-8"%>
  2. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
  3. <%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
  4. <%@ taglib prefix="shiro" uri="http://shiro.apache.org/tags"%>
  5. <%@ taglib prefix="tags" tagdir="/WEB-INF/tags"%>
  6. <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
  7. <script src="<c:url value="/js/jquery-ui.js"/>"></script>
  8. <script type="text/javascript">
  9. function buttonSubmit(url){
  10.     document.form.action=url;
  11.     document.form.submit();
  12. }
  13. function del(url){
  14.     if(confirm("确定要删除该活动？")){
  15.         document.form.action=url;
  16.         document.form.submit();
  17.     }
  18. }
  19. </script>
  20. <div class="app-content">
  21.     <ul class="breadcrumb">
  22.         <li>你当前的位置</li>
  23.         <tags:breadcrumb />
  24.         <li>列表</li>
  25.     </ul>
  26.     <div class="panel-group" id="accordion" role="tablist"
  27.         aria-multiselectable="true">
  28.         <div class="panel panel-default">
  29.             <div class="panel-heading" role="tab" id="headingOne">
  30.                 <h4 class="panel-title" id="-collapsible-group-item-#1-">
  31.                     <a data-toggle="collapse" data-parent="#accordion"
  32.                         href="#collapseOne" aria-expanded="true"
  33.                         aria-controls="collapseOne" class=""> 活动方案列表 </a>
  34.                 </h4>
  35.             </div>
  36.             <div id="collapseOne" class="panel-collapse collapse in"
  37.                 role="tabpanel" aria-labelledby="headingOne" aria-expanded="true">
  38.                 <div class="panel-body">
  39.                     <form name="form" class="form-inline"
  40.                         action="<c:url value="/business/activity/list.do"/>" method="post">
  41.                         <fieldset>
  42.                             <div class="form-group form-group-sm  right20">
  43.                                 <label class="control-label" for="businessId">商户:</label> <select
  44.                                     class="form-control" id="businessId" name="businessId">
  45.                                 <option value="">--全部--</option>
  46.                                 <c:forEach items="${business}" var="busines">
  47.                                     <option value="${busines.id }" <c:if test="${condition.businessId == busines.id}">selected="selected"</c:if>>${busines.name }</option>
  48.                                 </c:forEach>
  49.                             </select>
  50.                             </div>
  51.                             <div class="form-group form-group-sm  right20">
  52.                                 <label class="control-label" for="type">类型:</label> <select
  53.                                     class="form-control" id="type" name="type">
  54.                                     <option value="">--全部--</option>
  55.                                     <option value="0" <c:if test="${condition.type == 0}">selected="selected"</c:if>>免费领取</option>
  56.                                     <option value="1" <c:if test="${condition.type == 1}">selected="selected"</c:if>>商品秒杀</option>
  57.                                     <option value="2" <c:if test="${condition.type == 2}">selected="selected"</c:if>>限时抢购</option>
  58.                                     <option value="3" <c:if test="${condition.type == 3}">selected="selected"</c:if>>积分兑换</option>
  59.                                     <option value="4" <c:if test="${condition.type == 4}">selected="selected"</c:if>>抽奖活动</option>
  60.                                     <option value="5" <c:if test="${condition.type == 5}">selected="selected"</c:if>>转盘活动</option>
  61.                                     <option value="6" <c:if test="${condition.type == 6}">selected="selected"</c:if>>会员商品</option>
  62.                                     <option value="7" <c:if test="${condition.type == 7}">selected="selected"</c:if>>优惠券</option>
  63.                                     <option value="8" <c:if test="${condition.type == 8}">selected="selected"</c:if>>注册送积分</option>
  64.                                     <option value="9" <c:if test="${condition.type == 9}">selected="selected"</c:if>>合作方抽奖</option>
  65.                                     <option value="10" <c:if test="${condition.type == 10}">selected="selected"</c:if>>看广告抽奖</option>
  66.                                 </select>
  67.                             </div>
  68.                             <div class="form-group form-group-sm  right20">
  69.                                 <label class="control-label" for="title">标题:</label>
  70.                                 <input class="form-control" type="text" id="title"
  71.                                     name="title" value="${condition.title}">
  72.                             </div>
  73.                             <div class="form-group form-group-sm  right20">
  74.                                 <label class="control-label" for="status">状态:</label> <select
  75.                                     class="form-control" id="status" name="status">
  76.                                     <option value="">--全部--</option>
  77.                                     <option value="0" <c:if test="${condition.status == 0}">selected="selected"</c:if>>上线</option>
  78.                                     <option value="1" <c:if test="${condition.status == 1}">selected="selected"</c:if>>下线</option>
  79.                                 </select>
  80.                             </div>
  81.                             <div class="form-group form-group-sm">
  82.                                 <button type="submit" class="btn btn-primary btn-sm">
  83.                                     <i class="icon-search icon-white"></i> 查  询 
  84.                                 </button>
  86.                             </div>
  87.                             <div class="form-group form-group-sm">
  88.                                 <button type="button" οnclick="buttonSubmit('add.do')"
  89.                                     class="btn btn-primary btn-sm">
  90.                                     <i class="icon-search icon-white"></i> 添加方案
  91.                                 </button>
  93.                             </div>
  94.                         </fieldset>
  95.                     </form>
  96.                     <table class="table table-striped table-bordered top20">
  97.                         <thead>
  98.                             <tr>
  99.                                 <th>序号</th>
  100.                                 <th>商户</th>
  101.                                 <th>活动类型</th>
  102.                                 <th>商品名称</th>
  103.                                 <th>标题</th>
  104.                                 <th>参与频率</th>
  105.                                 <th>状态</th>
  106.                                 <th>上线时间</th>
  107.                                 <th>下线时间</th>
  108.                                 <th>操作</th>
  109.                             </tr>
  110.                         </thead>
  111.                         <c:if test="${null != activityInfos}">
  112.                             <c:forEach var="item" items="${activityInfos}">
  113.                                 <tr>
  114.                                     <td class="center">${item.id}</td>
  115.                                     <td class="center">
  116.                                         <c:forEach items="${business }" var="busines">
  117.                                             <c:if test="${busines.id == item.businessId }">${busines.name }</c:if>
  118.                                         </c:forEach>
  119.                                     </td>
  120.                                     <td class="center">
  121.                                         <c:choose>
  122.                                             <c:when test="${item.type == 0}">免费领取</c:when>
  123.                                             <c:when test="${item.type == 1}">商品秒杀</c:when>
  124.                                             <c:when test="${item.type == 2}">限时抢购</c:when>
  125.                                             <c:when test="${item.type == 3}">积分兑换</c:when>
  126.                                             <c:when test="${item.type == 4}">抽奖活动</c:when>
  127.                                             <c:when test="${item.type == 5}">转盘活动</c:when>
  128.                                             <c:when test="${item.type == 6}">会员商品</c:when>
  129.                                             <c:when test="${item.type == 7}">优惠券</c:when>
  130.                                             <c:when test="${item.type == 8}">注册送积分</c:when>
  131.                                             <c:when test="${item.type == 9}">合作方抽奖</c:when>
  132.                                             <c:when test="${item.type == 10}">看广告抽奖</c:when>
  133.                                         </c:choose>
  134.                                     </td>
  135.                                     <td class="center">
  136.                                         <c:if test="${item.type != 4 && item.type != 5}">
  137.                                             <c:forEach items="${commoditys}" var="commodity">
  138.                                                 <c:if test="${commodity.id == item.cid }">
  139.                                                     ${commodity.name}
  140.                                                 </c:if>
  141.                                             </c:forEach>
  142.                                         </c:if>
  143.                                         <c:if test="${item.type == 4 or item.type == 9 or item.type == 10}">
  144.                                             <a href="<c:url value="/business/lottery/list.do?aid=${item.id}"/>">查询奖品</a>
  145.                                         </c:if>
  146.                                         <c:if test="${item.type == 5}">
  147.                                             <a href="<c:url value="/business/turntable/list.do?aid=${item.id}"/>">查询奖品</a>
  148.                                         </c:if>
  149.                                     </td>
  150.                                     <td class="center" title="${item.title}">
  151.                                         <c:if test="${fn:length(item.title)<=5}">
  152.                                             ${item.title}
  153.                                         </c:if>
  154.                                         <c:if test="${fn:length(item.title)>5}">
  155.                                             ${fn:substring(item.title, 0, 5)}...
  156.                                         </c:if>
  157.                                     </td>
  158.                                     <td class="center">
  159.                                         ${item.frequency}
  160.                                     </td>
  161.                                     <td class="center">
  162.                                         <c:choose>
  163.                                             <c:when test="${item.status == 0}">上线</c:when>
  164.                                             <c:otherwise>下线</c:otherwise>
  165.                                         </c:choose>
  166.                                     </td>
  167.                                     <td class="center">
  168.                                         <fmt:formatDate value="${item.onlineTime}" pattern="yyyy-MM-dd HH:mm:ss"/>
  169.                                     <td class="center">
  170.                                         <fmt:formatDate value="${item.offlineTime}" pattern="yyyy-MM-dd HH:mm:ss"/>
  171.                                     </td>
  172.                                     <td>
  173.                                         <%--<c:if test="${item.type == 1}">
  174.                                             <button type="submit" class="btn btn-primary btn-xs"
  175.                                                     οnclick="buttonSubmit('/SG-web/business/spike/findByComm.do?activityId=${item.id}')">
  176.                                                 <i class="icon-edit icon-white"></i>设置秒杀规则
  177.                                             </button>
  178.                                         </c:if>--%>
  179.                                         <c:if test="${item.status == 0 }">
  180.                                             <button type="submit" class="btn btn-primary btn-xs"
  181.                                                 οnclick="buttonSubmit('offline.do?id=${item.id}')">
  182.                                                 <i class="icon-edit icon-white"></i>下线
  183.                                             </button>
  184.                                         </c:if>
  185.                                         <c:if test="${item.status == 1 }">
  186.                                             <button type="submit" class="btn btn-primary btn-xs"
  187.                                                 οnclick="buttonSubmit('online.do?id=${item.id}')">
  188.                                                 <i class="icon-edit icon-white"></i>上线
  189.                                             </button>
  190.                                         </c:if>
  191.                                         <button type="submit" class="btn btn-primary btn-xs"
  192.                                             οnclick="buttonSubmit('edit.do?id=${item.id}')">
  193.                                             <i class="icon-edit icon-white"></i>编辑
  194.                                         </button>
  195.                                         <c:if test="${item.status == 1 }">
  196.                                             <button type="submit" class="btn btn-primary btn-xs"
  197.                                                 οnclick="del('delete.do?id=${item.id}')">
  198.                                                 <i class="icon-edit icon-white"></i>删除
  199.                                             </button>
  200.                                         </c:if>
  201.                                     </td>
  202.                                 </tr>
  203.                             </c:forEach>
  204.                         </c:if>
  205.                     </table>
  206.                     <div style="text-align: right">
  207.                         <tags:page page1="${page}" />
  208.                     </div>
  209.                 </div>
  210.             </div>
  211.         </div>
  212.     </div>
  213. </div

拦截器：com.fire.SG.web.interceptor/PageQueryInterceptor

package com.fire.SG.web.interceptor;

import com.fire.SG.web.util.page.Page;
import com.fire.SG.web.util.page.PageUtil;
import com.google.common.base.Joiner;
import org.apache.ibatis.executor.Executor;
import org.apache.ibatis.mapping.*;
import org.apache.ibatis.mapping.MappedStatement.Builder;
import org.apache.ibatis.plugin.*;
import org.apache.ibatis.session.ResultHandler;
import org.apache.ibatis.session.RowBounds;

import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

/**
* Created by yb
*/
@Intercepts({@Signature(type = Executor.class, method = “query”, args = {MappedStatement.class, Object.class, RowBounds.class, ResultHandler.class})})
public class PageQueryInterceptor implements Interceptor {
private static final List EMPTY_RESULTMAPPING = new ArrayList(0);
@SuppressWarnings(“rawtypes”)
public Object intercept(Invocation invocation) throws Throwable {
//Page对象获取，“信使”到达拦截器！
Page page = PageUtil.getPage();
//不分页直接返回
if(page==null)
return invocation.proceed(); 

  1.     //清空分页参数  
  2.     PageUtil.removePage();  
  5.     //当前环境 MappedStatement，BoundSql，及sql取得  
  6.     MappedStatement mappedStatement=(MappedStatement)invocation.getArgs()\[0\];  
  7.     BoundSql boundSql = mappedStatement.getBoundSql(invocation.getArgs()\[1\]);  
  8.     String originalSql = boundSql.getSql().trim();  
  11.     //查询总数  
  12.     String countSql = getCountSql(originalSql);  
  13.     BoundSql countBS = newBoundSql(mappedStatement, boundSql, countSql);  
  14.     MappedStatement countMs = newMappedStatement(mappedStatement, new BoundSqlSqlSource(countBS),true);  
  15.     invocation.getArgs()\[0\] = countMs;  
  16.     Object result = invocation.proceed();  
  17.     //设置总数  
  18.     page.setTotalRecord((Integer) ((List) result).get(0));  
  21.     //分页查询  
  22.     int pageNo   = page.getPageNo();  
  23.     int pageSize = page.getPageSize();  
  24.     //分页计算  
  25.     //对原始Sql追加limit  
  26.     int offset = (pageNo - 1) \* pageSize;  
  27.     BoundSql newBoundSql = newBoundSql(mappedStatement, boundSql, originalSql + " limit " + offset + "," + pageSize);  
  28.     MappedStatement pageMs = newMappedStatement(mappedStatement, new BoundSqlSqlSource(newBoundSql),false);  
  29.     invocation.getArgs()\[0\]= pageMs;  
  32.     return invocation.proceed();  
  37. \}  
  44. /\*\*  
  45.  \* 新建MappedStatement对象  
  46.  \*/  
  47. private MappedStatement newMappedStatement(MappedStatement ms, SqlSource newSqlSource,boolean count) \{  
  48.     Builder builder = new Builder(ms.getConfiguration(),ms.getId(),newSqlSource,ms.getSqlCommandType());  
  51.     builder.resource(ms.getResource());  
  52.     builder.fetchSize(ms.getFetchSize());  
  53.     builder.statementType(ms.getStatementType());  
  54.     builder.keyGenerator(ms.getKeyGenerator());  
  55.     if((ms.getKeyProperties()!=null))\{  
  56.         builder.keyProperty(Joiner.on(",").join(ms.getKeyProperties()));  
  57.     \}  
  58.     builder.timeout(ms.getTimeout());  
  59.     builder.parameterMap(ms.getParameterMap());  
  60.     if (count) \{  
  61.         //count查询返回值int  
  62.         List<ResultMap> resultMaps = new ArrayList<ResultMap>();  
  63.         ResultMap resultMap = new ResultMap.Builder(ms.getConfiguration(), ms.getId(), int.class, EMPTY\_RESULTMAPPING).build();  
  64.         resultMaps.add(resultMap);  
  65.         builder.resultMaps(resultMaps);  
  66.     \} else \{  
  67.         builder.resultMaps(ms.getResultMaps());  
  68.     \}  
  69.     builder.resultSetType(ms.getResultSetType());  
  70.     builder.cache(ms.getCache());  
  71.     builder.flushCacheRequired(ms.isFlushCacheRequired());  
  72.     builder.useCache(ms.isUseCache());  
  73.     return builder.build();  
  74. \}  
  77. /\*\*  
  78.  \* 复制BoundSql对象  
  79.  \*/  
  80. private BoundSql newBoundSql(MappedStatement ms, BoundSql boundSql, String sql) \{  
  81.     BoundSql newBoundSql = new BoundSql(ms.getConfiguration(),sql, boundSql.getParameterMappings(), boundSql.getParameterObject());  
  82.     for (ParameterMapping mapping : boundSql.getParameterMappings()) \{  
  83.         String prop = mapping.getProperty();  
  84.         if (boundSql.hasAdditionalParameter(prop)) \{  
  85.             newBoundSql.setAdditionalParameter(prop, boundSql.getAdditionalParameter(prop));  
  86.         \}  
  87.     \}  
  88.     return newBoundSql;  
  89. \}  
  92. /\*\*  
  93.  \* 根据原Sql语句获取对应的查询总记录数的Sql语句  
  94.  \*/  
  95. private String getCountSql(String sql) \{  
  96.     String copy = sql;  
  97.     Pattern pattern = Pattern.compile("order\\\\s+by.\*(asc|desc)?",Pattern.MULTILINE&Pattern.CASE\_INSENSITIVE);  
  98.     Matcher matcher = pattern.matcher(copy);  
  99.     copy = matcher.replaceAll("");  
  100.     return "SELECT COUNT(\*) FROM (" + copy + ") aliasForPage";  
  101. \}  
  104. public class BoundSqlSqlSource implements SqlSource \{  
  105.     BoundSql boundSql;  
  106.     public BoundSqlSqlSource(BoundSql boundSql) \{  
  107.         this.boundSql = boundSql;  
  108.     \}  
  109.     public BoundSql getBoundSql(Object parameterObject) \{  
  110.         return boundSql;  
  111.     \}  
  112. \}  
  113. public Object plugin(Object arg0) \{

// return this;
return Plugin.wrap(arg0, this);
}
public void setProperties(Properties arg0) {
} 

  1. public static void main(String\[\] args) \{  
  2.     String s = "select c1,c2 from tbl\_test\_col Where c1=? order by c2 desc";  
  3.     System.out.println(testGetCountSql(s));  
  4. \}  
  7. //test  
  8. private static String testGetCountSql(String sql) \{  
  9.     String copy = sql;  
  10.     Pattern pattern = Pattern.compile("order\\\\s+by.\*(asc|desc)?",Pattern.CASE\_INSENSITIVE&Pattern.MULTILINE);  
  11.     Matcher matcher = pattern.matcher(copy);  
  12.     copy = matcher.replaceAll("");  
  13.     return "SELECT COUNT(\*) FROM (" + copy + ") aliasForPage";  
  14. \}

PageUtil Page

package com.fire.SG.web.util.page;

import com.alibaba.fastjson.JSON;
import com.google.common.base.Joiner;
import com.google.common.collect.Lists;
import com.google.common.collect.Maps;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import javax.servlet.http.HttpServletRequest;
import java.io.UnsupportedEncodingException;
import java.util.List;
import java.util.Map;

/**
* Created by yubin
*/
public class Page {
private static final Logger logger = LoggerFactory.getLogger(Page.class); 

  1. public static Integer DEFAULT\_PAGESIZE = 15;  
  2. private int pageNo;                    //当前页码  
  3. private int pageSize;                  //每页行数  
  4. private int totalRecord;               //总记录数  
  5. private int totalPage;                 //总页数  
  8. private Map<String, String> params;            //查询条件  
  9. private Map<String, List<String>> paramLists;  //数组查询条件  
  10. private String searchUrl;                      //Url地址  
  11. private String pageNoDisp;                     //可以显示的页号(分隔符"|"，总页数变更时更新)  
  14. public Page() \{  
  15.     pageNo = 1;  
  16.     pageSize = DEFAULT\_PAGESIZE;  
  17.     totalRecord = 0;  
  18.     totalPage = 0;  
  19.     params = Maps.newHashMap();  
  20.     paramLists = Maps.newHashMap();  
  21.     searchUrl = "";  
  22.     pageNoDisp = "";  
  23. \}  
  24. public Page(int pageNo,int pageSize)\{  
  25.     this.pageNo = pageNo>0?pageNo:1;  
  26.     this.pageSize = pageSize>0?pageSize:DEFAULT\_PAGESIZE;  
  27.     totalRecord = 0;  
  28.     totalPage = 0;  
  29.     params = Maps.newHashMap();  
  30.     paramLists = Maps.newHashMap();  
  31.     searchUrl = "";  
  32.     pageNoDisp = "";  
  33. \}  
  36. public void initParams(HttpServletRequest req)\{  
  37.     String uri = req.getRequestURI();  
  38.     int pot = uri.indexOf(".do");  
  39.     // 从uri中抽取右侧"/"后字符串作为的acton名 例子中对应的是 "users"  
  40.     searchUrl=uri.substring(0,pot + 3);  
  41.     // 这里是核心代码：遍历 req.getParameterMap() 提取请求参数,要注意数组的情况  
  42.     for (Object key : req.getParameterMap().keySet()) \{  
  43.         String\[\] args = req.getParameterValues(key.toString());  
  44.         if (args.length > 1) \{  
  45.             paramLists.put(key.toString(), convertParamArr(args, req));  
  46.         \} else \{  
  47.             params.put(key.toString(), convertIsoToUtf8(req.getParameter(key.toString()), req));  
  48.         \}  
  49.     \}  
  52.     if (params.get("pageNo") == null) \{  
  53.         params.put("pageNo", "1");    // 当前页 缺省值设定  
  54.     \} else \{  
  55.         pageNo= Integer.parseInt(params.get("pageNo"));  
  56.         // 点击分页标签时的请求 编辑totalRecord 项目（避免重复查询总记录数）  
  57.         totalRecord=Integer.parseInt(params.get("totalRecord"));  
  58.     \}  
  59. \}  
  64. /\*\*  
  65.  \* GET请求时，单个入参的转码处理  
  66.  \*/  
  67. private static String convertIsoToUtf8(String strIn, HttpServletRequest request) \{  
  68.     if (strIn == null || !request.getMethod().equalsIgnoreCase("get")) \{  
  69.         return strIn;  
  70.     \}  
  71.     try \{  
  72.         return new String(strIn.getBytes("iso-8859-1"), "utf-8");  
  73.     \} catch (UnsupportedEncodingException e) \{  
  74.         return strIn;  
  75.     \}  
  76. \}  
  79. /\*\*  
  80.  \* GET请求时，数组型入参的转码处理  
  81.  \*/  
  82. private static List<String> convertParamArr(String\[\] param,  
  83.                                             HttpServletRequest request) \{  
  84.     List<String> list = Lists.newArrayList();  
  85.     if (param != null) \{  
  86.         for (String p : param) \{  
  87.             String convertP = convertIsoToUtf8(p, request);  
  88.             if (!list.contains(convertP)) \{  
  89.                 list.add(convertP);  
  90.             \}  
  91.         \}  
  92.     \}  
  93.     return list;  
  94. \}  
  97. /\*\*  
  98.  \* 查询条件转JSON  
  99.  \*/  
  100. public String getParaJson() \{  
  101.     Map<String, Object> map = Maps.newHashMap();  
  102.     for (String key : params.keySet()) \{  
  103.         if (params.get(key) != null) \{  
  104.             map.put(key, params.get(key));  
  105.         \}  
  106.     \}  
  107.     String json = "";  
  108.     try \{  
  109.         json = JSON.toJSONString(map);  
  110.     \} catch (Exception e) \{  
  111.         logger.error("转换JSON失败", params, e);  
  112.     \}  
  113.     return json;  
  114. \}  
  117. /\*\*  
  118.  \* 数组查询条件转JSON  
  119.  \*/  
  120. public String getParaListJson() \{  
  121.     Map<String, Object> map = Maps.newHashMap();  
  122.     for (String key : paramLists.keySet()) \{  
  123.         List<String> lists = paramLists.get(key);  
  124.         if (lists != null && lists.size() > 0) \{  
  125.             map.put(key, lists);  
  126.         \}  
  127.     \}  
  128.     String json = "";  
  129.     try \{  
  130.         json = JSON.toJSONString(map);  
  131.     \} catch (Exception e) \{  
  132.         logger.error("转换JSON失败", params, e);  
  133.     \}  
  134.     return json;  
  135. \}  
  138. /\*\*  
  139.  \* 总件数变化时，更新总页数并计算显示样式  
  140.  \*/  
  141. private void refreshPage() \{  
  142.     //总页数计算  
  143.     totalPage = totalRecord % pageSize == 0 ? totalRecord / pageSize : (totalRecord / pageSize + 1);  
  144.     //防止超出最末页（浏览途中数据被删除的情况）  
  145.     if (pageNo > totalPage && totalPage != 0) \{  
  146.         pageNo = totalPage;  
  147.     \}  
  148.     pageNoDisp = computeDisplayStyleAndPage();  
  149. \}  
  152. /\*\*  
  153.  \* 计算页号显示样式  
  154.  \* 这里实现以下的分页样式("\[\]"代表当前页号)，可根据项目需求调整  
  155.  \* \[1\],2,3,4,5,6,7,8..12,13  
  156.  \* 1,2..5,6,\[7\],8,9..12,13  
  157.  \* 1,2..6,7,8,9,10,11,12,\[13\]  
  158.  \*/  
  159. private String computeDisplayStyleAndPage() \{  
  160.     List<Integer> pageDisplays = Lists.newArrayList();  
  161.     if (totalPage <= 11) \{  
  162.         for (int i = 1; i <= totalPage; i++) \{  
  163.             pageDisplays.add(i);  
  164.         \}  
  165.     \} else if (pageNo < 7) \{  
  166.         for (int i = 1; i <= 8; i++) \{  
  167.             pageDisplays.add(i);  
  168.         \}  
  169.         pageDisplays.add(0);// 0 表示 省略部分(下同)  
  170.         pageDisplays.add(totalPage - 1);  
  171.         pageDisplays.add(totalPage);  
  172.     \} else if (pageNo > totalPage - 6) \{  
  173.         pageDisplays.add(1);  
  174.         pageDisplays.add(2);  
  175.         pageDisplays.add(0);  
  176.         for (int i = totalPage - 7; i <= totalPage; i++) \{  
  177.             pageDisplays.add(i);  
  178.         \}  
  179.     \} else \{  
  180.         pageDisplays.add(1);  
  181.         pageDisplays.add(2);  
  182.         pageDisplays.add(0);  
  183.         for (int i = pageNo - 2; i <= pageNo + 2; i++) \{  
  184.             pageDisplays.add(i);  
  185.         \}  
  186.         pageDisplays.add(0);  
  187.         pageDisplays.add(totalPage - 1);  
  188.         pageDisplays.add(totalPage);  
  189.     \}  
  190.     return Joiner.on("|").join(pageDisplays.toArray());  
  191. \}  
  192. public int getPageNo() \{  
  193.     return pageNo;  
  194. \}  
  197. public void setPageNo(int pageNo) \{  
  198.     this.pageNo = pageNo;  
  199. \}  
  202. public int getPageSize() \{  
  203.     return pageSize;  
  204. \}  
  207. public void setPageSize(int pageSize) \{  
  208.     this.pageSize = pageSize;  
  209. \}  
  212. public int getTotalRecord() \{  
  213.     return totalRecord;  
  214. \}  
  217. public void setTotalRecord(int totalRecord) \{  
  218.     this.totalRecord = totalRecord;  
  219.     refreshPage();  
  220. \}  
  223. public int getTotalPage() \{  
  224.     return totalPage;  
  225. \}  
  228. public void setTotalPage(int totalPage) \{  
  229.     this.totalPage = totalPage;  
  230. \}  
  233. public Map<String, String> getParams() \{  
  234.     return params;  
  235. \}  
  238. public void setParams(Map<String, String> params) \{  
  239.     this.params = params;  
  240. \}  
  243. public Map<String, List<String>> getParamLists() \{  
  244.     return paramLists;  
  245. \}  
  248. public void setParamLists(Map<String, List<String>> paramLists) \{  
  249.     this.paramLists = paramLists;  
  250. \}  
  253. public String getSearchUrl() \{  
  254.     return searchUrl;  
  255. \}  
  258. public void setSearchUrl(String searchUrl) \{  
  259.     this.searchUrl = searchUrl;  
  260. \}  
  263. public String getPageNoDisp() \{  
  264.     return pageNoDisp;  
  265. \}  
  268. public void setPageNoDisp(String pageNoDisp) \{  
  269.     this.pageNoDisp = pageNoDisp;  
  270. \}

}

package com.fire.SG.web.util.page;

import org.springframework.web.context.request.RequestContextHolder;
import org.springframework.web.context.request.ServletRequestAttributes;

import javax.servlet.http.HttpServletRequest;

/**
* 只能对接下来的一个进行分页,
* Created by yubin
*/
public class PageUtil {
private static ThreadLocal threadPage = new ThreadLocal(); 

  1. public static Page getPage () \{  
  2.     return threadPage.get();  
  3. \}  
  6. public static Page removePage () \{  
  7.     Page page = threadPage.get();  
  8.     threadPage.set(null);  
  9.     return page;  
  10. \}  
  13. /\*\*  
  14.  \* 开始分页，只能对接下来的一个进行分页  
  15.  \*/  
  16. public static Page startPage(Page page)\{  
  17.     threadPage.set(page);  
  18.     initPageParam(page);  
  19.     return page;  
  20. \}  
  23. /\*\*  
  24.  \* 开始分页，只能对接下来的一个进行分页  
  25.  \*/  
  26. public static Page startPage(int pageNo,int pageSize) \{  
  27.     Page page = new Page(pageNo,pageSize);  
  28.     return startPage(page);  
  29. \}  
  32. private static void initPageParam(Page page)\{  
  33.     HttpServletRequest req = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();  
  34.     page.initParams(req);  
  35. \}

}

发表评论

表情：
评论列表 （有 0 条评论，469人围观）

还没有评论，来说两句吧...

相关阅读

    相关 Layui + ssm 分页

    做后台就会涉及到表格数据，当数据多的时候，就要使用分页来显示，这样就显得比较美观。分页确实有效，但它一定会加大系统的复杂度，如果数据量少的话可以不用分页，但是对于企业信息系统来

    男娘i男娘i/ 0 赞/ 361 阅读

    相关 ssm分页查询

    引言：基于ssm框架下,利用Mybaits插件PageHelper进行分页查询，可以省去大量繁琐的代码，操作起来更为方便, 1、数据库表的设计 ![70][] ---

    女爷i女爷i/ 0 赞/ 541 阅读

    相关 ssm框架下的分页查询

    一、开发项目时，对于多条记录的显示，我们采用分页查询将会更加方便。 二、基于ssm框架，我们通过一个记录的起始值start,和记录的大小size封装到一个list集合里

    - 日理万妓- 日理万妓/ 0 赞/ 751 阅读