package com.home.db;

import java.sql.Connection;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

public class Conntion {

private Connection conn ;
	
	public Conntion() throws Exception{
		String DSName="java:comp/env/jdbc/mypro";
		Context ctx=new InitialContext();
		DataSource ds=(DataSource)ctx.lookup(DSName);
		this.conn = ds.getConnection();
	}

	public Connection getConnection() {
		return this.conn ;
	}

	public void close(){
		if(this.conn != null){
			try{
				this.conn.close() ;
			}catch(Exception e){
				e.printStackTrace();
			}
		}
	}
}