Mega Code Archive
JDBC Applet Policy
<![CDATA[
/*
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"
>
]]>
if (_ie == true) document.writeln(
'');
else
document.writeln(
'');
No JDK 1.2 support for APPLET!!