Source files:

Schools.html

(this html page),

SchoolsDef.xml

(static XML layout),

Schools.jsp

(server script generates and processes XML data and manages users),

SchoolsRatings.jsp

(server script generates XML with user ratings),

SchoolsReview.jsp

(server script saves user review to db),

../Database.*

(source SQL database, tables Schools_Schools, Schools_Ratings, Schools_Reviews)

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.

There are three modes to work with data:
a) View all data and rate and review the schools. Default mode, without log in.
b) Edit data as user . Every user has his own data. You can log in as Jan, Magda, David, Adam, Linda , all without password. Or you can add new user by entering new name and password.
c) Edit all data as administrator . You can edit all data or even assign it to another user. You can log in as Admin, without password.