Home Java Textile Shop Inventory Management Using Java Mysql

Textile Shop Inventory Management Using Java Mysql

5 min read

This tutorial will teach you  to make a  Textile Shop Inventory  system. The following  system will use to manage the Textile Shop Inventory  system.

Batch No

The batch no is used to identify the shipping item.i described following table below. i explain clearly.

Batch Table


Product Table

Product IDProduct NameBatch NoQtyPrice

Above table is explained. Batch table consist of 3 colums batchno,batchname,createddate.consider you have purchased the item for the first item B001 it means batch 1 second time purchased  batch changed as B002 it means batch 2.it is very easy to identify the shipping items.when you sell item if you  enter the relavent product id. it will display the batches you will able to select your relavent  batch for the item.

Establish the database connection

we have created the database name “etextileshop

Add Records

you can use the following code snippet to add the records in to database. paste the code inside the save button

View Records

you can use the following code snippet to retrieve the data stored in the database and present it to users in a proper format. create a method batch_Load().paste the method inside the constructor of the class.when the form is loaded all the records will be shown on the jTable.

Form Constructor









Load More Related Articles
Load More By admin
Load More In Java

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also

Create Maven project in Intellij

In this tutorial will see how to create Maven project in Intellij step by step. First Step…