import java.awt.*;
import java.applet.*;

import java.net.URL;
import exjava.sql.*;
import exgwe.sql.*;

public class example extends Applet {
 void button1_Clicked(Event event) {


  try {

  // Load the gweMysqlDriver JDBC Driver for use with the external java classes

        Class.forName("exgwe.sql.gweMysqlDriver");

  // The url of the database we wish to connect to
  // jdbc:mysql://host:port/database

        String url = "jdbc:mysql://noodle.ecst.csuchico.edu:3306/test";

  // Set up a connection, as user and password (both as
  // clear text here - the password is encrypted by the
  // driver)

        Connection con = DriverManager.getConnection(url, "monty","greatsqldb");

  // Create statement
        Statement stmt = con.createStatement();

  // Execute query
     String query = "select * from jdbc";

  // Obtain the result set
        ResultSet rs = stmt.executeQuery(query);

        textArea1.appendText("JDBC SQL Query : "+query);
     textArea1.appendText("\nResults : \n");

  // Loop through each result row
        while(rs.next()) {

   // Print out each field as a string
   for (int i=1; i<=15; i++)
    textArea1.appendText(rs.getString(i)+" : ");
   textArea1.appendText("\n");

   // Print out each field as it's type
   byte r1 = rs.getByte(1); textArea1.appendText("r1 : "+r1+"\n");
   short r2 = rs.getShort(2); textArea1.appendText("r2 : "+r2+"\n");
   int r3 = rs.getInt(3); textArea1.appendText("r3 : "+r3+"\n");
   int r4 = rs.getInt(4); textArea1.appendText("r4 : "+r4+"\n");
   long r5 = rs.getLong(5); textArea1.appendText("r5 : "+r5+"\n");
   float r6 = rs.getFloat(6); textArea1.appendText("r6 : "+r6+"\n");
   double r7 = rs.getDouble(7); textArea1.appendText("r7 : "+r7+"\n");
   boolean r8 = rs.getBoolean(8); textArea1.appendText("r8 : "+r8+"\n");
   Date r9d = rs.getDate(9); textArea1.appendText("r9d : "+r9d+"\n");
   Time r9t = rs.getTime(9); textArea1.appendText("r9t : "+r9t+"\n");
   Timestamp r9ts = rs.getTimestamp(9); textArea1.appendText("r9ts :"+r9ts+"\n");
   String r10 = rs.getString(10); textArea1.appendText("r10 : "+r10+"\n");
   String r11 = rs.getString(11); textArea1.appendText("r11 : "+r11+"\n");
   String r12 = rs.getString(12); textArea1.appendText("r12 : "+r12+"\n");
   String r13 = rs.getString(13); textArea1.appendText("r13 : "+r13+"\n");
   String r14 = rs.getString(14); textArea1.appendText("r14 : "+r14+"\n");
   String r15 = rs.getString(15); textArea1.appendText("r15 : "+r15+"\n");
   byte[] b = rs.getBytes(15); textArea1.appendText("r15 as byte array :");
   //for (int i=0; i<b.length; i++) textArea1.appendText((char)b[i]);

   // Print delimeter - note that here we're calling by
   // column name rather than column index, just for variety.

textArea1.appendText("\n\n---------------"+rs.getString("r1")+"--------------\n");

  }

  // Close result set
  rs.close();

  // Close statement
  stmt.close();

  // Close connection
  con.close();
    }
    catch( Exception e ) {
      textArea1.appendText(e.getMessage());
      e.printStackTrace();
    }

 }

 public void init() {
  super.init();

  // Take out this line if you don't use symantec.itools.net.RelativeURL


//symantec.itools.lang.Context.setDocumentBase(getDocumentBase());


  setLayout(null);
  addNotify();
  resize(426,266);
  button1 = new java.awt.Button("button");
  button1.reshape(348,216,72,37);
  add(button1);
  textArea1 = new java.awt.TextArea();
  textArea1.reshape(12,0,404,206);
  add(textArea1);

 }

 public boolean handleEvent(Event event) {
  if (event.target == button1 && event.id == Event.ACTION_EVENT) {
   button1_Clicked(event);
   return true;
  }
  return super.handleEvent(event);
 }


 java.awt.Button button1;
 java.awt.TextArea textArea1;

}