001: /*
002: * $Header: /export/home/cvsroot/MyPersonalizerRepository/MyPersonalizer/Subsystems/Kernel/Sources/es/udc/mypersonalizer/kernel/model/repository/sql/util/SQLOperations.java,v 1.1.1.1 2004/03/25 12:08:37 fbellas Exp $
003: * $Revision: 1.1.1.1 $
004: * $Date: 2004/03/25 12:08:37 $
005: *
006: * =============================================================================
007: *
008: * Copyright (c) 2003, The MyPersonalizer Development Group
009: * (http://www.tic.udc.es/~fbellas/mypersonalizer/index.html) at
010: * University Of A Coruna
011: * All rights reserved.
012: *
013: * Redistribution and use in source and binary forms, with or without
014: * modification, are permitted provided that the following conditions are met:
015: *
016: * - Redistributions of source code must retain the above copyright notice,
017: * this list of conditions and the following disclaimer.
018: *
019: * - Redistributions in binary form must reproduce the above copyright notice,
020: * this list of conditions and the following disclaimer in the documentation
021: * and/or other materials provided with the distribution.
022: *
023: * - Neither the name of the University Of A Coruna nor the names of its
024: * contributors may be used to endorse or promote products derived from
025: * this software without specific prior written permission.
026: *
027: * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
028: * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
029: * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
030: * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
031: * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
032: * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
033: * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
034: * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
035: * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
036: * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
037: * POSSIBILITY OF SUCH DAMAGE.
038: *
039: */
040:
041: package es.udc.mypersonalizer.kernel.model.repository.sql.util;
042:
043: import java.sql.ResultSet;
044: import java.sql.Statement;
045: import java.sql.Connection;
046: import java.sql.SQLException;
047:
048: import es.udc.mypersonalizer.kernel.util.exceptions.InternalErrorException;
049:
050: /**
051: * A Utility class for SQL operations.
052: *
053: * @author Fernando Bellas
054: * @since 1.0
055: */
056: public final class SQLOperations {
057:
058: private SQLOperations() {
059: }
060:
061: /**
062: * It closes a <code>ResultSet</code> if not <code>null</code>.
063: *
064: * @param resultSet the <code>ResultSet</code> to close
065: */
066: public static void closeResultSet(ResultSet resultSet)
067: throws InternalErrorException {
068:
069: if (resultSet != null) {
070: try {
071: resultSet.close();
072: } catch (SQLException e) {
073: throw new InternalErrorException(e);
074: }
075: }
076:
077: }
078:
079: /**
080: * It closes a <code>Statement</code> if not <code>null</code>.
081: *
082: * @param statement the <code>statement</code> to close
083: */
084: public static void closeStatement(Statement statement)
085: throws InternalErrorException {
086:
087: if (statement != null) {
088: try {
089: statement.close();
090: } catch (SQLException e) {
091: throw new InternalErrorException(e);
092: }
093: }
094:
095: }
096:
097: /**
098: * It closes a <code>Connection</code> if not <code>null</code>.
099: *
100: * @param connection the <code>connection</code> to close
101: */
102: public static void closeConnection(Connection connection)
103: throws InternalErrorException {
104:
105: if (connection != null) {
106: try {
107: connection.close();
108: } catch (SQLException e) {
109: throw new InternalErrorException(e);
110: }
111: }
112:
113: }
114:
115: }
|