postpresql Jdbc java连接

一：下载：postgresql-9.1-901.jdbc4.jar 驱动

二：

package postpresql;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


/**
 * postpresqlJdbc java jdbc 测试类
 * 
 * @author Administrator
 *
 */
public class postpresqlJdbc {
static String url = "jdbc:postgresql://localhost:5432/postgres";
static String usr = "testuser";
static String psd = "testuser";


public static void main(String args[]) {
Connection conn = null;
try {
Class.forName("org.postgresql.Driver");
conn = DriverManager.getConnection(url, usr, psd);
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM tds_user");
while (rs.next()) {
System.out.print(rs.getString(1));
System.out.print("  ");
}
rs.close();
st.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}