Java SQL ResultSet Close closeAll(Connection con, PreparedStatement ps, ResultSet rs)

Description

Frees Database Connection.

License

Open Source License

Parameter

Parameter	Description
con	Connection Object.
ps	Prepared Statement Object.
rs	ResultSet Object.

Declaration

public static void closeAll(Connection con, PreparedStatement ps, ResultSet rs) 

Method Source Code

//package com.java2s;
/** Copyright (c) 2012 Memorial Sloan-Kettering Cancer Center.
**
** This library is free software; you can redistribute it and/or modify it
** under the terms of the GNU Lesser General Public License as published
** by the Free Software Foundation; either version 2.1 of the License, or
** any later version.//from  w w  w  .j a v a  2  s .  c o  m
**
** This library is distributed in the hope that it will be useful, but
** WITHOUT ANY WARRANTY, WITHOUT EVEN THE IMPLIED WARRANTY OF
** MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.  The software and
** documentation provided hereunder is on an "as is" basis, and
** Memorial Sloan-Kettering Cancer Center 
** has no obligations to provide maintenance, support,
** updates, enhancements or modifications.  In no event shall
** Memorial Sloan-Kettering Cancer Center
** be liable to any party for direct, indirect, special,
** incidental or consequential damages, including lost profits, arising
** out of the use of this software and its documentation, even if
** Memorial Sloan-Kettering Cancer Center 
** has been advised of the possibility of such damage.  See
** the GNU Lesser General Public License for more details.
**
** You should have received a copy of the GNU Lesser General Public License
** along with this library; if not, write to the Free Software Foundation,
** Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
**/

import java.sql.*;

public class Main {
    /**
     * Frees Database Connection.
     *
     * @param con Connection Object.
     * @param ps  Prepared Statement Object.
     * @param rs  ResultSet Object.
     */
    public static void closeAll(Connection con, PreparedStatement ps, ResultSet rs) {
        try {
            if (con != null) {
                closeConnection(con);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

        // pooling, so do not close prepared statement...
        //        if (ps != null) {
        //            try {
        //                ps.close();
        //            } catch (SQLException e) {
        //                e.printStackTrace();
        //            }
        //        }

        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    /**
     * Frees Database Connection.
     *
     * @param con Connection Object.
     */
    private static void closeConnection(Connection con) throws SQLException {
        if (con != null && !con.isClosed()) {
            try {
                con.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

Related

1. close(ResultSet rs, Statement stmt)
2. close(ResultSet rs, Statement stmt, Connection con)
3. close(ResultSet rs, Statement stmt, Connection con)
4. close(ResultSet rs, Statement stmt, Connection con)
5. close(Statement statement, ResultSet resultSet)
6. closeAll(Connection conn, Statement stmt, ResultSet rs)
7. closeAll(Connection conn, Statement stmt, ResultSet rs)
8. closeAll(ResultSet rs)
9. closeAll(ResultSet rs, Statement st, Connection conn)