<%@page import="java.sql.ResultSet"%> <%@page import="java.sql.PreparedStatement"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.DriverManager"%> <%@page import="java.sql.Connection"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <% String department=request.getParameter("department"); String driver="com.mysql.cj.jdbc.Driver"; String url="jdbc:mysql://localhost:3306/edu?characterEncoding=utf-8" + "&serverTimezone=UTC"; String user="root"; String password="1234"; Class.forName(driver); Connection conn=DriverManager.getConnection(url,user,password); //插入数据 String sql="SELECT*FROM manager1 where department=?"; PreparedStatement pstmt=conn.prepareStatement(sql); pstmt.setString(1,department); ResultSet rs = pstmt.executeQuery(); int i=1; 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") + "	删除 修改

<% pstmt.close(); conn.close(); %>