<script runat="server">
void Page_Load(Object sender, EventArgs e) {
OleDbConnection Conn=new OleDbConnection();
Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"+
"Data Source="+Server.MapPath("person.mdb");
Conn.Open();
OleDbCommand Comm = new OleDbCommand();
OleDbTransaction Trans;
Trans = Conn.BeginTransaction();
Comm.Connection = Conn;
Comm.Transaction = Trans;
try {
Comm.CommandText = "UPDATE grade SET 数学=100 WHERE 姓名 LIKE '%周%'";
Comm.ExecuteNonQuery();
Comm.CommandText = "UPDATE grade SET 数学=70 WHERE 姓名 LIKE '%张%'";
Comm.ExecuteNonQuery();
Trans.Commit();
Response.Write("事务执行成功!");
}
catch(Exception ex) {
Trans.Rollback();
Response.Write("出现错误,事务已经回滚!");
}
finally {
Conn.Close();
}
}
</script>
ASP.NET中的事务处理
最新推荐文章于 2024-09-21 16:56:47 发布