DW中事务问题

来源：百度知道 编辑：UC知道 时间：2024/05/13 18:18:05
如何在以下代码中加入事务系统
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_bank_STRING
Command1.CommandText = "UPDATE dbo.银行客户账户管理表 SET 资金=资金+"&request.form("money")&" WHERE 账户="&request.form("id2")&""
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%>
<%

set Command2 = Server.CreateObject("ADODB.Command")
Command2.ActiveConnection = MM_bank_STRING
Command2.CommandText = "UPDATE dbo.银行客户账户管理表 SET 资金=资金-"&request.form("money")&" WHERE 账户="&request.form("id1")&""
Command2.CommandType = 1
Command2.CommandTimeout = 0
Command2.Prepared = true
Command2.Execute()

%>
要的就是将这两个语句合并到一个里来。本人水平所限，不懂如何做，请高手帮忙。

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_bank_STRING
conn.begintrans
Command1.CommandText = "UPDATE dbo.银行客户账户管理表 SET 资金=资金+"&request.form("money")&" WHERE 账户="&request.form("id2")&""
conn.committrans
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%>
<%

set Command2 = Server.CreateObject("ADODB.Command")
Command2.ActiveConnection = MM_bank_STRING
conn.begintrans
Command2.CommandText = "UPDATE dbo.银行客户账户管理表 SET 资金=资金-"&request.form("money")&" WHERE 账户="&request.form("id1")&""
conn.committrans
Command2.CommandType = 1
Command2.CommandTimeout = 0
Command2.Prepared = true
Command2.Execute()

%>
conn是连接的对象，添加事务后可以时提交完成后才执行事务确认操作生效,一般对多