prerna.util.ConnectionUtils Maven / Gradle / Ivy
/*******************************************************************************
* Copyright 2015 Defense Health Agency (DHA)
*
* If your use of this software does not include any GPLv2 components:
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
* ----------------------------------------------------------------------------
* If your use of this software includes any GPLv2 components:
* 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 2
* 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.
*******************************************************************************/
package prerna.util;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* Utility functions for closing all RDBMS connections
*
* @author
* @version $Revision: 1.0 $
*/
public class ConnectionUtils {
public static void closeAllConnections(Connection con, ResultSet rs, Statement ps){
if(rs!=null){
try{
rs.close();
} catch (Exception e){
e.printStackTrace();
}
}
if(ps!=null){
try{
ps.close();
} catch (Exception e){
e.printStackTrace();
}
}
if(con!=null){
try{
con.close();
} catch (Exception e){
e.printStackTrace();
}
}
}
public static void closeResultSet(ResultSet rs){
closeAllConnections(null, rs, null);
}
public static void closePreparedStatement(Statement ps){
closeAllConnections(null, null, ps);
}
public static void closeConnection(Connection con){
closeAllConnections(con, null, null);
}
}