2024/4/11

<%@ page import="java.sql.*" %><%--
Created by IntelliJ IDEA.
User: 联想
Date: 2023/11/23
Time: 22:37
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>
<table>
<tr>
<td>工号</td>
<td>姓名</td>
<td>性别</td>
<td>部门</td>
<td>职位</td>
<td>生日</td>
</tr><br>
<%
String jobid= (String) session.getAttribute("jobid");
out.println(jobid);
try {
String url = "jdbc:mysql://localhost:3306/fish?serverTimezone=Asia/Shanghai";
String user = "root";
String password = "123456";

Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn = DriverManager.getConnection(url, user, password);
String sql = "select * from message1 where jobid=?";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1, jobid);
ResultSet rs = stmt.executeQuery();

if (rs.next()) {
%>
<tr>
<td><%=rs.getString("jobid") %></td>
<td><%=rs.getString("name") %></td>
<td><%=rs.getString("sex") %></td>
<td><%=rs.getString("department") %></td>
<td><%=rs.getString("role") %></td>
<td><%=rs.getString("birthday") %></td>
</tr>
<%
} else {
out.println("No records found");
}
rs.close();
stmt.close();
conn.close();
} catch (Exception ex) {
ex.printStackTrace();
out.println("An error occurred: " + ex.getMessage());
}
%>
</table>
</body>
</html>
posted @ 2024-04-11 22:01  几条小鱼  阅读(13)  评论(0)    收藏  举报