Ecommerce Makeup Sales

Headline text

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

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

⦁ Information on source code files and screenshots ⦁ Manager Part: It is designed for connecting jsp files to database. ⦁ BaseManager:

   public BaseManager() throws Exception{
       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();
   }

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. User Manager: Provides the connection and maintenance between Database (User) and Java files, synchronizes User.java entities.

Database Explanation Our Project’s database performs all CRUD ( Create – Read - Delete – Update) actions. 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.