This Project Is Created Using: - java programming language. - netbeans ide 8.2. - mysql database. - canva.com for images. - flatuicolorpicker.com for colors. - text file to print order details.
what this java inventory system project can do: in this project if you login as an user with the user type user you can: in products tab: - add,edit,remove the selected product - display all products from mysql database into jtable. - search products. - refresh the jtable data.
in categories tab: - insert,update,delete selected category - show all categories from mysql database into jtable. - when you select a category from the jtable the products in this category will show up on a jlist - if you click on the "show full products list in this category" button a new form will show up with all products data in this category - navigate between categories using two buttons next and previous
in customers tab: - insert,update,delete selected customer - show all customer from mysql database into jtable. - navigate between customers using two buttons next and previous - button to clear all jtextfields - when you select a customer, 1) set the customer data into jtextfields, 2) get the customer number orders, 3) get the customer total orders amount, 4) get the customer last order date
in orders tab: - when the order from will show up you can see 3 jtable one for the customers, one for the products, and another for the products you want to add in the order - you can display products in jtable depending on the category you want using jcombobox - show all the orders - add the products you want to the order and select the quantity you want - remove the products you want from the order - clear the table order.
but if you login as an user with the user type admin you can a unique tab visible only for the admin, it's the user tab in users tab: - add,edit,remove the selected user