JDBC Applet Policy : Database Swing Applet « Database SQL JDBC « Java






JDBC Applet Policy

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


           
       








Related examples in the same category

1.Java database and Swing
2.Accounts
3.Applet JDBC
4.RowSet Model based on TableModel (JTable)
5.Applet and Oracle JDBC
6.JDBC Applet running in Netscape
7.This is a demonstration JDBC applet