📚 Online Book Store Application

The Online Book Store Application is a Java-based web platform designed to solve the real-world problem of limited access to physical bookstores and the time-consuming process of book shopping. It provides users with a convenient way to browse, search, and purchase books online, making reading more accessible and efficient. This system addresses the need for 24/7 book availability, easy discovery of titles, and a smooth buying experience from anywhere this is a Java-based web application that allows users to browse, search, and purchase books online. It includes user registration/login, book listings, shopping cart functionality, and order management. Admins can manage inventory and handle orders through a dedicated admin panel. The project aims to provide an easy and efficient way to buy and sell books online.

---

ℹ️ About

A user-friendly Online Bookstore project in which users can log in or register, view the available books, select books along with their quantity, and buy them. Users can also get payment receipts after successful payment. The project can also be used by the administrator, who can add new books, remove books, increase and decrease the quantity of books, change the price of the books as well as maintain the selling history of books.

---

🎯 This Website is built for following purpose:-

• For Selling books online.
• Maintaining books selling history.
• Adding and managing books.
• User Friendly.
• For Implementation of Http Servlets in Java.
• This is a Mini-project developed using Java, Jdbc, And Servlets.

---

👨‍💼 Admin Have Following Access for this online store site:-

• Add New Books.
• View Books Available.
• Remove Books.
• Increase Books Amount.

---

🙋‍♂️ Users Have Following Access for this online store site:-

• Create New Account or Register.
• Login.
• View Available Books.
• Select Books to Buy.
• Select Books Quantity.
• Buy Books.
• Get Payment Receipt.

---

🛠️ Technologies used:-

1. Front-End Development:

• HTML
• CSS
• Javascript
• BootStrap

2. Back-End Development:

• Java [JDK 8+]
• JDBC
• Servlet

3. Database:

• MySql

---

📸 Some Screenshots for the project:

👤 User Role

• Home

• Login

• When double tab on login display this

• Registration

• User Registered Successfully

• User Login

• Available Books

• Add To cart

• Cart

• When Click Proceed Pay Button Redirect Cart Checkout Page

• Your Orders

---

🛡️ Admin Role

• Login

• Admin Login

• Store Books

• Add Books

• Remove Books

---

================ 💻 Software And Tools Required ================

• : Java JDK 8+
• : Eclipse EE (Enterprise Edition)
• : Apache Maven
• : Tomcat v8.0+
• : MySQL Server
• : MySQL Workbench

---

🗃️ ================= MySQL Database =================

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: MySQL Database

---

📞 Contact Information

🐙 GitHub: https://github.com/pratikkhot100

💼 LinkedIn: https://www.linkedin.com/in/pratikkhot01

📧 Email: pratikkhot1207@gmail.com