How to handle Transaction IN and OUT in Inventory using java
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.
View Answers
Related Tutorials/Questions & Answers:
Advertisements
java exception handlejava exception handle
How error can be handled in the exception class??
can we
handle fatal error in
java Handle mail function using JSP & ServletHandle 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 handle enter key in javascriptHow 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 run java application with out stopinghow 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
adding two numbers with out using any operatoradding 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
with out using scanner mul two matriceswith
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
ERP Inventory ManagementERP
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 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
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
Java User Transaction. - Java BeginnersJava 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
ModuleNotFoundError: No module named 'inventory' '
inventory'
How to remove the ModuleNotFoundError: No module named '
inventory' error?
Thanks
Hi,
In your python environment you...ModuleNotFoundError: No module named '
inventory' Hi,
My Python
ModuleNotFoundError: No module named 'inventory' '
inventory'
How to remove the ModuleNotFoundError: No module named '
inventory' error?
Thanks
Hi,
In your python environment you...ModuleNotFoundError: No module named '
inventory' Hi,
My Python
How to implement FTP using javaHow 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 how to open notepad using javahow to open notepad
using java Hi,
how to open notepad
using java?
I want to open windows notepad from
java program.
Thanks
Hi,
Use following code:
import java.util.*;
import java.io.*;
class Notepad {
public
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..._TO_REPLACE_1
Distributed
Transaction in
java EEIn the above
diagram
Java Swing code for zoom in and outJava 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 eft transactionJava 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
JAVA image zoom in/out - FrameworkJAVA 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