📚 Bookstore Management System(Spring Boot + MySQL)

This is a full-stack Bookstore Management System using Spring Boot and Thymeleaf following MVC design pattern, with complete CRUD functionality and MySQL integration.

---

🚀 Features

• Add a new book with title, author, price.
• View a list of all books
• Update book details
• Delete a book
• Responsive frontend using Thymeleaf
• Integrated with MySQL database

---

🛠️ Tech Stack

• Backend: Java, Spring Boot, Spring MVC, Spring Data JPA
• Frontend: HTML, CSS, Bootstrap, Thymeleaf
• Database: MySQL
• Build Tool: Maven

---

---

⚙️ Setup Instructions

Prerequisites:

• Java 17+
• Maven
• MySQL installed and running

Steps to Run:

1. Clone the repository

   git clone https://github.com/damon005/Bookstore.git
   cd bookstore
   
   

2. Create the database

   Mysql:

      CREATE DATABASE bookstore_db;
   

3. Configure DB credentials

   Open src/main/resources/application.properties and update:

   properties:

      spring.datasource.url=jdbc:mysql://localhost:3306/bookstore_db
   
      spring.datasource.username=root
   
      spring.datasource.password=yourpassword
   

4. Run the application

    mvn spring-boot:run
   

5. Access in browser http://localhost:8080/books

Screenshot

IMG - 1: Bookstore Home

IMG - 2: New Book Register

IMG - 3: Available Books

IMG - 4: My Books