View Javadoc

1   package com.atlassian.core.db;
2   
3   import java.sql.Connection;
4   import java.sql.ResultSet;
5   import java.sql.SQLException;
6   import java.sql.Statement;
7   
8   /**
9    * JDBC utilities. Initially from Confluence
10   */
11  public class JDBCUtils
12  {
13      public static void close(Statement stmt)
14      {
15          if (stmt != null)
16          {
17              try
18              {
19                  stmt.close();
20              }
21              catch (SQLException e)
22              {
23                  //noop.
24              }
25          }
26      }
27  
28      public static void close(ResultSet rs)
29      {
30          if (rs != null)
31          {
32              try
33              {
34                  rs.close();
35              }
36              catch (SQLException e)
37              {
38                  //noop.
39              }
40          }
41      }
42  
43      public static void close(Connection conn)
44      {
45          try
46          {
47              if (conn != null && !conn.isClosed())
48              {
49                  conn.close();
50              }
51          }
52          catch (SQLException e)
53          {
54              // noop.
55          }
56      }
57  }