Its a simple inventory system for record keeping of items purchased and available in different departments of a college. It can be used for inserting items, updating them also for searching items by name or faculty and to keep records of items purchased.When additional items are purchased, clicking on purchase button records that information with time and date of purchase and one can view it by clicking on purchase info button. Also on every purchase final number of quantity and latest unit price of the item purchased is updated in the item table and can be viewed by clicking on display button. It also has some other features you can check them out.
This inventory system uses mysql database and hence for its proper implementation one must have knowledge of its database and its design. Basically, it uses database with name practise, yes i know correct spelling is practice but still database name is practise :) and it has two tables named items and purchased_items.
Now I'm gonna give you a basic idea about the design of database you can follow this and set up your mysql database yourself, once you are done with that you can download the InventoryLogin save the file inside your projectsfile and open it with JRE u r using, netbeans in this case.
Note: you can assign suitable size to these yourself and also index_no is primary,auto increment and not null for both tables mentioned above.
THANK YOU GUYS If you need any help mail me at [email protected]