Ecommerce Makeup Sales

Introduction

Goals&Objectives

•Provide an effective online shopping platform with popular and various make up products with suitable and enlightening descriptions •With one simple click deliver a product to a customer’s door, without having them to step out of the house. •Make the online shopping process as easy and as effective as possible

Advantages of getthelook.com

• Convenient, no need for an extra effort since it enables buyers to purchase products easily with just one click • Variety of products with visual images • Products suitable for different budgets • Different brands, different models; costumers are not limited to what’s in the sore racks and stock rooms. • The ability to price compare; it is easy to compare and find the best price instantly • Shop 24/7: No working hour limitations

Major Software Functions

Users are able to: • Log in and sign up • Add products to the cart before or after logging in • Buy products by providing the card information after logging in • View categories, Choose a brand, Choose a product • Add and delete various products to/from the cart

Admins are able to: • Update/delete products • Update/delete categories • View carts • View users

Technical Documentation

Information of the System Environment

The Project is developed on Sony Vaio Tap 11. It’s Windows 8 64-bit, Core i5-4210Y (1.50GHz/1.90GHz), 4GB RAM, Intel HD Graphics 4200. First of all we downloaded MySql Web Community Edition and Netbeans with Tomcat extension. In order to build our e-commerce website, we used MySql, JDBC, JSP, HTML and Java. Since we used HTML, Java and MySql we had to set up a connection among them. As displayed in the Figure below HTML and Java are connected by using JSP while Java and mySql are connected by using JDBC.

Modules of getthelook.com

Shopper Module

Main and Login Page (index.jsp)

We created both Html and java codes together in this file in order to display the main page figure below. We created style sheet to design the index page. (stylesheet.css) 

Sign-up Page

This page will be developed soon.

Category Viewing Page

This file displays all the categories available to the user. We created style sheet to design the category view page. (categorystylesheet.css)

Product Viewing Page

This file displays all the products available to the user. We created style sheet to design the product view page. (productstylesheet.css)

Manage My Account Page

This page will be developed soon.

Shopper Logout Page

Enables user to logout and releases the session attributes. (Current Shopper and Current Cart)

Admin Module

The pages in this module will be developed soon.

Data Structures and Variables

Connection to Database

By using BaseManager class we can connect database to the Java. In order to avoid code repetition about the connection we formed a manager class, named BaseManager to make all connections at once. In order to make the connection possible we later created separate java files for each table (Category, Product, Users, Cart, Cartline). At the beginning of the coding process first there were java files just for the Category and Product tables. Once we progressed and formed other tables we created separate java files for each of them. In this way we avoided the need for putting URL for each separate file by using BaseManager class. By using Polymorphism, we created BaseManager class and extended subclasses so that we do not have to write these methods over and over again. Following are the extended classes: • Category Manager: Provides the connection and maintenance between Database (category) and Java files, synchronizes Category.java entities. • Product Manager: Provides the connection and maintenance between Database (product) and Java files, synchronizes Product.java entities. • CartLineManager: Provides the connection and maintenance between Database (cartLine) and Java files, synchronizes CartLine.java entities. • User Manager: Provides the connection and maintenance between Database (User) and Java files, synchronizes User.java entities.