Java Oracle Example 2

// Copyright (c) 2001
package package1;

/**
 * package1.Application1
 * 

 * @author Mike Elms
 */
import java.util.*;
import java.sql.*;

public class Application1 {
  Connection conn;
  String user;
  String pass;
  /**
   * Constructor
   */
  public Application1(String user, String pass) {
    System.out.println("Application1");
    try {
      DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
      conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:Karen", user, pass);

      Statement st = conn.createStatement();
      ResultSet rs = st.executeQuery("select * from global_name");

      while (rs.next()) {
        System.out.println(rs.getString(1));
      }
    }
    catch (SQLException sqle) {
      System.out.println(sqle.toString());
    }
    catch (Exception e) {
      System.out.println(e.toString());
    }
  }

  public void myMethod() {
    System.out.println("myMethod");
     try {
      Statement st = conn.createStatement();
      ResultSet rs = st.executeQuery("select * from dba_users");

      while (rs.next()) {
        System.out.println("UserName: " + rs.getString(1) + "\nID: " + rs.getString(2));
      }
    }
    catch (SQLException sqle) {
      System.out.println(sqle.toString());
    }
  }

   public void myMethod2() {
    System.out.println("myMethod2");
     try {
      Statement st = conn.createStatement();
      ResultSet rs = st.executeQuery("select * from tab where rownum < 10");

      while (rs.next()) {
        System.out.println(rs.getString(1));
      }
    }
    catch (SQLException sqle) {
      System.out.println(sqle.toString());
    }
  }

  /**
   * main
   * @param args
   */
  public static void main(String[] args) {
    Application1 appA = new Application1("mike", "mike");
    Application1 appB = new Application1("sys", "change_on_install");
    Application1 appC = new Application1("system", "manager");

    appA.myMethod();
    appA.myMethod2();

    appB.myMethod2();
    appC.myMethod2();

    System.out.println("Finished...");
  }
}