Com+事务

原创

iteyer 2021-07-31 10:11:14 ©著作权

文章标签 autocomplete exception class insert table 文章分类 后端开发

©著作权归作者所有：来自51CTO博客作者iteyer的原创作品，请联系作者获取转载授权，否则将追究法律责任

1、手动提交

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.EnterpriseServices;

namespace prjEnterprise
{
    [Transaction(TransactionOption.Required)]
    public class clsES : System.EnterpriseServices.ServicedComponent
    {
        public SqlConnection Conn;

        public void dbAccess(int pID1, int nScore)
        {
            try
            {
                SqlConnection Conn = new SqlConnection("user id=sa;password=;Initial Catalog=myDataBase;Data Source=.;");
                Conn.Open();
                SqlCommand sqlCommand = new SqlCommand("UPDATE ComAction SET userScore = " + nScore + " WHERE userID = " + pID1, Conn);
                sqlCommand.ExecuteNonQuery();

                ContextUtil.SetComplete();
                Conn.Close();
            }
            catch (Exception e)
            {
                ContextUtil.SetAbort();

                throw e;
            }
            finally
            {

            }
        }
    }
}

2、自动提交

在数据记录部分为事务性操作，一条失败全部回滚。一上方法的缺点就不用说了，总之是个没头脑的方法，面向对象，应该申请课程相关的方法在课程类中实现，费用操作的方法在费用类中实现，应用层在一个申请课程的方法中调用相关类，但有个问题，如果面向对象则事务如何实现，要知道以上三条SQL语句应该是要不都成功如果有一句不成功应该全部回滚，那应该怎么实现看如下代码:

using System;
using System.Data;
using System.Data.OleDb;
using System.Collections;
using System.EnterpriseServices;
namespace test
{
/** <summary>
/// 客户类
/// </summary>
public class Client
{
//客户的申请选课方法
private void Apply()
{
//实例化过程类
MyCourse myCourse=new MyCourse();
//过程中加入一个课程类
   myCourse.Course.Add(new Elective());
   //过程中加入一个费用类
   myCourse.Course.Add(new Tuition());
   //实例化事务类
MyTransaction mTransaction=new MyTransaction();
   try
   {
   //用事务类的提交方法提交过程类，过程类中的任何方法异常将导致回滚
    mTransaction.MyCommit(myCourse);
   }
   catch(Exception e)
{
     Console.WriteLine(e.Message);
}
   }
}

/** <summary>
/// 费用类
/// </summary>
public class Tuition:Iwork
{
//实现费用相关的数据库操作
public void Working()
{
OleDbConnection oConn=new OleDbConnection("server=localhost");
oConn.Open();
OleDbCommand oCmd=new OleDbCommand();
oCmd.Connection=oConn;
oCmd.CommandText="insert into table1 values('test',1)";
oCmd.ExecuteNonQuery();
oCmd.CommandText="update table2 set ttt='test'";
oCmd.ExecuteNonQuery();
oConn.Close();
}
}
/** <summary>
/// 选课类
/// </summary>
public class Elective:Iwork
{
//实现选课相关的数据库操作
public void Working()
{
OleDbConnection oConn=new OleDbConnection("server=localhost");
oConn.Open();
OleDbCommand oCmd=new OleDbCommand();
oCmd.Connection=oConn;
oCmd.CommandText="insert into table3 values('test',10)";
oCmd.ExecuteNonQuery();
oConn.Close();
}
}

/** <summary>
/// 事务类
/// </summary>
[Transaction(TransactionOption.Required)]
public class MyTransaction:ServicedComponent
{
//提交方法，AutoComplete属性指定异常自动回滚
[AutoComplete]
public void MyCommit(MyCourse l_mCourse)
{
    l_mCourse.MyRuning();
}
}
/** <summary>
/// 过程类
/// </summary>
public class MyCourse
{
private ArrayList alCourse;
public MyCourse()
{
   alCourse=new ArrayList();
}
//保存代调用类
public ArrayList Course
   {
get
   {
     return alCourse;
}
}
//运行Course中类的Wroking方法
public void MyRuning()
{
   foreach(object o in alCourse)
{
    if(o is Iwork)
    {
    Iwork iw=(Iwork)o;
    iw.Working();
}
}
}
}
interface Iwork
{
void Working();
}
}