MovieReviews.Com

This website allows users to post reviews about movies.

It allows user to do the following:

Architecture Of the Project

This project uses JSPs and JSTL to build the interface. Java Beans talk to DAO (Data Access Objects), which talk to database using JDBC.

So overall architecture is - JSPs and JSTL -> Java Beans -> DAO -> JDBC -> Oracle Database.

It uses JavaMail to send mail to user when user places an order.

It uses AJAX to vertify whether username is unique at the time of registration.

Products and technologies used in this project

Steps to download and deploy this project

  1. Download moviereviews.rar. The .rar file contains the entire source code for the project. Unzip the file into c:\ so that c:\moviereviews folder is created with all the components of the project.
  2. Open the project in NetBeans 7.x
  3. Go to properties of the project using popup menu. Select libraries node and delete existing libraries using  Remove button. Then add - Oracle - ojdbc6.jar and mail.jar (assuming you have downloaded JavaMail API) for Java Mail. You have to add these .jar files to the project using Add Jar/Folder button.
  4. Add the .jar files related to JSTL using Add Library option.
  5. Create moviereviews account with password mr in Oracle11g Express Edition. This must be done after you log in as SYSTEM user. Then create tables and sequences listed below after connecting to Oracle as moviereviews. These commands are also present in tables.sql file in your project source code.
  6. Run login.jsp. Login and check existing options.