E-Commerce

An E-commerce Web Application with Admin Panel

This project is deployed on AWS EC2. Here is the link to the project: http://13.250.198.160:8080/E-Commerce/index.jsp .
PS: It's not responsive and hence is best viewed on a desktop browser.

Intro to the project

Here's the index page of the application. All these products are loaded from the database.

You can click on any item to view details like this

You can also make a search

You can add items to your cart and can checkout any time

And here is the admin panel where you can sign up and then can add products

Install this project on your system

You will need Apache-Tomcat server to run this project on your system

-then create the following mysql tables

desc users;

+----------+-------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+----------+-------------+------+-----+---------+----------------+

| userId | int(11) | NO | PRI | NULL | auto_increment |

| email | varchar(50) | YES | | NULL | |

| password | varchar(50) | YES | | NULL | |

| name | varchar(50) | YES | | NULL | |

+----------+-------------+------+-----+---------+----------------+

desc sellers;

+----------+-------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+----------+-------------+------+-----+---------+----------------+

| id | int(11) | NO | PRI | NULL | auto_increment |

| name | varchar(50) | YES | | NULL | |

| email | varchar(50) | YES | | NULL | |

| password | varchar(50) | YES | | NULL | |

+----------+-------------+------+-----+---------+----------------+

desc products;

+-----------------------+-------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+-----------------------+-------------+------+-----+---------+----------------+

| productId | int(11) | NO | PRI | NULL | auto_increment |

| productName | varchar(50) | YES | | NULL | |

| productDescription | varchar(50) | YES | | NULL | |

| productGender | varchar(50) | YES | | NULL | |

| productCategory | varchar(50) | YES | | NULL | |

| productQuantitySmall | int(11) | YES | | NULL | |

| productQuantityMedium | int(11) | YES | | NULL | |

| productQuantityLarge | int(11) | YES | | NULL | |

| productSoldBy | varchar(50) | YES | | NULL | |

| productPrice | int(11) | YES | | NULL | |

| productDiscount | int(11) | YES | | NULL | |

+-----------------------+-------------+------+-----+---------+----------------+

desc cart;

+-----------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-----------+-------------+------+-----+---------+-------+

| userEmail | varchar(50) | YES | | NULL | |

| productId | int(11) | YES | MUL | NULL | |

| size | varchar(50) | YES | | NULL | |

+-----------+-------------+------+-----+---------+-------+