利用DataSet部分功能实现网站登录

华尔街小趴菜 發表於 2023-8-25 00:00:00

<p>
首先，我之前必须完成过注册，并把个人信息存入数据库中。</p>
<p>
其次，这部分的个别对象是存于某些文档中的，需要引用命名空间。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_823567">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
<div class="line number16 index15 alt1">
16</div>
<div class="line number17 index16 alt2">
17</div>
<div class="line number18 index17 alt1">
18</div>
<div class="line number19 index18 alt2">
19</div>
<div class="line number20 index19 alt1">
20</div>
<div class="line number21 index20 alt2">
21</div>
<div class="line number22 index21 alt1">
22</div>
<div class="line number23 index22 alt2">
23</div>
<div class="line number24 index23 alt1">
24</div>
<div class="line number25 index24 alt2">
25</div>
<div class="line number26 index25 alt1">
26</div>
<div class="line number27 index26 alt2">
27</div>
<div class="line number28 index27 alt1">
28</div>
<div class="line number29 index28 alt2">
29</div>
<div class="line number30 index29 alt1">
30</div>
<div class="line number31 index30 alt2">
31</div>
<div class="line number32 index31 alt1">
32</div>
<div class="line number33 index32 alt2">
33</div>
<div class="line number34 index33 alt1">
34</div>
<div class="line number35 index34 alt2">
35</div>
<div class="line number36 index35 alt1">
36</div>
<div class="line number37 index36 alt2">
37</div>
<div class="line number38 index37 alt1">
38</div>
<div class="line number39 index38 alt2">
39</div>
<div class="line number40 index39 alt1">
40</div>
<div class="line number41 index40 alt2">
41</div>
<div class="line number42 index41 alt1">
42</div>
<div class="line number43 index42 alt2">
43</div>
<div class="line number44 index43 alt1">
44</div>
<div class="line number45 index44 alt2">
45</div>
<div class="line number46 index45 alt1">
46</div>
<div class="line number47 index46 alt2">
47</div>
<div class="line number48 index47 alt1">
48</div>
<div class="line number49 index48 alt2">
49</div>
<div class="line number50 index49 alt1">
50</div>
<div class="line number51 index50 alt2">
51</div>
<div class="line number52 index51 alt1">
52</div>
<div class="line number53 index52 alt2">
53</div>
<div class="line number54 index53 alt1">
54</div>
<div class="line number55 index54 alt2">
55</div>
<div class="line number56 index55 alt1">
56</div>
<div class="line number57 index56 alt2">
57</div>
<div class="line number58 index57 alt1">
58</div>
<div class="line number59 index58 alt2">
59</div>
<div class="line number60 index59 alt1">
60</div>
<div class="line number61 index60 alt2">
61</div>
<div class="line number62 index61 alt1">
62</div>
<div class="line number63 index62 alt2">
63</div>
<div class="line number64 index63 alt1">
64</div>
<div class="line number65 index64 alt2">
65</div>
<div class="line number66 index65 alt1">
66</div>
<div class="line number67 index66 alt2">
67</div>
<div class="line number68 index67 alt1">
68</div>
<div class="line number69 index68 alt2">
69</div>
<div class="line number70 index69 alt1">
70</div>
<div class="line number71 index70 alt2">
71</div>
<div class="line number72 index71 alt1">
72</div>
<div class="line number73 index72 alt2">
73</div>
<div class="line number74 index73 alt1">
74</div>
<div class="line number75 index74 alt2">
75</div>
<div class="line number76 index75 alt1">
76</div>
<div class="line number77 index76 alt2">
77</div>
<div class="line number78 index77 alt1">
78</div>
<div class="line number79 index78 alt2">
79</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">using System;</code>
</div>
<div class="line number2 index1 alt1">
<code class="sql plain">using System.Collections.Generic;</code>
</div>
<div class="line number3 index2 alt2">
<code class="sql plain">using System.Linq;</code>
</div>
<div class="line number4 index3 alt1">
<code class="sql plain">using System.Web;</code>
</div>
<div class="line number5 index4 alt2">
<code class="sql plain">using System.Web.UI;</code>
</div>
<div class="line number6 index5 alt1">
<code class="sql plain">using System.Web.UI.WebControls;</code>
</div>
<div class="line number7 index6 alt2">
<code class="sql plain">using ZG.Common;//后面用到ScriptHelper对象（ScriptHelper.cs是自己编写的cs文件）</code>
</div>
<div class="line number8 index7 alt1">
<code class="sql plain">using System.Data;//后面用到dataset</code>
</div>
<div class="line number9 index8 alt2">
<code class="sql plain">namespace WebApplication</code>
</div>
<div class="line number10 index9 alt1">
<code class="sql plain">{</code>
</div>
<div class="line number11 index10 alt2">
<code class="sql spaces"> </code><code class="sql keyword">public</code> <code class="sql keyword">partial</code> <code class="sql plain">class Login : System.Web.UI.Page</code>
</div>
<div class="line number12 index11 alt1">
<code class="sql spaces"> </code><code class="sql plain">{</code>
</div>
<div class="line number13 index12 alt2">
<code class="sql spaces"> </code><code class="sql plain">protected void Page_Load(object sender, EventArgs e)</code>
</div>
<div class="line number14 index13 alt1">
<code class="sql spaces"> </code><code class="sql plain">{</code>
</div>
<div class="line number15 index14 alt2">
<code class="sql plain">}</code>
</div>
<div class="line number16 index15 alt1">
<code class="sql plain">/// <summary></code>
</div>
<div class="line number17 index16 alt2">
<code class="sql spaces"> </code><code class="sql plain">/// 登录按钮</code>
</div>
<div class="line number18 index17 alt1">
<code class="sql plain">/// </summary></code>
</div>
<div class="line number19 index18 alt2">
<code class="sql spaces"> </code><code class="sql plain">/// <param </code><code class="sql keyword">name</code><code class="sql plain">=</code><code class="sql string">"sender"</code><code class="sql plain">></param></code>
</div>
<div class="line number20 index19 alt1">
<code class="sql spaces"> </code><code class="sql plain">/// <param </code><code class="sql keyword">name</code><code class="sql plain">=</code><code class="sql string">"e"</code><code class="sql plain">></param></code>
</div>
<div class="line number21 index20 alt2">
<code class="sql plain">protected void btnLogin_Click(object sender, EventArgs e)</code>
</div>
<div class="line number22 index21 alt1">
<code class="sql spaces"> </code><code class="sql plain">{</code>
</div>
<div class="line number23 index22 alt2">
<code class="sql plain">//用户表 Sys_User 列PersonStatus 为 “正常” 才可登录不然提示账户状态为PersonStatus内的内容</code>
</div>
<div class="line number24 index23 alt1">
<code class="sql plain">//列PersonCode为用户名 </code><code class="sql keyword">PassWord</code><code class="sql plain">为密码</code>
</div>
<div class="line number25 index24 alt2">
<code class="sql plain">//数据库中</code><code class="sql keyword">PassWord</code><code class="sql plain">保存的为加密后的字符串.Ext_DecryptString();为解密 Ext_EncryptString();为加密</code>
</div>
<div class="line number26 index25 alt1">
<code class="sql plain">string userName = txtUserName.Text.Trim();//.Trim()是去掉字符串前后的空字符</code>
</div>
<div class="line number27 index26 alt2">
<code class="sql plain">string </code><code class="sql keyword">passWord</code> <code class="sql plain">= txtPwd.Text.Trim();</code>
</div>
<div class="line number28 index27 alt1">
<code class="sql plain">//.Ext_IsNullOrEmpty()是在另一个文件中自己编写的函数，用于判断字符串是否为空字符（也可用userName==“”等判断）</code>
</div>
<div class="line number29 index28 alt2">
<code class="sql plain">if (userName.Ext_IsNullOrEmpty())</code>
</div>
<div class="line number30 index29 alt1">
<code class="sql spaces"> </code><code class="sql plain">{</code>
</div>
<div class="line number31 index30 alt2">
<code class="sql spaces"> </code><code class="sql plain">ScriptHelper.ShowAlertScript(</code><code class="sql string">"请输入用户名！"</code><code class="sql plain">);//弹出窗体提示</code>
</div>
<div class="line number32 index31 alt1">
<code class="sql keyword">return</code><code class="sql plain">;</code>
</div>
<div class="line number33 index32 alt2">
<code class="sql spaces"> </code><code class="sql plain">}</code>
</div>
<div class="line number34 index33 alt1">
<code class="sql plain">if (</code><code class="sql keyword">passWord</code><code class="sql plain">.Ext_IsNullOrEmpty())</code>
</div>
<div class="line number35 index34 alt2">
<code class="sql spaces"> </code><code class="sql plain">{</code>
</div>
<div class="line number36 index35 alt1">
<code class="sql spaces"> </code><code class="sql plain">ScriptHelper.ShowAlertScript(</code><code class="sql string">"请输入密码！"</code><code class="sql plain">);</code>
</div>
<div class="line number37 index36 alt2">
<code class="sql keyword">return</code><code class="sql plain">;</code>
</div>
<div class="line number38 index37 alt1">
<code class="sql spaces"> </code><code class="sql plain">}</code>
</div>
<div class="line number39 index38 alt2">
<code class="sql plain">//在Sys_User 表中筛选出用户名为userName的数据数量，如果为0表示没有该用户，为1表示有。</code>
</div>
<div class="line number40 index39 alt1">
<code class="sql plain">DataSet ds = SqlHelper.GetData(</code><code class="sql string">"select count(*) from Sys_User where PersonCode='"</code> <code class="sql plain">+ userName+ </code><code class="sql string">"'"</code><code class="sql plain">);</code>
</div>
<div class="line number41 index40 alt2">
<code class="sql spaces"> </code><code class="sql plain">if (ds.Tables.</code><code class="sql keyword">Rows</code><code class="sql plain">.ToString() != </code><code class="sql string">"1"</code><code class="sql plain">)</code>
</div>
<div class="line number42 index41 alt1">
<code class="sql spaces"> </code><code class="sql plain">{</code>
</div>
<div class="line number43 index42 alt2">
<code class="sql spaces"> </code><code class="sql plain">ScriptHelper.ShowAlertScript(</code><code class="sql string">"用户名不存在！"</code><code class="sql plain">);</code>
</div>
<div class="line number44 index43 alt1">
<code class="sql keyword">return</code><code class="sql plain">;</code>
</div>
<div class="line number45 index44 alt2">
<code class="sql spaces"> </code><code class="sql plain">}</code>
</div>
<div class="line number46 index45 alt1">
<code class="sql plain">//在Sys_User 表中筛选出用户名为userName的PersonStatus 值。</code>
</div>
<div class="line number47 index46 alt2">
<code class="sql plain">DataSet dsStatus = SqlHelper.GetData(</code><code class="sql string">"select PersonStatus from Sys_User where PersonCode='"</code> <code class="sql plain">+ userName + </code><code class="sql string">"'"</code><code class="sql plain">);</code>
</div>
<div class="line number48 index47 alt1">
<code class="sql plain">//取出dsStatus（小数据库）中（）第一张表的第一行中名为PersonStatus的列的值</code>
</div>
<div class="line number49 index48 alt2">
<code class="sql plain">string personStatus = dsStatus.Tables.</code><code class="sql keyword">Rows</code><code class="sql plain">[</code><code class="sql string">"PersonStatus"</code><code class="sql plain">].ToString();</code>
</div>
<div class="line number50 index49 alt1">
<code class="sql spaces"> </code><code class="sql plain">if (personStatus != </code><code class="sql string">"正常"</code><code class="sql plain">)</code>
</div>
<div class="line number51 index50 alt2">
<code class="sql spaces"> </code><code class="sql plain">{</code>
</div>
<div class="line number52 index51 alt1">
<code class="sql plain">ScriptHelper.ShowAlertScript(</code><code class="sql string">"用户状态不正确："</code> <code class="sql plain">+ personStatus);</code>
</div>
<div class="line number53 index52 alt2">
<code class="sql spaces"> </code><code class="sql keyword">return</code><code class="sql plain">;</code>
</div>
<div class="line number54 index53 alt1">
<code class="sql spaces"> </code><code class="sql plain">}</code>
</div>
<div class="line number55 index54 alt2">
<code class="sql plain">//注意密码的加密，空字符加密后便不是空字符了。数据库中的密码是加密后的字符，实际比较中需要用实际输入字符经加密得到的字符与数据库中的比较</code>
</div>
<div class="line number56 index55 alt1">
<code class="sql plain">//判断密码法一</code>
</div>
<div class="line number57 index56 alt2">
<code class="sql spaces">      </code><code class="sql plain">//string sql = </code><code class="sql string">"select * from Sys_User where PersonCode='{0}' and Password='{1}'"</code><code class="sql plain">;</code>
</div>
<div class="line number58 index57 alt1">
<code class="sql spaces">      </code><code class="sql plain">//DataSet dsUser = SqlHelper.GetData(string.Format(sql, userName, </code><code class="sql keyword">passWord</code><code class="sql plain">.Ext_EncryptString()));</code>
</div>
<div class="line number59 index58 alt2">
<code class="sql spaces">      </code><code class="sql plain">//if (dsUser.Tables.</code><code class="sql keyword">Rows</code><code class="sql plain">.</code><code class="sql color2">Count</code><code class="sql plain">!=1)</code>
</div>
<div class="line number60 index59 alt1">
<code class="sql spaces">      </code><code class="sql plain">//{</code>
</div>
<div class="line number61 index60 alt2">
<code class="sql spaces">      </code><code class="sql plain">// ScriptHelper.ShowAlertScript(</code><code class="sql string">"密码不正确！"</code><code class="sql plain">);</code>
</div>
<div class="line number62 index61 alt1">
<code class="sql spaces">      </code><code class="sql plain">// </code><code class="sql keyword">return</code><code class="sql plain">;</code>
</div>
<div class="line number63 index62 alt2">
<code class="sql spaces">      </code><code class="sql plain">//}</code>
</div>
<div class="line number64 index63 alt1">
<code class="sql plain">//判断密码法二</code>
</div>
<div class="line number65 index64 alt2">
<code class="sql spaces">      </code><code class="sql plain">string sql = </code><code class="sql string">"select * from Sys_User where PersonCode='{0}' "</code><code class="sql plain">;</code>
</div>
<div class="line number66 index65 alt1">
<code class="sql spaces">      </code><code class="sql plain">DataSet dsUser = SqlHelper.GetData(string.Format(sql, userName));</code>
</div>
<div class="line number67 index66 alt2">
<code class="sql spaces">      </code><code class="sql plain">if (dsUser.Tables.</code><code class="sql keyword">Rows</code><code class="sql plain">[</code><code class="sql string">"PassWord"</code><code class="sql plain">].ToString() != </code><code class="sql keyword">passWord</code><code class="sql plain">.Ext_EncryptString())</code>
</div>
<div class="line number68 index67 alt1">
<code class="sql spaces">      </code><code class="sql plain">{</code>
</div>
<div class="line number69 index68 alt2">
<code class="sql spaces">        </code><code class="sql plain">ScriptHelper.ShowAlertScript(</code><code class="sql string">"密码不正确！"</code><code class="sql plain">);</code>
</div>
<div class="line number70 index69 alt1">
<code class="sql spaces">        </code><code class="sql keyword">return</code><code class="sql plain">;</code>
</div>
<div class="line number71 index70 alt2">
<code class="sql spaces">      </code><code class="sql plain">}</code>
</div>
<div class="line number72 index71 alt1">
<code class="sql plain">Session[</code><code class="sql string">"UserName"</code><code class="sql plain">] = dsUser.Tables.</code><code class="sql keyword">Rows</code><code class="sql plain">[</code><code class="sql string">"PersonCode"</code><code class="sql plain">].ToString();</code>
</div>
<div class="line number73 index72 alt2">
<code class="sql spaces"> </code><code class="sql plain">Session[</code><code class="sql string">"LoginUser"</code><code class="sql plain">] = dsUser.Tables.</code><code class="sql keyword">Rows</code><code class="sql plain">[</code><code class="sql string">"PersonName"</code><code class="sql plain">].ToString();</code>
</div>
<div class="line number74 index73 alt1">
<code class="sql spaces"> </code><code class="sql plain">Session[</code><code class="sql string">"UserID"</code><code class="sql plain">] = dsUser.Tables.</code><code class="sql keyword">Rows</code><code class="sql plain">[</code><code class="sql string">"ItemID"</code><code class="sql plain">].ToString();</code>
</div>
<div class="line number75 index74 alt2">
<code class="sql spaces"> </code><code class="sql plain">//如果登录成功跳转到首页</code>
</div>
<div class="line number76 index75 alt1">
<code class="sql plain">Response.Redirect(</code><code class="sql string">"index.aspx"</code><code class="sql plain">);</code>
</div>
<div class="line number77 index76 alt2">
<code class="sql spaces"> </code><code class="sql plain">}</code>
</div>
<div class="line number78 index77 alt1">
<code class="sql spaces"> </code><code class="sql plain">}</code>
</div>
<div class="line number79 index78 alt2">
<code class="sql plain">}</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
以上所述是小编给大家介绍的利用DataSet部分功能实现网站登录，希望对大家有所帮助，如果大家有任何疑问欢迎给我留言，小编会及时回复大家的！</p>
<p>
原文链接：http://www.cnblogs.com/tangxx1996/archive/2017/05/29/6919293.html</p>

頁: [1]

琼殿技术论坛's Archiver

利用DataSet部分功能实现网站登录