Enterprise Systems Programming
Project 1: A Web Application connecting to a Two-table Database
(Due January 12, midnight, though moodle)
Instructions:
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:
- 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
- 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.
- You are expected to use servlets, but not JSP, for this simple project.
Refer to
week 2 tasks for an example.
- You are free to use any of the HTML form features,
even those not discussed in class.
- 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 .