Skip to content

A payroll processing system developed using Java Spring Boot, Spring ORM, and MySQL. This system calculates employee salaries, deducts taxes, and generates pay stubs. It showcases the use of MVC architecture for financial calculations, data processing, and report generation.

Notifications You must be signed in to change notification settings

Divyanshu27k/Payroll_Processing_System

Repository files navigation

Payroll Processing System Project Overview This Payroll Processing System calculates employee salaries, applies tax deductions, and generates pay stubs. It demonstrates skills in financial calculations, data processing, and report generation using Java Spring Boot, Spring ORM, and MySQL in an MVC architecture.

Features Employee management (CRUD operations) Salary calculation with tax deductions Generate pay stubs Database integration (MySQL) Technologies Used Java Spring Boot Spring ORM MySQL JPA for persistence Setup Instructions Clone the repository: bash Copy code git clone https://github.com/divyanshu27k/payroll-processing-system.git Configure MySQL database in application.properties. Run the application using your IDE or the terminal: bash Copy code mvn spring-boot:run Database Tables sql Copy code CREATE TABLE Employee ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), role VARCHAR(50), department VARCHAR(50) );

CREATE TABLE Salary ( id INT AUTO_INCREMENT PRIMARY KEY, employee_id INT, gross_salary DECIMAL(10,2), tax DECIMAL(10,2), net_salary DECIMAL(10,2), FOREIGN KEY (employee_id) REFERENCES Employee(id) );

CREATE TABLE Tax ( id INT AUTO_INCREMENT PRIMARY KEY, tax_rate DECIMAL(4,2) ); Usage Access the employee and salary endpoints via: /employees (GET, POST, PUT, DELETE) /salaries (GET, POST) License MIT License.

About

A payroll processing system developed using Java Spring Boot, Spring ORM, and MySQL. This system calculates employee salaries, deducts taxes, and generates pay stubs. It showcases the use of MVC architecture for financial calculations, data processing, and report generation.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages