import java.sql.*;
import oracle.jdbc.pool.OracleDataSource;


public class EstabConn

{

private  Connection conn;

public Connection connectdb(String dbName)
{

try {
// Create a OracleDataSource instance
OracleDataSource ods = new OracleDataSource();

ods.setURL("jdbc:oracle:oci:@");

// Sets the database name
ods.setDatabaseName(dbName);

// Sets the user name
ods.setUser("scott");

// Sets the password
ods.setPassword("tiger");

// Database Connection Object
conn = ods.getConnection();

return conn;

} catch(SQLException ex)  {
	ex.printStackTrace();

	System.out.println("Error in establishing connection with the database : in class EstabConn ");
	System.exit(0);
}

return null;

}


public void close()
{
   // Close the connection
    try {
    conn.close();
	} catch(SQLException ex)  {
	ex.printStackTrace();
	System.out.println("Error in closing connection to the database: in class EstabConn ");
	System.exit(0);
	}
}



}