import java.lang.*;
import java.awt.*;
import java.io.*;
import java.util.*;
import java.sql.*;
/*
 *
 * DBConnect
 *
 */

public class DBConnect
{

	String mDrvr;
	String mDB;
	String mURL;

	public void DBConnect(){
		mDrvr = "";
		mDB = "";
		mURL = "";
	}

	public void SetConnectionInfo(String drvr, String db){
		mDrvr = drvr;
		mDB = db;
		if (drvr.equals("Symantec")){
			mDrvr = "symantec.itools.db.jdbc.Driver";
			// <protocol>:<secondary-protocol>://<host>:<port>/<db-engine>/<server-name>/<database>
			if (db.equals("Access")){
				//mURL = "jdbc:dbaw://localhost:8889/MS_Access/nwind/nwind";
				mURL = "jdbc:dbaw://127.0.0.1:8889/MS_Access/nwind/nwind";
			}
			if (db.equals("SQL Anywhere")){
				mURL = "jdbc:dbaw://127.0.0.1:8889/Sybase_SQLANY/sybase/sybase";
			}
		}
			
		if (drvr.equals("IDS Driver")){
			mDrvr = "ids.sql.IDSDriver";
			// <protocol>:<secondary-protocol>://<host>:<port>/<db-engine>/<server-name>/<database>
			if (db.equals("Access")){
				mURL = "jdbc:ids://127.0.0.1:12/conn?dsn='nwind'";
			}
			if (db.equals("SQL Anywhere")){
				mURL = "jdbc:ids://127.0.0.1:12/conn?dsn='sybase'";
			}
		}
		System.out.print("Connection Info: " + drvr + ", " + db + "\n");			
			
	}

	public void ExecQuery(String sql, TextArea textArea){
		try {
			//Driver driver = (Driver)Class.forName(mDrvr).newInstance();
			Class.forName(mDrvr);

			Properties p = new Properties();
			//p.put("user", "dba");
			//p.put("password", "sql");
			
			//Connection connection = driver.connect(mURL, p);
			Connection connection = DriverManager.getConnection(mURL,p);
			
			Statement sqlStatement = connection.createStatement();
			//String sql = "select emp_fname, emp_lname from Employee";
			System.out.print("URL: " + mURL + ", SQL: " + sql + "\n");			
			ResultSet results = sqlStatement.executeQuery(sql);
			String text = "";
			while (results.next()) {
				text += results.getString(1) + " " + 
						results.getString(2) + "\n";
			}
			textArea.setText(text);
		}
		catch (SQLException e) {
				System.out.println("SQLERROR!");
				e.printStackTrace();
				}
		catch (Exception e) {
				System.out.println("ERROR!");
				e.printStackTrace();
				}

	}
}