How should I use try-with-resources with JDBC?

by

I realize this was long ago answered but want to suggest an additional approach that avoids the nested try-with-resources double block.

public List<User> getUser(int userId) {
    try (Connection con = DriverManager.getConnection(myConnectionURL);
         PreparedStatement ps = createPreparedStatement(con, userId); 
         ResultSet rs = ps.executeQuery()) {

         // process the resultset here, all resources will be cleaned up

    } catch (SQLException e) {
        e.printStackTrace();
    }
}

private PreparedStatement createPreparedStatement(Connection con, int userId) throws SQLException {
    String sql = "SELECT id, username FROM users WHERE id = ?";
    PreparedStatement ps = con.prepareStatement(sql);
    ps.setInt(1, userId);
    return ps;
}

More Related Contents:

  1. Java 7 Automatic Resource Management JDBC (try-with-resources statement)
  2. What’s the purpose of try-with-resources statements?
  3. Close resource quietly using try-with-resources
  4. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  5. Show JDBC ResultSet in HTML in JSP page using MVC and DAO pattern
  6. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  7. How to establish a connection pool in JDBC?
  8. java.sql.SQLException: – ORA-01000: maximum open cursors exceeded
  9. Using setDate in PreparedStatement
  10. java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
  11. Handling MySQL datetimes and timestamps in Java
  12. Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?
  13. java.sql.SQLException: Column count doesn’t match value count at row 1
  14. Can’t transparent and undecorated JFrame in JDK7 when enabling nimbus
  15. Android import java.nio.file.Files; cannot be resolved
  16. How is driver class located in JDBC4
  17. Getting output from dbms_output.get_lines using JDBC
  18. Technically what is the main difference between Oracle JDK and OpenJDK? [duplicate]
  19. Java – Can’t use ResultSet after connection close
  20. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  21. Try-with-resources and return statements in java
  22. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  23. Close multiple resources with AutoCloseable (try-with-resources)
  24. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  25. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  26. Connection cannot be cast to oracle.jdbc.OracleConnection
  27. How to connect to a remote MySQL database with Java?
  28. Does collect operation on Stream close the stream and underlying resources?
  29. Postgres UUID JDBC not working
  30. How to get jdbc connection from hibernate session? [duplicate]

Leave a Comment