This example demonstrates how to implement the applet so that the graph data
is acquired from a database. Here we set up the applet to acquire the configuration from a text file and the graph data from a
server side process which in turn acquires the data from a database.
The configuration data is acquired from the text file areaprops.txt
(click here to view)
and here is the HTML code,
<applet code="AreaGraphApplet.class" archive="AreaGraph.jar" width="460"
height="440">
<!-- Start Up Parameters -->
<PARAM name="LOADINGMESSAGE" value="Area Graph Loading - Please Wait."> <!-- Message to be displayed
on Startup -->
<PARAM name="STEXTCOLOR" value="0,0,100"> <!-- Message Text Color-->
<PARAM name="STARTUPCOLOR" value="255,255,255"> <!-- Applet Background color -->
<!-- Data files -->
<PARAM name="chartproperties" value="areaprops.txt">
<PARAM name="chartdata" value="http://www.jpowered.com/area_graph/areadata.php">
</applet>
The areadata.php script is designed to retrieve product sales data from a
MySQL database, from a table with the following structure,
Table Name : ProductSales |
|
|
ProductName |
Character |
Quarter1sales |
Integer |
Quarter2sales |
Integer |
Quarter2sales |
Integer |
Quarter2sales |
Integer |
Year |
Integer |
The script will pick out the sales figures for the year 2001 for three products
( ProductX, ProductY and ProductZ) and return the data in the correct format for the area graph.
The method is as follows,
- Set the output characteristics for the return data
- Establish the database connection
- Build the query statement and retrieve the database records
- Process the database records and return the Data
- All finished so close the database connection
For a full explanation of and range of values for the above parameters please
see the Documentation - Configuration Options».
« back to Examples Index
« back to Getting Started
|