2024/3/21

<%@ page import="java.sql.*" %><%--
Created by IntelliJ IDEA.
User: 联想
Date: 2023/10/25
Time: 14:33
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<tr>
<th>姓名</th>
<th>学号</th>
<th>性别</th>
<th>班级</th>
</tr><br>
<%
String driverClass="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/name3?serverTimezone=Asia/Shanghai";
String user="root";
String password="123456";
String num=new String(request.getParameter("number"));
Connection conn;
try{
Class.forName(driverClass);
conn= DriverManager.getConnection(url, user, password);
String sql="select * from message where number='"+num+"'";
Statement stmt=conn.prepareStatement(sql);
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<tr>
<td><%=rs.getString("name") %></td>
<td><%=rs.getString("number") %></td>
<td><%=rs.getString("sex") %></td>
<td><%=rs.getString("class") %></td>
</tr><br>
<%
}
}catch (Exception ex){
ex.printStackTrace();

}
%>
</body>
</html>
posted @ 2024-03-21 20:35  几条小鱼  阅读(7)  评论(0)    收藏  举报