Software in Java to control the buying and Selling of inventories.Helps in interaction between producer and consumer
The Prgramming Language used is Java .
For handling data it uses MySQL database.
###About this system### An Inventory Control System is an integrated package of software and hardware used in warehouse operation, and elsewhere, to monitor the quantity, location and status of inventory as well as the related shipping, receiving, picking and put away process. In common usage, the term may also refer to just the software components. The system will keep a log of the spares available and also be intelligent enough which spares have been taken from which supplier and in which quantity plus the amount of spares being sold to individual customer under what requirement. It will also indicate how many spares will be available for individual sectors and what should be the buying price so that we have a selling profit . Inventory Control System also include system to sell products and create bill. It include java source code, ODBC, MySQL .
Front End of this Application look like this
##MySQL database
Name of the database used is practise .
Item 1
Item 2
Item 3
Item 4
####Item1 table - It is related to storage of data of item that the company have
| S.NO. | Column Name | Data Type | Size | Key | NULL |
|---|---|---|---|---|---|
| 1 | item_code | Integer | 5 | YES | |
| 2 | item_name | Varchar | 20 | YES | |
| 3 | rate | Float | 13,2 | YES | |
| 4 | stock_in_hand | Integer | 7 | YES |
####Item2 table - It is related to storage of data of customers of company.
| S.NO. | Column Name | Data Type | Size | Key | NULL |
|---|---|---|---|---|---|
| 1 | customer_code | Integer | 5 | YES | |
| 2 | customer_name | Varchar | 25 | YES | |
| 3 | Address | Varchar | 30 | YES | |
| 4 | City | Varchar | 20 | YES | |
| 5 | State | Varchar | 20 | YES | |
| 6 | pin_no | Integer | 6 | YES | |
| 7 | phone_no | Integer | 15 | YES |
####Item3 table - It is related to storage of bill history of sold products.
| S.NO. | Column Name | Data Type | Size | Key | NULL |
|---|---|---|---|---|---|
| 1 | Billno | Integer | 6 | YES | |
| 2 | customer_type | Varchar | 8 | YES | |
| 3 | Name | Varchar | 25 | YES | |
| 4 | Date | Date | YES | ||
| 5 | item_code | Integer | 16 | YES | |
| 6 | item_name | Varchar | 15 | YES | |
| 7 | Quantity | Integer | 7 | YES | |
| 8 | Amount | Float | 13,2 | YES | |
| 9 | Discount | Float | 13,2 | YES | |
| 10 | Netamount | Float | 13,2 | YES |
####Item4 table - It is stores data of suppliers of company .
| S.NO. | Column Name | Data Type | Size | Key | NULL |
|---|---|---|---|---|---|
| 1 | supplier_code | Integer | 5 | YES | |
| 2 | supplier_name | Varchar | 25 | YES | |
| 3 | Address | Varchar | 30 | YES | |
| 4 | City | Varchar | 20 | YES | |
| 5 | State | Varchar | 25 | YES | |
| 6 | pin_no | Integer | 6 | YES | |
| 7 | phone_no | Integer | 15 | YES |
##Set up this project in your System
Open all the files in this repositry in your ide, i used Netbean IDE here.
Username and Password used by me are "root" and "netbean". So, edit this line of code according to your mysql username and password
Connection con = (Connection)DriverManager.getConnection("jdbc:mysql://localhost/practise","root","netbean");