<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.text.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>
PostgreSQL JDBC 测试页面
<%request.setCharacterEncoding("GBK");%>
<%
/*
本例是使用jdbc连接PostgreSQL的例子，相应参数根据自己情况进行修改！
有关PostgreSQL JDBC的详细说明请访问 http://jdbc.postgresql.org/
*/
Class.forName("org.postgresql.Driver");
Connection conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/数据库名称?user=账号&password=密码");
Statement stmt = null;
ResultSet rs = null;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM cities");
while(rs.next()){
%>
<%=rs.getString("name")%>
<%
}
rs.close();rs=null;
stmt.close();stmt = null;
conn.close();conn = null;
} finally {
if (rs != null) {
try {
rs.close();
} catch (Exception sqlex) {
}
rs = null;
}
if (stmt != null) {
try {
stmt.close();
} catch (Exception sqlex) {
}
stmt = null;
}
if (conn != null) {
try {
conn.close();
} catch (Exception sqlex) {
}
conn = null;
}
}
%>