This is an Inventory Management System built in the form of a GUI desktop application developed in Java using MySQL as its database. The GUI was designed using Swing and the database connectivity was managed using JDBC API.
This application can be used by any small to mid-sized stores to easily maintain and manage an inventory of all their-
Supports two user types:
[Admins have the ability to manage all other personnel.]
Default credentials for the connection to MySQL database is:
Incase your database uses a different username and password to connect, follow these steps:
lib
folder in the zip file that you downloaded.DBCredentials.xml
.entry
tags with values username
and password
from "root" to whatever username and password you are using. (Ln 12 and 13)
<properties>
<comment>Credentials for the database.</comment>
<entry key="username">root</entry>
<entry key="password">root</entry>
</properties>
root
and Password: root
.All the project dependencies are available in the lib
directory.
The login page takes in the credentials entered by the user and verifies with the database.
The landing page of the application after a successful login.
The products section allows the user to add, edit and delete products from the store's inventory.
This section allows the user to check the availability of every item.
Here, the user can manage and manipulate the record of all the suppliers associated with the store.
Allows user to add new customers or update/delete existing customers in the database.
This section is where users can sell a product and manage all the sales transactions. The user only needs to enter the customer and product code and the software will handle the rest, showing all the necessary details like available stock and selling price of the product.
This section is where users can view purchase logs and enter new purchase transactions. Similar to the sales section, this section only requires the user to enter the product code and the details that are already available in the database will immediately be displayed in the respective spaces.
This section is only available to ADMINISTRATORS. It allows them to view, add and delete any users.
Stores and shows the administrator a log of all the users that have previously logged in, including their login time and logout time.
The following are the technologies that have been used in the development of this project. All of them are free to use.
The ER diagram for the sample schema that has been used in the application.
The software code has been divided into four different packages:
Click here to skip directly to the source code.
This project is a work in progress and more features are yet to be added with new technologies.