Skip to content

A simple CRUD application built with Spring Boot, Thymeleaf, and MySQL, demonstrating the basic operations of Create, Read, Update, and Delete. This project is perfect for beginners to understand how to interact with databases using Spring Data JPA and how to render data dynamically on the front end using Thymeleaf templates.

Notifications You must be signed in to change notification settings

ruturajjadhav07/Simple-CRUD-Spring-Application

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

image

Display data

image

Insert data

image

Edit data

image

Delete data

image

About

A simple CRUD application built with Spring Boot, Thymeleaf, and MySQL, demonstrating the basic operations of Create, Read, Update, and Delete. This project is perfect for beginners to understand how to interact with databases using Spring Data JPA and how to render data dynamically on the front end using Thymeleaf templates.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published