simple JDBC

Jdbc.java

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

public class Test {

	public static void main(String[] args) throws Exception {
		Connection conn = DriverManager.getConnection("jdbc:postgresql://hostname:port/schema", "username", "password");
		try {
			doStuff(conn);
		} finally {
			conn.close();
		}

	}

	private static void doStuff(Connection conn) throws SQLException {
		Statement stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery("select now()");
		while (rs.next()) {
			Timestamp ts = rs.getTimestamp(1);
			System.out.println(ts);
		}
		stmt.close();
	}
}

pom.xml

  	<dependency>
  		<groupId>org.postgresql</groupId>
  		<artifactId>postgresql</artifactId>
  		<version>9.2-1003-jdbc4</version>
  	</dependency>