e代劍客——溫柔一刀

<% @?page?contentType = " text/html;charset=GB2312 " ? %>
<% @?page?import = " java.sql.* " ? %>
< head >
< title > 事務處理程序 </ title >
</ head >
< body >
< center >
< table? border ="1" ?width ="700" >
?? < tr >
???? < td? width ="100%" ?colspan ="2" ?align ="center" > 事務處理程序 </ td >
?? </ tr >
?? < tr >
???? < td? width ="100%" ?colspan ="2" >
<% // 事務處理
? String ?sqlString1 = " update?userTable?set?user_age=30?where?user_true_name?like?'鄧%' " ;
? String ?sqlString2 = " update?userTable?set?user_age=40?where?user_true_name?like?'張%' " ;
?Connection?con;
?Statement?sql;
?Class.forName( " com.microsoft.jdbc.sqlserver.SQLServerDriver " );
?con = DriverManager.getConnection( " jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabse " , " sa " , " 6599996 " );
?try?
???{?? // 設置不會自動提交
??????con.setAutoCommit( false );
??????sql = con.createStatement();
??????sql.executeUpdate(sqlString1);
??????sql.executeUpdate(sqlString2);
?????? // 提交事務
??????con.commit();
??????out.print( " 事務提交成功，執行兩條SQL語句。 " );
??????con.close();
????}
?catch(SQLException?e)?
????{? // 操作不成功，回滾事務
??????con.rollback();
??????out.print( " 事務操作不成功，事務已回滾！ " );
????}
%>
???? </ td >
?? </ tr >
?? </ table >
</ center >
</ body >
</ html >