Java JDBC How to - Use jdbc driver for postgresql

Question

We would like to know how to use jdbc driver for postgresql.

Answer

import java.sql.Connection;
import java.sql.DriverManager;
//from   w w w .java2 s  .c  o m
public class Main {
  public static final String driver = "org.postgresql.Driver";
  public static final String url = "jdbc:postgresql://localhost:5432/party";
  public static final String username = "pgsuper";
  public static final String password = "pgsuper";

  public static void main(String[] args) {
    try {
      Class.forName(driver);
      Connection conn = DriverManager.getConnection(url, username, password);
      System.out.println(conn.getMetaData().getDatabaseProductName());
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
}