.Net 下数据库操作类库 一点学习和研究 实现类(二)

事务操作事例：

    CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
            try
            {                
                pComm.BeginTrans();
                pComm.Execute("delete from A53");
                pComm.Execute("delete from A70");
                pComm.Execute("delete from A71");
                pComm.Execute("asdasdddfasdd");
                pComm.CommitTrans();
                pComm.Close();
                MessageBox.Show("OK");
            }
            catch (Exception exc)
            {
                MessageBox.Show(exc.Message);
                pComm.RollbackTrans();
            }

调用的Execute 的定义如下：

public void Execute(String sql)
        {
            try
            {
                cmd.CommandText = sql;
                cmd.ExecuteNonQuery();
            }

            catch (Exception e)
            {
                throw e;
            }
        }

事务操作如下：

/**//// <summary>
/// 开始一个事务
/// </summary>
public void BeginTrans()
{
    trans = conn.BeginTransaction();
    cmd.Transaction = trans;
}

/**//// <summary>
        /// 提交一个事务
        /// </summary>
    public void CommitTrans()
        {
            trans.Commit();
        }

/**//// <summary>
        /// 回滚一个事务
        /// </summary>
    public void RollbackTrans()
        {
            trans.Rollback();
        }