Author: [log in to unmask]
Date: Mon Nov 17 13:52:54 2014
New Revision: 1554
Log:
Move a few static utility methods to new class from DatabaseConditionsManager.
Added:
java/trunk/conditions/src/main/java/org/hps/conditions/database/DatabaseUtilities.java
Added: java/trunk/conditions/src/main/java/org/hps/conditions/database/DatabaseUtilities.java
=============================================================================
--- java/trunk/conditions/src/main/java/org/hps/conditions/database/DatabaseUtilities.java (added)
+++ java/trunk/conditions/src/main/java/org/hps/conditions/database/DatabaseUtilities.java Mon Nov 17 13:52:54 2014
@@ -0,0 +1,42 @@
+package org.hps.conditions.database;
+
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
+
+public final class DatabaseUtilities {
+
+ /**
+ * Close a JDBC <code>Statement</code>.
+ * @param statement the Statement to close
+ */
+ public static void close(Statement statement) {
+ if (statement != null) {
+ try {
+ if (!statement.isClosed()) {
+ statement.close();
+ }
+ } catch (SQLException x) {
+ throw new RuntimeException("Failed to close statement.", x);
+ }
+ }
+ }
+
+ /**
+ * Close the JDBC the <code>Statement</code> connected to the <code>ResultSet</code>.
+ * @param resultSet the ResultSet to close
+ */
+ public static void close(ResultSet resultSet) {
+ if (resultSet != null) {
+ try {
+ Statement statement = resultSet.getStatement();
+ if (!statement.isClosed()) {
+ statement.close();
+ }
+ } catch (SQLException x) {
+ throw new RuntimeException("Failed to close statement.", x);
+ }
+ }
+ }
+
+}
|