KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > exolab > jms > persistence > SQLHelper


1 /**
2  * Redistribution and use of this software and associated documentation
3  * ("Software"), with or without modification, are permitted provided
4  * that the following conditions are met:
5  *
6  * 1. Redistributions of source code must retain copyright
7  * statements and notices. Redistributions must also contain a
8  * copy of this document.
9  *
10  * 2. Redistributions in binary form must reproduce the
11  * above copyright notice, this list of conditions and the
12  * following disclaimer in the documentation and/or other
13  * materials provided with the distribution.
14  *
15  * 3. The name "Exolab" must not be used to endorse or promote
16  * products derived from this Software without prior written
17  * permission of Exoffice Technologies. For written permission,
18  * please contact info@exolab.org.
19  *
20  * 4. Products derived from this Software may not be called "Exolab"
21  * nor may "Exolab" appear in their names without prior written
22  * permission of Exoffice Technologies. Exolab is a registered
23  * trademark of Exoffice Technologies.
24  *
25  * 5. Due credit should be given to the Exolab Project
26  * (http://www.exolab.org/).
27  *
28  * THIS SOFTWARE IS PROVIDED BY EXOFFICE TECHNOLOGIES AND CONTRIBUTORS
29  * ``AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT
30  * NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
31  * FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL
32  * EXOFFICE TECHNOLOGIES OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
33  * INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
34  * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
35  * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
36  * HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT,
37  * STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
38  * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED
39  * OF THE POSSIBILITY OF SUCH DAMAGE.
40  *
41  * Copyright 2000-2005 (C) Exoffice Technologies Inc. All Rights Reserved.
42  */

43 package org.exolab.jms.persistence;
44
45 import java.io.IOException JavaDoc;
46 import java.io.InputStream JavaDoc;
47 import java.io.OutputStream JavaDoc;
48 import java.sql.Connection JavaDoc;
49 import java.sql.ResultSet JavaDoc;
50 import java.sql.SQLException JavaDoc;
51 import java.sql.Statement JavaDoc;
52
53
54 /**
55  * SQL helper routines.
56  *
57  * @version $Revision: 1.2 $ $Date: 2005/06/09 14:39:52 $
58  * @author <a HREF="mailto:tima@intalio.com">Tim Anderson</a>
59  */

60 public class SQLHelper {
61
62     public static boolean rollback(Connection JavaDoc connection) {
63         boolean rolledback = false;
64         if (connection != null) {
65             try {
66                 connection.rollback();
67                 rolledback = true;
68             } catch (SQLException JavaDoc ignore) {
69             }
70         }
71         return rolledback;
72     }
73
74     public static boolean close(Connection JavaDoc connection) {
75         boolean closed = false;
76         if (connection != null) {
77             try {
78                 connection.close();
79                 closed = true;
80             } catch (SQLException JavaDoc ignore) {
81             }
82         }
83         return closed;
84     }
85
86     public static boolean close(Statement JavaDoc statement) {
87         boolean closed = false;
88         if (statement != null) {
89             try {
90                 statement.close();
91                 closed = true;
92             } catch (SQLException JavaDoc ignore) {
93             }
94         }
95         return closed;
96     }
97
98     public static boolean close(ResultSet JavaDoc set) {
99         boolean closed = false;
100         if (set != null) {
101             try {
102                 set.close();
103                 closed = true;
104             } catch (SQLException JavaDoc ignore) {
105             }
106         }
107         return closed;
108     }
109
110     public static boolean close(InputStream JavaDoc is) {
111         boolean closed = false;
112         if (is != null) {
113                 try {
114                     is.close();
115                     closed = true;
116                 } catch (IOException JavaDoc ignore) {}
117         }
118         return closed;
119     }
120
121     public static boolean close(OutputStream JavaDoc os) {
122         boolean closed = false;
123         if (os != null) {
124                 try {
125                     os.close();
126                     closed = true;
127                 } catch (IOException JavaDoc ignore) {}
128         }
129         return closed;
130     }
131
132 }
133
Popular Tags