Ecommerce CRUD Application 🛒

A simple Java-based E-commerce Web Application built using JSP, Servlets, and JDBC with complete CRUD (Create, Read, Update, Delete) functionality for product management.

---

🚀 Features

• Add new products
• View all products
• Update existing products
• Delete products
• Clean and simple UI

---

🛠️ Tech Stack

• Frontend: JSP, HTML, CSS
• Backend: Java Servlets
• Database: MySQL
• Server: Apache Tomcat

---

📂 Project Structure

EcommerceCRUD/

├── .settings

│ ├── .jsdtscope

│ ├── org.eclipse.core.resources.prefs

│ ├── org.eclipse.jdt.core.prefs

│ ├── org.eclipse.wst.common.component

│ ├── org.eclipse.wst.common.project.facet.core.xml

│ ├── org.eclipse.wst.jsdt.ui.superType.container

│ ├── org.eclipse.wst.jsdt.ui.superType.name

├── build

│ └── classes/Ecommerce/CrudServlet.class

├── src

│ └── main/java/Ecommerce/CrudServlet.java

├── webapp

│ ├── META-INF/MANIFEST.MF

│ ├── WEB-INF

│ │ ├── classes

│ │ ├── lib

│ │ └── web.xml

│ ├── Productlist.jsp

│ ├── addproduct.jsp

│ ├── editproduct.jsp

├── .classpath

├── .gitignore

├── .project

---

⚡ Setup Instructions

1. Clone the repository:

   git clone https://github.com/MuhammadMuazAhmed/EcommerceCRUD.git

Import the project into your IDE (Eclipse/IntelliJ).

Configure your Tomcat server.

Set up MySQL database:

USE ecommerce;

CREATE TABLE products (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  price DECIMAL(10,2) NOT NULL,
  description TEXT
);

Update your DB connection settings in the project.

Deploy the project on Tomcat and run:

 http://localhost:8080/EcommerceCRUD/

📸 Screenshots

📌 Future Improvements

Add user authentication (login/register)

Implement shopping cart

Add payment gateway integration

🤝 Contributing

Contributions are welcome! Feel free to fork this repo and submit a PR.