Try{
Con = java.sql.DriverManager.getConnection(dburl , dbUser , dbPass);
Con.setAutoCommit(false);
Stmt = con.createStatement();
Stmt.executeUpdate(“update account set monery=monery-1000 where name=’zhangsan’”);
stmt.executeUpdate(“update account set monery=monery+1000 where name=’lisi’”);
con.commit();
}catch(Exception ex){
ex.printStackTrace();
try{
con.rollback();
}catch(Exception e){
e.printStackTrace();
}
}finally{
try{
stmt.close();
con.close();
}catch(Exception e){
e.printStackTrace();
}
}