Java tutorial
/* Java Programming with Oracle JDBC by Donald Bales ISBN: 059600088X Publisher: O'Reilly */ import java.applet.Applet; import java.awt.Graphics; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.sql.Timestamp; 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()); } } } //File: TestAppletPolicy.html /* <html> <head> <title>Test an Applet's access to Sockets using Java 2 Policies</title> </head> <body> <!-- The following code is specified at the beginning of the <BODY> tag. --> <SCRIPT LANGUAGE="JavaScript"> <!-- var _info = navigator.userAgent; var _ns = false; var _ie = (_info.indexOf("MSIE") > 0 && _info.indexOf("Win") > 0 && _info.indexOf("Windows 3.1") < 0); //--> </SCRIPT> <COMMENT> <SCRIPT LANGUAGE="JavaScript1.1"> <!-- var _ns = (navigator.appName.indexOf("Netscape") >= 0 && ((_info.indexOf("Win") > 0 && _info.indexOf("Win16") < 0 && java.lang.System.getProperty("os.version").indexOf("3.5") < 0) || _info.indexOf("Sun") > 0)); //--> </SCRIPT> </COMMENT> <!-- The following code is repeated for each APPLET tag --> <SCRIPT LANGUAGE="JavaScript"> <!-- if (_ie == true) document.writeln( '<OBJECT ' + ' classid="clsid:8AD9C840-044E-11D1-B3E9-00805F499D93" ' + ' codebase="http://java.sun.com/products/plugin/1.2.2/jinstall-1_2_2-win.cab#Version=1,2,2,0" ' + ' align="baseline" ' + ' height="20" ' + ' width="750" ' + ' ><NOEMBED><XMP>' + ' <PARAM NAME="otherparams" VALUE="Applet launched with OBJECT">'); else if (_ns == true) document.writeln( '<EMBED ' + ' type="application/x-java-applet;version=1.2.2" ' + ' pluginspage="http://java.sun.com/products/plugin/1.2/plugin-install.html" ' + ' code="TestAppletPolicy.class" ' + ' codebase="." ' + ' archive="TestAppletPolicy.zip" ' + ' align="baseline" ' + ' height="20" ' + ' width="750" ' + ' otherparams="Applet launched with EMBED" ' + ' ><NOEMBED><XMP>'); //--> </SCRIPT> <APPLET code="TestAppletPolicy.class" codebase="." archive="TestAppletPolicy.zip" align="baseline" height="20" width="750" > </XMP> <PARAM NAME="java_code" VALUE="TestAppletPolicy.class"> <PARAM NAME="java_codebase" VALUE="."> <PARAM NAME="java_archive" VALUE="TestAppletPolicy.zip"> <PARAM NAME="type" VALUE="application/x-java-applet;version=1.2.2"> <PARAM NAME="scriptable" VALUE="true"> if (_ie == true) document.writeln( '<PARAM NAME="otherparams" VALUE="Applet launched with OBJECT">'); else document.writeln( '<PARAM NAME="otherparams" VALUE="Applet launched with APPLET">'); No JDK 1.2 support for APPLET!! </APPLET> </NOEMBED> </EMBED> </OBJECT> </body> </html> */