Reference no: EM13163887

Description:

Create a web application for Sheridan Restaurant Reviews that contains the following functionality:

• Display a table of all restaurants based on the city entered by the user and whether the restaurants allow take-out orders or not

• Allow the user to update the ratings of a restaurant

1. Database - Restaurants.sql

The provided script does the following:

- Creates a new database called RestaurantReviews
- Creates a new table called Review and populates it with some records:

o ReviewId - An auto-incremented value that represents this table's primary key
o Restaurant - The name of the restaurant
o Food - The restaurant's score for food
o Service - The restaurant's score for service
o Price - The restaurant's score for menu prices
o Location - The city where the restaurant is located
o Cuisine - The type of cuisine served at the restaurant
o TakeOut - A true value indicates that the restaurant allows for take-out orders

2. Your Web Application

a) Make sure the DBConnection and MySQL JDBC Driver libraries are imported in your new project.

b) Modify index.html by adding two HTML forms - one for each function within the application.

• Each form should send a request to an appropriate servlet
• The Price Rating field when updating a restaurant review should be a dropdown list with the values 1, 2, 3, 4, 5 in that order

c) Your database configuration must be stored as a series of context-initialization parameters.

d) Your solution must have a ServletContextListener that does the following when the application loads:

• Get the database configuration from the ServletContext
• Construct a new DBConnection object based on the database configuration
• Store the DBConnection object as a ServletContext attribute

e) Create a JavaBean that maps with the Review table of the database

f) Create a DAO class that contains methods that do the following:

• Get restaurants by location. This method should have parameters for a Connection object, the city, and whether to return restaurants that allow take-out orders. Your results should be ordered by descending food rating, then descending service rating.

The method should return a list of Review beans.

• Update a restaurant review. This method should have parameters for a Connection object and the values required to update a restaurant review's ratings. The method should return true if the new review was successfully updated, false otherwise.

g) Create a servlet that handles requests to get a list of restaurants by location

• The request should be forwarded to a JSP which will display a table of those restaurants

h) Create a servlet that handles requests to update a restaurant's review

• Forward the request to index.html if the restaurant review was successfully updated
• Forward the request to an error page if the restaurant review was not updated

i) Create a JSP that displays a table of all restaurants that match the selected criteria. Below is the sample page if the user wanted to view all restaurants in Brampton that allow take-out: