Objectives

Demonstrate the Data Access Object (DAO) pattern  by creating a java servlet which reads the IndyWinners database and displays a list of Indy Winners to the remote user. The application must support multiple concurrent users ensuring the Java servlet is “thread safe”. You must create and use a DAO design pattern for building/creating IndyWinner objects (which are then used to provide the data for display  purposes to the remote user.) Make sure you apply SOLID with regards to each classes/interface you create for the application.

Tasks:

1.  Use the provided SQL scripts to create your database using MySQL and the MySQL Workbench (CTLDIndyWinners.sql, in the provided ZIP file).

2.  Create the Java Servlet which will be invoked by a HTML page with a servlet request to the servlet engine (server, Tomcat).   Provided ZIP file is a complete Netbeans project for a working “simplified” example.   Note this environment uses a web browser, servlet engine (Tomcat server), and the MySQL database server, MySQL workbench tool helps. (Your lab Prof should review the provided sample)

3.  The servlet must build IndyWinner objects which must incorporate a DAO design pattern for accessing the database with the Indy Winners state.

4.  The servlet must be thread safe (support multiple concurrent users).

5.  The display to the client (remote user, web browser) must show a maximum of 10 winners per screen/page with a “continue” button on the bottom (effectively scroll thru the list of winners 10 at a time).

6.  You must create a UML class diagram for your application (meet SOLID principles and incorporate a DAO design pattern, minimum).