/**
 Package sqlObjects

 @author: Ismael H F Santos
 @version: 1.0
 @see
*/
package sqlObjects;

import java.sql.*;
import java.util.*;
import java.io.*;

/**
 * Public class used outside of the database access library to represent
 * a database connection.
 */
public class ConnectionObj {
   private final static ConnectionImpl.ConnectionPool
      connectionPool = ConnectionImpl.ConnectionPool.getInstance();
   private String user, passwd, dataBaseName;

	// Constructor
	public ConnectionObj (String dataBaseName, String user, String passwd) {
		 this.dataBaseName = dataBaseName; this.user = user;
		 this.passwd = passwd;
   }

   //

    /**
     * Send a request to the database and return the result.
     */
    Object sendRequest(Request request) {
        Object result;
        ConnectionImpl impl = 
		     connectionPool.acquireImpl(dataBaseName);
           result = impl.sendRequest(request);
           connectionPool.releaseImpl(impl);
        return result;
    } // sendRequest(Request)
} // class Connection


public class ConnectionObj {
   private Driver driver;
	private Connection c;
   private String user, passwd, dataBaseName;

	public ConnectionObj (String dataBaseName, String user, String passwd) {
      //
	   this.dataBaseName = dataBaseName; this.user = user; this.passwd = passwd;
		try {
		   // Loading the driver 
			String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
			Driver driver = (Driver)Class.forName(driverName).newInstance();

			// Shows Driver Version
			System.out.println("Driver version is " +
				Integer.toString(driver.getMajorVersion()) +
				"." + Integer.toString(driver.getMinorVersion()));

			// Create a properties object and add username and password
			Properties p = new Properties();
			p.put("user", user);
			p.put("password", passwd);

			// Specify a Url for the database
			String dbURL = "jdbc:odbc:" + dataBaseName;

			// Check whether Driver can connect to URL
			if (driver.acceptsURL(dbURL)) {
				System.out.println("URL "+ dbURL +" is valid");
				c = driver.connect(dbURL, p);
				System.out.println("--- Conection established ---");
			}
			else {
				System.out.println("URL "+ dbURL +" is not valid");
			}
		}
		catch (Exception e) {}
	}
	public Connection getConnection() {
      return c;
	}
}