package com.nitpro.school.util;

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

import javax.naming.InitialContext;
import javax.sql.DataSource;

public class ConnectionPoolHelper {
	private static InitialContext cxt;
	private static DataSource ds;
	
	static{
		try {
			cxt = new InitialContext();
			ds = (DataSource) cxt.lookup("java:/comp/env/jdbc/school");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
    public static Connection getConnection(){
    	Connection conn =  null;
    	try {
		    conn = ds.getConnection();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return conn;
    }
    
    public static void closeConnection(Connection conn){
		try {
    	    if(conn != null){
				conn.close();
     	    }
		} catch (SQLException e) {
			e.printStackTrace();
		}
    }
    
    public static void closeStatement(Statement state){
		try {
    	    if(state != null){
    	    	state.close();
     	    }
		} catch (SQLException e) {
			e.printStackTrace();
		}
    }

    public static void closeResultSet(ResultSet rs){
		try {
    	    if(rs != null){
    	    	rs.close();
     	    }
		} catch (SQLException e) {
			e.printStackTrace();
		}
    }
}