/*
 * This sample applet just selects 'Hello World' and the date from the database
 */

// Import the JDBC classes
import java.sql.*;

// Import the java classes used in applets
import java.awt.*;
import java.io.*;
import java.util.*;

public class TestApplet extends java.applet.Applet
{
  // The driver to load
  static final String driver_class = "oracle.jdbc.driver.OracleDriver";

  // The connect string 
  static final String connect_string = 
                  "jdbc:oracle:thin:student/cst336@internetprog";

  // This is the kind of string you woudl use if going through the 
  // Oracle 8 connection manager which lets you run the database on a 
  // different host than the Web Server.  See the on-line documentation
  // for more information.
  // static final String connect_string = "jdbc:oracle:thin:scott/tiger@(description=(address_list=(address=(protocol=tcp)(host=dlsun511)(port=1610))(address=(protocol=tcp)(host=pkrishna-pc2)(port=1521)))(source_route=yes)(connect_data=(sid=orcl)))";
/* 
  OUR???         HOW IS THIS DIFFERENT THAN 1st Connection String ABOVE?

static final String connect_string = "jdbc:oracle:oci8:student/cst336@(description=(address_list=(address=(protocol=tcp)(host=207.62.129.150)(port=1521)))(source_route=yes)(connect_data=(sid=intprog)))";


*/

  // The query we will execute
  static final String query = "select * || sysdate from system.javatest";
  

  // The button to push for executing the query
  Button execute_button;

  // The place where to dump the query result
  TextArea output;

  // The connection to the database
  Connection conn;

  // Create the User Interface
  public void init ()
  {
    this.setLayout (new BorderLayout ());
    Panel p = new Panel ();
    p.setLayout (new FlowLayout (FlowLayout.LEFT));
    execute_button = new Button ("Hello JDBC");
    p.add (execute_button);
    this.add ("North", p);
    output = new TextArea (10, 60);
    this.add ("Center", output);
  }

  // Do the work
  public boolean action (Event ev, Object arg)
  {
    if (ev.target == execute_button)
    {
      try
      {
	// Clear the output area
	output.setText (null);

	// See if we need to open the connection to the database
	if (conn == null)
	{
	  // Load the JDBC driver
	  output.appendText ("Loading JDBC driver " + driver_class + "\n");
	  Class.forName (driver_class);

	  // Connect to the databse
	  output.appendText ("Connecting to jdbc:oracle:oci8:@internetprog\n");
	  conn = DriverManager.getConnection ("jdbc:oracle:oci8:@internetprog", "student", "cst336");
	  output.appendText ("Connected\n");
	}

	// Create a statement
	Statement stmt = conn.createStatement ();

	// Execute the query
	output.appendText ("Executing query " + query + "\n");
	ResultSet rset = stmt.executeQuery (query);

	// Dump the result
	while (rset.next ())
	{
	   for(int i=1; i<rset.getMetaData().getColumnCount(); i++) //visit each column
		  output.appendText (rset.getString (i) + "  |  ");
           output.appendText("------------------------------------\n");		
        }

	// We're done
	output.appendText ("done.\n");
      }
      catch (Exception e)
      {
	// Oops
	output.appendText (e.getMessage () + "\n");
      }
      return true;
    }
    else
      return false;
  }
}