Java DBReports
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)