Free Inventory Management System

 

Inventory Management System

The Inventory Management System is a robust GUI desktop application crafted in Java, utilizing MySQL as its database backend. The graphical interface is built with Swing, and JDBC API seamlessly handles database connectivity. Tailored for small to mid-sized stores, the system efficiently oversees and organizes inventory details, including products, customers, suppliers, users, and transactions.

Key Features:

• Comprehensive Inventory Management:

  • Allows users to proficiently handle product inventory and stock levels.
  • Tracks all sales and purchase transactions, ensuring accurate record-keeping.

• User Types:

  • Administrator: Manages all aspects of the system, including personnel.
  • Employee: Performs day-to-day operations within defined limits.

• Automated Stock Management:

  • Transactions automatically update stock levels, maintaining accurate inventory records.

• Search Functionality:

  • Each section incorporates a search feature, facilitating quick and efficient data retrieval.

• Effortless Sales Transactions:

  • Users simply enter the product code during a sale, and the system retrieves all relevant details from the database.

• User Activity Logging:

  • Maintains a detailed time log of all users accessing the application.

Installation Steps:

• Minimum Requirements:

  • Ensure JDK or JRE version 16 is installed on the system.

• Download and Unzip:

  • Download and unzip the provided ZIP folder (InventoryManagement.zip).

• Database Setup:

  • Import the SQL dump file into MySQL Workbench to create the necessary schema and tables.

• Run the Application:

  • Execute the JAR file (InventoryManagement.jar) included in the zip folder.

• Database Credentials:

  • Default credentials:
    • Username: root
    • Password: root
  • Update credentials if needed by modifying the DBCredentials.xml file in the lib folder.

• Login Information:

  • Access the application using Username: root and Password: root.

• Dependencies:

  • Ensure all project dependencies are available in the lib directory.

Application Preview:

• Login Page:

• Dashboard/Welcome Page:

• Products:

  • The products section allows the user to add, edit, and delete products from the store's inventory.

• Current Stock:

  • This section allows the user to check the availability of every item.

• Suppliers:

  • Here, the user can manage and manipulate the record of all the suppliers associated with the store.

• Customers:

  • Allows the user to add new customers or update/delete existing customers in the database.

• Sales:

  • 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.

• Purchase:

  • 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.

• Users:

  • This section is only available to ADMINISTRATORS. It allows them to view, add, and delete any users.

• User Logs:

  • Stores and shows the administrator a log of all the users that have previously logged in, including their login time and logout time.

Technologies Used:

The following are the technologies that have been used in the development of this project. All of them are free to use.

• JetBrains IntelliJ IDE
• Apache NetBeans IDE (for the GUI designer)
• MySQL Server and Workbench
• JDK 16

ER Diagram:

The ER diagram for the sample schema that has been used in the application.