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.
-
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
-
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.sqland 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.javaand 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
Link to the pdf of the user manual, which explains how to use the application.
Felipe Villamizar
Project developed during the studies of software analysis and development technology at SENA