JSP文件的内容：
<%@ page import="java.sql.*" pageEncoding="utf-8" %><!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>PostgreSQL Example</title>
</head>
<body>
<%
try {
Class.forName("org.postgresql.Driver");
Connection conn = DriverManager.getConnection("jdbc:postgresql://localhost/mydb", "postgres", "密码");
String sql = "SELECT * FROM test ORDER BY id";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
%>
<table width="100%" border="1" cellpadding="4" style="border-collapse:collapse">
<tbody>
<tr>
<th scope="col">ID</th>
<th scope="col">Name</th>
<th scope="col">Value</th>
</tr>
<% while (rs.next()) { %>
<tr align="center">
<td><%= rs.getString(1) %></td>
<td><%= rs.getString(2) %></td>
<td><%= rs.getString(3) %></td>
</tr>
<% } %>
</tbody>
</table>
<%
rs.close();
stmt.close();
conn.close();
} catch (ClassNotFoundException err) {
out.println("<h4>无法找到数据库驱动！</h4>");
out.println("<p>请检查WEB-INF文件夹下是否有web.xml文件，以及WEB-INF/lib下是否有数据库驱动的jar文件</p>");
}
%></body>
</html>
