Ecommerce Makeup Sales: Difference between revisions
Created page with "== Headline text == '''Goals & Objectives''' Provide an effective online shopping platform with popular and various make up products with suitable and enlightening description..." (change visibility) |
No edit summary (change visibility) |
||
| Line 1: | Line 1: | ||
=='''Introduction'''== |
|||
== Headline text == |
|||
| ⚫ | |||
==='''Project Scope'''=== |
|||
| ⚫ | |||
•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 |
|||
| ⚫ | |||
| ⚫ | |||
'''⦁ Information on source code files and screenshots''' |
|||
| ⚫ | |||
'''⦁ Manager Part:''' |
|||
| ⚫ | |||
It is designed for connecting jsp files to database. |
|||
| ⚫ | |||
⦁ BaseManager: |
|||
| ⚫ | |||
public BaseManager() throws Exception{ |
|||
• Add and delete various products to/from the cart |
|||
Class.forName ("com.mysql.jdbc.Driver").newInstance (); |
|||
} |
|||
protected void connect() throws SQLException{ |
|||
connection=DriverManager.getConnection(url, user,password); |
|||
} |
|||
protected void disconnect() throws SQLException{ |
|||
connection.close(); |
|||
} |
|||
'''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. |
|||
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: |
|||
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. |
|||
⦁ 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. |
|||
User Manager: Provides the connection and maintenance between Database (User) and Java files, synchronizes User.java entities. |
|||
[[File:systemEnvironment.png]] |
|||
'''Database Explanation''' |
|||
Our Project’s database performs all CRUD ( Create – Read - Delete – Update) actions. |
|||
=='''Modules of getthelook.com'''== |
|||
The explanation of each database table and their entities are explained below in the formation order. We first created the Category table. It’s formed of a main category and two sub categories. Root category is composed of skin, lips and eyes. Then each parent category is divided into sub categories: (Skin into concealer, powder, foundation), (Lips into lip balm, lipstick, lip pencil), (Eyes into eye pencil, eye shadow, mascara). After that step, each sub category is divided into another sub category. So system works recursively. The parentCategory id of the root category (skin, lips, eyes) are assigned as NULL. In this form, each child category is linked to its parent category by using parentCategory id. A simple display for this system is shown below in order to make the explanation more clear. |
|||
Revision as of 01:23, 11 March 2015
Introduction
Project Scope
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.
