package bean;

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

public class connectionpool {

    private static connectionpool pool = null;
    private static DataSource datasource = null;

    private connectionpool(){

        try{
            InitialContext ic = new InitialContext();
            datasource = (DataSource) ic.lookup("java:/comp/env/jdbc/database");
        }
        catch(Exception e){
        }
    }

    public static connectionpool getinstance(){
        if (pool == null)
            pool = new connectionpool();
        return pool;
    }

    public Connection getconnection(){
        try{
            return datasource.getConnection();
        }
        catch (SQLException s){
            s.printStackTrace();
            return null;
        }
    }

    public void freeconnection (Connection c){
        try{
            c.close();
        }
        catch (SQLException s){
            s.printStackTrace();
        }
    }
}