Java JDBC How to - Connect with PostgreSQL

Question

We would like to know how to connect with PostgreSQL.

Answer

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
/*from   ww  w.  ja v  a2s .c  o  m*/
public class Main {
  public static void main(String[] args) throws Exception {
    String hostname = "", dbname = "", username = "", password = "";
    Class.forName("org.postgresql.Driver");
    Connection connection = DriverManager.getConnection("jdbc:postgresql://"
        + hostname + "/" + dbname, username, password);
    ResultSet rs = connection.createStatement().executeQuery(
        "select version() as version");
    while (rs.next()) {
      System.out.println(rs.getString("version"));
    }
  }
}