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

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

public class exampleNoGui {
 public static void main(String args[]) {


  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, "username","password");

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

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

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

   System.out.println("Hello World!");
   System.out.println("JDBC SQL Query : "+query);
   System.out.println("\nResults : \n");

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

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

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

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

System.out.println("\n\n---------------"+rs.getString("r1")+"--------------\n");
	}
  // Close result set
  rs.close();

  // Close statement
  stmt.close();

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