/*
** +-------------------------------------------------------+
** | PROGRAM NAME  : TestJServerConnection.java            |
** | AUTHOR        : Jeffrey Hunter                        |
** | DATE          : 06-DEC-2001                           |
** | ----------------------------------------------------- |
** | LOAD          : % LoadJServer.sh                      |
** | CALL SPEC     : SQL> @CallSpecJServer.sql             |
** | RUN           : SQL> @RunJServer.sql                  |
** +-------------------------------------------------------+
*/

import java.sql.*;
import java.io.*;
import oracle.jdbc.driver.*;
 
public class TestJServerConnection {

  // +--------------------------------------+
  // | SHOW USER AND SYSDATE                |
  // +--------------------------------------+
  public static void showUser()  throws SQLException {

    Connection conn = null;
    Statement stmt = null;
    ResultSet rset = null;
    String sql;

    System.out.print("\n");
    System.out.print("+-------------------------------+\n");
    System.out.print("| METHOD: showUser              |\n");
    System.out.print("+-------------------------------+\n");
    System.out.print("\n");

    // Build SQL statement
    sql = "SELECT user, TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') FROM dual";

    try {

      // Connect to Oracle using Home-Made Oracle Connection Manager
      conn = OracleConnection.getConnection();

      stmt = conn.createStatement (ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);

      System.out.print("Opening ResultsSet...\n");
      rset = stmt.executeQuery (sql);

      while (rset.next ()) {

        int     rowNumber;
        String  user;
        String  sysdate;

        rowNumber = rset.getRow();

        user = rset.getString(1);
        if ( rset.wasNull() ) {
          user = "<null>";
        }

        sysdate = rset.getString(2);
        if ( rset.wasNull() ) {
          sysdate = "<null>";
        }

        System.out.print("RESULTS      --> [Row Number  : " + rowNumber + "]\n");
        System.out.print("RESULTS      --> [User        : " + user + "]\n");
        System.out.print("RESULTS      --> [Date/Time   : " + sysdate + "]\n");
      }

      System.out.print("Closing ResultSet...\n");
      rset.close();

      System.out.print("Closing Statement...\n");
      stmt.close();

    } catch (SQLException e) {
      System.err.println(e.getMessage());
    }

  } // END: showUser

}