try-with-resources.java

try (Connection con = DriverManager.getConnection(JDBC_URL, USER, PASSWORD)) {
  try (PreparedStatement query = con.prepareStatement(SQL_SELECT)) {
    query.setInt(1, Integer.valueOf(value));
    try (ResultSet rs = query.executeQuery()) {
        while (rs.next()) {
          System.out.println(rs.getString(1));
        }
    }
  }
} catch (SQLException e) {
  throw new RuntimeException(e);
}