This section is where users can sell a product and manage all the sales transactions. Here, the user can manage and manipulate the record of all the suppliers associated with the store.Īllows user to add new customers or update/delete existing customers in the database. This section allows the user to check the availability of every item. The products section allows the user to add, edit and delete products from the store's inventory. The landing page of the application after a successful login.

The login page takes in the credentials entered by the user and verifies with the database. You can log into the application using Username: root and Password: root.Īll the project dependencies are available in the lib directory. Once these credentials match, the JAR file should execute without any issues provided that you have the minimum JRE.

Simply change the values of the two entry tags with values username and password from 'root' to whatever username and password you are using.

Open the XML source file DBCredentials.xml.

Go to the lib folder in the zip file that you downloaded.

Incase your database uses a different username and password to connect, follow these steps: Import the SQL dump file using MySQL Workbench to locally create the sample schema and tables associated with this software.Īfter the inventory schema has been locally created, you can go ahead and run the JAR file (InventoryManagement.jar) included in the zip folder.ĭefault credentials for the connection to MySQL database is: How to download and run the software Minimum Requirements: JDK or JRE version 16.ĭownload and unzip the ZIP folder: InventoryManagement.zip Maintains a time log of all the users using the application. Users only need to enter the product code while making a sale and all the relevant details will be retrieved from the database automatically. Users can manage all sales and purchase transactions made by the store.Īny transaction made automatically handles the stock availability in the inventory.Įach section includes a search feature to make it easier for users to view the data they want to see. Users can manage inventory and stock of all the products available in their store. This application can be used by any small to mid-sized stores to easily maintain and manage an inventory of all their. The GUI was designed using Swing and the database connectivity was managed using JDBC API. This is an Inventory Management System built in the form of a GUI desktop application developed in Java using MySQL as its database.

Java inventory program