/**************************************************************************
  test.java 
 **************************************************************************/

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

public class test {
  String url, SQLstmt;
  Connection c;
  Statement stmt;
  ResultSet rs;

  public test () {
    try { 
      System.out.println ("\nloading JDBC class \"postgresql.Driver\"...");
      Class.forName ("postgresql.Driver");
    } catch (Exception eDriver) {
      System.out.println ("can't load JDBC driver:");
      System.out.println (eDriver.getMessage());
      System.exit (1);
    }

    try {
      url = "jdbc:postgresql://miranda:5432/factory";
      System.out.println ("\nconnecting to " + url + "...");
      c = DriverManager.getConnection (url, "factory", "factory"); 
      stmt = c.createStatement ();
    } catch (Exception eConnect) {
      System.out.println ("can't connect to database:");
      System.out.println (eConnect.getMessage());
      System.exit(1);
    }
    
    System.out.println ("executeQuery...");
    SQLstmt = "SELECT DISTINCT SkidNo FROM SkidData";
    try {
      rs = stmt.executeQuery (SQLstmt);
    } catch (SQLException eSQL) {
      System.out.println (eSQL.getMessage ());
      System.out.println ("return code is: " + eSQL.getErrorCode());
      System.exit (1);
    }

    try {
      while (rs.next ()) {
        System.out.println (rs.getString ("SkidNo"));
      }
    } catch (SQLException eSQL) {
      System.out.println ("thrown! caught!");
    }
  } 

  public static void main (String argv[]) {
    new test ();
  }
}