<%@page import="java.sql.ResultSet"%> <%@page import="java.sql.PreparedStatement"%> <%@page import="java.sql.DriverManager"%> <%@page import="java.sql.Connection"%> <%@page contentType="text/html" pageEncoding="UTF-8"%> 员工信息

员工信息列表


欢迎你， 退出

姓名：
部门：
<% String driver = "com.mysql.cj.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/edu?characterEncoding=utf-8" + "&serverTimezone=UTC"; String usr = "root"; String password = "1234"; Class.forName(driver); Connection conn = DriverManager.getConnection(url, usr, password); String sqlString = "select * from manager1"; PreparedStatement pstmt = conn.prepareStatement(sqlString); ResultSet rs = pstmt.executeQuery(); %> <% while (rs.next()) { out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); } %>
序号 姓名 性别 电话 邮箱 年龄 部门 操作
" + rs.getString("count") + "" + rs.getString("name") + "" + rs.getString("gender") + "" + rs.getString("telephone") + "" + rs.getString("mailbox") + "" + rs.getInt("age") + "" + rs.getString("department") + "