JAVA Inventory System Source Code

Inventory Management System Source Code Using JAVA NetBeans And MySQL Database

Java inventory management system project

In this Java project demo, we will demonstrate how to use our inventory management system developed with Java NetBeans and MySQL database.

Goals of this project:
- To provide students and curious individuals with an example they can learn from.
- To help people create their first project. 
- To share knowledge with others.

- Java programming language.
- netbeans IDE 8.2.
- MySQL database.
- for images.
- for colors.
- Text file to generate order.

Watch This Full Project Demo

Watch The Project Setup Tutorial

1 - Login Form

The login form allows both the administrator and other users to log in to the home form of the application.

java inventory system - login form

If the user enters the wrong username or password, a message will show up.

java inventory system - login form error

If everything is okay, clicking the login button will display the main/home form and close the login form.

2 - Home Form

if the user type is ADMIN a "User" tab will be visible on the top menu

java inventory system - admin home form

if the user type is USER the "User" tab will be invisible

java inventory system - user home form

3 - Product Section

when you click on the Product tab, the MANAGE_PRODUCTS_FORM will show up

java inventory system - manage products

- on the form load all products will be displayed into a jtable.

- when you enter a value in the search box and click search button, only the products that contain this value will be shown in the jtable.

java inventory system - search products

When you click on the 'Add New Product' button, the Add_Product_Form will appear, which allows you to enter the new product data and insert it into the MySQL database.

java inventory system - add new product

In the top form, you can see a combobox labeled 'categories'. The options in this combobox are populated from the 'category' table in the MySQL database, using a HashMap to map the category names to their respective IDs.

and if you want to update a product just select the product you want to edit from the jtable and click on the "Edit Selected Product" and the Edit_Product_Form will show up with all the selected product data displayed on the form. 

java inventory system - edit selected product

when you want to delete a product just select the product you want to remove and click on the "Remove Selected Product" button.

NOTE: when you Edit or Remove a product click on the "Refresh" button to see the updated results in the jtable..

4 - Category Section

now if you want to manage the categories you have to go to the category tab.
- when you click on the category tab the MANAGE_CATEGORIES_FORM will show up.

- you can insert a new category by just entering the name on the textfield and click the "Insert New Category" button.

- The MANAGE_CATEGORIES_FORM includes a jtable listing all categories by name and ID.

- if you select a category from the jtable : 1) the data of the selected category will be displayed on the textfields, 2) the products on the selected category will be displayed on a list. 

- also navigation buttons for next and previous .

java inventory system - manage categories

- when you click on "show full  products list in this category" button a a list ( in a form ) of all products in this category will be displayed"..

java inventory system - show products in a category

5 - Customer Section

in this section you can:

- see all the customers in database displayed on jtable.

- get the selected customer data from jtable and set it into jtextfields on jtable click.

- insert a new customer.

- update the selected customer data.

- delete the selected customer.

- navigate using "Next" & "Previous".

- clear all jtextfields text using the "clear" buttons.

- display the selected customer orders count.

- display the selected customer total orders amount.

- display the selected customer last order date.

java inventory system - manage customers

6 - Order Section

When you click on the 'Order' tab, the 'MANAGE_ORDERS_FORM' will show up, which contains:

- 1 'jTable' with all customers.

- 1 'jTable' for products (showing products depending on the selected category in the combobox).

- 1 'jTable' to display the products you want to add to the order .

java inventory system - manage orders

Watch A Full Order Section Demonstration

on the jtable for customers, if you select a row the customer id will be set into the jtextfield id.

Now, if you want to add products to the order, follow these steps:

1 - Select the category you want from the combobox.

2 - Click on the product you want to add, then click on the '>>>' button. Enter the quantity you want. Note that you cannot enter 0 or leave the box empty, and you cannot enter a quantity higher than what is available in the database.

java inventory system - quantity

java inventory system - quantity 0

java inventory system - unavailable quantity

If everything is okay, the selected product will be added to the order JTable with the quantity you want.

now lets add more products to the order table

java inventory system - add products to order

- in the jtable you can see a column "Quantity X Price" where we calculate the total price for this product.
- on the bottom you can see the total amount of all products.

java inventory system - order buttons

- The "Remove Product" button allows you to remove the selected product from the order table.
- The "Clear" button allows you to remove all products from the order table.

if all is good, click the "Insert Order" button to add the new order with the details into the database.

If you want to view all the orders, click on the 'Show All Orders' button, and the All_Orders_Form will appear with all the orders displayed in a jTable.

java inventory system - show all orders

when you click on "Print Selected Order" the selected order will be printed into a text file.

java inventory system - print order

7 - User Section

The last tab is for users, which is only accessible by the admin. When the user tab is clicked, the MANAGE_USERS_FORM will appear, displaying all users in a jtable.

- When you select a user from the JTable, all of their data will be populated into text fields, allowing you to edit or delete the information.

- And to add a new user, enter the user information and click on the 'Insert' button.
java inventory system - manage users

Share this

Related Posts

Next Post »


7 décembre 2018 à 00:05 delete

Hi there i already purchase this product but it's not working please help me.

12 janvier 2019 à 02:14 delete

Are the gui files (.form files) will be with the project ?

20 janvier 2019 à 11:18 delete Ce commentaire a été supprimé par l'auteur.
20 janvier 2019 à 11:31 delete

Is there another payment method, when I make a payment it returns by an error

8 mars 2019 à 11:05 delete

how can i modify the GUI after purchase there is no design view on these items how can i access design view ?

8 mars 2019 à 12:05 delete

you need to download the swing builder and add it to netbeans (if you are not already)

17 avril 2019 à 00:55 delete

Amaizing keep it up,,as an upcoming programer i find this helpful

1 juin 2019 à 07:25 delete

I am unable to have the program grab information from the database(ms access). I tried using the one in the folder, but I don't know what to do with a phpadmin dump file. Any way to help??

18 novembre 2019 à 02:58 delete

Hi, i can't get the files, how to do it?

18 novembre 2019 à 02:59 delete

Hi, i can't get the files, how to do it?

19 novembre 2019 à 19:36 delete

Hey! I bought your product! Simply amazing. Is helping me a lot to understand how does it work everything. As well it will help me for a project about UML diagrams and reverse engineering that I need to do. I question. How did you set up the filepath to print the voucher on TXT? Would you please help me how to do it? Thanks!

20 novembre 2019 à 01:55 delete

1 - go to "All_Orders_Form".
2 - in the button "jButton_PRINT_ORDER" you can find the filepath.
the filepath name is "OrderFile.txt"

28 mars 2020 à 16:32 delete

I need java code for inventory management system but not using should include inheritance, polymorphism, overriding methods, abstract classes,interfaces, exception handling,I/o fundamentals,nested classes, lambda expressions

4 août 2020 à 06:28 delete

1bestcsharp nothing FREE SOURCE any more :(

20 août 2020 à 01:21 delete

can i get the code???? look for as reference

16 septembre 2020 à 01:18 delete

I bought the Java inventory Source Code but after successful install and configuration on Netbeans, I run the project successfully but i am unable to Print Orders after inserting the Product

7 mars 2021 à 11:02 delete

Hi, I bought the java inventory application package. Unfortunately I lost the package, where can I retrieve my download?

26 avril 2021 à 17:09 delete

Please, i purchased source code, but i have problem in insert order, please help me

13 mai 2021 à 16:21 delete

Hi, I purchased the package, there is an in Manage_order_form. could you help me with fixing it?

5 août 2021 à 17:26 delete

I purchases the package, but there was no mysql-connector-java.5.1.48 in it. could you send me one?

6 août 2021 à 03:51 delete

hi, please contact me via sellfy

19 août 2022 à 23:08 delete

Website Development Agency In Patna Dynode Software is a group of expert architects with long periods of experience. We have, since 16 years been making quality applications for android, iOS and so on. We make site for business and do computerized advertising.