TestAppletNetscape.java Source code

Introduction

Here is the source code for TestAppletNetscape.java
Source

/*
    
Java Programming with Oracle JDBC
by Donald Bales 
ISBN: 059600088X
Publisher: O'Reilly
    
*/

import java.applet.Applet;
import java.awt.*;
import java.sql.*;
import netscape.security.PrivilegeManager;

public class TestAppletNetscape extends Applet {
    private Connection conn;

    private Timestamp created = new Timestamp(System.currentTimeMillis());

    public void init() {
        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 void start() {
        System.out.println("start(): ");
    }

    public void stop() {
        System.out.println("stop(): ");
    }

    public void paint(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 void destroy() {
        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());
        }
    }
}

//File: TestAppletNestscape.html
/*
<html>
<head>
</head>
<body>
<applet codebase="." code="TestAppletNetscape.class" archive="TestAppletNetscape.zip" width=750 height=20></applet>
</body>
</html>
    
*/