SQLhelper使用事务

SQL事务处理示例

最新推荐文章于 2024-06-10 11:42:11 发布

原创最新推荐文章于 2024-06-10 11:42:11 发布 · 2k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#string

sql 同时被 3 个专栏收录

64 篇文章

订阅专栏

ASP.NET

55 篇文章

订阅专栏

VB.NET

41 篇文章

订阅专栏

本文介绍了一个使用SQL Server进行事务处理的VB.NET示例代码。该示例演示了如何通过开始事务、执行SQL命令并在成功时提交或失败时回滚来确保数据操作的一致性和准确性。

1、声明连接myConnectString

2、开启事务BeginTransaction

3、执行时使用st

4、成功提交，失败回滚

Public function testshiwu()

Dim strSQL As String
Dim myConnectString As String = o.GetConn
Dim myConnection As New SqlConnection(myConnectString)
myConnection.Open()
Dim st As SqlTransaction = myConnection.BeginTransaction()
Try
'插入用户
strSQL = "Insert into EC_User(cUserID,cUserName,cPassword,cDepCode,badministrator,buse,bDel,cdyzm,cip,cdemo) "
strSQL += "values('test','test','test','01',0,0,0,'t','','')"
SqlHelper.ExecuteNonQuery(st, CommandType.Text, strSQL)
'更新用户
strSQL = "update ec_user set cusername='aaa' where cuserid='test' "
SqlHelper.ExecuteNonQuery(st, CommandType.Text, strSQL)
'再次插入用户，违反主键约束，事务回滚
strSQL = "Insert into EC_User(cUserID,cUserName,cPassword,cDepCode,badministrator,buse,bDel,cdyzm,cip,cdemo) "
strSQL += "values('test','test','test','01',0,0,0,'t','','')"
SqlHelper.ExecuteNonQuery(st, CommandType.Text, strSQL)

st.Commit()

return "success"

Catch ex As Exception
st.Rollback()
MsgBox(ex.Message, MsgBoxStyle.Critical, "发生错误")
Return ""
Finally
myConnection.Close()
End Try

End Sub