<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<table width="300" border="1">
<tr>
<td>序号</td>
<td>姓名</td>
<td>年龄</td>
</tr>
<%
//驱动程序名
String driverName="com.mysql.jdbc.Driver";
//数据库用户名，根据实际情况改成你的用户名
String userName="root";
//密码，改成你的密码
String userPasswd="123456";
//数据库名，改成你的数据库名称
String dbName="test";
//表名，更改成你的表名
String tableName="people";
//联结字符串
String url="jdbc:mysql://localhost:3306/"+dbName;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection=DriverManager.getConnection(url,userName,userPasswd);
Statement statement = connection.createStatement();
String sql="SELECT * FROM "+tableName;
ResultSet rs = statement.executeQuery(sql);
while(rs.next()) {%>
<tr>
<td><%= rs.getInt(1) %></td>
<td><%= rs.getString(2) %></td>
<td><%= rs.getInt(3) %></td>
</tr>
<%}
out.print("数据库操作成功，恭喜你");
rs.close();
statement.close();
connection.close();
%>
</table>
</body>
</html>
