|
/*
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>
*/
|