You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Star15 (15)You must be signed in to star a repository
About
Back-End to a Personal Full Stack Employee Management System Project, incorporating Spring Boot & MySQL for the Back-End and React for the Front-End. Project is now in full use at my local sports club.
I developed a RESTful API using Spring Boot and MySQL for the back-end, tested it with Postman, and integrated it into a React front-end using axios.
CREATE, READ, UPDATE and DELETE (CRUD) appliction.
This repository contains the back-end of a Full Stackpersonal project, which is responsible for storing employee information and is implemented using the Spring Boot Java Framework which serves as the web framework for the back-end.
This application allows users to view, add, remove, and edit individuals within their management system.
This project is now fully utilised by my community's sports club.
🎯Aims and Motivation
The main objective of this project was to create a thorough Full Stack Application using Spring Boot & MySQL as the back-end and React as the front-end.
Driven by an unwavering enthusiasm for learning and self-improvement, I dedicated my personal time to meticulously develop and refine this Full Stack Application.
⚙️Technologies, Requirements and Software Tools
Requirements listed below are for the front-end and back-end.
Programming and Scripting Languages
Java
JavaScript
HTML
CSS
JSON
Frameworks & Libraries
Spring Boot - Back-end
React - Front-end
Bootstrap - Front-end & Back-end
npm Requirements (React)
nmp axios
npm react-router-dom
Other Software Tools
MySQLWorkbench played a role where the back-end relied on this technology to store user information.
DataGrip was also used to support the back-end in storing user information.
Postman was used to test PUT, GET, POST and DELETE requests to the database.
✏️Design - Back-end
Back-end Technology Stack
Java served as the back-end programming language for the web application, while the Spring Boot framework was employed to facilitate its development and operation.
Spring Boot was utilised to create user models, which were subsequently employed to store employee information in the database. The user models were established using the Jakarta Persistence import and annotations, including @Entity, @Id, and @GeneratedValue. This approach facilitated the maintenance of the REST API, making it more manageable and easier to maintain in the long run.
MySQL Workbench and DataGrip were employed to store employee information. The back-end, developed with Spring Boot, was configured to connect with the database, while the front-end, built with React, was responsible for retrieving and displaying this information.
Spring Boot was additionally utilised to create custom exceptions, specifically designed for handling scenarios where the user ID was not found or encountered other exceptional conditions.
React & Spring Boot Summarisation Diagram
Postman and Testing Sceenshots
Postman was used as an API platform to design, build, test and iterate the RESTful API which was built using Spring Boot.
Requests were dealt in JSON and SQL.
GET Request (Normal Case)
GET Request (Exceptional Case)
The customer error handling implemented in the Spring Boot back-end works successfully, as evidenced by the appropriate handling of the situation where a user with an ID of 20 does not exist.
PUT Request (Normal Case)
DELETE Request (Exceptional Case)
POST Request (Normal Case)
Postman Summarisation Diagram
Application Screenshots
Home Page
Register User Page
View User Details Page
Edit User Page
About
Back-End to a Personal Full Stack Employee Management System Project, incorporating Spring Boot & MySQL for the Back-End and React for the Front-End. Project is now in full use at my local sports club.