Online Shopping Cart E-Commerce Website Project in Java, JDBC, Servlets, JSP

Online Shopping Cart E-Commerce Website Project in Java, JDBC, Servlets, JSP

In this project, users can browse the website, register, and log in to explore available products. They have the ability to search and filter items based on various categories and add multiple products to their cart. Users can adjust the quantity of each product in the cart, with options to increase or decrease the number of items. Once satisfied with their cart, users can proceed to checkout, where they will input their credit card details to complete the payment. Upon successful payment, the order will be confirmed, and users can view their order details, including the shipping status, in the “Orders” section.

The admin plays a crucial role in managing the e-commerce platform. Admins are responsible for adding new products, updating product details, and removing items from the store. They also handle inventory management and can view all orders placed by customers. Admins have the ability to mark orders as “shipped” or “delivered” based on the product’s delivery status.

A key feature of this project is the integration of email notifications. When a user registers on the website, they receive a confirmation email. Additionally, every time a product is ordered or shipped, users receive a notification via email. If an item is out of stock, the system notifies the user when it becomes available again.

This project efficiently manages customer interactions, product inventory, and order fulfillment, ensuring a seamless shopping experience for users and smooth management for the admin.

Home Page

Login Page

Category Wise Product Filter

Cart Items

Admin Home

Stock Items

• New User Registration
• Order Successfully Placed
• The Item was out of stock while exploring but now it got available in the store
• Successful shipment and delivery of the Item

1. Front-End Development:

• HTML
• CSS
• Javascript
• BootStrap

1. Back-End Development:

• Java [JDK 8+]
• JDBC
• Servlet
• JSP

1. Database:

• MySql

• : Git [https://www.youtube.com/watch?v=gv7VPQ4LZ7g]
• : Java JDK 8+ [https://www.youtube.com/watch?v=O9PWH9SeTTE]
• : Eclipse EE (Enterprise Edition) [https://www.youtube.com/watch?v=8aDsEV7txXE]
• : Apache Maven [https://www.youtube.com/watch?v=jd2zx3dLjuw]
• : Tomcat v8.0+ [https://youtu.be/mLFPodZO8Iw?t=903]
• : MySQL Server [https://www.youtube.com/watch?v=Ydh5jYA6Frs]
• : MySQL Workbench [https://www.youtube.com/watch?v=t79oCeTXHwg]

STEP 1: Open MySQL Command Prompt or MySQL Workbench

STEP 2: Login to the administrator user of MySql: mysql -u <username> -p (Enter Password if asked)

STEP 3: Copy paste and execute the MySQL Query from the following file:-

• Run the Sql Query From this file: databases/mysql_query.sql

Step 1: Create a gmail account or login to existing account in any browser

Step 2 : Go to https://myaccount.google.com/security and check if 2 step verifications is enabled or not, enable it if not enabled

Step 3: Go to https://myaccount.google.com/apppasswords and enter password if asked

Step 4: In Select an App Section: select Other (custom name) => enter “Ellison Electronics” => Generate

Step 5: After that it will generate 16 digits app password which you need to copy and save for future configurations.

Step 6: Done : Now continue to importing the project. [Don’t share the above password generated to anyone]

Step 1: Open Eclipse Enterprise Edition. [Install, if not already installed.]

Step 2: Click On File > Import > Git > Projects From Git > Clone Uri > Paste The Repository Url as: https://github.com/shashirajraja/shopping-cart.git> Select master Branch > Next > Next > Finish.

Step 3: Go inside Java Resources > src > application.properties and update the values as below:

• a) Update value for db.username and db.password according to your installed mysql credentials.
• b) Update value for mailer.email and mailer.password, with the same email and app password that you generated earlier in above section [ NOTE:Actual gmail password will not work]

Step 4: Right Click on Project > Run as > Maven Build > In the goals field enter “clean install” > apply > run

Step 5: Right Click On Project > Build Path > Configure Build Path > Libraries > Remove and Update Any Libraries if Red Mark Exists > Finish.

Step 6: Right Click on Project > maven > update project > select force update > apply > close

Step 7: Tomcat Configurations:

• If Tomcat Server is not configured in Eclipse :

  • Right Click On Project > Run As > Run On Server > Manually Define a new server > Select server type > select Tomcat v8.0+ > (Select Tomcat V8.0+ Installation Location If Asked) > Next > Add the current project > Finish.

• Else If Tomcat Server is already configured in Eclipse:

  • Right Click On Project > Run As > Run On Server > Select Tomcat Version > Next > Add the project > Finish.

    or

  • You can directly goto server tab, select the tomcat server and use the debug or run button to start the previously ran project

Step 8: Check Running The Site At http://localhost:8080/shopping-cart/

Step 9: [To Change the Port, if getting error like ‘port already in use’] Open The Server Tab > Double Click On Tomcat Server > Ports > Change The Port Number For Http/1.1 To 8083 > Close And Save. Now Start and you can access the project on http://localhost:8083/shopping-cart/

Step 10: Default Username And Password For Admin Is “[email protected]” And “admin”

Step 11: The default Username And Password For User Is “[email protected]” And “guest”