【插件】PageHelper实现分页

 

--Controller：

 1 @RequestMapping("/selectSth")
 2 @ResponseBody
 3 public Map selectSth(HttpServletRequest request,
 4 HttpServletResponse response){
 5 Map<String, Object> params =$params(request);     【$params：自定义的方法，用于获取前台参数。】
 6 
 7 //分页处理，显示第一页的2条数据
 8 PageHelper.startPage((Integer.valueOf(params.get("page").toString())), (Integer.valueOf(params.get("pagesize").toString())));
 9 params.put("state", 1);
10 PageInfo<Map<String, Object>> pageInfo = new PageInfo<>(invoicesService.selectInvoice(params)); 
11 long total = pageInfo.getTotal(); //获取总记录数 
12 Map map = new HashMap();
13 map.put("Rows", pageInfo.getList());
14 map.put("Total", total);
15 return map;
16 }
View Code

 

--Page：

  1 <%@ page contentType="text/html; charset=utf-8"%>
  2 
  3 <%@ include file="../../scon/topForList.jsp"%>
  4 
  5 <div class="contbox_a1"> 
  6 
  7 <div class="box_a1">
  8 
  9 <div class="box_a1_cont">
 10 
 11 <div id="searchDiv" class="searchDiv">
 12 
 13 <div>
 14 
 15 <!-- <label class="label_block">发货单ID：</label> <input id="id" name="id" type="text" class="txt enterAsSearch" /> -->
 16 
 17 <label class="label_block"> 标段：</label>
 18 
 19     <select style="height:25px;width:115px;"  id="bids" name="bids_no" class="txt" onchange="gradeMixingStation()"></select>      
 20 
 21                    <label class="label_block">拌合站：</label>       
 22 
 23             <select style="height:25px;width:115px;" id="MixingStation" name="node_no"  class="txt" ></select>    
 24 
 25 <label class="label_block">发货单编号：</label><input id="iNo" name="iNo" type="text" class="txt enterAsSearch" />
 26 
 27 <label class="label_block">发货单调度时间：</label><input type="text" name="startTime" id="startTime" readonly="readonly" value="" class="txt txt_datetime"/>到
 28 
 29 <input type="text" name="endTime" id="endTime" readonly="readonly"  value="" class="txt txt_datetime"/>
 30 
 31 <input id="btnOK" type="button" class="btn_a wanwu_search" data="{grid:'gridBox',scope:'searchDiv'}" value="查询" />
 32 
 33     </div> 
 34 
 35 </div>
 36 
 37 <div id="gridBox"></div>
 38 
 39 </div>
 40 
 41 </div>
 42 
 43 </div>
 44 
 45 <script type="text/javascript">
 46 
 47 var grid,selectDialog;
 48 
 49 var itemsStr = "[{ text: '处理', click: dicOper, icon: 'modify'}]";
 50 
 51 $(function(){
 52 
 53 grid = $("#gridBox").ligerGrid({
 54 
 55 toolbar:{ items: eval(itemsStr) },
 56 
 57 columns: [
 58 
 59 {display:'预警站点',name:'parentNodeName',width:150},
 60 
 61 {display:'发货单编号',name:'iNo',width:100},
 62 
 63 {display:'车牌号',name:'plateNumber',width:100},
 64 
 65 {display:'预警时间',name:'warningTime',type:'date',format:'yyyy-MM-dd hh:mm',width:120},
 66 
 67 {display:'预警内容',name:'warningContent',width:620},
 68 
 69 {display:'审核姓名',name:'auditName',width:100,render:function(r,n,v){
 70 
 71 if(v!=null){
 72 
 73 return "<font  color='red'>"+v+"</font>";
 74 
 75 }else{
 76 
 77 return "";
 78 
 79 }
 80 
 81 }},
 82 
 83 {display:'审核时间',name:'auditTime',type:'date',format:'yyyy-MM-dd hh:mm',width:120},
 84 
 85 {display:'审核不通过原因',name:'auditCase',width:220,render:function(r,n,v){
 86 
 87 if(v!=null){
 88 
 89 return "<font color='red'>"+v+"</font>";
 90 
 91 }else{
 92 
 93 return "";
 94 
 95 }
 96 
 97 }}
 98 
 99 ],
100 
101 onContextmenu : function (parm,e)
102 
103         {
104 
105             menu.show({ top: e.pageY, left: e.pageX });
106 
107             return false;
108 
109         },       
110 
111 onAfterShowData : function(){
112 
113 showTips();
114 
115 },
116 
117 rownumbers:true,
118 
119 isScroll: false,
120 
121 url: "/scon/EngineeringStation/invoices/selectInvoice",
122 
123 sortName: 'id',
124 
125    sortOrder: 'asc',
126 
127    isSort: false,
128 
129    excel:{title:'预警处理',url:'/selectInv'}
130 
131 });
132 
133 });
134 
135 function dicOper(item) {
136 
137 switch (item.text) {
138 
139 case "处理":
140 
141 f_common_edit($("#gridBox"), "/scon/EngineeringStation/invoices/toProcessingInv?id={id}", false, 750, 400,"处理");
142 
143         break;
144 
145     }
146 
147 } 
148 
149 $.ajax({  
150 
151     async:false,//使用同步的Ajax请求  
152 
153     type: "POST",  
154 
155     dataType: 'json',
156 
157     url: "/sal/order/linkage?parentNodeNo=1",  
158 
159     error: function(error) {
160 
161     alert("加载站点下拉框出错！");          
162 
163     },
164 
165     success: function(rst){  
166 
167     var material = document.getElementById("bids");
168 
169         var materialstr ="<option value=''>全部</option>";
170 
171     for (var i = 0; i < rst.length; i++) {   
172 
173     materialstr += "<option value='" + rst[i].nodeNo + "'>" + rst[i].nodeDisplay + "</option>"; //公共变量赋值
174 
175          }       
176 
177         material.innerHTML=materialstr; 
178 
179     }  
180 
181 });
182 
183 function getTdate(){
184 
185 var bids = document.getElementById("bids").value;
186 
187 $.ajax({  
188 
189     async:false,//使用同步的Ajax请求  
190 
191     type: "POST",  
192 
193     dataType: 'json',
194 
195     url: "/sal/order/linkage?parentNodeNo="+bids,  
196 
197     error: function(error) {
198 
199     alert("加载站点下拉框出错！");          
200 
201     },
202 
203     success: function(rst){  
204 
205     var material = document.getElementById("MixingStation");
206 
207         var materialstr ="<option value=''>全部</option>";
208 
209     for (var i = 0; i < rst.length; i++) {   
210 
211     materialstr += "<option value='" + rst[i].nodeNo + "'>" + rst[i].nodeDisplay + "</option>"; //公共变量赋值
212 
213          } 
214 
215         material.innerHTML=materialstr; 
216 
217     }  
218 
219 });
220 
221 }
222 
223  </script>
224 
225 <%@ include file="../../scon/bottom.jsp"%>

 

 

【备注 其中top文件中引入前段框架为以下内容】

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8" %>

<%@ page contentType="text/html; charset=utf-8"%>

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

  <head>

<!-- ligerUI -->

<script src="/resources/js/jquery-1.7.1.min.js" type="text/javascript"></script>

<!-- yuwei 添加 -->

    <script src="/resources/js/liger/ligerUI/js/core/base.js" type="text/javascript"></script>

    <script src="/resources/js/liger/ligerUI/js/ligerui.all.js" type="text/javascript"></script>

    <script src="/resources/js/liger/ligerUI/js/plugins/ligerGrid.js" type="text/javascript"></script>

    <script src="/resources/js/liger/ligerUI/js/plugins/ligerToolBar.js" type="text/javascript"></script>

    <script src="/resources/js/liger/ligerUI/js/plugins/ligerDialog.js" type="text/javascript"></script>

    <script src="/resources/js/liger/ligerUI/js/plugins/ligerTextBox.js" type="text/javascript"></script>

    <script src="/resources/js/liger/ligerUI/js/plugins/ligerCheckBox.js" type="text/javascript"></script>

    <script src="/resources/js/liger/ligerUI/js/plugins/ligerComboBox.js" type="text/javascript"></script>

    <script src="/resources/js/liger/ligerUI/js/plugins/ligerLayout.js" type="text/javascript"></script>

    <script src="/resources/js/liger/ligerUI/js/plugins/ligerDateEditor.js" type="text/javascript"></script>

    <script src="/resources/js/liger/ligerUI/js/plugins/ligerSpinner.js" type="text/javascript"></script>

    <script src="/resources/js/liger/ligerUI/js/plugins/ligerMenu.js" type="text/javascript"></script> 

    <script src="/resources/js/liger/ligerUI/js/plugins/ligerFilter.js" type="text/javascript"></script>

    <script src="/resources/js/liger/ligerUI/js/plugins/ligerDrag.js" type="text/javascript"></script>

    <script src="/resources/js/liger/ligerUI/js/plugins/ligerResizable.js" type="text/javascript"></script>

 

<script src="/resources/js/jquery-validation/jquery.validate.js" type="text/javascript"></script> 

<script src="/resources/js/jquery-validation/jquery.metadata.js" type="text/javascript"></script>

<script src="/resources/js/jquery-validation/messages_cn.js" type="text/javascript"></script>

<script src="/resources/js/jquery.json-2.3.min.js" type="text/javascript"></script>

<script src="/resources/js/soTree.js" type="text/javascript"></script>

 

 

<script src="/resources/js/commcomponent.js" type="text/javascript"></script>

<script src="/resources/js/layer/layer.min.js" type="text/javascript"></script>

 

<!-- 日历 -->

<script src="/resources/js/datetimepicker/jquery.datetimepicker.js" type="text/javascript"></script>

<script src="/resources/js/qTip/jquery.qtip.min.js" type="text/javascript"></script>

<link type="text/css" rel="stylesheet" media="all" href="/resources/js/qTip/jquery.qtip.min.css"  />

    <link href="/resources/js/liger/ligerUI/skins/Aqua/css/ligerui-all.css" rel="stylesheet" type="text/css" />

    <link href="/resources/js/liger/ligerUI/skins/Gray/css/all.css" rel="stylesheet" type="text/css" />

    <link href="/resources/js/liger/ligerUI/skins/ligerui-icons.css" rel="stylesheet" type="text/css" />

    <link href="/resources/css/style_for_list.css" rel="stylesheet" type="text/css" />

    <link href="/resources/js/datetimepicker/jquery.datetimepicker.css" rel="stylesheet" type="text/css" />

    <!--打印  -->

<style>

body{font-size:13px; font-family:Arial,宋体,Verdana,Tahoma,Helvetica,sans-serif;}

label{cursor:pointer;}

</style>

  </head>

  <body>

 

<%@ page contentType="text/html; charset=utf-8"%><%@ include file="../../scon/topForList.jsp"%>
<div class="contbox_a1"> <div class="box_a1"><div class="box_a1_cont"><div id="searchDiv" class="searchDiv"><div><!-- <label class="label_block">发货单ID：</label> <input id="id" name="id" type="text" class="txt enterAsSearch" /> --><label class="label_block"> 标段：</label>    <select style="height:25px;width:115px;"  id="bids" name="bids_no" class="txt" onchange="gradeMixingStation()"></select>                          <label class="label_block">拌合站：</label>                   <select style="height:25px;width:115px;" id="MixingStation" name="node_no"  class="txt" ></select>     <label class="label_block">发货单编号：</label><input id="iNo" name="iNo" type="text" class="txt enterAsSearch" /><label class="label_block">发货单调度时间：</label><input type="text" name="startTime" id="startTime" readonly="readonly" value="" class="txt txt_datetime"/>到<input type="text" name="endTime" id="endTime" readonly="readonly"  value="" class="txt txt_datetime"/>    <input id="btnOK" type="button" class="btn_a wanwu_search" data="{grid:'gridBox',scope:'searchDiv'}" value="查询" />    </div> </div><div id="gridBox"></div></div></div></div><script type="text/javascript">
var grid,selectDialog;var itemsStr = "[{ text: '处理', click: dicOper, icon: 'modify'}]";
$(function(){grid = $("#gridBox").ligerGrid({toolbar:{ items: eval(itemsStr) },columns: [//{display:'发货单ID',name:'id',width:80},//{display:'站点编号',name:'stationNo',width:100},{display:'预警站点',name:'parentNodeName',width:150},{display:'发货单编号',name:'iNo',width:100},{display:'车牌号',name:'plateNumber',width:100},{display:'预警时间',name:'warningTime',type:'date',format:'yyyy-MM-dd hh:mm',width:120},{display:'预警内容',name:'warningContent',width:620},{display:'审核姓名',name:'auditName',width:100,render:function(r,n,v){if(v!=null){return "<font  color='red'>"+v+"</font>";}else{return "";}}},{display:'审核时间',name:'auditTime',type:'date',format:'yyyy-MM-dd hh:mm',width:120},{display:'审核不通过原因',name:'auditCase',width:220,render:function(r,n,v){if(v!=null){return "<font color='red'>"+v+"</font>";}else{return "";}}}],onContextmenu : function (parm,e)        {            menu.show({ top: e.pageY, left: e.pageX });            return false;        },       onAfterShowData : function(){showTips();},rownumbers:true,isScroll: false,url: "/scon/EngineeringStation/invoices/selectInvoice",sortName: 'id',   sortOrder: 'asc',   isSort: false,   excel:{title:'预警处理',url:'/selectInv'}});});
function dicOper(item) {switch (item.text) {case "处理":f_common_edit($("#gridBox"), "/scon/EngineeringStation/invoices/toProcessingInv?id={id}", false, 750, 400,"处理");        break;    }} $.ajax({      async:false,//使用同步的Ajax请求      type: "POST",      dataType: 'json',    url: "/sal/order/linkage?parentNodeNo=1",      error: function(error) {    alert("加载站点下拉框出错！");              },    success: function(rst){      var material = document.getElementById("bids");        var materialstr ="<option value=''>全部</option>";    for (var i = 0; i < rst.length; i++) {       materialstr += "<option value='" + rst[i].nodeNo + "'>" + rst[i].nodeDisplay + "</option>"; //公共变量赋值         }               material.innerHTML=materialstr;     }  });function getTdate(){ var bids = document.getElementById("bids").value;$.ajax({      async:false,//使用同步的Ajax请求      type: "POST",      dataType: 'json',    url: "/sal/order/linkage?parentNodeNo="+bids,      error: function(error) {    alert("加载站点下拉框出错！");              },    success: function(rst){      var material = document.getElementById("MixingStation");        var materialstr ="<option value=''>全部</option>";    for (var i = 0; i < rst.length; i++) {       materialstr += "<option value='" + rst[i].nodeNo + "'>" + rst[i].nodeDisplay + "</option>"; //公共变量赋值         }         material.innerHTML=materialstr;     }  });} </script><%@ include file="../../scon/bottom.jsp"%>

　　

posted @ 2018-11-20 15:15  Onionle  阅读(350)  评论(0)  编辑  收藏  举报