Inventory Control System

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 .

Tables used by this System

Item 1
Item 2
Item 3
Item 4

Structure of Table with their description

####Item1 table - It is related to storage of data of item that the company have

S.NO.	Column Name	Data Type	Size	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	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	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	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");

swapnil147 / inventory-control-system Goto Github PK