Namespace DataProviderPublic Class DataProvider
'更新
Public Shared Function ExecNonQuery(ByVal cmd As SqlCommand) As IntegerTryIf cmd.Connection.State <> ConnectionState.Open Thencmd.Connection.Open()End IfReturn cmd.ExecuteNonQuery()
go()
Catch ex As Exception
Throw exFinallyIf cmd.Connection.State = ConnectionState.Open Thencmd.Connection.Close()End IfEnd Try
End Function
那为朋友 有时间的话 能帮我一句一句 解释出来 每一条语句的意思吗? 我只知道大概的意思 比如 Namespace DataProvider
(定义一个DataProbider的命名空间)
'更新
Public Shared Function ExecNonQuery(ByVal cmd As SqlCommand) As IntegerTryIf cmd.Connection.State <> ConnectionState.Open Thencmd.Connection.Open()End IfReturn cmd.ExecuteNonQuery()
go()
Catch ex As Exception
Throw exFinallyIf cmd.Connection.State = ConnectionState.Open Thencmd.Connection.Close()End IfEnd Try
End Function
那为朋友 有时间的话 能帮我一句一句 解释出来 每一条语句的意思吗? 我只知道大概的意思 比如 Namespace DataProvider
(定义一个DataProbider的命名空间)
Namespace DataProvider--类
Public Class DataProvider
--方法,参数sqlCommand类型,返回值Int类型
'更新
Public Shared Function ExecNonQuery(ByVal cmd As SqlCommand) As Integer
--尝试
Try--如果sqlcommand连接状态不等于 连接状态.打开 ,Then
If cmd.Connection.State <> ConnectionState.Open Then--连接打开
cmd.Connection.Open()--结束
End If--返回
Return cmd.ExecuteNonQuery()--??
go()--捕获异常ex为Exception类型
Catch ex As Exception
--抛出异常
Throw ex--无论是否异常
Finally
--如果连接状态为打开
If cmd.Connection.State = ConnectionState.Open Then
--关闭连接
cmd.Connection.Close()
--结束
End If--尝试结束
End Try
--方法结束
End Function
Namespace DataProvider '命名空间为DataProviderPublic Class DataProvider 'Public的名字为"DataProvider"的类
'更新
Public Shared Function ExecNonQuery(ByVal cmd As SqlCommand) As Integer
'Public的静态的方法,名字为ExecNonQuery(),参数类型为SqlCommand,返回值为整型
Try'捕捉异常-开始If cmd.Connection.State <> ConnectionState.Open Then '这个cmd是传进来的参数
'如果cmd的连接状态 不等于 打开 则cmd.Connection.Open()
'cmd打开
End IfReturn cmd.ExecuteNonQuery()'返回这个cmd执行ExecuteNonQuery后的值,类型为Integergo()
Catch ex As Exception'捕捉到了异常
Throw ex'抛出它Finally'无论是否捕捉到异常If cmd.Connection.State = ConnectionState.Open Then'同上cmd.Connection.Close()‘关闭End IfEnd Try'捕捉异常结束
End Function'方法结束
rtsp(自命不凡) 不胜感激