package com.proreg;

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

public class dbcon {
	
	private Statement stmt;
	private ResultSet rs;
	private static Connection con;
	
	public static synchronized Connection getCon()throws Exception{
		Context ctx;
		DataSource ds;
		try{
			ctx = new InitialContext();
			ds = (DataSource)ctx.lookup("java:comp/env/jdbc/Project");
			return ds.getConnection();
		}catch(SQLException e){
			throw e;
		}
		catch(NamingException e){
			throw e;
		}
	}

	public Statement getStmt(){
		try{
			con=getCon();
			stmt=con.createStatement();
		}catch(Exception e){
			System.out.println("getStmt");
			System.out.println(e.getMessage());
		}
		return stmt;
	}
	
	public void close(){
		try{
			if(rs!=null)rs.close();
		}catch(Exception e){
		}
		try{
			if(stmt!=null)stmt.close();
		}catch(Exception e){
		}
		try{
			if(con!=null)con.close();
		}catch(Exception e){
			System.out.println("close");
			System.out.println(e.getMessage());
		}
	}
}