Additional Code - Zip File

Listing 1

<?xml version='1.0' encoding='utf-8'?>
<Context displayName="DBTest" docBase="C:/Program Files/Apache Software
Foundation/Tomcat 5.0/webapps/DBTest" path="/DBTest" workDir="work\Catalina\localhost\DBTest">

<Resource auth="Container" description="DB Connection" name="jdbc/TestDB"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/TestDB">
			<parameter>
			<name>factory</name>
			<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
			</parameter>
			<parameter>
			<name>url</name>
			<value>jdbc:mysql://localhost/test?autoReconnect=true</value>
			</parameter>
			<parameter>
			<name>password</name>
			<value></value>
			</parameter>
			<parameter>
			<name>maxActive</name>
			<value>100</value>
			</parameter>
			<parameter>
			<name>maxWait</name>
			<value>5000</value>
			</parameter>
			<parameter>
			<name>driverClassName</name>
			<value>com.mysql.jdbc.Driver</value>
			</parameter>
			<parameter>
			<name>username</name>
			<value>ODBC</value>
			</parameter>
			<parameter>
			<name>maxIdle</name>
			<value>2</value>
			</parameter>
	</ResourceParams>
</Context>

Listing 2

package command;

import java.sql.Connection;
import java.sql.SQLException;

public interface DatabaseCommand {
	public Object executeDatabaseOperation(Connection conn) throws SQLException ;

Additional Code - Zip File