Enterprise Systems Programming
Project 1: A Web Application connecting to a Two-table Database (Due January 12, midnight, though moodle)

For this project, you will write a web application that connects to a two-table database. The database has already been created for you. You must use this database and register it as a System DSN called emps. This way, when your instructor tests your application, the correct connection to the database will be made.

Use Eclipse for this project. Create a Dynamic Web Project under Eclipse and create all your source files from this environment.

Specifications:

1. Your application should support two queries:
   • Given an employee ID, list all information about the employee including the name of the department the employee belongs to.
   • Given a department name, list all names of employees under the department
2. You may create two separate html forms (one for each query) and then invoke those forms from a main webpage, or have a single html source containing both forms.
3. You are expected to use servlets, but not JSP, for this simple project. Refer to week 2 tasks for an example.
4. You are free to use any of the HTML form features, even those not discussed in class.
5. Make sure to enclose all of your Java source code within a named package.

Create a zip archive your Eclipse project folder. Name the archive [idnumber]-Project1.zip. This time, you may NOT work in pairs. Make sure you indicate your name in the programs you write. Submit through moodle .