Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training  
 

How to handle Transaction IN and OUT in Inventory using java

Ads

 
 

Share on Google+Share on Google+

lissy
How to handle Transaction IN and OUT in Inventory using java
0 Answer(s)      6 years and 4 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.

Ads
View Answers
Ads









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
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
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
java exception handle
java exception handle  How error can be handled in the exception class?? can we handle fatal error in java
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 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
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
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
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
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
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
How to design a form using java?
How to design a form using java?  Please help in designing of form using java for my project
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
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
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
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 implement FTP using java
How to implement FTP using java  Hi, I am a B.tech student and I want to implement FTP using Java to transfer files and exchange files between FTP client and FTP server. Could anyone help me for How to implement FTP using java
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
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
calling java method from html form with out using javascript - JSP-Servlet
calling java method from html form with out using javascript  How can i call java method from a HTML form, java script should be disabled?  Hi <html><head><title>Test Input Validation</title><
How to merge two word document using java
How to merge two word document using java   how to merge two word document using java
How to open a file in java using JFileChooser
How to open a file in java using JFileChooser  How to open a file in java using JFileChooser