<%@page import="java.sql.*"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> 教师信息
<% request.setCharacterEncoding("utf-8"); //jdbc注册数据库驱动，连接数据库 Class.forName("com.mysql.jdbc.Driver"); String username = "root";//数据库用户名 String url = "jdbc:mysql://127.0.0.1:3306/teamessage?serverTimezone=UTC";//数据库名字 String password = "1314";//数据库密码 Connection conn = DriverManager.getConnection(url,username,password); String sql = "SELECT * from teachermessage";//编写SQL语句 Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql); while(rs.next()){ int id = rs.getInt(1); String Teaname=rs.getString(1); %> <% } //关闭流操作，先打开的后关闭 rs.close(); stmt.close(); conn.close(); %>
教师姓名 教师年龄 教师性别 删除选项
<%=rs.getString("TeaName")%> <%=rs.getString("TeaAge")%> <%=rs.getString("TeaSex")%>