Source files:

SortingExport.html

(this html page),

SortingExport_Layout.xml

(static XML layout),

SortingExport_Data.jsp

(server script generates XML list of pages),

SortingExport_Page.jsp

(server script generates XML for individual page),

SortingExport_Upload.jsp

(server script saves XML changes to db),

SortingExport_Export.jsp

(server script generates XHTML file for Excel),

../Database.*

(source SQL database, table TableData)

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.

The pages are downloaded on demand from server (when the page is visible by scrollbars).
It is simple example with ineffective database access - it loads the whole table for every page and throws the rest away. It also simply reloads all body when rows are added or deleted instead of handling changes in pages.