<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
Revise
<%!
String id;
String sourceId;
String name;
String _class;
String sex;
String project;
String grade;
String ranking;
%>
<%
request.setCharacterEncoding("UTF-8");
id = request.getParameter("num");
String sqlid = "SELECT * FROM ydh.grade where num='"+id+"'";
sourceId = id;
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(sqlid);
if(rs.next()){
name = rs.getString(2);
_class = rs.getString(3);
sex = rs.getString(4);
project = rs.getString(5);
grade = rs.getString(6);
ranking = rs.getString(7);
}
rs.close();
sql.close();
con.close();
}catch(Exception e){
e.printStackTrace();
}
%>