2024/4/12

<%--
Created by IntelliJ IDEA.
User: 联想
Date: 2023/11/20
Time: 16:57
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title><%@ 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>
<th>职位</th>
<th>生日</th>
<th>密码</th>
</tr><br>
<%
String driverClass="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/fish?serverTimezone=Asia/Shanghai";
String user="root";
String password="123456";
Connection conn;
try{
Class.forName(driverClass);
conn= DriverManager.getConnection(url, user, password);
String sql="select * from message1";
Statement stmt=conn.prepareStatement(sql);
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<tr>
<td><%=rs.getString("name") %></td>
<td><%=rs.getString("jobid") %></td>
<td><%=rs.getString("sex") %></td>
<td><%=rs.getString("department") %></td>
<td><%=rs.getString("role") %></td>
<td><%=rs.getString("birthday") %></td>
<td><%=rs.getString("password1") %></td>
<td><a href="change03.jsp?jobid=<%=rs.getString("jobid")%>" >更改职位</a></td>
</tr><br>
<%
}
}catch (Exception ex){
ex.printStackTrace();
}
%>
<a href="guanli.jsp">返回</a>
</body>
</html>
posted @ 2024-04-12 22:01  几条小鱼  阅读(8)  评论(0)    收藏  举报