Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JSP-Servlet How to handle Transaction IN and OUT in Inventory using java
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


lissy
How to handle Transaction IN and OUT in Inventory using java
0 Answer(s)      3 years and 6 months ago
Posted in : JSP-Servlet


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,TransactionStatus, Dt.of.Transaction, when i load the .CSV file to this table the TransactionStatus,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 TransactionStatus, Dt.of.Transaction,InventoryQty 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.


Advertisement
View Answers

Related Tutorials/Questions & Answers:
How to handle Transaction IN and OUT in Inventory using java
How to handle Transaction IN and OUT in Inventory using java  Hi... 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
You handle your own transaction
You handle your own transaction  How do you handle your own transaction
Advertisements
Java transaction
Java transaction  How do you handle your own transaction
How to handle the text using Key Listener Interface
How to handle the text using Key Listener Interface       In this section, you will learn how to handle the text using the key events on the Java Awt component. All the key events
How does Java handle integer overflows and underflows?
How does Java handle integer overflows and underflows?   hi, How does Java handle integer overflows and underflows? Thanks
How do I handle the reaction of a circle and a semi-circle colliding in java?
How do I handle the reaction of a circle and a semi-circle colliding in java?  How do I handle the reaction of a circle and a semi-circle colliding in java
How to Handle Event Handlers?
How to Handle Event Handlers?  How to Handle Event Handlers
Java File - Learn how to handle files in Java with Examples and Tutorials
handling in Java. You will learn how to handle file in Java. Examples given here... programs. In real programming scenario developers are using Java File... in Java Reading files in Java How to read file in Java into byte
java exception handle
java exception handle  How error can be handled in the exception class?? can we handle fatal error in java
how to handle MySQLIntegrityConstraintViolationException?
how to handle MySQLIntegrityConstraintViolationException?  Cannot add or update a child row: a foreign key constraint fails (outerdb.outerpatient, CONSTRAINT outerpatient_ibfk_1 FOREIGN KEY (xrayno) REFERENCES xray (xrayno
ERP Inventory Management
ERP Inventory Management  ERP (Inventory Management module) Inventory Management module is sub divided into different modules as under Inventory Requisition. Inventory Order Assessment Inventory Placing. Supplier Performa
how to display duplicate elements with out using collection Frame work?
how to display duplicate elements with out using collection Frame work?  how to display duplicate elements with out using collection Frame work
Java User Transaction. - Java Beginners
Java User Transaction.  Hi Experts, Could you please guide me for writing a java program of File Handling using user transaction, also please tell me which jars do I need. Please give me a program for above mentioned
Java eft transaction
Java eft transaction  4.3 Problem Constraints The following... of a particular type (savings, current, credit). ? A transaction request.... In this case the transaction should be declined. Hint 1: When a Card Processor (the class
how to run java application with out stoping
how to run java application with out stoping  I have one java application to download some pdf file but its going to stop downloading after some time it not giving any errors any thing can any one help me to solve this problem
how to get data from list to map with out using a loop?
how to get data from list to map with out using a loop?  List list...("15"); how to get this data into map with out using a loop. i want this data like this--map.put(name,id); Is it possible to do without using loop
Transaction
as the TransactionProxyFactoryBean Using AOP in the same bean... just to explain it more: lets say we... the transaction so I need to use the TransactionProxyFactoryBean. My question is that can I use the advice as well as the spring provided transaction in the same person
Distributed transaction in java
-small; text-decoration: underline; } Distributed Transaction in java EE In distributed java enterprise application, transaction is processed...; Distributed Transaction in java EEIn the above diagram the client call
How to handle enter key in javascript
How to handle enter key in javascript  Can any one tell me how to handle the enter key event on a Button in HTML. Like in my simple HTML page i want to submit the form even if user hits the enter key from keyboard instead
Java User Transaction - Java Beginners
Java User Transaction  Hi, I am trying to do file handling through User Transaction, I would like to know that if server crashes while writing file... Operation and file handling both in one User Transaction with atomicity
How to use java.net.URLConnection to fire and handle HTTP requests?
How to use java.net.URLConnection to fire and handle HTTP requests?  How to use java.net.URLConnection to fire and handle HTTP requests
Reading xml file using dom parser in java with out using getelementby tag name
Reading xml file using dom parser in java with out using getelementby tag name  Hi, How to read the xml file using java with dom parser, but without using getelementbytag name, and also read the attribute values also. I had
Handle mail function using JSP & Servlet
Handle mail function using JSP & Servlet  Dear Sir, for my final year... appointment. I'm using JSP & Servlet and apache web server. I'm developing this using e-clips IDE. Please be kind to provide sample code for this requirement
HOW TO FIND OUT GPS COORDINATES WITHOUT USING ONLINE DATABASE OR OTHERTHING ON MOBILE
HOW TO FIND OUT GPS COORDINATES WITHOUT USING ONLINE DATABASE OR OTHERTHING ON MOBILE  Hello Sir,, Good Morning Actually i have been... which i have to display on any java supported devive i have learned only j2me so
HOW TO FIND OUT GPS COORDINATES WITHOUT USING ONLINE DATABASE OR OTHERTHING ON MOBILE
HOW TO FIND OUT GPS COORDINATES WITHOUT USING ONLINE DATABASE OR OTHERTHING ON MOBILE  Hello Sir,, Good Morning Actually i have been... which i have to display on any java supported devive i have learned only j2me so
HOW TO FIND OUT GPS COORDINATES WITHOUT USING ONLINE DATABASE OR OTHERTHING ON MOBILE
HOW TO FIND OUT GPS COORDINATES WITHOUT USING ONLINE DATABASE OR OTHERTHING ON MOBILE  Hello Sir,, Good Morning Actually i have been... which i have to display on any java supported devive i have learned only j2me so
inventory System of Medical Store
inventory System of Medical Store  I am an IT student n I want to develop a software based on Inventory System of sI am an IT student n I want to develop a software based on Inventory System of a Medical Store. Sir, Ma'am, could
inventory System of Medical Store
inventory System of Medical Store  I am an IT student n I want to develop a software based on Inventory System of sI am an IT student n I want to develop a software based on Inventory System of a Medical Store. Sir, Ma'am, could
inventory System of Medical Store
inventory System of Medical Store  I am an IT student n I want to develop a software based on Inventory System of sI am an IT student n I want to develop a software based on Inventory System of a Medical Store. Sir, Ma'am, could
inventory System of Medical Store
inventory System of Medical Store  I am an IT student n I want to develop a software based on Inventory System of sI am an IT student n I want to develop a software based on Inventory System of a Medical Store. Sir, Ma'am, could
JDBC Transaction Example
; } JDBC Transaction Example JDBC Transaction  JDBC transaction... successfully. When  you create a connection using JDBC, by default it is in auto-commit mode and  each SQL statement is treated as transaction
 

 

 

DMCA.com