Java DBReports

Sorry, but this applet can only run in a Java compatible browser. Sorry, but this applet can only run in a Java compatible browser.

Java DBReports: This applet is a demonstration of the Power of JAVA to empower Business users to generate Powerful Database Reports/Queries with very simple HTML level parameters. The example shows the power of the JavaReports Applet by implementing an "N-Level" Master Detail relationship to report data from an Oracle Database. The Applet talks to an intermediate "Application" server via TCP/IP which in turn communicates to an Oracle Database using SQL*Net.



Here is the definition of the Applet Tag:

Note that the host/port tags should be set to the Place where the serv program is executing on the Java Contest Machine. The serv program MUST be running for this Applet to function. If there were any problems in the installation/configuration of the serv deamon (i.e. Applet seems to not be working), please go to http://vit.com:9001/java to examine the referance Applet at my development site. I promise that the code there is identical to that which has been submitted (can be verified if needed)


APPLET CODE="JavaTest.class" height=150 width=600
PARAM NAME="host" VALUE="vit.com"
PARAM NAME="port" VALUE="9999"
PARAM NAME="num_parameters" VALUE="4"
PARAM NAME="p0" VALUE="loc_id=choice:select distinct location_id, regional_group from location"
PARAM NAME="p1" VALUE="region=textfield:select regional_group from location where location_id=:loc_id order by regional_group"
PARAM NAME="p2" VALUE="dept_id=list:select distinct department_id, name from department where location_id=:loc_id order by name"
PARAM NAME="p3" VALUE="emp=sheet:select last_name,first_name,salary,commission from employee where department_id=:dept_id UNION select ' ',' ',SUM(salary),SUM(commission) from employee where department_id=:dept_id order by last_name"
/APPLET

Note that the four widgets are defined by the HTML writer by setting the number of parameters with num_parameters and then setting parameters 0 through num_parameters-1 with a command string. The command string is defined as:
{Widget Value Name}={Widget Type}:{SQL optionally containing other Widget Value Names}

Java DBReports automatically computes a dependency tree and requeries ONLY those widgets which recursively get thier identity from one or more other widgets.

(Note that to minimize load on the server, Java DBReports will automatically log out of the database if the page is left. The session will automatically reconnect and restart the applet if the page is returned to)