java 数据库 事务处理

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();

}

}