|
1
43 package org.exolab.jms.persistence;
44
45 import java.io.IOException  ;
46 import java.io.InputStream ;
47 import java.io.OutputStream ;
48 import java.sql.Connection ;
49 import java.sql.ResultSet ;
50 import java.sql.SQLException ;
51 import java.sql.Statement ;
52
53
54
60 public class SQLHelper {
61
62 public static boolean rollback(Connection connection) {
63 boolean rolledback = false;
64 if (connection != null) {
65 try {
66 connection.rollback();
67 rolledback = true;
68 } catch (SQLException ignore) {
69 }
70 }
71 return rolledback;
72 }
73
74 public static boolean close(Connection connection) {
75 boolean closed = false;
76 if (connection != null) {
77 try {
78 connection.close();
79 closed = true;
80 } catch (SQLException ignore) {
81 }
82 }
83 return closed;
84 }
85
86 public static boolean close(Statement statement) {
87 boolean closed = false;
88 if (statement != null) {
89 try {
90 statement.close();
91 closed = true;
92 } catch (SQLException ignore) {
93 }
94 }
95 return closed;
96 }
97
98 public static boolean close(ResultSet set) {
99 boolean closed = false;
100 if (set != null) {
101 try {
102 set.close();
103 closed = true;
104 } catch (SQLException ignore) {
105 }
106 }
107 return closed;
108 }
109
110 public static boolean close(InputStream is) {
111 boolean closed = false;
112 if (is != null) {
113 try {
114 is.close();
115 closed = true;
116 } catch (IOException ignore) {}
117 }
118 return closed;
119 }
120
121 public static boolean close(OutputStream os) {
122 boolean closed = false;
123 if (os != null) {
124 try {
125 os.close();
126 closed = true;
127 } catch (IOException ignore) {}
128 }
129 return closed;
130 }
131
132 }
133 |
Popular Tags |
Java API By Example, From Geeks To Geeks.