import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.LinkedList;
import java.util.List;

/**
 * This is one possible solution that basically iterates over the
 * PreparedStatements provided and collects all of the SQLExceptions
 * thrown during the closing of the statement. Once the statements are
 * all closed, a rollup occurs to organize the order of the exceptions
 * by calling SQLException#setNextException(SQLException).
 * @author Richard L. Burton III
 */
public class CloseableStatements {

    /**
     * This method will take an array of PreparedStatements and close
     * each of the statements in order they were provided. If any exceptions
     * are thrown during the closing of the PreparedStatements, they are then
     * rolled up using <code>rollup</tt>.
     * @param statements An array of PreparedStatement objects to close.
     * @throws SQLException The SQLException if any are thrown during the closing
     *                      of the PreparedStatement objects.
     */
    protected void close(PreparedStatement... statements) throws SQLException {
        List<SQLException> exceptions = new LinkedList<SQLException>();
        for (PreparedStatement statement : statements) {
            try {
                statement.close();
            } catch (SQLException e) {
                exceptions.add(e);
            }
        }
        SQLException exception = rollup(exceptions);
        if (exception != null)
            throw exception;
    }

    /**
     * This method rolls up the exceptions by taking each proceeding exception
     * and making it a child of the previous using the <tt>setNextException</tt>
     * method of SQLException.
     * @param exceptions A List of SQLExceptions thrown during the closing.
     * @return The final rolled up exception.
     */
    protected SQLException rollup(List<SQLException> exceptions) {
        SQLException parent = null;
        for (SQLException exception : exceptions) {
            if (parent != null)
                exception.setNextException(parent);
            parent = exception;
        }
        return parent;
    }

}