Chapter 15
620
You may also want to modify index.html to filter on a different minimum commission level. For example,
the following index.html will cause the system to only show trips with commission of $300 or more:
<html>
<head>
</head>
<body>
<table width="600">
<tr><td>
<center><h1>Wrox Travel Center</h1></center>
</td></tr>
</table>
<applet archive="aelfred.jar" code="VacationApplet.class" width=600
height=400>
<param name="mincomm" value="300">
</applet>
</body>
</html>
You may want to repeat this test with the Netscape 4.7 and Netscape 6 browsers to convince yourself
that this is a cross-browser compatible solution.
Finally, we need to test the optimized incremental update mechanism that is built into the system. For
this, we will need a testing tool.
Compiling and Using the XML-to-RDBMS Data
Injection Test Tool
The testing tool we look at will allow us to perform three simple RDBMS operations:
q
Read an XML document called data1.xml containing sell-off information and add the trips
to the RDBMS
q
Read an XML document called data2.xml containing sell-off information and add the trips
to the RDMBS
q
Clear the RDBMS of all records
The tool provides a GUI consisting of three buttons. Clicking each button will perform the associated
task. The finished GUI should resemble the one below:
The testing tool can be found in the projavaxml\Chapter15\tools distribution directory. It consists
of the following source files:
q
TestTool.java
q
HandlerBase.java
q
databaseBean.java
q
sqlBean.java