weiyong
/
z202109g06


			
				
					
						
						
							12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061
							<%@ 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 article";
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			while(rs.next()){
				int id = rs.getInt(1);
		%><tbody>
		<tr>
			<td><%=rs.getString("authArticle")%></td>
			<td><%=rs.getString("titleArticle")%></td>
			<td><%=rs.getString("prizeArticle")%></td>
		<td>
			<a  href="shown.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="addArticle.html">
			<input type="button" value="增加信息">
			</a>

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