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

Have Programming Question? Ask it here!
 
 
 


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


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
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 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
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
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
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
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
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
with out class - Java Beginners
with out class  can we write a program with out a class in core java?if yes,give example
how to handle action events in case of more than one JFrame
how to handle action events in case of more than one JFrame   I have... contains three java files namely 1. Engine.java 2. Snake.java 3. Gameoard.java when i... is not moving and i am not getting to point how to resolve this problem .. So
Use of <sql:transaction> tag of jstl
application that how to group queries and update operations by using <sql...;html> <HEAD> <TITLE>Using a Transaction with a JSP</TITLE>... are explaining how to use <sql:transaction> tag.  <sql
Transaction Management
Transaction Management  How are transactions managed in EJB
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><
Can JSP using apachi POI handle the very complicated JSP?
Can JSP using apachi POI handle the very complicated JSP?  Can the following jsp handle the very complicated excel: such as, multiple sheet, tree structure, with chart in the excell file, etc. <%@page import="java.io.*"%>
really need help on how to write this program plz some 1 help out. - Java Beginners
really need help on how to write this program plz some 1 help out.  i am confused here on what to write can some 1 help out here i dont quite understand how to code it so can some 1 help out. Part II Write, compile and execute
How can you handle form in Spring 3.2 MVC?
How can you handle form in Spring 3.2 MVC?  Hi, How can you handle... the How can you handle form in Spring 3.2 MVC?   Hi, This article.... For more please visit the How can you handle form in Spring 3.2 MVC
add tow numbers with out using arthamatic operaters
add tow numbers with out using arthamatic operaters  add tow numbers with out using arthamatic operaters
adding two numbers with out using any operator
adding two numbers with out using any operator  how to add two numbers with out using any operator   import java.math.*; class AddNumbers { public static void main(String[] args) { BigInteger num1=new
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
Java Swing code for zoom in and out
Java Swing code for zoom in and out  hi.......... I require a code in java swing for image zoom in and zoom out can u tell me how it can be done or what is the code plz help
Java Exception - Handle Exceptions in Java
and exception handling in Java. This tutorial is going to show you how to handle... Java Exception - Handle Exceptions in Java       What is Exception in Java? How
How to handle the list dynamically in struts inside logic:iterate tag
How to handle the list dynamically in struts inside logic:iterate tag  I am having following code in JSP <table> <tr> <logic:iterate name="loginForm" id="inutParams" property="inutParams" indexId="i"> <
Hibernate 4.0-nested transaction not suported
Hibernate 4.0-nested transaction not suported  how i do nested transaction using Hibernate 4, i know hibernate 4 does not support nested transaction. Is there any way to do nested transaction like inserting more than one record
Hibernate 4.0-nested transaction not suported
Hibernate 4.0-nested transaction not suported  how i do nested transaction using Hibernate 4, i know hibernate 4 does not support nested transaction. Is there any way to do nested transaction like inserting more than one record
MySQL BEGIN Transaction
MySQL BEGIN Transaction This example illustrates how to use the BEGIN keyword in a Transaction. In this example we create a table 'trans' with column 'id', 'item' and 'quantity'. Here in the query below we insert one row in the table
JAVA image zoom in/out - Framework
JAVA image zoom in/out  how to write function in java for image zoom in and zoom out using jFreeChart?  Hi Friend, Try the following... ("XYLine Chart using JFreeChart", "ID", "Marks", xyDataset
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
with out using scanner mul two matrices
with out using scanner mul two matrices  write a java program to multiply two matrices and print there result. note: don't use the scanner and the values is passed at run time....   import java.io.*; class
java code for print true if even and false if odd and print error if any float value with out using conditional and looping statement
java code for print true if even and false if odd and print error if any float value with out using conditional and looping statement  hi class Even{ public static void main(String[] arg){ int num=Integer.parseInt
How to handle traversing in CustomItem of J2ME in a mobile phone which does not support traversing?
How to handle traversing in CustomItem of J2ME in a mobile phone which does not support traversing?  Hi, How to handle traversing in CustomItem... application using J2ME - MIDP 2.0.In my application i draw the table using
Commiting and Rolling Back transaction
; } Rolling Back Transaction When you do any operation such as , SELECT, INSERT, DELETE, or UPDATE  in database then the transaction is committed after the execute update. This is default mode of transaction. To commit more than
Advertisements
 

 

 

DMCA.com