Skip to content

Latest commit

 

History

History
90 lines (72 loc) · 2.16 KB

README.md

File metadata and controls

90 lines (72 loc) · 2.16 KB

🚀 Spring Boot JPA CRUD Demo

A simple Spring Boot REST API for managing employees using Spring Boot, Spring Data JPA, and MySQL.

📌 Features

✅ Add a new employee
✅ Retrieve all employees
✅ Retrieve an employee by ID
✅ Update an employee’s details
✅ Delete an employee
✅ Filter employees by role and department

🛠️ Tech Stack

🔹 Java 17+
🔹 Spring Boot 3.x
🔹 Spring Data JPA
🔹 MySQL
🔹 Hibernate
🔹 Maven

⚙️ Setup & Installation

🔹 1. Clone the Repository

git clone https://github.com/Bothinath-B/SpringBootJPADemo.git
cd SpringBootJPADemo

🔹 2. Configure Database

Edit src/main/resources/application.properties:

spring.datasource.url=jdbc:mysql://localhost:3306/your_database_name
spring.datasource.username=your_username
spring.datasource.password=your_password

spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true

🔹 3. Build & Run

mvn clean install
mvn spring-boot:run

📌 API Endpoints

Method Endpoint Description
GET /getAllEmployee Get all employees
POST /setEmployee Add a new employee
GET /getEmpById/{id} Get employee by ID
PUT /updateEmp/{id} Update employee details
DELETE /removeEmp/{id} Delete an employee
GET /getEmpByRole/{role} Get employees by role
GET /getEmpByRoleAndDept?role=role&dept=dept Get employees by role and department

📂 Project Structure

SpringBootJPADemo
├── src/main/java/com/example/SpringBootJPADemo
│   ├── Controller
│   │   ├── EmployeeController.java
│   ├── Model
│   │   ├── Employee.java
│   ├── Repository
│   │   ├── EmployeeRepository.java
│   ├── Service
│   │   ├── EmployeeService.java
│   ├── SpringBootJpaDemoApplication.java
│
├── src/main/resources
│   ├── application.properties
│
├── pom.xml
└── README.md

🔥 Happy Coding! 🚀