weiyong
/
201906G105


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178
							<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
		<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
		<!-- Bootstrap CSS -->
		<link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
		<!-- Optional JavaScript -->
		<!-- jQuery first, then Popper.js, then Bootstrap JS -->
		<script src="https://cdn.bootcss.com/jquery/3.2.1/jquery.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
		<script src="https://cdn.bootcss.com/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
		<script src="https://cdn.bootcss.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
		<style type="text/css">
			body {
				/*background-color: #eee;*/
			}
			
			form h1 {
				display: inline-block;
				width: 820px;
			}
			
			.check {
				padding: 30px 30px;
			}
			
			form {
				display: inline;
			}
			
			.contain {
				width: 1100px;
				border-radius: 10px;
				border: 1px #bbb solid;
				background-color: #f0f8ff;
				padding-top: 20px;
			}
			
			button {
				margin-left: 10px;
			}
			
			.search {
				display: inline-block;
				margin-left: 500px;
			}
			
			.add {
				float: right;
				margin-right: 50px;
			}
			.pageNav{
				margin-left: 200px;
			}
			.a{
				float:left;
				list-style:none;
			}
			.a li{
				float:left;
				margin:0 40px;
				padding:40px;
			}
			.a li:hover{
				background-color:grey;
			}
		</style>
  </head>
  <body>
	<%
		request.setCharacterEncoding("UTF-8");
		String pages = request.getParameter("pages");//获取当前页数
		int pagesNo = Integer.parseInt(pages);//把当前页数从字符串转为整型
		int startLine = (Integer.parseInt(pages)-1)*10;//指定数据库从哪一行开始读取
		%>
		<ul class="a">
			<a href="race1.jsp?pages=1" target="contain"><li>50米跑</li></a>
			<a href="race2.jsp?pages=1" target="contain"><li>800米跑</li></a>
			<a href="race3.jsp?pages=1" target="contain"><li>跳高</li></a>
			<a href="race4.jsp?pages=1" target="contain"><li>跳远</li></a>
			<a href="race5.jsp?pages=1" target="contain"><li>铅球</li></a>
		</ul>
		<div class="contain pull-left" id="">
		<div class="pull-left">
  		<table class="table table-hover">
					<thead>
						<tr>
							<th>姓名</th>
							<th>学号</th>
							<th>班级</th>
							<th>性别</th>
							<th>项目</th>
							<th>比赛成绩</th>
							<th>排名</th>
						</tr>
					</thead>
					<tbody>
<%
	int pageSize = 10;//指定数据库一次读取多少行
	String sqlQuery = "SELECT * FROM ydh.grade where project='铅球' order by grade desc limit "+startLine+","+pageSize;//对数据库进行伪分页读取，一次只能读10行
	String sqlAll = "SELECT * FROM ydh.grade where project='铅球' order by grade desc";
	int pagesCount = 0;//用于数据库最后读出所有行后总共有多少页
	int lastRow = 0;//记录数据库的最后一行
	try{
		Class.forName("com.mysql.cj.jdbc.Driver");
		Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ydh?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=utf8","root","123456");
		Statement sql = con.createStatement();
		Statement stat = con.createStatement();
		ResultSet rs = sql.executeQuery(sqlQuery);
		ResultSet rsAll = stat.executeQuery(sqlAll);
		rsAll.last();
		lastRow = rsAll.getRow();//记录数据库最后一行
		while(rs.next()){
			out.print("<tr>");
			out.print("<td>"+rs.getString(1)+"</td>");
			out.print("<td>"+rs.getString(2)+"</td>");
			out.print("<td>"+rs.getString(3)+"</td>");
			out.print("<td>"+rs.getString(4)+"</td>");
			out.print("<td>"+rs.getString(5)+"</td>");
			out.print("<td>"+rs.getString(6)+"</td>");
			out.print("<td>"+rs.getString(7)+"</td>");
			out.print("</tr>");
			}
		con.close();
	}catch(SQLException e){
		e.printStackTrace();
	}
%>
					</tbody>
				</table>
				<div class="pageNav">
					<ul class="pagination">
					<%
						int prePage;//上一页的页数
						if(pagesNo == 1){
							prePage = 1;//若当前页是第一页，则第一页只能是当前页
						}else{
							prePage = pagesNo - 1;//除了上述情况外上一页等于当前页-1页
						}
					%>
					<li class="page-item"><a class="page-link" href="race5.jsp?pages=<%=prePage%>" target="contain">上一页</a></li>
					<%
						pagesCount = (lastRow % pageSize == 0) ? (lastRow / pageSize) : (lastRow / pageSize +1);//计算数据库能读出来的全部页数
						int minpages = (pagesNo - 3 >0) ? (pagesNo - 3) : 1;//设定最小页，防止页数小于第一页
						int maxpages = (pagesNo + 3 >= pagesCount) ? (pagesCount) : (pagesNo+3);//设定最大页
						for(int i = minpages;i <=maxpages ;i++){
							if(i == pagesNo){//当前页和遍历出来的页数相等时，需要通过调用css里面的样式“active"进行高亮
								out.print("<li class='page-item active'>");
								out.print("<a class='page-link' href='contain.jsp?pages="+i+"'>"+i+"</a>");
								out.print("</li>");
							}else{//输出每一个分页
								out.print("<li class='page-item'>");
								out.print("<a class='page-link' href='contain.jsp?pages="+i+"'>"+i+"</a>");
								out.print("</li>");
							}
							
						}
							//out.print("<li class='page-item'>");
							//out.print("<a class='page-link' href='#>...</a>");
							//out.print("</li>");
					%>
					<%
						int nextPage;
						if(pagesNo == pagesCount){//下一页的原理和上一页同理
							nextPage = pagesCount;
						}else{
							nextPage = pagesNo + 1;
						}
					%>
					<li class="page-item"><a class="page-link" href="race5.jsp?pages=<%=nextPage%>" target="contain">下一页</a></li>
					</ul>
				</div>
			</div>
		</div>			
  </body>
</html>