Using TreeGrid JSP framework
Creates grid data from and saves changes back to database using AJAX and TreeGrid JSP framework
Do not run this file locally!
Run it from your local or remote web http server where is installed JAVA JRE.
Source files:

Framework.html

(this html page),

DBDef.xml

 (static XML layout),

Framework.jsp

 (server script generates and processes XML data),

../Database.*

(source SQL database, table TableData),

../Framework/TreeGridFramework.jsp

(TreeGrid JSP framework support script, included into Framework.jsp script)

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 Framework.jsp. You can run the ../MySqlUTF8.sql script to create the "TreeGridTest" sample database on your SQL server.