MovieReviews.Com Using Struts2

It allows user to do the following:

• Register
• Login
• Recover password
• Change password
• View recent movies
• Search for movies
• See reviews for each movie
• Post review
• Get list of reviews posted by the user
• Delete review posted by the user

Architecture Of the Project

So overall architecture is - JSPs-> Action Classes -> DAO -> JDBC -> Oracle Database.

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

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

Products and technologies used in this project

• Java EE 6.0 - JSP, Java Bean, Filter, JSTL and Java Mail
• Oracle11g Express Edition
• NetBeans IDE 7.3
• Struts 2.3
• Jdk 7.0
• Tomcat 7.x
• Mail Server
• JQuery

Steps to download and deploy this project

1. Download struts2_movies.rar. The .rar file contains the entire source code for the project. Unzip the file into c:\ so that c:\struts2_movies 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 the following .jar files related to struts2 using Add Jar/Folder option. These .jar files are found in LIB directory of Struts2 download.

   asm-3.3.jar
   asm-commons-3.3.jar
   asm-tree-3.3.jar
   commons-beanutils-1.8.0.jar
   commons-digester-2.0.jar
   commons-fileupload-1.3.jar
   commons-io-2.0.1.jar
   commons-lang3-3.1.jar
   commons-logging-1.1.3.jar
   freemarker-2.3.19.jar
   javassist-3.11.0.GA.jar
   log4j-1.2.17.jar
   mail.jar
   ognl-3.0.6.jar
   ojdbc6.jar
   struts2-convention-plugin-2.3.15.1.jar
   struts2-core-2.3.15.1.jar
   struts2-jquery-plugin-3.6.1.jar
   struts2-tiles-plugin-2.3.15.1.jar
   tiles-api-2.0.6.jar
   tiles-compat-3.0.1.jar
   tiles-core-2.0.6.jar
   tiles-el-3.0.1.jar
   tiles-jsp-2.0.6.jar
   tiles-servlet-3.0.1.jar
   xwork-core-2.3.15.1.jar
   

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 all/login.jsp. Login and check existing options.