README.md

Simple CRUD App with Spring Boot

This is a simple CRUD (Create, Read, Update, Delete) application built using Spring Boot. It is a great beginner project to understand how to use Spring Boot, Thymeleaf, and MySQL for basic database operations.

Project Structure

• Spring Boot for the backend
• Thymeleaf for templating engine
• MySQL for the database

Prerequisites

• Java 17 or higher
• MySQL installed and running
• Maven or Gradle for dependency management

Steps to Build the Application

1. Initialize the Project using Spring Initializr

Go to Spring Initializr, and generate a Spring Boot project with the following options:

• Project: Maven Project
• Language: Java
• Spring Boot version: (Select the latest stable version)
• Project Metadata:
  • Group: com.name
  • Artifact: name
  • Name: name
  • Description: Simple CRUD App
  • Package name: com.packagename
  • Packaging: Jar
  • Java: 17 or higher
• Dependencies:
  • Spring Web
  • Spring Data JPA
  • MySQL Driver
  • Thymeleaf

1. Or you can Clone or Download the Repository

You can either clone the repository or download it as a ZIP file.

git clone https://github.com/ruturajjadhav07/Simple-CRUD-Spring-Application.git

2. Set Up the Database

Create a database in MySQL called springDB.

CREATE DATABASE springDB;

SQL Query for Database Creation

Before running the application, ensure that you have MySQL installed and create the database. Here's the SQL query to create the required clients table:

CREATE TABLE clients (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(255),
    last_name VARCHAR(255),
    email VARCHAR(255) UNIQUE NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

4. Build and Run the Application

mvn clean install
mvn spring-boot:run

5. Access the Application

http://localhost:8080/

Summary

This CRUD app is a great project for beginners to get hands-on experience with Spring Boot, JPA, and MySQL. It will help you understand the basic flow of a Spring Boot application, how to use Thymeleaf for rendering HTML, and how to interact with a MySQL database.

Feel free to extend the project, add more features, or improve the UI!

Happy coding!

Interface

landing page

Display data

Insert data

Edit data

Delete data