weiyong
/
z202109g06


			
				
					
						
						
							1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
							<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<p align="center">当天授课信息表</p>
	<table align="center" width="50%" border="1">
	<tr>
		<th>课程名字</th>
		<th>授课教师</th>
		<th>课程时间</th>
	</tr>
	<%
		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);
	%>
		<tbody>
	<tr>
		<td><%=rs.getString("ClassName")%></td>
		<td><%=rs.getString("ClassTeacherName")%></td>
		<td><%=rs.getString("ClassTime")%></td>
		<td>
			<a  href="shaw.jsp?id=<%= id%>"><!-- 通过主键id值来获取到当前行最后删除> -->
				<input type="button" value="删除" class="btn btn-warning" >
			</a>
		</td>
	</tr>
		</tbody>
		<!-- 创建数据库表
		create table teachclass
        (
    		id int auto_increment primary key,
    		ClassName varchar(20),
    		ClassTeacherName varchar(20),
    		ClassTime varchar(20),
		);
	 -->
		<%
		}
		rs.close();
		stmt.close();
		conn.close();
	%>
	</table>
	<p></p>
	<p></p>
		<div align="center">
			<a href="show.jsp">
				<input type="button" value="返回首页">
			</a>
			<a href="addTeacherClass.html">
				<input type="button" value="增加信息">
			</a>

		</div>

</body>
</html>