FileDocCategorySizeDatePackage
TestAppletNetscape.javaAPI DocExample1883Thu Oct 05 19:20:20 BST 2000None

TestAppletNetscape

public class TestAppletNetscape extends Applet

Fields Summary
private Connection
conn
private Timestamp
created
Constructors Summary
Methods Summary
public voiddestroy()

  System.out.println(
   "destroy(): closing connection for applet created at " + created.toString());
  try {
   conn.close();
  }
  catch (SQLException e) {
   System.err.println("destroy: SQLException: " + e.getMessage());
  }
 
public voidinit()

    
  try {
   System.out.println(
    "init(): loading OracleDriver for applet created at " + created.toString());
   Class.forName("oracle.jdbc.driver.OracleDriver");
   PrivilegeManager.enablePrivilege("UniversalConnect");
   System.out.println("init(): getting connection");
   PrivilegeManager.checkPrivilegeEnabled("UniversalConnect");
   conn = DriverManager.getConnection(
    "jdbc:oracle:thin:@dssnt01:1521:dssora01","scott","tiger");
  }
  catch (ClassNotFoundException e) {
   System.err.println("init(): ClassNotFoundException: " + e.getMessage());
  }
  catch (SQLException e) {
   System.err.println("init(): SQLException: " + e.getMessage());
  }
 
public voidpaint(java.awt.Graphics g)

  System.out.println("paint(): querying the database");
  try {
   PrivilegeManager.enablePrivilege("UniversalConnect");
   Statement stmt = conn.createStatement();
   ResultSet rset = stmt.executeQuery(
    "select 'Hello '||initcap(USER) result from dual");
   while(rset.next()) 
    g.drawString(rset.getString(1),10,10);
   rset.close();
   stmt.close();
  }
  catch (SQLException e) {
   System.err.println("paint(): SQLException: " + e.getMessage());
  }
 
public voidstart()

  System.out.println("start(): ");
 
public voidstop()

  System.out.println("stop(): ");