weiyong
/
z202109g06


			
				
					
						
						
							1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
							<%@ 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 keyanproject";
		Statement stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery(sql);
		while(rs.next()){
			int id = rs.getInt(1);

	%>
		<tbody>
	<tr>
		<td><%=rs.getString("projectName")%></td>
		<td><%=rs.getString("projectDate")%></td>
		<td><%=rs.getString("projectAuthor")%></td>
	<td>
		<a  href="shew.jsp?id=<%= id%>"><!-- 通过主键id值来获取到当前行最后删除> -->
			<input type="button" value="删除" class="btn btn-warning" >
		</a>
	</td>
	</tr>
		</tbody>
	<%
		}
		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="addKeyan.html">
				<input type="button" value="增加信息">
			</a>

		</div>
</body>
</html>