import java.util.*;
import java.sql.*;

public class JDBCTester{
  public static void main(String argv[]) throws Exception{
    Class.forName("org.gjt.mm.mysql.Driver").newInstance();

    java.sql.Connection conn;
    String connurl = 
      "jdbc:mysql://localhost.localdomain/shipping_events";
    String user = "DBUSERNAME";
    String pw = "DBPASSWORD";

    System.out.println("Using:" + connurl);

    conn = DriverManager.getConnection(connurl,user,pw);
    Statement stmt = conn.createStatement();
    ResultSet res = stmt.executeQuery("SELECT * FROM event_log");
    for(res.first();!res.isAfterLast();res.next()){
      System.out.println(res.getRow() + ":" + 
			 res.getString("event_id") + "\t" +
			 res.getString("descr") + "\t" +
			 res.getString("package_id") + "\t" +
			 res.getString("time_stamp") + "\t");
    }
  }
}
/* <!-- (c) 2003 Prentice Hall PTR . --> */