<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@page import="java.sql.*"%>
| 学号 |
姓名 |
班级 |
性别 |
项目 |
比赛成绩 |
排名 |
操作 |
<%
//查询功能
request.setCharacterEncoding("UTF-8");
String search = request.getParameter("check");
String sqlQuery;
if(search.matches("[0-9]+")){
sqlQuery = "SELECT * FROM ydh.grade where num='"+search+"'";
}else{
sqlQuery = "SELECT * FROM ydh.grade where name='"+search+"'";
}
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();
ResultSet rs = sql.executeQuery(sqlQuery);
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(" | ");
out.print("
");
}
con.close();
}catch(SQLException e){
e.printStackTrace();
}
%>