<% @page import= "java.sql.*"%>
<% @page contenttype= "text/html" pageencoding= "UTF-8"%>
<! DOCTYPE html>
<meta http-equiv= "Content-type" content= "text/html; Charset=utf-8 ">
<title> access the database through the MySQL JDBC driver </title>
<body>
<table border= "1" bgcolor= "#ccceee" align= "Center" >
<tr>
<th width= "" align= "Center" > Study No. </th>
<th width= "" align= "center" > Name </th>
<th width= "align=", "center" > Professional </th>
</tr>
<%
Connection Con=null;
Statement Stmt=null;
ResultSet Rs=null;
Class.forName ("Com.mysql.jdbc.Driver");
/*3306 is the port number, student is the database name, the URL is appended to the USEUNICODE=TRUE&CHARACTERENCODING=GBK, is to handle the problem of garbled when adding data to the database. */
String url= "JDBC:MYSQL://LOCALHOST:3306/STUDENT?USEUNICODE=TRUE&CHARACTERENCODING=GBK";
Con=drivermanager.getconnection (URL, "root", "root");
Stmt=con.createstatement ();
String sql= "SELECT * from Sinfo";
Rs=stmt.executequery (SQL);
while (Rs.next ()) {
%>
<tr>
<td><%=rs.getstring ("Studentnumber")%></td>
<td><%=rs.getstring ("Studentname")%></td>
<td><%=rs.getstring ("StudentClass")%></td>
</tr>
<%
}
Rs.close ();
Stmt.close ();
Con.close ();
%>
</table>
</body>
