數(shù)據(jù)庫實驗報告七

1、3/3實驗七以銀行轉(zhuǎn)賬為例，用java程序在客戶端進行事務控制創(chuàng)建賬戶數(shù)據(jù)表：Acccount(AccountID,CHAR(6),Balance number(10,2)String str1=create table Acccount(AcccountID char(6),name varchar2(20),Balance number(10,2);stat.executeUpdate(str1);在賬戶表中輸入兩條記錄String str2=insert into Acccount values(000000,張三,1999);String str3=insert into Acccou

2、nt values(000001,李四,1888);stat.executeUpdate(str2);stat.executeUpdate(str3);實現(xiàn)兩個賬戶的轉(zhuǎn)賬操作String str4=update Acccount set balance=balance-1000 where AcccountID=000000;String str5=update Acccount set balance=balance+1000 where AcccountID=000001;stat.executeUpdate(str3);stat.executeUpdate(str4);在程序中設置代碼缺

3、陷，檢驗事務的原子性在本程序中000000賬戶和000001賬戶的兩個更新操作時一個整體要么都執(zhí)行要么都不執(zhí)行修改代碼只更新000001的賬戶運行結(jié)果顯示000001賬戶金額改變而000000賬戶的金額不發(fā)生變化所以驗證了事務的原子性Java程序代碼import java.sql.*;public class JDBCTest02 public static void main(String args) Connection con=null; Statement stat=null; try Class.forName(oracle.jdbc.driver.OracleDriver); co

4、n = DriverManager.getConnection(jdbc:oracle:thin:localhost:1521:xe,cyb,cyb); stat = con.createStatement(); String str1=create table Acccount(AcccountID char(6),name varchar2(20),Balance number(10,2); String str2=insert into Acccount values(000000,張三,1999); String str3=insert into Acccount values(000

5、001,李四,1888); String str4=update Acccount set balance=balance-1000 where AcccountID=000000; String str5=update Acccount set balance=balance+1000 where AcccountID=000001; stat.executeUpdate(str1); stat.executeUpdate(str2); stat.executeUpdate(str3); stat.executeUpdate(str4); stat.executeUpdate(str5); catch(ClassNotFoundException | SQLException e) e.StackTrace(); finally if(stat!=null) try stat.close(); catch (SQLException throwables) throwables.StackTrace(); i