10-07-2012, 11:24 AM
E-Commerce Website
CSE 220 Final Project .doc (Size: 2.04 MB / Downloads: 379)
INTRODUCTION
What was the purpose?
For the Final Project for our class, CSE220 Enterprise Software Development, we had to choose a project to complete that would demonstrate our knowledge of the class material. We could choose any task that required the use of an enterprise application to solve the problem. The application solution that we ultimately would generate must follow the MVC (Model View Controller) architecture and must utilize a MySQL database.
I chose to do an e-commerce website. I programmed my site based on ideas that I had seen in popular and successful online shopping websites as well as from ideas I gathered during my class studies. To differentiate my site from other projects, I decided to do two things:
1) Create a website with REAL products in it from an actual company owned by an associate of mine.
2) Create features on the website that we had not previously covered in class to demonstrate my knowledge of enterprise software development.
There will be more explanation later in this report about the administration screens and what their significance is to the application.
Application Features
My application contains the following features:
• MVC Architecture using a MySQL relational database back-end in 3rd Normal Form and a JSP driven front-end interface
• Ability to search and browse catalog items
• Ability to add, delete and view items in a shopping cart
• Ability for administrators to view customer orders and the individual items in those orders
• An “always-on” shopping cart sidebar (to allow for the viewing of the shopping cart while browsing items)
Software Utilized
All my JSP and Java coding was done using notepad. Some examples were used from classroom samples taken from various textbooks. The documentation for these files contains the original comments from these resources denoting where they came from.
The following table lists the software used to build and run the ABS e-commerce website application.
What do I do with the install files for this application?
The install files will include a folder named “ABS” and a .sql script file named “ABSdb.sql”. To install this application simply copy the “ABS” folder into the “webapps” folder of an installed TomCat web server. Normally you would also have to make a configuration entry in TomCat’s “server.xml” file, but I ran this application fine on two different versions of TomCat and never made that entry! Nevertheless, since this is the way we learned it, go into the “conf” folder of TomCat and open “server.xml” and after the last non-commented <context> tag you find add the following lines (if this prevents the application from running feel free to remove this entry):
Model View Controller
The Type-2 model used to operate this application behind-the-scenes is called the Model View Controller (MVC) architecture. Basically, a servlet named “Controller” handles every request that comes to the web application. Depending on what action argument the URL request has, if any, the controlling servlet will request the appropriate JSP page and the page will carry out the appropriate behavior for the particular action passed to it. This architecture is harder to code and implement as opposed to a Type-1 model which would just use JSP files to handle all the application navigation but it provides for the greatest flexibility, upgradeability and power.