6-08.aspx

来自「这是一个很好的基于数据库的系统」· ASPX 代码 · 共 32 行

<% @ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<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 数学=60 WHERE 姓名 LIKE '%张%'";
      Comm.ExecuteNonQuery();
      Trans.Commit();
      Response.Write("事务执行成功！");
    }
    catch(Exception ex)    {
      Trans.Rollback();
      Response.Write("出现错误，事务已经回滚！");
    }
    finally  {
      Conn.Close();
    }
}
</script>