java jdbc连接postgresql

通过最基础的jdbc形式来连接postgresql，相关代码如下：

package com;

import java.sql.*;

public class DbTest {

private static String url = "jdbc:postgresql://127.0.0.1:5432/test";

private static String driver = "org.postgresql.Driver";

private static String user = "postgres";

private static String password = "postgres";

public static void main(String[] args) {

String sql = "select * from biz_account";

DbTest dbHelper = new DbTest(sql);

try {

ResultSet resultSet = dbHelper.getStatement().executeQuery();

System.out.println("Id username password");

while (resultSet.next()) {

System.out.println(resultSet.getString(1) + " " + resultSet.getString(2) + " " + resultSet.getString(3));

}

dbHelper.close();

} catch (SQLException e) {

dbHelper.close();

e.printStackTrace();

}

private Connection connection = null;

public Connection getConnection() {

return connection;

}

public PreparedStatement getStatement() {

return statement;

}

private PreparedStatement statement = null;

public DbTest(String sql) {

try {

Class.forName(driver);

connection = DriverManager.getConnection(url, user, password);

statement = connection.prepareStatement(sql);

} catch (Exception e) {

e.printStackTrace();

}

public void close() {

try {

this.connection.close();

this.statement.close();

} catch (Exception e) {

e.printStackTrace();

}

package com; import java.sql.*; public class DbTest { private static String url = "jdbc:postgresql://127.0.0.1:5432/test"; private static String driver = "org.postgresql.Driver"; private static String user = "postgres"; private static String password = "postgres"; public static void main(String[] args) { String sql = "select * from biz_account"; DbTest dbHelper = new DbTest(sql); try { ResultSet resultSet = dbHelper.getStatement().executeQuery(); System.out.println("Id username password"); while (resultSet.next()) { System.out.println(resultSet.getString(1) + " " + resultSet.getString(2) + " " + resultSet.getString(3)); } dbHelper.close(); } catch (SQLException e) { dbHelper.close(); e.printStackTrace(); } } private Connection connection = null; public Connection getConnection() { return connection; } public PreparedStatement getStatement() { return statement; } private PreparedStatement statement = null; public DbTest(String sql) { try { Class.forName(driver); connection = DriverManager.getConnection(url, user, password); statement = connection.prepareStatement(sql); } catch (Exception e) { e.printStackTrace(); } } public void close() { try { this.connection.close(); this.statement.close(); } catch (Exception e) { e.printStackTrace(); } } }

package com;

import java.sql.*;

public class DbTest {

	private static String url = "jdbc:postgresql://127.0.0.1:5432/test";
	private static String driver = "org.postgresql.Driver";
	private static String user = "postgres";
	private static String password = "postgres";

	public static void main(String[] args) {
		String sql = "select * from biz_account";
		DbTest dbHelper = new DbTest(sql);
		try {
			ResultSet resultSet = dbHelper.getStatement().executeQuery();
			System.out.println("Id      username        password");
			while (resultSet.next()) {
				System.out.println(resultSet.getString(1) + "          " + resultSet.getString(2) + "             " + resultSet.getString(3));
			}
			dbHelper.close();
		} catch (SQLException e) {
			dbHelper.close();
			e.printStackTrace();
		}

	}


	private Connection connection = null;

	public Connection getConnection() {
		return connection;
	}


	public PreparedStatement getStatement() {
		return statement;
	}


	private PreparedStatement statement = null;

	public DbTest(String sql) {
		try {
			Class.forName(driver);
			connection = DriverManager.getConnection(url, user, password);
			statement = connection.prepareStatement(sql);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public void close() {
		try {
			this.connection.close();
			this.statement.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

}

java jdbc连接postgresql插图