/*
 * This can be used to check the JDBC connection to limani.cs.uchicago.edu.
 * Just run it and provide the connect information.  It will select
 * sample data from one of the sample tables in the oracle database.
 */

// You need to import the java.sql package to use JDBC
import java.sql.*;

// We import java.io to be able to read from the command line
import java.io.*;

class JdbcTest
{
  public static void main (String args [])
       throws SQLException, IOException
  {
    // Load the Oracle JDBC driver
	try {
   // EITHER style will obtain the oracle driver:
   //   DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
	Class.forName("oracle.jdbc.OracleDriver").newInstance();
	}
	catch ( Exception e)
	{ e.printStackTrace(); }

    // Connect to the database

    System.out.println ("Connecting...");
    // THIS connection is over the thin client driver
    Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@limani.cs.uchicago.edu:1521:cs51024","matei", "matei");

    System.out.println ("connected.");

//     // Create a prepared statement
//     PreparedStatement pstmt = conn.prepareStatement("INSERT INTO xxxx VALUES(?)");        
//     java.util.Date d = new java.util.Date();
// 
//     pstmt.setDate( 1, new java.sql.Date(d.getTime()));   
//     pstmt.executeUpdate( );  
//     // Close the statement
//     pstmt.close();

   // Walk through the result set and print out the first two columns of data
   Statement stmt = conn.createStatement();
   ResultSet rset = stmt.executeQuery( "SELECT * FROM xxxx");
   while (rset.next ())
     System.out.println (rset.getString (1));
   stmt.close();

   System.out.println ("Your JDBC installation is correct.");

   // close the resultSet
   rset.close();


    // Close the connection
    conn.close();
  }

  // Utility function to read a line from standard input
  static String readEntry (String prompt)
  {
    try
    {
      StringBuffer buffer = new StringBuffer ();
      System.out.print (prompt);
      System.out.flush ();
      int c = System.in.read ();
      while (c != '\n' && c != -1)
      {
        buffer.append ((char)c);
        c = System.in.read ();
      }
      return buffer.toString ().trim ();
    }
    catch (IOException e)
    {
      return "";
    }
  }
}