Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Java in General and the fly likes How to handle Transaction IN and OUT in Inventory using Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "How to handle Transaction IN and OUT in Inventory using Java" Watch "How to handle Transaction IN and OUT in Inventory using Java" New topic
Author

How to handle Transaction IN and OUT in Inventory using Java

lisy jessica
Ranch Hand

Joined: Oct 27, 2010
Posts: 47
Hi Everyone,

I have an Inventory Database(Oracle 10g), where when the items are IN, we scan two times as we have two barcodes PartNo, SerialNo for each item. The scanned data is in .CSV file, Loaded to Oracle database using Oracle SQL Developer. The database table have 23 columns, including PartNo, SerialNo,Transaction_Status, Dt.of.Transaction, when i load the .CSV file to this table the Transaction_Status,Dt.of.Transaction,Inventory_Qty should be IN ,currentDate() and 100 automatically on load. This is the process for Transaction IN.

We scan the items again when the items are OUT, again same scan two times as we have two barcodes for each item, PartNo can be same for a series of SerialNo. When we scan 10 items for eg. i need to write a program to compare these scanned items in the database and just make Transaction_Status, Dt.of.Transaction,Inventory_Qty to OUT, watever dt.of.out transaction,90 respectively. This is the process of OUT Transaction.

And one more thing is Add New OUT Transaction, I have a jsp page where i have all the 23 fields to add to Database, for ex. 10 items with same PartNo and series of 10 SerialNo is scanned and OUT today, In this Add New OUT Transaction page if i key in all these values once, and click submit it should fill 10 fields in the database with one submit.

Now the problem is i have no idea how to do this in Java/J2EE. Please can anybody help me to do this or give me some skeleton structure would be great. Is this possible in java?? Please reply soon.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to handle Transaction IN and OUT in Inventory using Java