FileDocCategorySizeDatePackage
TestClassForNameNewInstanceApp.javaAPI DocExample1623Thu Jun 14 18:09:10 BST 2001None

TestClassForNameNewInstanceApp

public class TestClassForNameNewInstanceApp extends Object

Fields Summary
Constructors Summary
Methods Summary
public static voidmain(java.lang.String[] args)


    try {
      Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
    }
    catch(ClassNotFoundException e) {
      System.out.println(
       "Oops! Can't find class oracle.jdbc.driver.OracleDriver");
      System.exit(1);
    }
    catch(IllegalAccessException e) {
      System.out.println(
       "Uh Oh! You can't load oracle.jdbc.driver.OracleDriver");
      System.exit(2);
    }
    catch(InstantiationException e) {
      System.out.println(
       "Geez! Can't instantiate oracle.jdbc.driver.OracleDriver");
      System.exit(3);
    }
  
    Connection conn = null;
    Statement  stmt = null;
    ResultSet  rset = null;
    try {
      conn = DriverManager.getConnection(
       "jdbc:oracle:thin:@dssw2k01:1521:orcl","scott","tiger");     

      stmt = conn.createStatement();
      rset = stmt.executeQuery(
       "select 'Hello '||USER||'!' result from dual");
      while(rset.next()) 
        System.out.println(rset.getString(1));
      rset.close();
      rset = null;
      stmt.close();
      stmt = null;
      conn.close();
      conn = null;
    }
    catch(SQLException e) {
      System.out.println("Darn! A SQL error: " + e.getMessage());
    }
    finally {
      if (rset != null)
        try {rset.close();} catch(SQLException ignore) {}
      if (stmt != null)
        try {stmt.close();} catch(SQLException ignore) {}
      if (conn != null)
        try {conn.close();} catch(SQLException ignore) {}
    }