Applet Demo

This is a very simple demonstration of an applet connecting to an odbc data source using the Easysoft JDBC-ODBC Bridge. The HTML code that is used to launch the applet is as follows:
<APPLET    
    CODE = "QueryApplet.class" 
    ARCHIVE = "../jars/EJOB.jar" 
    WIDTH = 450 HEIGHT = 200>
    <PARAM NAME = "jdbcUrl" 
           VALUE  = "jdbc:easysoft:"
        </PARAM>
</APPLET>
 

    <PARAM NAME = "query" 
           VALUE  = "select COF_NAME, PRICE from COFFEES"
        </PARAM>
</APPLET>
 

The CODE tag specifies the class file for the applet's code: QueryApplet.class
The ARCHIVE tag specifies the Java archive file that contains the Easysoft JDBC-ODBC Bridge driver's classes:"../jars/EJOB.jar"


The applet takes a single parameter the jdbc url required to connect to an ODBC data sources on the machine where the JOB server is installed and this html page is served from.
Here is the source QueryApplet.java

When the page is loaded the applet is started and if the JOB server is running it will popup a dialog box allowing a choice from the avaliable ODBC Data sources to connect to:

Upon successfull connection the result of running query select COF_NAME, PRICE from COFFEES is displayed.

Click on this link COFFEES to run another applet to create and populate the sample table, and rerun this applet. See SetupCoffees.java

You can also insert some unicode data by running another applet InsertUnicode.html See InsertUnicode.java You need to rerun SetupCoffees.html to recreate the COFFEES table.

The last three rows contain unicode data. Your browser may not be able to show them. In that case run the applet with Java Plugin, or if you have a recent version of Java installed try to look at this page with the appletviewer. The very last row contains Japanese text. Your java may or may not be configured to display it.

The output should be something like: