String url = "jdbc:postgresql://hostname:port/database";
String username = "username";
String password = "password";
Connection connection = DriverManager.getConnection(url, username, password);
Statement statement = connection.createStatement();
String sql = "SELECT * FROM table WHERE condition";
ResultSet resultSet = statement.executeQuery(sql);
if (resultSet.next()) {
} else {
}
connection.setAutoCommit(false);
try {
connection.commit();
} catch (SQLException e) {
connection.rollback();
}
ResultSet resultSet = statement.executeQuery(sql);
java.sql.Date date = resultSet.getDate("date_column");
