01: /*
02: * Copyright (c) JForum Team
03: * All rights reserved.
04: *
05: * Redistribution and use in source and binary forms,
06: * with or without modification, are permitted provided
07: * that the following conditions are met:
08: *
09: * 1) Redistributions of source code must retain the above
10: * copyright notice, this list of conditions and the
11: * following disclaimer.
12: * 2) Redistributions in binary form must reproduce the
13: * above copyright notice, this list of conditions and
14: * the following disclaimer in the documentation and/or
15: * other materials provided with the distribution.
16: * 3) Neither the name of "Rafael Steil" nor
17: * the names of its contributors may be used to endorse
18: * or promote products derived from this software without
19: * specific prior written permission.
20: *
21: * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT
22: * HOLDERS AND CONTRIBUTORS "AS IS" AND ANY
23: * EXPRESS OR IMPLIED WARRANTIES, INCLUDING,
24: * BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
25: * MERCHANTABILITY AND FITNESS FOR A PARTICULAR
26: * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL
27: * THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE
28: * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
29: * EXEMPLARY, OR CONSEQUENTIAL DAMAGES
30: * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
31: * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA,
32: * OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
33: * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER
34: * IN CONTRACT, STRICT LIABILITY, OR TORT
35: * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
36: * ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
37: * ADVISED OF THE POSSIBILITY OF SUCH DAMAGE
38: *
39: * The JForum Project
40: * http://www.jforum.net
41: * 19.08.2006 21:50:05
42: */
43: package net.jforum.util;
44:
45: import java.sql.ResultSet;
46: import java.sql.SQLException;
47: import java.sql.Statement;
48:
49: /**
50: * General utility methods to close statements and resultsets
51: *
52: * @author Serge Maslyukov
53: * @version $Id: DbUtils.java,v 1.3 2006/09/24 16:10:14 rafaelsteil Exp $
54: */
55: public class DbUtils {
56: public static void close(ResultSet rs, Statement st) {
57: if (rs != null) {
58: try {
59: rs.close();
60: } catch (Exception e) {
61: }
62: }
63:
64: if (st != null) {
65: try {
66: st.clearWarnings();
67: st.close();
68: } catch (Exception e) {
69: }
70: }
71: }
72:
73: public static void close(ResultSet rs) {
74: if (rs != null) {
75: try {
76: rs.close();
77: } catch (Exception e) {
78: }
79: }
80: }
81:
82: public static void close(Statement st) {
83: if (st != null) {
84: try {
85: st.clearWarnings();
86: st.close();
87: } catch (SQLException e) {
88: }
89: }
90: }
91: }
|