advanced code snippet search

Posted By

octaviannitagmailcom on 02/24/12


Tagged

connection close jdbc statement resultset boilerplate


Versions (?)

Boilerplate: closing JDBC resources

 / Published in: Java
 

Boilerplate JDBC code to close various resources (I just hate repeating myself in my code...)

Expand | Embed | Plain Text 
  1. public static void close(ResultSet resultSet, Statement statement, Connection connection) {
  2.     if (resultSet != null) {
  3.         try {
  4.             resultSet.close();
  5.         } catch (SQLException e) {
  6.             logger.error("cannot close result set", e);
  7.         }
  8.     }
  9.     if (statement != null) {
  10.         try {
  11.             statement.close();
  12.         } catch (SQLException e) {
  13.             logger.error("cannot close statement", e);
  14.         }
  15.     }
  16.     if (connection != null) {
  17.         try {
  18.             connection.close();
  19.         } catch (SQLException e) {
  20.             logger.error("cannot close database connection", e);
  21.         }
  22.     }
  23. }
  24.  
  25. public static void close(ResultSet resultSet, Statement statement) {
  26.     close(resultSet, statement, null);
  27. }
  28.  
  29. public static void close(ResultSet resultSet) {
  30.     close(resultSet, null, null);
  31. }

Report this snippet  

You need to login to post a comment.