CIS 4331/5301: Principles of Database Systems - Fall 2015

• About Me
• Course Home
• Schedule
• Projects
• Assignments
• Announcements

Phase 2: Web User Interface.

Develop a Web user interface that allows the user to query your database. The interface has to meet the following requirements.

Requirements

1. The user interface contains an HTML form, which allows the user to formulate her query.
2. In response to a user query, draw a HTML table and place the records in that table.
3. The user query form is always shown at the top of your user interface and the result of the query bellow it.
4. The form must have the following fields: Associated Term (e.g., Fall 2015), Course Title, Credit Hours, Instructor, Course Number, Days. Associated Term is a HTML SELECT (Drop-Down List) element. Course Title is a HTML TEXT element. Credit Hours consists of two HTML NUMBER FIELDS: from and to. It allows to add a between constraint. Instructor is a HTML SELECT with the MULTIPLE attribute. Course Number is a HTML SELECT with the MULTIPLE attribute and displays the options in sorted order. Days consists of five (5) checkboxes corresponding to Monday, Tuesday, Wednesday, Thursday and Friday.
5. DO NOT IMPLEMENT ANY VALIDATION OF THE INPUTS. E.g., check that for Credit Hours the value in FROM is smaller than the in TO. THIS WILL BE PART OF THE NEXT PHASE OF THE PROJECT. We assume that the user fills in correct values.
6. Create dynamically the SQL query based on the input from the user. The only dynamic part of the query is the WHERE clause. The WHERE clause is an AND of all the conditions. If the user does not mention a value in one of the fields then that field does not appear in the WHERE clause.
7. Implement the two methods for creating the SQL query described in class: (A) using string concatenation and (B) using the PrepareStatement class.
8. The table will have the following columns: Associated Term (e.g., Fall 2015), Course Title, Credit Hours, Instructor, Course Number, Days, Registration Level, and Location. You will display two types of results. If the user selects a instructor then the table will not have the Instructor and Registration Level columns. Otherwise, they will be shown in the table.
9. The form must include a SUBMIT button.

Deliverables

10. Update your report. Show the code (functions) for creating the SQL query using the method A and method B.
11. Describe the challenges you met while implementing this phase of the project.

Start early!