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