实现分页代码

来源：互联网发布：可以画画的软件编辑：程序博客网时间：2024/06/11 11:47

一。servlet界面

package com.ly.integralmanager.control.addconsumehistory;import java.io.IOException;import java.util.List;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.ly.integralmanager.model.AddconsumeHistory;import com.ly.integralmanager.service.impl.ConsumeHistoryServiceImpl;import com.ly.integralmanager.service.intf.ConsumeHistoryService;@WebServlet("/HistoryQuery")public class HistoryQuery extends HttpServlet {ConsumeHistoryService consumeHistory=new ConsumeHistoryServiceImpl();protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request, response);}protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {int pagecount=5;//每页显示条数int currentpage=0;//当前页int allpageNumber=0;//总页数String mname=request.getParameter("mname");String adminname=request.getParameter("adminname");//查询到满足条件的总条数int Allcount=consumeHistory.getqueryTotal(mname, adminname);System.out.println("Allcount===>"+Allcount);//查询到满足条件的记录Integer.parseInt(request.getParameter("currentpage"))String current=request.getParameter("currentpage");//判断是否为第一次登陆，第一次则当前页设为1if(current==null){currentpage=1;}else{currentpage=Integer.parseInt(current);}//得到总页数if(Allcount%pagecount==0){ allpageNumber = Allcount / pagecount;} else {allpageNumber = Allcount / pagecount + 1;}List<AddconsumeHistory>  consumeHistorylist=consumeHistory.ManyConditionsQuery(mname, adminname, currentpage, pagecount);//设置值，方便传到jsp中request.setAttribute("consumeHistorylist", consumeHistorylist);request.setAttribute("currentpage", currentpage);//当前页request.setAttribute("pagecount", pagecount);//每页显示的条数request.setAttribute("allpageNumber", allpageNumber);//总页数request.setAttribute("Allcount", Allcount);//总记录数request.setAttribute("mname", mname);request.setAttribute("adminname", adminname);request.getRequestDispatcher("jsp/history/historyquery.jsp").forward(request, response);}}

二.jsp界面

<%@page import="java.util.List"%><%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="utf-8"%><%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>JSP连接数据库测试代码</title><style>.emp_container {text-align: center;height: 100%;padding-top: 10px;padding-bottom: 40px}table {width: 500px;height: 50px;border-collapse: collapse; /*设置表格的边框折叠成一个单一的边框*/margin: 0 auto; /*设置表格居中*/background-color: white;}table, tr, td, th {border: 1px solid black; /*边框：大小 实线 颜色*/text-align: center; /*表格内容居中*/padding: 8px; /*内边距*/}th {background-color: green;color: white;}tr:hover {color: #FF00FF;background-color: #ADD8E6;}a:link, a:visited /* 未访问链接*/ {display: block;font-weight: bold;color: #FFFFFF;background-color: #98bf21;text-align: center;padding: 4px;text-decoration: none;}a:hover, a:active /* hover 鼠标移动到链接上,active鼠标点击时 */ {background-color: #7A991A;}img {width: 50px;height: 50px;}</style><script src="js/jquery.js"></script><script type="text/javascript">function allCheckbox() {var trs = document.getElementById("tab").getElementsByTagName("tr");//从数组下标为1的tr标签开始（下标为零时为th标签，不满足），trs[i].getElementsByTagName("td")[0]即td的第一格的内容也就是checkbox的选项框里面的内容for (var i = 1; i < trs.length; i++) {document.write(trs[i].getElementsByTagName("td")[0].innerHTML);}}function allCheckboxOne() {var names = document.getElementsByName("checkbox");var allcheckbox = document.getElementById("allcheckbox");for (var i = 0; i < names.length; i++) {//当全选勾被选中时，遍历names集合，让每一个勾都设为trueif (allcheckbox.checked == true) {names[i].checked = true;} else {names[i].checked = false;}}}/*根据单个复选框的选择情况确定全选复选框是否被选中*/function selectSingle() {var k = 0;var oInput = document.getElementsByName("checkbox");//设置当多选框中的东西全选中的时候，让全选allcheckbox也设置成选中状态for (var i = 0; i < oInput.length; i++) {if (oInput[i].checked == false) {k = 1;break;}}if (k == 0) {document.getElementById("allcheckbox").checked = true;} else {document.getElementById("allcheckbox").checked = false;}}//批量删除function deleteSome() {var str = "";var deletearray = document.getElementsByName("checkbox");for (var i = 0; i < deletearray.length; i++) {if (deletearray[i].checked) {str += deletearray[i].value + ",";}}if (str == "") {alert("请至少选择一条记录！");return;}window.location.href = "MemberDelete?id=" + str;} //下一页function nextPage(){var allpageNumber=${allpageNumber}; //总页数var currentpage=${currentpage};//当前页if(currentpage>=allpageNumber){alert("已到最后一页!");}else{ window.location.href="HistoryQuery?mname=${mname}&adminname=${adminname}¤tpage="+(currentpage+1); }}//上一页function backPage(){var currentpage=${currentpage};//当前页if(currentpage<=1){alert("已到第一页！");}else{window.location.href="HistoryQuery?mname=${mname}&adminname=${adminname}¤tpage="+(currentpage-1);}}//首页function firstPage(){window.location.href="HistoryQuery?mname=${mname}&adminname=${adminname}¤tpage="+1;}//尾页function endPage(){var allpageNumber=${allpageNumber};//总页数window.location.href="HistoryQuery?mname=${mname}&adminname=${adminname}¤tpage="+allpageNumber;} </script></head><body><form action="${pageContext.request.contextPath}/HistoryQuery" method="post"><b style="color: red">查询： </b> 姓名：<input type="text" size=10 name="mname" value="${mname}" /> 管理员：<input type="text" size=10 name="adminname" value="${adminname}" /> <input type="submit" value="提交" /></form><div class="emp_container"><h3>消费历史记录</h3><table id="tab"><tr><th>全选<input type="checkbox" id="allcheckbox"onclick="allCheckboxOne()" /></th><th>编号</th><th>姓名</th><th>类型</th><th>时间</th><th>管理员</th><th>金额</th><th colspan="3">操作<a href="javascript:void(0);"onclick="deleteSome();">删除选中</a></th></tr><tr><c:forEach items="${consumeHistorylist}" var="consumeHistory"><td><input type="checkbox" name="checkbox"value="${membership.mid }" onclick="selectSingle();" /></td><td ><c:out value="${consumeHistory.cid }"></c:out></td><td><c:out value="${consumeHistory.mname }"></c:out></td><td><c:out value="${consumeHistory.type }"></c:out></td><td><c:out value="${consumeHistory.logindate }"></c:out></td><td><c:out value="${consumeHistory.adminname }"></c:out></td><td><c:out value="${consumeHistory.integral }"></c:out></td><td><a href="jsp/membership/memberadd.jsp">增加</a></td><td><ahref="MemberDelete?id=<c:out value="${membership.mid }" ></c:out>">删除</a></td><td><ahref="MemberpreUpdate?id=<c:out value="${membership.mid }" ></c:out>">修改</a></td></tr></c:forEach></table><br><!-- href="javascript:void(0);" onclick="backPage()" --><div><span style="color: blue; font-size: 14px; display: inline"><b>总共：${Allcount}条记录 </b> </span> <a href="javascript:void(0);" onclick="firstPage()" style="color: blue; font-size: 14px; display: inline">首页</a> <a href="javascript:void(0);" onclick="backPage()" style="color: blue; font-size: 14px; display: inline">上一页</a> <a href="javascript:void(0);" onclick="nextPage()" style="color: blue; font-size: 14px; display: inline">下一页</a> <a href="javascript:void(0);" onclick="endPage()" style="color: blue; font-size: 14px; display: inline">尾页</a></div></div></body></html>

1 0