<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" import="java.sql.*"%> Insert title here

教师信息表

<% request.setCharacterEncoding("utf-8"); 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 keyanproject"; Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql); while(rs.next()){ int id = rs.getInt(1); %> <% } rs.close(); stmt.close(); conn.close(); %>
课设项目 完成时间 项目作者
<%=rs.getString("projectName")%> <%=rs.getString("projectDate")%> <%=rs.getString("projectAuthor")%>