import java.awt.*;
import java.sql.*;

public class TestFrame extends java.awt.Frame {
  private   java.awt.Button ivjcmdExit = null;
  private   java.awt.Button ivjcmdOpen = null;
  private   java.awt.Label ivjLabel1 = null;
  private   java.awt.Label ivjLabel11 = null;
  private   java.awt.Label ivjLabel2 = null;
  private   java.awt.TextField ivjtxtClassName = null;
  private   java.awt.TextField ivjtxtDBName = null;
  private   java.awt.TextArea ivjtxtDetails = null;

  /**
   * Constructor
   * @return java.awt.Frame
   */
  public Test2() {
    super();
    setLayout(null);
    reshape(5, 8, 571, 432);
    /* Rather long winded way of creating objects, but this is standard
       code produced by VAJ */
    this.add("ivjcmdExit", getcmdExit());
    this.add("ivjtxtClassName", gettxtClassName());
    this.add("ivjLabel1", getLabel1());
    this.add("ivjLabel11", getLabel11());
    this.add("ivjtxtDBName", gettxtDBName());
    this.add("ivjtxtDetails", gettxtDetails());
    this.add("ivjLabel2", getLabel2());
    this.add("ivjcmdOpen", getcmdOpen());
    ivjtxtClassName.setText("sun.jdbc.odbc.JdbcOdbcDriver");
    ivjtxtDBName.setText("jdbc:odbc:Rincewind1");
  }

  /**
   * @return boolean
   * @param evt java.awt.Event
   * @param arg java.lang.Object
   */
  public boolean action(Event evt, Object arg) {
    if (arg.equals("Exit"))
      System.exit(0);
    else if (arg.equals("Open"))
      openDatabase(ivjtxtClassName.getText(),ivjtxtDBName.getText());
    else return false;
    return true;
  }

  /**
   * Return the cmdExit property value.
   * @return java.awt.Button
   */
  private java.awt.Button getcmdExit() {
    if (ivjcmdExit == null) {
      try {
        ivjcmdExit = new java.awt.Button("Exit");
        ivjcmdExit.setName("cmdExit");
        ivjcmdExit.reshape(427, 390, 125, 30);
      } catch (java.lang.Throwable exception) {
        System.err.println("Exception creating cmdExit");
      }
    };
    return ivjcmdExit;
  }

  /**
   * Return the cmdOpen property value.
   * @return java.awt.Button
   */
  private java.awt.Button getcmdOpen() {
    if (ivjcmdOpen == null) {
      try {
        ivjcmdOpen = new java.awt.Button("Open");
        ivjcmdOpen.setName("cmdOpen");
        ivjcmdOpen.reshape(478, 55, 74, 92);
      } catch (java.lang.Throwable exception) {
        System.err.println("Exception creating cmdOpen");
      }
    };
    return ivjcmdOpen;
  }

  /**
   * Return the Label1 property value.
   * @return java.awt.Label
   */
  private java.awt.Label getLabel1() {
    if (ivjLabel1 == null) {
      try {
        ivjLabel1 = new java.awt.Label("Enter class name to use to attach to database:");
        ivjLabel1.setName("label1");
        ivjLabel1.reshape(19, 31, 278, 22);
      } catch (java.lang.Throwable exception) {
        System.err.println("Exception creating Label1");
      }
    };
    return ivjLabel1;
  }

  /**
   * Return the Label11 property value.
   * @return java.awt.Label
   */
  private java.awt.Label getLabel11() {
    if (ivjLabel11 == null) {
      try {
        ivjLabel11 = new java.awt.Label("Enter Database name:");
        ivjLabel11.setName("label1");
        ivjLabel11.reshape(19, 94, 278, 22);
      } catch (java.lang.Throwable exception) {
        System.err.println("Exception creating Label11");
      }
    };
    return ivjLabel11;
  }

  /**
   * Return the Label2 property value.
   * @return java.awt.Label
   */
  private java.awt.Label getLabel2() {
    if (ivjLabel2 == null) {
      try {
        ivjLabel2 = new java.awt.Label("Details:");
        ivjLabel2.reshape(21, 185, 125, 30);
      } catch (java.lang.Throwable exception) {
        System.err.println("Exception creating Label2");
      }
    };
    return ivjLabel2;
  }

  /**
   * Return the txtClassName property value.
   * @return java.awt.TextField
   */
  private java.awt.TextField gettxtClassName() {
    if (ivjtxtClassName == null) {
      try {
        ivjtxtClassName = new java.awt.TextField(0);
        ivjtxtClassName.setName("txtClassName");
        ivjtxtClassName.reshape(19, 56, 446, 29);
      } catch (java.lang.Throwable exception) {
        System.err.println("Exception creating txtClassName");
      }
    };
    return ivjtxtClassName;
  }

  /**
   * Return the txtDBName property value.
   * @return java.awt.TextField
   */
  private java.awt.TextField gettxtDBName() {
    if (ivjtxtDBName == null) {
      try {
        ivjtxtDBName = new java.awt.TextField(0);
        ivjtxtDBName.setName("txtDBName");
        ivjtxtDBName.reshape(20, 119, 446, 29);
      } catch (java.lang.Throwable exception) {
        System.err.println("Exception creating txtDBName");
      }
    };
    return ivjtxtDBName;
  }

  /**
   * Return the txtDetails property value.
   * @return java.awt.TextArea
   */
  private java.awt.TextArea gettxtDetails() {
    if (ivjtxtDetails == null) {
      try {
        ivjtxtDetails = new java.awt.TextArea();
        ivjtxtDetails.reshape(20, 218, 528, 155);
        ivjtxtDetails.append("Welcome to my database viewer\n\n");
      } catch (java.lang.Throwable exception) {
        System.err.println("Exception creating txtDetails");
      }
    };
    return ivjtxtDetails;
  }

  /**
   * Method to handle old AWT events
   * @return boolean
   * @param evt java.awt.Event
   */
  public boolean handleEvent(java.awt.Event evt) {
    /* Note: Changes to this method will not be overwritten when code is re-generated */
    if (evt.id == java.awt.Event.WINDOW_DESTROY) {
      dispose();
      if (getParent() == null) {
        java.lang.System.exit(0);
      };
      return true;
    }
    return super.handleEvent(evt);
  }

  /**
   * main entrypoint - starts the part when it is run as an application
   * @param args java.lang.String[]
   */
  public static void main(java.lang.String[] args) {
    /* Note: Changes to this method will not be overwritten when code is re-generated */
    try {
        ProjectTests.Test2 aTest2 = new ProjectTests.Test2();
        aTest2.show(true);
      } catch (java.lang.Throwable exception) {
        System.err.println("Exception occurred in main() of Test2");
      }
  }

  /**
   * @return boolean
   * @param className java.lang.String
   * @param url java.lang.String
   */
  private boolean openDatabase(String className, String url) {
    String txtDetail = null;
    int i;
    try {
      ivjtxtDetails.append("About to register driver '" + className + "'\n");
      Class.forName(className);
      ivjtxtDetails.append("Registered driver\n");
    } catch (ClassNotFoundException e) {
      ivjtxtDetails.append("Exception registering driver\n");
      e.printStackTrace();
    }
    try {
      ivjtxtDetails.append("Executing query...");
      Connection con = DriverManager.getConnection(url);
      ivjtxtDetails.append("...");
      Statement stmt = con.createStatement();
      ivjtxtDetails.append("...");
      ResultSet rs = stmt.executeQuery("SELECT * FROM Books");
      ivjtxtDetails.append("...\nReturned results:\n");
      while (rs.next()) {
        for (i=1;i<4;i++)
          ivjtxtDetails.append(rs.getString(i)+": ");
        ivjtxtDetails.append("\n");
      }
    } catch (Exception e) {
      e.printStackTrace();
    }
    
    return false;
  }
}