<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@page import="java.sql.*"%>
<%
request.setCharacterEncoding("UTF-8");
String pages = request.getParameter("pages");//获取当前页数
int pagesNo = Integer.parseInt(pages);//把当前页数从字符串转为整型
int startLine = (Integer.parseInt(pages)-1)*10;//指定数据库从哪一行开始读取
%>
| 姓名 |
学号 |
班级 |
性别 |
项目 |
比赛成绩 |
排名 |
<%
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("");
out.print("| "+rs.getString(1)+" | ");
out.print(""+rs.getString(2)+" | ");
out.print(""+rs.getString(3)+" | ");
out.print(""+rs.getString(4)+" | ");
out.print(""+rs.getString(5)+" | ");
out.print(""+rs.getString(6)+" | ");
out.print(""+rs.getString(7)+" | ");
out.print("
");
}
con.close();
}catch(SQLException e){
e.printStackTrace();
}
%>