Inventory system

Description

Inventory management system developed in Java, MySQL and React. The system allows to keep track of items, stock, purchases, sales, suppliers and customers registered in the system, as well as the users that make use of the inventory.

Tech Stack

• Database

  • Engine: MySQL Community 8.0
  • Command line tool: MySQL Workbench 8.0 CE

• Backend

  • Java - JDK 17
  • Spring Boot 3.1.3
  • Maven 4.0.0
  • IDE: IntelliJ IDEA Community Edition 2023.2.2

• Frontend

  • Node ^18.10.0
  • React 18.2.0

Installation

• Database

  Open MySQL Workbench and create or select an instance. Then, Open a tab to run queries from the top bar, first option (Create a new SQL tab).

  Copy and paste the code found in the file database.sql and run it.

  And finally, copy and paste the code of each of the files that are located in the Database/procedures/ directory and execute them.

• Backend

  First, from the editor (IntelliJ IDEA) open the project Backend/. The editor will start configuring and installing the project.

  Once everything is configured and installed, go to the file BackendApplication.java and press the run button in the top bar.

• Frontend

  Locate yourself in the directory Frontend/

  Once inside, run the following command to install the dependencies:

  npm install

  Once the dependencies are installed, run the following command to start the application:

  npm start

User manual

Link to the pdf of the user manual, which explains how to use the application.

Author

Felipe Villamizar

Project developed during the studies of software analysis and development technology at SENA