<%@ 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 teachclass"; 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("ClassName")%> <%=rs.getString("ClassTeacherName")%> <%=rs.getString("ClassTime")%>