MS SQL\u5b58\u50a8\u8fc7\u7a0b
\nCreate proc sp_join
\n@result int output,
\n@email nvarchar(30),
\n@username nvarchar(15)
\nAS<\/p>\n
— \u5f00\u59cb\u4e8b\u52a1
\nBegin Tran
\nINSERT INTO users(username, email) VALUES(@username, @email)
\nIF @@ERROR <> 0 GOTO back<\/p>\n
INSERT INTO register(username) VALUES(@userName)
\nIF @@ERROR <> 0 GOTO back<\/p>\n
\n— \u63d0\u4ea4\u4e8b\u52a1
\nSet @result = 1
\nCommit Tran
\nReturn<\/p>\n
\n— \u56de\u6eda\u4e8b\u52a1
\nback:
\nSet @result = 0
\nRollBack Tran
\nReturn<\/p>\n
\u6570\u636e\u5e93\u8fde\u63a5\u4ee3\u7801
\nSub Command(oCmd)
\nSet oCmd = Server.CreateObject("ADODB.Command")
\nEnd Sub<\/p>\n
Sub Connection(oConn)
\nSet oConn = Server.CreateObject("ADODB.Connection")
\noConn.Open "Provider=SQLOLEDB;Server=;User ID=;Password=;Database=;"
\nEnd Sub<\/p>\n
Sub Destroy(obj)
\nIf isObject(obj) Then Set obj = Nothing
\nEnd Sub<\/p>\n
ASP\u8c03\u7528\u4ee3\u7801
\nDim strEmail, strUserName
\nDim objCmd, objConn, intResult<\/p>\n
strEmail = Request.Form("email")
\nstrUserName = Request.Form("username")<\/p>\n
‘\u670d\u52a1\u5668\u7aef\u6570\u636e\u9a8c\u8bc1\uff08\u7565\uff09<\/p>\n
Command objCmd
\nConnection objConn<\/p>\n
With objCmd
\n.ActiveConnection = objConn
\n.CommandType = 4
\n.CommandText = "sp_join"
\n.Parameters.Refresh
\n.Parameters("@email") = strEmail
\n.Parameters("@username") = strUserName
\n.Execute
\nEnd With
\nintResult = objCmd.parameters("@result")<\/p>\n
Destroy objCmd
\nDestroy objConn<\/p>\n
If intResult = 0 Then
\nResponse.Write("\u6ce8\u518c\u5931\u8d25")
\nElse
\nResponse.Write("\u6ce8\u518c\u6210\u529f")
\nEnd If
\n <\/p>\n
\u8fd9\u662f\u4e00\u4e2a\u7b80\u5355\u7684\u4f8b\u5b50\uff0c\u5e0c\u671b\u80fd\u8d77\u5230\u629b\u7816\u5f15\u7389\u7684\u4f5c\u7528\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
MS SQL\u5b58\u50a8\u8fc7\u7a0b Create proc sp_join @result int output, @email nvarchar(30), @username nvarchar(15) AS — \u5f00\u59cb\u4e8b\u52a1 Begin Tra…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"topic":[],"class_list":["post-681","post","type-post","status-publish","format-standard","hentry","category-technology"],"_links":{"self":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/681","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/comments?post=681"}],"version-history":[{"count":1,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/681\/revisions"}],"predecessor-version":[{"id":66524,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/681\/revisions\/66524"}],"wp:attachment":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/media?parent=681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/categories?post=681"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/tags?post=681"},{"taxonomy":"topic","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/topic?post=681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}