DAOUtil.java

package com.ning.metrics.goodwill.dao;


import com.ning.metrics.goodwill.store.MySQLStore;
import org.apache.log4j.Logger;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public final class DAOUtil
{
    private static Logger log = Logger.getLogger(MySQLStore.class);

    /**
     * Quietly close the Connection
     *
     * @param connection The Connection to be closed quietly
     */
    public static void close(Connection connection)
    {
        if (connection != null) {
            try {
                connection.close();
            }
            catch (SQLException e) {
                log.warn("Closing Connection failed: " + e.getLocalizedMessage(), e);
            }
        }
    }

    /**
     * Quietly close the Statement
     *
     * @param statement The Statement to be closed quietly
     */
    public static void close(Statement statement)
    {
        if (statement != null) {
            try {
                statement.close();
            }
            catch (SQLException e) {
                log.warn("Closing Statement failed: " + e.getLocalizedMessage(), e);
            }
        }
    }

    /**
     * Quietly close the ResultSet.
     *
     * @param resultSet The ResultSet to be closed quietly
     */
    public static void close(ResultSet resultSet)
    {
        if (resultSet != null) {
            try {
                resultSet.close();
            }
            catch (SQLException e) {
                log.warn("Closing ResultSet failed: " + e.getLocalizedMessage(), e);
            }
        }
    }

    /**
     * Quietly close the Connection and Statement.
     *
     * @param connection The Connection to be closed quietly
     * @param statement  The Statement to be closed quietly
     */
    public static void close(Connection connection, Statement statement)
    {
        close(statement);
        close(connection);
    }

    /**
     * Quietly close the Connection, Statement and ResultSet
     *
     * @param connection The Connection to be closed quietly
     * @param statement  The Statement to be closed quietly
     * @param resultSet  The ResultSet to be closed quietly
     */
    public static void close(Connection connection, Statement statement, ResultSet resultSet)
    {
        close(resultSet);
        close(statement);
        close(connection);
    }
}