Java SQL ResultSet Close close(ResultSet rs, Statement ps, Connection con)

Here you can find the source of close(ResultSet rs, Statement ps, Connection con)

Description

close

License

Open Source License

Parameter

Parameter Description
rs a parameter
ps a parameter
con a parameter

Declaration

public static void close(ResultSet rs, Statement ps, Connection con) 

Method Source Code


//package com.java2s;
/*/* ww  w.j av a 2s. c o m*/
 * This program is free software: you can redistribute it and/or modify it under
 * the terms of the GNU General Public License as published by the Free Software
 * Foundation, either version 3 of the License, or (at your option) any later
 * version.
 * 
 * This program 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. See the GNU General Public License for more
 * details.
 * 
 * You should have received a copy of the GNU General Public License along with
 * this program. If not, see <http://www.gnu.org/licenses/>.
 */

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

public class Main {
    /**
     * @param rs
     * @param pstm
     * @param con
     */
    public static void close(ResultSet rs, PreparedStatement pstm, Connection con) {
        close(rs);
        close(pstm);
        close(con);
    }

    /**
     * @param rs
     * @param ps
     * @param con
     */
    public static void close(ResultSet rs, Statement ps, Connection con) {
        close(rs);
        close(ps);
        close(con);
    }

    /**
     * @param pstm
     * @param con
     */
    public static void close(PreparedStatement pstm, Connection con) {
        close(pstm);
        close(con);
    }

    /**
     * @param ps
     * @param con
     */
    public static void close(Statement ps, Connection con) {
        close(ps);
        close(con);
    }

    /**
     * @param con
     * @return
     */
    public static SQLException close(Connection con) {
        try {
            if (con != null) {
                con.close();
            }
        } catch (SQLException e) {
            return e;
        }
        return null;
    }

    /**
     * @param pstm
     * @return
     */
    public static SQLException close(PreparedStatement pstm) {
        try {
            if (pstm != null) {
                pstm.close();
            }
        } catch (SQLException e) {
            return e;
        }
        return null;
    }

    /**
     * @param ps
     * @return
     */
    public static SQLException close(Statement ps) {
        try {
            if (ps != null) {
                ps.close();
            }
        } catch (SQLException e) {
            return e;
        }
        return null;
    }

    /**
     * @param rs
     * @return
     */
    public static SQLException close(ResultSet rs) {
        try {
            if (rs != null) {
                rs.close();
            }
        } catch (SQLException e) {
            return e;
        }
        return null;
    }
}

Related

  1. close(ResultSet rs)
  2. close(ResultSet rs)
  3. close(ResultSet rs)
  4. close(ResultSet rs)
  5. close(ResultSet rs, PreparedStatement pstmt, Connection con)
  6. close(ResultSet rs, Statement ps, Connection conn)
  7. close(ResultSet rs, Statement st, Connection con)
  8. close(ResultSet rs, Statement st, Connection conn)
  9. close(ResultSet rs, Statement stmt)