<%@ page language= "java" contentType="text/html;charset=UTF-8" %>
<%@ page import="java.util.*,java.sql.*" %>
<html>
<head>
<meta charset="utf-8">
<title>test</title>
</head>
<body>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection conn= DriverManager.getConnection("jdbc:mysql://localhost/webtest","root","123");
String sql = "SELECT * FROM user;";
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs =ps.executeQuery();
%>
<table border=1 align=center>
<tr>
<th>用户编号</th>
<th>用户名</th>
<th>密码</th>
<th>邮箱</th>
</tr>
<% while( rs.next()){ %>
<tr>
<td><%=rs.getInt("id") %></td>
<td><%=rs.getString("username") %></td>
<td><%=rs.getString("password") %></td>
<td><%=rs.getString("email") %></td>
</tr>
<% } %>
</table>
</body>
</html>