笔记--------手动分页
生活随笔
收集整理的這篇文章主要介紹了
笔记--------手动分页
小編覺得挺不錯(cuò)的,現(xiàn)在分享給大家,幫大家做個(gè)參考.
1.頁面 綁定page對(duì)象的 ?pageSize每頁大小 和 pageCurren當(dāng)前頁數(shù)(隱藏域中保存這兩個(gè)值),首次請求后臺(tái)后,把值放上去。
2.首頁,上一頁,當(dāng)前頁,下一頁,尾頁。綁定事件,動(dòng)態(tài)改變pageCurren的值,然后發(fā)送請求后臺(tái)。
3. 每次后臺(tái)查詢出 總的行數(shù)totalRows,根據(jù) pageSize計(jì)算出總頁數(shù)totalPages ?(totalRows/pageSize),
oracle: 開始行數(shù):startRow = (currentPage - 1) * pageSize; ??結(jié)束行數(shù):currentPage* pageSize
<div id="pageNumDiv" style="margin-top: 5px;"><div style="float: left;"><select id="pageSizeSelect" style="height: 20px"> <option value="20" selected="selected">20</option><option value="50">50</option><option value="100">100</option></select></div><div style="float: left;"><img id="topImg" alt="第一頁" src="${pageContext.request.contextPath}/css/common/images/first.gif" style="padding-top: 4px;cursor:pointer;"></div><div style="float: left;"><img id="prevImg" alt="上一頁" src="${pageContext.request.contextPath}/css/common/images/prev.gif" style="padding-top: 4px;cursor:pointer;"></div><div style="float: left;">當(dāng)前頁<input type="text" id="txtCurrPage" value="1" style="height: 20px" size="4"/>總頁數(shù)<span>1</span></div><div style="float: left;"><img id="nextImg" alt="下一頁" src="${pageContext.request.contextPath}/css/common/images/next.gif" style="padding-top: 4px;cursor:pointer;"></div><div style="float: left;"><img id="lastImg" alt="最后一頁" src="${pageContext.request.contextPath}/css/common/images/last.gif" style="padding-top: 4px;cursor:pointer;"></div> </div>$("#flightDetailListSearchBtn").click(function(){$("#txtCurrPage").val("1");searchInfo();});$("#pageNumDiv div:eq(1)").click(function(){//第一頁$("#txtCurrPage").val(1);searchInfo();});$("#pageNumDiv div:eq(2)").click(function(){//上一頁var prePage = Number($("#txtCurrPage").val())-1;if(!isNaN($("#txtCurrPage").val()) && prePage > 0 ){$("#txtCurrPage").val( prePage );searchInfo();}});$("#pageNumDiv div:eq(4)").click(function(){//下一頁var nextPage = Number($("#txtCurrPage").val())+1;if(!isNaN($("#txtCurrPage").val()) && nextPage <= totalPage){$("#txtCurrPage").val(nextPage);searchInfo();}});$("#txtCurrPage").keydown(function(event){//回車鍵if(event.keyCode=="13"){if(!isNaN($(this).val())){searchInfo();}}});$("#pageNumDiv div:eq(5)").click(function(){//最后一頁$("#txtCurrPage").val(totalPage);searchInfo();});$("#pageNumDiv select").change(function(){searchInfo();});
function searchInfo(){firstOpen++;//分頁設(shè)置$("#pageSize").val($("#pageSizeSelect").val());$("#currentPage").val($("#txtCurrPage").val());var data = $("#flightDetailListSearchForm").serialize();$("#flightDetailListDiv").parent().find(".ui-button-text").eq(0).attr("params",data);//綁定參數(shù)//生成遮蓋converflexigrid("#flightDetailListWithChooseDiv");$.post($path+"/mc/foilManage/goodAnalysisshowList",data,function($data){//返回?cái)?shù)據(jù)之后隱藏遮蓋removeConverflexigrid("#flightDetailListWithChooseDiv");var errorMessage = $data.errorMessage;if(errorMessage!=undefined ){hiAlert(errorMessage,"提示");}else {var vwStatisticalAnalysisList = $data.vwStatisticalAnalysisList;var html = "";//$("#moreFoilDetail tr:gt(0)").remove();$("#moreFoilDetailList tr").remove();if (vwStatisticalAnalysisList != undefined && vwStatisticalAnalysisList.length > 0) {for (var i = 0; i < vwStatisticalAnalysisList.length; i++) {if (i % 2 == 0) {html = html + "<tr style='background-color: rgb(220, 220, 220);'>";}var moreFoil = vwStatisticalAnalysisList[i];for (var j = 0; j < vwStatisticalAnalysisparamters.length; j++) {var showValue = "";if(moreFoil[vwStatisticalAnalysisparamters[j]]!= undefined ){showValue = moreFoil[vwStatisticalAnalysisparamters[j]];}html = html + "<td><div class='dataManage_td_div3' style='width:100%;"+tableWidthCss[j]+"'>" + showValue + "</div></td>";}html = html + "</tr>";}var pager = $data.pager;$("#pageNumDiv div span").html(pager.totalPages);totalPage = pager.totalPages;$("#totalRows").html("總數(shù):"+pager.totalRows);} else {//html = html + "<tr><td colspan='" + vwStatisticalAnalysisColumns.length + "'>暫無數(shù)據(jù)</td></tr>";var pager = $data.pager;$("#pageNumDiv div span").html("1");totalPage = pager.totalPages;$("#totalRows").html("無記錄數(shù)");$("#currentPage").val("1");}$("#moreFoilDetailList").append(html);}},'json');
?
后臺(tái)page核心代碼如下:
public void setTotalRows(int totalRows) {this.totalRows = totalRows;this.totalPages = totalRows / pageSize;int mod = totalRows % pageSize;if (mod > 0) {this.totalPages++;}if (this.currentPage > totalPages){if(isFor){int forSize = currentPage%totalPages;if(forSize>0){currentPage=forSize;}else{currentPage = totalPages;}}else{this.currentPage = totalPages;}}this.startRow = (currentPage - 1) * pageSize;if (this.startRow < 0) {startRow = 0;}if (this.currentPage == 0 || this.currentPage < 0) {currentPage = 1;}}
?
轉(zhuǎn)載于:https://www.cnblogs.com/GotoJava/p/6158477.html
總結(jié)
以上是生活随笔為你收集整理的笔记--------手动分页的全部內(nèi)容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 在腾讯云上创建您的SQL Cluster
- 下一篇: 双11不过瘾?双十二低至半价继续抢,更有