| 1. |
Locate the Database Applet install directory on your computer. On windows the default directory is
c:\program files\dbapplet. If you downloaded the zip package the
install directory is the location or the extracted files.
|
| 2. |
Create an empty folder for your project |
| 3. |
Copy the dbapplet.jar file in the install directory to the new project folder. This file contains the
applet
|
| 4. |
Prepare your data in a CSV (Comma delimited) format and save
it to the project folder in a file named data.csv. Software like Microsoft Excel will allow you to
"Save as" in CSV format
The default name is data.csv. You can use another name and set the
dataFile property in the properties file as described below.
|
| 5. |
Create a file named dbapplet.properties in the project folder. This file is a configuration file for
the applet.
The details on how to configure the applet are described below.
Use a simple text editor to create dbapplet.properties. You can name
the properties file something else and specify the properties file in
the applet param tag as shown below
|
| 6. |
Create a html file that contains the applet tag below. You can cut and paste the tag below into your
html file.
|
| 7. |
You should now have four files in the project folder you created,
dbapplet.jar, dbapplet.properties, data.csv and
your html file. Upload these files to your web site and open the html page in a web browser. You
should see the applet
and the data loading correctly. Before you test the applet you typically want to add a minimum of
configuration instructions in the
dbapplet.properties such as column names and data types. Add one property per line in
dbapplet.properties. A property has a name and a value separated by a space. The
properties are listed below. All properties are optional
|
| Property |
Description |
headerInFile
|
If this is set to true the applet will use the first line in the data.csv file as column
headers.
|
rowCount
|
Number of rows (lines) in your data file.
|
column
|
You can add a column property per column in the data file. The column property is followed
by arguments such as name and type e.g. name=Price; type=number;
pattern=$#,##0.00. The applet will use the name
as column header and type to format and sort the column.
In addtion to name and type arguments the column can have href and baseref arguments.
|
dataFile
|
data.cvs is the default data file. You can specify
another name with the dataFile property.
|
delimiter
|
Comma is the default delimiter. You can specify
other delimiters. The delimiter property be one of the
following: COMMA, SPACE, TAB, POUND or SEMICOLON.
|
licenseKey
|
Your license key. Without a valid license key the
applet will display a Nag Screen every time it loads.
|
printAction
|
Link to a server side script that will print the selected
rows. E.g.
printAction
http://www.nktsoft.com/php/upload.php
|
checkoutAction
|
Link to a server side script that will display a shopping
chart containing the selected rows E.g.
checkoutAction
http://www.nktsoft.com/php/checkout.php
|