KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > mule > providers > jdbc > JdbcUtils


1 /*
2  * $Id: JdbcUtils.java 3798 2006-11-04 04:07:14Z aperepel $
3  * --------------------------------------------------------------------------------------
4  * Copyright (c) MuleSource, Inc. All rights reserved. http://www.mulesource.com
5  *
6  * The software in this package is published under the terms of the MuleSource MPL
7  * license, a copy of which has been included with this distribution in the
8  * LICENSE.txt file.
9  */
10
11 package org.mule.providers.jdbc;
12
13 import java.sql.Connection JavaDoc;
14 import java.sql.SQLException JavaDoc;
15
16 /**
17  * Utility methods for working with various parts of JDBC.
18  */
19 public abstract class JdbcUtils
20 {
21
22     public static void close(Connection JavaDoc con) throws SQLException JavaDoc
23     {
24         if (con != null && !con.isClosed())
25         {
26             con.close();
27         }
28     }
29
30     public static void commitAndClose(Connection JavaDoc con) throws SQLException JavaDoc
31     {
32         if (con != null)
33         {
34             if (con.getAutoCommit() == false)
35             {
36                 con.commit();
37             }
38             con.close();
39         }
40     }
41
42     public static void rollbackAndClose(Connection JavaDoc con) throws SQLException JavaDoc
43     {
44         if (con != null)
45         {
46             if (con.getAutoCommit() == false)
47             {
48                 con.rollback();
49             }
50             con.close();
51         }
52     }
53
54 }
55
Popular Tags