import java.applet.Applet;
import java.awt.*;
import java.sql.*;
public class TestAppletPolicy extends Applet {
private Connection conn;
private Timestamp created = new Timestamp(System.currentTimeMillis());
public void init() {
System.out.println(getParameter("otherparams"));
try {
System.out.println(
"init(): loading OracleDriver for applet created at " + created.toString());
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println("init(): getting connection");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@dssnt01:1521:dssora01","scott","tiger");
}
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 {
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());
}
}
} |