实现分页代码

最新推荐文章于 2024-07-01 11:34:43 发布

luobotoutou123

最新推荐文章于 2024-07-01 11:34:43 发布

阅读量328

点赞数 1

分类专栏： Java基础知识文章标签：分页分页查询

本文链接：https://blog.csdn.net/luobotoutou123/article/details/71101815

版权

Java基础知识专栏收录该内容

30 篇文章 0 订阅

订阅专栏

一。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");
		//判断是否为第一次登陆，第一次则当前页设为1
		if(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集合，让每一个勾都设为true
			if (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"
					οnclick="allCheckboxOne()" /></th>
				<th>编号</th>
				<th>姓名</th>
				<th>类型</th>
				<th>时间</th>
				<th>管理员</th>
				<th>金额</th>
				

				<th colspan="3">操作<a href="javascript:void(0);"
					οnclick="deleteSome();">删除选中</a></th>
			</tr>

			<tr>
				<c:forEach items="${consumeHistorylist}" var="consumeHistory">
					<td><input type="checkbox" name="checkbox"
						value="${membership.mid }" οnclick="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><a
						href="MemberDelete?id=<c:out value="${membership.mid }" ></c:out>">删除</a></td>
					<td><a
						href="MemberpreUpdate?id=<c:out value="${membership.mid }" ></c:out>">修改</a></td>
			</tr>
			</c:forEach>
		</table>
		<br>
		<!-- href="javascript:void(0);" οnclick="backPage()" -->
		<div>
			<span style="color: blue; font-size: 14px; display: inline"><b>总共：${Allcount}条记录 </b> </span> 
				<a href="javascript:void(0);" οnclick="firstPage()" style="color: blue; font-size: 14px; display: inline">首页</a> 
				<a href="javascript:void(0);" οnclick="backPage()" style="color: blue; font-size: 14px; display: inline">上一页</a> 
				<a href="javascript:void(0);" οnclick="nextPage()" style="color: blue; font-size: 14px; display: inline">下一页</a> 
				<a href="javascript:void(0);" οnclick="endPage()" style="color: blue; font-size: 14px; display: inline">尾页</a>
		</div>
	</div>
	
</body>
</html>

luobotoutou123

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
实现分页代码

一。servlet界面package com.ly.integralmanager.control.addconsumehistory;import java.io.IOException;import java.util.List;import javax.servlet.ServletException;import javax.servlet.annotation.W
复制链接

扫一扫

专栏目录