存储过程的例子

OriginalGriff:你怎么做，这将取决于你与你的密码:如果你存储为纯文本（非常糟糕），那么它是一个简单的比较，如果你存储加密的二进制信息（强烈建议），那么它是更为复杂。密码一般有一些意见:imgsrc=]
P.Salini

查看{A}{A2}{A3的}{A4纸}]
SwingSwis

由于据我理解你的问题，你想存储过程来验证用户名和密码转寄此:{A1}]
阿米尔Mahfoozi

其他的解决方案，除了记得储存您的密码加密，它没有必要的，但它会给你带来更多的安全这里是一个简单的例子:用户表codeprelang="sql"spanclass="code-keyword"CREATE/spanspanclass="code-keyword"TABLE/span[dbo].[spanclass="code-keyword"User/span]([ID][spanclass="code-keyword"int/span]spanclass="code-keyword"IDENTITY/span(spanclass="code-digit"1/span,spanclass="code-digit"1/span)spanclass="code-keyword"NOT/spanspanclass="code-keyword"NULL/span,[UserName][spanclass="code-keyword"varchar/span](spanclass="code-digit"50/span)spanclass="code-keyword"NOT/spanspanclass="code-keyword"NULL/span,[Pass][spanclass="code-keyword"image/span]spanclass="code-keyword"NULL/span,[FirstName][spanclass="code-keyword"varchar/span](spanclass="code-digit"50/span)spanclass="code-keyword"NULL/span,[LastName][spanclass="code-keyword"varchar/span](spanclass="code-digit"50/span)spanclass="code-keyword"NULL/span,spanclass="code-keyword"CONSTRAINT/span[PK_User]spanclass="code-keyword"PRIMARY/spanspanclass="code-keyword"KEY/spanspanclass="code-keyword"CLUSTERED/span([ID]spanclass="code-keyword"ASC/span)spanclass="code-keyword"WITH/span(PAD_INDEX=spanclass="code-keyword"OFF/span,STATISTICS_NORECOMPUTE=spanclass="code-keyword"OFF/span,IGNORE_DUP_KEY=spanclass="code-keyword"OFF/span,ALLOW_ROW_LOCKS=spanclass="code-keyword"ON/span,ALLOW_PAGE_LOCKS=spanclass="code-keyword"ON/span)spanclass="code-keyword"ON/span[spanclass="code-keyword"PRIMARY/span])spanclass="code-keyword"ON/span[spanclass="code-keyword"PRIMARY/span]TEXTIMAGE_ON[spanclass="code-keyword"PRIMARY/span]/pre/code和登录过程:{C}调用此过程后，请检查返回的行，如果没有结果，所以登录失败。时也使用HASHBYTES插入新用户或修改自己的密码。若要在您的NET代码HASHBYTES输出使用这个片段:codeprelang="cs"spanclass="code-keyword"public/spanspanclass="code-keyword"static/spanspanclass="code-keyword"byte/span[]HashString(spanclass="code-keyword"string/spaninput){System.Security.Cryptography.MD5CryptoServiceProvidercsp=spanclass="code-keyword"new/spanSystem.Security.Cryptography.MD5CryptoServiceProvider();spanclass="code-keyword"return/spancsp.ComputeHash(System.Text.Encoding.ASCII.GetBytes(input));}/pre/code希望它帮助