Transaction Management Tool
?Download as DOCX, PDF?
0 likes?93 views
This document describes a Java program that uses a transaction management tool to transfer money between bank accounts. The program gets input from the user for the source and destination account numbers and amount. It then uses JDBC to connect to an Oracle database, begins a transaction, withdraws money from one account and deposits it into another using a batch process, and then either commits or rolls back the transaction based on the results of executing the batch. Finally it closes the JDBC connections.
![Transaction Management Tool
package com.nt.batch;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.Statement;
importjava.util.Scanner;
publicclassTxMgmtDemo{
publicstaticvoidmain(String[] args) throwsException{
Connectioncon=null;
try{
//take inputfromuser
Scannersc=newScanner(System.in);
System.out.println("EnterSource Accountno:");
intsrcacno=sc.nextInt();
System.out.println("EnterDestination Accountno:");
intdestno=sc.nextInt();
System.out.println("Enterthe amounttodeposit:");
longamount=sc.nextInt();
//registerdriverandcreate connection
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","password");
//disable AutoCommitfirst....
con.setAutoCommit(false);//now commitof datainside database will be inourcontrol...
//create Statementobj](https://image.slidesharecdn.com/a760d29e-d42a-4310-81ce-3285debbe72d-151228140528/85/Transaction-Management-Tool-1-320.jpg)
![Statementst=con.createStatement();
//create batchprocess....
//towithdrawmoney
st.addBatch("update bank_accountsetbalance=balance-"+amount+"where
accno="+srcacno);
//fordepositmoney
st.addBatch("update bank_accountsetbalance=balance+"+amount+"where accno="+destno);
//execute BatchProcess
int[] result=st.executeBatch();
//processtransaction
booleanflag=true;
//processthe result...
for(inti=0;i<result.length;++i){
if(result[i]==0){
flag=false;
break;
}
}//for
//commitor rollbackthe txMgmt
if(flag==false){
con.rollback();
System.out.println("Moneynottransferred...");
}
else{
con.commit();
System.out.println("Moneytransferred...");
}//if](https://image.slidesharecdn.com/a760d29e-d42a-4310-81ce-3285debbe72d-151228140528/85/Transaction-Management-Tool-2-320.jpg)
Transaction Management Tool
- 1. Transaction Management Tool package com.nt.batch; importjava.sql.Connection; importjava.sql.DriverManager; importjava.sql.Statement; importjava.util.Scanner; publicclassTxMgmtDemo{ publicstaticvoidmain(String[] args) throwsException{ Connectioncon=null; try{ //take inputfromuser Scannersc=newScanner(System.in); System.out.println("EnterSource Accountno:"); intsrcacno=sc.nextInt(); System.out.println("EnterDestination Accountno:"); intdestno=sc.nextInt(); System.out.println("Enterthe amounttodeposit:"); longamount=sc.nextInt(); //registerdriverandcreate connection Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","password"); //disable AutoCommitfirst.... con.setAutoCommit(false);//now commitof datainside database will be inourcontrol... //create Statementobj
- 2. Statementst=con.createStatement(); //create batchprocess.... //towithdrawmoney st.addBatch("update bank_accountsetbalance=balance-"+amount+"where accno="+srcacno); //fordepositmoney st.addBatch("update bank_accountsetbalance=balance+"+amount+"where accno="+destno); //execute BatchProcess int[] result=st.executeBatch(); //processtransaction booleanflag=true; //processthe result... for(inti=0;i<result.length;++i){ if(result[i]==0){ flag=false; break; } }//for //commitor rollbackthe txMgmt if(flag==false){ con.rollback(); System.out.println("Moneynottransferred..."); } else{ con.commit(); System.out.println("Moneytransferred..."); }//if