Source files:

DB.html

(this html page),

DBDef.xml

(static XML layout),

DB.jsp

(server script generates and processes XML data and generates XLS export; uses the TreeGrid.dll/so),

../Database.*

(source SQL database, table TableData)

TreeGrid.jar

(support code to use TreeGrid server library),

TreeGrid.dll

or

TreeGrid.so

(library located in package root directory /Server/TreeGrid32/ or /Server/TreeGrid64/ depending on server system, used in TreeGrid.jar),

tmp/

directory can be used for temporary data to free JAVA memory.

You have to copy file hsqldb.jar to your JRE shared lib directory and restart your http server

The JSP service program must have write access to all files database.*

The

hsqldb.jar

is JDBC driver for

HSQLDB database

and is located in TreeGrid distribution in /Server/Jsp/ directory. The shared lib directory is usually jre_install_path/lib/ext and also e.g. in Tomcat is usually tomcat_install_path/shared/lib.
You can use any other SQL database instead of HSQLDB (e.g.

Oracle

,

MS SQL server

,

MySQL

,...), just assign different connection to java.sql.Connection Conn in the *.jsp files. You can run the ../MySqlUTF8.sql script to create the "TreeGridTest" sample database on your SQL server.

To use the TreeGrid server side library you have to copy file TreeGrid.jar to your JRE shared lib directory and restart your http server

The

TreeGrid.jar

is support code for using

TreeGrid server side DLL / SO

and is located in TreeGrid distribution in /Server/Jsp/ directory.

This example demonstrates using

TreeGrid server side DLL / SO

library for server side paging, calculations, grouping, sorting, filtering, Excel export and updates.
This example loads all data from database and fills them to TreeGrid DLL and uses it for generating data, pages and export for client. Uploaded changes are sent to both database and TreeGrid DLL to be synchronized.