EXERCISE 1: MOVIE DATABASE

Using the techniques and Java JDBC APIs introduced in chapter 28 of your text book define a movie database application that allows a user to look up information about a movie and provide a review for a movie. Your application should provide the following features:

List all movies that are rated a particular rating (PG, PG-13, R, etc) entered by the user.

All a user to post a review for a particular movie. A review consists of review text and a star rating with

5 stars = Excellent

4 stars = Good

3 stars = Neutral

2 stars = Poor

1 star = Very Poor

List all reviews for a movie and include the average star rating for the movie

Your solution should read the database connection information (jdbc driver and connection url) from a properties file called database.properties. You can create a console based application to implement this application or write a GUI interface to provide these movie database features described above. The only requirement is that the class containing the main method should be called MovieDBApp.