Skip to content

Full-stack User Management System with Spring Boot, React & MySQL featuring OTP verification, login, password reset, role-based access, and Excel export with filters.

License

Notifications You must be signed in to change notification settings

AkashKobal/User-Management-System

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

🧑‍💼 User Management System

React Spring Boot MySQL License: MIT

A full-featured User Management System built using Spring Boot, React, MySQL, and JavaMailSender. The system supports user registration with email OTP verification, login, password reset, role-based access (Admin/User), and advanced features like exporting user data to Excel, sorting, and filtering.


🚀 Tech Stack

  • Frontend: React.js (with Axios, Bootstrap)
  • Backend: Spring Boot (Spring Security, JWT)
  • Database: MySQL
  • Email Service: JavaMailSender (SMTP)
  • Export: Apache POI for Excel export
  • Token Management: JWT (JSON Web Token)

🔐 Features

  • ✅ Register with OTP email verification
  • ✅ Login with secure JWT token
  • 🔁 Forgot Password with email OTP
  • 📤 Export user data to Excel
  • 🔍 Filter, sort, and search users
  • 🔑 Admin/User role segregation
  • 👤 User Profile management
  • 📊 Dashboard with charts

📸 Screenshots

Name Screenshot
🏠 Home Home
🔐 Login Login
📝 Register (Create User) Create User
🔑 Forgot Password Forgot Password
📧 Enter OTP Enter OTP
🔄 Verify OTP Verify OTP
📥 Export User Export User
🧑‍💼 Manage Users Manage User
🆙 Update User Update User
🔃 Sort User Sort User
📄 Profile Profile
🔁 Logout Logout
📊 Dashboard Dashboard

🛠️ Getting Started

Prerequisites

  • Node.js & npm
  • Java 17+
  • MySQL
  • Maven

1️⃣ Backend Setup

cd Backend
mvn clean install

Update application.properties with your DB credentials and SMTP details.

Run the Spring Boot App:

mvn spring-boot:run

2️⃣ Frontend Setup

cd frontend
npm install
npm start

📦 API Highlights

  • POST /api/auth/register
  • POST /api/auth/login
  • POST /api/auth/verify-email
  • POST /api/auth/forgot-password
  • GET /admin/get-all-users
  • GET /admin/export-excel

🙌 Acknowledgements

  • Spring Boot & Spring Security
  • React & Axios
  • Apache POI (Excel Export)
  • JWT Authentication
  • JavaMailSender for SMTP

📄 License

This project is open-source and free to use under the MIT License.

About

Full-stack User Management System with Spring Boot, React & MySQL featuring OTP verification, login, password reset, role-based access, and Excel export with filters.

Topics

Resources

License

Code of conduct

Security policy

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published