Table Name 
Primary Key(s) 
Description 
Holiday HolName This table contains the holiday schedule. Permits will not 
be issued on holidays. 
Admin   
The Admin table stores several parameters that are used 
to configure the behavior of the Automated Permit 
Approval System. This table does not have a primary key 
since it contains only one row. 
Frequently 
FAQID 
This table contains a list of all frequently asked questions. 
Asked 
The list of FAQ's is composed by the town's employees, 
Questions 
and presented to external users. 
Table 5: Description of Database Tables 
As mentioned earlier, MySQL provides a command line user interface. On line documentation 
explaining both basic and advanced features is available at 
http://www.mysql.com/documentation/index.html
. 
The connection from the Web application to the database is usually done with a JDBC driver. 
The JDBC driver provides the middle tier from the Java SQL classes to the database. The 
JDBC driver serves to translate the Java SQL statement format to the database specific format, 
and returns the results that the processing of the statement generated to the application. 
The Permit System uses the MM MySQL JDBC driver, which was released under the GNU 
LGPL license. It is available at 
http://mmmysql.sourceforge.net/
.  
With the JDBC driver, connecting to the database becomes easy. The Permit System uses a 
simple JavaBean class to get a connection and to execute SQL statements. The connection is 
closed immediately after execution of the SQL statements. The DbBean class and its most 
important methods are presented below. 
Due to the low expected load of the application (more than 5 concurrent users are very unlikely), 
no connection pooling was implemented (connecting to a database is a very resource intensive 
task. Heavy duty applications therefore use connection pools that leave a set of connections 
open that are re used many times. Please see Section 5.5.4 for further details on database 
connection pooling).  
61 




Java Web Hosting Application Development Using Java Technologies Hosting




 
TotalRoute.net Business web hosting division of Vision Web Hosting Inc. All rights reserved.