当前位置：Gxlcms > 数据库问题 > ASP.net+SQL server2008简单的数据库增删改查 VS2012

ASP.net+SQL server2008简单的数据库增删改查 VS2012

时间：2021-07-01 10:21:17 帮助过：12人阅读

using System; 2 using System.Collections.Generic; 3 using System.Linq; 4 using System.Web; 5 using System.Data.SqlClient; 6 7 /// <summary> 8 /// DBHelper 的摘要说明 9 /// </summary> 10 namespace testDAO.Library 11 { 12 public class DBHelper 13 {//server=.;Trusted_Connection=SSPI;database=easylife 14 private String connectionString = "server=.;database=easylife;uid=sa;pwd=root"; 15 16 public SqlDataReader ExecuteReader(String sql) 17 { 18 SqlConnection connection = new SqlConnection(connectionString); 19 connection.Open(); 20 21 SqlCommand command = new SqlCommand(sql,connection); 22 23 SqlDataReader result = command.ExecuteReader(); 24 25 return result; 26 } 27 28 public bool ExecuteCommand(String sql) 29 { 30 bool result = false; 31 32 try 33 { 34 SqlConnection connection = new SqlConnection(connectionString); 35 connection.Open(); 36 37 SqlCommand command = new SqlCommand(sql,connection); 38 //command.Connection = connection; 39 //command.CommandText = sql; 40 command.ExecuteNonQuery(); 41 42 43 connection.Close(); 44 45 result = true; 46 } 47 catch (Exception e) 48 { 49 throw e; 50 } 51 52 return result; 53 } 54 55 } 56 }

定义User类封装用户信息  User.cs

  1. <span style="color: #0000ff;">using</span><span style="color: #000000;"> System;
  2. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Collections.Generic;
  3. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Linq;
  4. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Web;
  5. </span><span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span>
  6. <span style="color: #808080;">///</span><span style="color: #008000;"> User 的摘要说明
  7. </span><span style="color: #808080;">///</span> <span style="color: #808080;"></summary></span>
  8. <span style="color: #0000ff;">namespace</span><span style="color: #000000;"> testDAO.Library
  9. {
  10.     </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> User
  11.     {
  12.         </span><span style="color: #0000ff;">private</span> String userName = <span style="color: #800000;">""</span><span style="color: #000000;">;
  13.         </span><span style="color: #0000ff;">private</span> String userLogin = <span style="color: #800000;">""</span><span style="color: #000000;">;
  14.         </span><span style="color: #0000ff;">private</span> String userPwd = <span style="color: #800000;">""</span><span style="color: #000000;">;
  15.         </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> String UserName
  16.         {
  17.             </span><span style="color: #0000ff;">get</span><span style="color: #000000;">
  18.             {
  19.                 </span><span style="color: #0000ff;">return</span><span style="color: #000000;"> userName;
  20.             }
  21.             </span><span style="color: #0000ff;">set</span><span style="color: #000000;">
  22.             {
  23.                 userName </span>=<span style="color: #000000;"> value;
  24.             }
  25.         }
  26.         </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> String UserLogin
  27.         {
  28.             </span><span style="color: #0000ff;">get</span><span style="color: #000000;">
  29.             {
  30.                 </span><span style="color: #0000ff;">return</span><span style="color: #000000;"> userLogin;
  31.             }
  32.             </span><span style="color: #0000ff;">set</span><span style="color: #000000;">
  33.             {
  34.                 userLogin </span>=<span style="color: #000000;"> value;
  35.             }
  36.         }
  37.         </span><span style="color: #0000ff;">public</span><span style="color: #000000;"> String UserPwd
  38.         {
  39.             </span><span style="color: #0000ff;">get</span><span style="color: #000000;">
  40.             {
  41.                 </span><span style="color: #0000ff;">return</span><span style="color: #000000;"> userPwd;
  42.             }
  43.             </span><span style="color: #0000ff;">set</span><span style="color: #000000;">
  44.             {
  45.                 userPwd </span>=<span style="color: #000000;"> value;
  46.             }
  47.         }
  48.     }
  49. }</span>

 

 采用UserService实现将用户信息的数据库操作 UserService.cs

  1. <span style="color: #008080;">  1</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System;
  2. </span><span style="color: #008080;">  2</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Collections.Generic;
  3. </span><span style="color: #008080;">  3</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Linq;
  4. </span><span style="color: #008080;">  4</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Web;
  5. </span><span style="color: #008080;">  5</span> 
  6. <span style="color: #008080;">  6</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Data.SqlClient;
  7. </span><span style="color: #008080;">  7</span> <span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span>
  8. <span style="color: #008080;">  8</span> <span style="color: #808080;">///</span><span style="color: #008000;"> UserService 的摘要说明
  9. </span><span style="color: #008080;">  9</span> <span style="color: #808080;">///</span> <span style="color: #808080;"></summary></span>
  10. <span style="color: #008080;"> 10</span> <span style="color: #0000ff;">namespace</span><span style="color: #000000;"> testDAO.Library
  11. </span><span style="color: #008080;"> 11</span> <span style="color: #000000;">{
  12. </span><span style="color: #008080;"> 12</span>     <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> UserService
  13. </span><span style="color: #008080;"> 13</span> <span style="color: #000000;">    {
  14. </span><span style="color: #008080;"> 14</span>         <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">bool</span><span style="color: #000000;"> AddUser(User user)
  15. </span><span style="color: #008080;"> 15</span> <span style="color: #000000;">        {
  16. </span><span style="color: #008080;"> 16</span>             <span style="color: #0000ff;">bool</span> result = <span style="color: #0000ff;">false</span><span style="color: #000000;">;
  17. </span><span style="color: #008080;"> 17</span>             String sql = <span style="color: #800000;">""</span><span style="color: #000000;">;
  18. </span><span style="color: #008080;"> 18</span> 
  19. <span style="color: #008080;"> 19</span>             sql = <span style="color: #800000;">"</span><span style="color: #800000;">insert into table_user (userName,userLogin,userPwd)values(</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  20. </span><span style="color: #008080;"> 20</span>             sql += <span style="color: #800000;">"</span><span style="color: #800000;">‘</span><span style="color: #800000;">"</span> + user.UserName + <span style="color: #800000;">"</span><span style="color: #800000;">‘,</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  21. </span><span style="color: #008080;"> 21</span>             sql += <span style="color: #800000;">"</span><span style="color: #800000;">‘</span><span style="color: #800000;">"</span> + user.UserLogin + <span style="color: #800000;">"</span><span style="color: #800000;">‘,</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  22. </span><span style="color: #008080;"> 22</span>             sql += <span style="color: #800000;">"</span><span style="color: #800000;">‘</span><span style="color: #800000;">"</span> + user.UserPwd + <span style="color: #800000;">"</span><span style="color: #800000;">‘</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  23. </span><span style="color: #008080;"> 23</span>             sql += <span style="color: #800000;">"</span><span style="color: #800000;">)</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  24. </span><span style="color: #008080;"> 24</span> 
  25. <span style="color: #008080;"> 25</span>             DBHelper helper = <span style="color: #0000ff;">new</span><span style="color: #000000;"> DBHelper();
  26. </span><span style="color: #008080;"> 26</span>             result =<span style="color: #000000;"> helper.ExecuteCommand(sql);
  27. </span><span style="color: #008080;"> 27</span>             <span style="color: #0000ff;">return</span><span style="color: #000000;"> result;
  28. </span><span style="color: #008080;"> 28</span>            
  29. <span style="color: #008080;"> 29</span> <span style="color: #000000;">        }
  30. </span><span style="color: #008080;"> 30</span> 
  31. <span style="color: #008080;"> 31</span>         <span style="color: #0000ff;">public</span><span style="color: #000000;"> User GetUserByLogin(User user)
  32. </span><span style="color: #008080;"> 32</span> <span style="color: #000000;">        {
  33. </span><span style="color: #008080;"> 33</span>             String sql = <span style="color: #800000;">""</span><span style="color: #000000;">;
  34. </span><span style="color: #008080;"> 34</span> 
  35. <span style="color: #008080;"> 35</span>             sql = <span style="color: #800000;">"</span><span style="color: #800000;">select * from table_user where userLogin=‘</span><span style="color: #800000;">"</span> + user.UserLogin + <span style="color: #800000;">"</span><span style="color: #800000;">‘</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  36. </span><span style="color: #008080;"> 36</span> 
  37. <span style="color: #008080;"> 37</span>             DBHelper helper = <span style="color: #0000ff;">new</span><span style="color: #000000;"> DBHelper();
  38. </span><span style="color: #008080;"> 38</span>             SqlDataReader reader =<span style="color: #000000;"> helper.ExecuteReader(sql);
  39. </span><span style="color: #008080;"> 39</span>             User result = <span style="color: #0000ff;">new</span><span style="color: #000000;"> User();
  40. </span><span style="color: #008080;"> 40</span>             <span style="color: #0000ff;">if</span><span style="color: #000000;"> (reader.Read())
  41. </span><span style="color: #008080;"> 41</span> <span style="color: #000000;">            {
  42. </span><span style="color: #008080;"> 42</span> 
  43. <span style="color: #008080;"> 43</span>                 result.UserName = reader.GetString(<span style="color: #800080;">0</span><span style="color: #000000;">);
  44. </span><span style="color: #008080;"> 44</span>                 result.UserLogin = reader.GetString(<span style="color: #800080;">1</span><span style="color: #000000;">);
  45. </span><span style="color: #008080;"> 45</span>                 result.UserPwd = reader.GetString(<span style="color: #800080;">2</span><span style="color: #000000;">);
  46. </span><span style="color: #008080;"> 46</span>                
  47. <span style="color: #008080;"> 47</span> <span style="color: #000000;">            }
  48. </span><span style="color: #008080;"> 48</span>             <span style="color: #0000ff;">else</span> 
  49. <span style="color: #008080;"> 49</span> <span style="color: #000000;">            {
  50. </span><span style="color: #008080;"> 50</span>                 <span style="color: #0000ff;">return</span> <span style="color: #0000ff;">null</span><span style="color: #000000;">;
  51. </span><span style="color: #008080;"> 51</span> <span style="color: #000000;">            }
  52. </span><span style="color: #008080;"> 52</span>            
  53. <span style="color: #008080;"> 53</span>             <span style="color: #0000ff;">return</span><span style="color: #000000;"> result;
  54. </span><span style="color: #008080;"> 54</span> <span style="color: #000000;">        }
  55. </span><span style="color: #008080;"> 55</span> 
  56. <span style="color: #008080;"> 56</span>         <span style="color: #0000ff;">public</span> List<User><span style="color: #000000;"> GetAllUsers()
  57. </span><span style="color: #008080;"> 57</span> <span style="color: #000000;">        {
  58. </span><span style="color: #008080;"> 58</span>             String sql = <span style="color: #800000;">""</span><span style="color: #000000;">;
  59. </span><span style="color: #008080;"> 59</span> 
  60. <span style="color: #008080;"> 60</span>             sql = <span style="color: #800000;">"</span><span style="color: #800000;">select * from table_user</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  61. </span><span style="color: #008080;"> 61</span> 
  62. <span style="color: #008080;"> 62</span>             DBHelper helper = <span style="color: #0000ff;">new</span><span style="color: #000000;"> DBHelper();
  63. </span><span style="color: #008080;"> 63</span>             SqlDataReader reader =<span style="color: #000000;"> helper.ExecuteReader(sql);
  64. </span><span style="color: #008080;"> 64</span> 
  65. <span style="color: #008080;"> 65</span>             <span style="color: #0000ff;">if</span> (!<span style="color: #000000;">reader.HasRows)
  66. </span><span style="color: #008080;"> 66</span> <span style="color: #000000;">            {
  67. </span><span style="color: #008080;"> 67</span>                 <span style="color: #0000ff;">return</span> <span style="color: #0000ff;">null</span><span style="color: #000000;">;
  68. </span><span style="color: #008080;"> 68</span> <span style="color: #000000;">            }
  69. </span><span style="color: #008080;"> 69</span> 
  70. <span style="color: #008080;"> 70</span>             List<User> list = <span style="color: #0000ff;">new</span> List<User><span style="color: #000000;">();
  71. </span><span style="color: #008080;"> 71</span>             <span style="color: #0000ff;">while</span><span style="color: #000000;"> (reader.Read())
  72. </span><span style="color: #008080;"> 72</span> <span style="color: #000000;">            {
  73. </span><span style="color: #008080;"> 73</span>                 User item = <span style="color: #0000ff;">new</span><span style="color: #000000;"> User();
  74. </span><span style="color: #008080;"> 74</span> 
  75. <span style="color: #008080;"> 75</span>                 item.UserName = reader.GetString(<span style="color: #800080;">0</span><span style="color: #000000;">);
  76. </span><span style="color: #008080;"> 76</span>                 item.UserLogin = reader.GetString(<span style="color: #800080;">1</span><span style="color: #000000;">);
  77. </span><span style="color: #008080;"> 77</span>                 item.UserPwd = reader.GetString(<span style="color: #800080;">2</span><span style="color: #000000;">);
  78. </span><span style="color: #008080;"> 78</span> 
  79. <span style="color: #008080;"> 79</span> <span style="color: #000000;">                list.Add(item);
  80. </span><span style="color: #008080;"> 80</span> <span style="color: #000000;">            }
  81. </span><span style="color: #008080;"> 81</span> 
  82. <span style="color: #008080;"> 82</span>             <span style="color: #0000ff;">return</span><span style="color: #000000;"> list;
  83. </span><span style="color: #008080;"> 83</span> <span style="color: #000000;">        }
  84. </span><span style="color: #008080;"> 84</span> 
  85. <span style="color: #008080;"> 85</span>         <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">bool</span><span style="color: #000000;"> DeleteUsers(String i) 
  86. </span><span style="color: #008080;"> 86</span> <span style="color: #000000;">        {
  87. </span><span style="color: #008080;"> 87</span>             <span style="color: #0000ff;">bool</span> result = <span style="color: #0000ff;">false</span><span style="color: #000000;">;
  88. </span><span style="color: #008080;"> 88</span>             String sql = <span style="color: #800000;">""</span><span style="color: #000000;">;
  89. </span><span style="color: #008080;"> 89</span>             sql = <span style="color: #800000;">"</span><span style="color: #800000;">delete  from table_user where userLogin =‘</span><span style="color: #800000;">"</span>+ i+<span style="color: #800000;">"</span><span style="color: #800000;"> ‘</span><span style="color: #800000;">"</span><span style="color: #000000;"> ;
  90. </span><span style="color: #008080;"> 90</span>             DBHelper helper = <span style="color: #0000ff;">new</span><span style="color: #000000;"> DBHelper();
  91. </span><span style="color: #008080;"> 91</span>             result =<span style="color: #000000;"> helper.ExecuteCommand(sql);
  92. </span><span style="color: #008080;"> 92</span>             <span style="color: #0000ff;">return</span><span style="color: #000000;"> result;
  93. </span><span style="color: #008080;"> 93</span> <span style="color: #000000;">        }
  94. </span><span style="color: #008080;"> 94</span> 
  95. <span style="color: #008080;"> 95</span>         <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">bool</span><span style="color: #000000;"> UpdateUsers(User user)
  96. </span><span style="color: #008080;"> 96</span> <span style="color: #000000;">        {
  97. </span><span style="color: #008080;"> 97</span>             <span style="color: #0000ff;">bool</span> result = <span style="color: #0000ff;">false</span><span style="color: #000000;">;
  98. </span><span style="color: #008080;"> 98</span>             String sql = <span style="color: #800000;">""</span><span style="color: #000000;">;
  99. </span><span style="color: #008080;"> 99</span>             sql = <span style="color: #800000;">"</span><span style="color: #800000;">update table_user set userName= ‘</span><span style="color: #800000;">"</span> + user.UserName + <span style="color: #800000;">"</span><span style="color: #800000;">‘,userPwd=‘</span><span style="color: #800000;">"</span> + user.UserPwd + <span style="color: #800000;">"</span><span style="color: #800000;"> ‘  where userlogin=‘</span><span style="color: #800000;">"</span> + user.UserLogin + <span style="color: #800000;">"</span><span style="color: #800000;"> ‘</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  100. </span><span style="color: #008080;">100</span>           <span style="color: #008000;">//</span><span style="color: #008000;">  update  table_user set userName=‘1‘,userPwd=‘1‘ where userLogin=‘5‘</span>
  101. <span style="color: #008080;">101</span>             DBHelper helper = <span style="color: #0000ff;">new</span><span style="color: #000000;"> DBHelper();
  102. </span><span style="color: #008080;">102</span>             result =<span style="color: #000000;"> helper.ExecuteCommand(sql);
  103. </span><span style="color: #008080;">103</span>             <span style="color: #0000ff;">return</span><span style="color: #000000;"> result;
  104. </span><span style="color: #008080;">104</span> <span style="color: #000000;">        }
  105. </span><span style="color: #008080;">105</span> 
  106. <span style="color: #008080;">106</span> <span style="color: #000000;">    }
  107. </span><span style="color: #008080;">107</span> }

 

业务逻辑层UserManager.cs，是表示层与数据访问层的桥梁 ，用于完成逻辑判断、业务处理、数据传递等操作。

  1. <span style="color: #008080;"> 1</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System;
  2. </span><span style="color: #008080;"> 2</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Collections.Generic;
  3. </span><span style="color: #008080;"> 3</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Linq;
  4. </span><span style="color: #008080;"> 4</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Web;
  5. </span><span style="color: #008080;"> 5</span> 
  6. <span style="color: #008080;"> 6</span> <span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span>
  7. <span style="color: #008080;"> 7</span> <span style="color: #808080;">///</span><span style="color: #008000;"> UserManager 的摘要说明
  8. </span><span style="color: #008080;"> 8</span> <span style="color: #808080;">///</span> <span style="color: #808080;"></summary></span>
  9. <span style="color: #008080;"> 9</span> <span style="color: #0000ff;">namespace</span><span style="color: #000000;"> testDAO.Library
  10. </span><span style="color: #008080;">10</span> <span style="color: #000000;">{
  11. </span><span style="color: #008080;">11</span>     <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> UserManager
  12. </span><span style="color: #008080;">12</span> <span style="color: #000000;">    {
  13. </span><span style="color: #008080;">13</span>         <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">bool</span><span style="color: #000000;"> AddUser(User user)
  14. </span><span style="color: #008080;">14</span> <span style="color: #000000;">        {
  15. </span><span style="color: #008080;">15</span>             UserService service = <span style="color: #0000ff;">new</span><span style="color: #000000;"> UserService();
  16. </span><span style="color: #008080;">16</span>             User temp =<span style="color: #000000;"> service.GetUserByLogin(user);
  17. </span><span style="color: #008080;">17</span> 
  18. <span style="color: #008080;">18</span>             <span style="color: #0000ff;">if</span> (temp != <span style="color: #0000ff;">null</span><span style="color: #000000;">)
  19. </span><span style="color: #008080;">19</span> <span style="color: #000000;">            {
  20. </span><span style="color: #008080;">20</span>                 <span style="color: #0000ff;">return</span> <span style="color: #0000ff;">false</span><span style="color: #000000;">;
  21. </span><span style="color: #008080;">21</span> <span style="color: #000000;">            }
  22. </span><span style="color: #008080;">22</span> 
  23. <span style="color: #008080;">23</span>             <span style="color: #0000ff;">bool</span> result =<span style="color: #000000;"> service.AddUser(user);
  24. </span><span style="color: #008080;">24</span>             <span style="color: #0000ff;">return</span><span style="color: #000000;"> result;
  25. </span><span style="color: #008080;">25</span> <span style="color: #000000;">        }
  26. </span><span style="color: #008080;">26</span> 
  27. <span style="color: #008080;">27</span>         <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">bool</span><span style="color: #000000;"> Login(User user)
  28. </span><span style="color: #008080;">28</span> <span style="color: #000000;">        {
  29. </span><span style="color: #008080;">29</span>             <span style="color: #0000ff;">bool</span> result = <span style="color: #0000ff;">false</span><span style="color: #000000;">;
  30. </span><span style="color: #008080;">30</span> 
  31. <span style="color: #008080;">31</span>             UserService service = <span style="color: #0000ff;">new</span><span style="color: #000000;"> UserService();
  32. </span><span style="color: #008080;">32</span> 
  33. <span style="color: #008080;">33</span>             User temp =<span style="color: #000000;"> service.GetUserByLogin(user);
  34. </span><span style="color: #008080;">34</span>             <span style="color: #0000ff;">if</span> (temp == <span style="color: #0000ff;">null</span><span style="color: #000000;">)
  35. </span><span style="color: #008080;">35</span> <span style="color: #000000;">            {
  36. </span><span style="color: #008080;">36</span>                 result = <span style="color: #0000ff;">false</span><span style="color: #000000;">;
  37. </span><span style="color: #008080;">37</span> <span style="color: #000000;">            }
  38. </span><span style="color: #008080;">38</span>             <span style="color: #0000ff;">else</span> <span style="color: #0000ff;">if</span><span style="color: #000000;"> (user.UserPwd.Equals(temp.UserPwd))
  39. </span><span style="color: #008080;">39</span> <span style="color: #000000;">            {
  40. </span><span style="color: #008080;">40</span>                 result = <span style="color: #0000ff;">true</span><span style="color: #000000;">;
  41. </span><span style="color: #008080;">41</span> <span style="color: #000000;">            }
  42. </span><span style="color: #008080;">42</span> 
  43. <span style="color: #008080;">43</span>             <span style="color: #0000ff;">return</span><span style="color: #000000;"> result;
  44. </span><span style="color: #008080;">44</span> <span style="color: #000000;">        }
  45. </span><span style="color: #008080;">45</span> 
  46. <span style="color: #008080;">46</span>         <span style="color: #0000ff;">public</span> List<User><span style="color: #000000;"> GetAllUsers()
  47. </span><span style="color: #008080;">47</span> <span style="color: #000000;">        {
  48. </span><span style="color: #008080;">48</span>             UserService service = <span style="color: #0000ff;">new</span><span style="color: #000000;"> UserService();
  49. </span><span style="color: #008080;">49</span>             <span style="color: #0000ff;">return</span><span style="color: #000000;"> service.GetAllUsers();
  50. </span><span style="color: #008080;">50</span> <span style="color: #000000;">        }
  51. </span><span style="color: #008080;">51</span>         <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">bool</span><span style="color: #000000;"> DeleteUser(User user)
  52. </span><span style="color: #008080;">52</span> <span style="color: #000000;">        {
  53. </span><span style="color: #008080;">53</span>             UserService service = <span style="color: #0000ff;">new</span><span style="color: #000000;"> UserService();
  54. </span><span style="color: #008080;">54</span>         
  55. <span style="color: #008080;">55</span>             <span style="color: #0000ff;">bool</span> result =<span style="color: #000000;"> service.DeleteUsers(user.UserLogin);
  56. </span><span style="color: #008080;">56</span>             <span style="color: #0000ff;">return</span><span style="color: #000000;"> result;
  57. </span><span style="color: #008080;">57</span>             
  58. <span style="color: #008080;">58</span> <span style="color: #000000;">        }
  59. </span><span style="color: #008080;">59</span> 
  60. <span style="color: #008080;">60</span>         <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">bool</span><span style="color: #000000;"> UpdateUser(User user)
  61. </span><span style="color: #008080;">61</span> <span style="color: #000000;">        {
  62. </span><span style="color: #008080;">62</span>             UserService service = <span style="color: #0000ff;">new</span><span style="color: #000000;"> UserService();
  63. </span><span style="color: #008080;">63</span>             <span style="color: #0000ff;">bool</span> result =<span style="color: #000000;"> service.UpdateUsers(user);
  64. </span><span style="color: #008080;">64</span>             <span style="color: #0000ff;">return</span><span style="color: #000000;"> result;
  65. </span><span style="color: #008080;">65</span> <span style="color: #000000;">        }
  66. </span><span style="color: #008080;">66</span> <span style="color: #000000;">    }
  67. </span><span style="color: #008080;">67</span> }

 

 

注册界面代码regeister.aspx

  1. <%@ Page Language=<span style="color: #800000;">"</span><span style="color: #800000;">C#</span><span style="color: #800000;">"</span> AutoEventWireup=<span style="color: #800000;">"</span><span style="color: #800000;">true</span><span style="color: #800000;">"</span> CodeFile=<span style="color: #800000;">"</span><span style="color: #800000;">register.aspx.cs</span><span style="color: #800000;">"</span> Inherits=<span style="color: #800000;">"</span><span style="color: #800000;">register</span><span style="color: #800000;">"</span> %>
  2. <!DOCTYPE html>
  3. <html xmlns=<span style="color: #800000;">"</span><span style="color: #800000;">http://www.w3.org/1999/xhtml</span><span style="color: #800000;">"</span>>
  4. <head runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span>>
  5. <meta http-equiv=<span style="color: #800000;">"</span><span style="color: #800000;">Content-Type</span><span style="color: #800000;">"</span> content=<span style="color: #800000;">"</span><span style="color: #800000;">text/html; charset=utf-8</span><span style="color: #800000;">"</span>/>
  6.     <title></title>
  7. </head>
  8. <body>
  9.     <form id=<span style="color: #800000;">"</span><span style="color: #800000;">form1</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span>>
  10.  
  11.     <div>
  12.         <br />
  13.         <asp:Label ID=<span style="color: #800000;">"</span><span style="color: #800000;">Label1</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span> Text=<span style="color: #800000;">"</span><span style="color: #800000;">姓名：</span><span style="color: #800000;">"</span>></asp:Label>
  14.         <asp:TextBox ID=<span style="color: #800000;">"</span><span style="color: #800000;">nameText</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span>></asp:TextBox>
  15.         <br />
  16.         <br />
  17.         <asp:Label ID=<span style="color: #800000;">"</span><span style="color: #800000;">Label2</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span> Text=<span style="color: #800000;">"</span><span style="color: #800000;">帐号：</span><span style="color: #800000;">"</span>></asp:Label>
  18.         <asp:TextBox ID=<span style="color: #800000;">"</span><span style="color: #800000;">loginText</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span>></asp:TextBox>
  19.         <br />
  20.         <br />
  21.         <asp:Label ID=<span style="color: #800000;">"</span><span style="color: #800000;">Label3</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span> Text=<span style="color: #800000;">"</span><span style="color: #800000;">密码：</span><span style="color: #800000;">"</span>></asp:Label>
  22.         <asp:TextBox ID=<span style="color: #800000;">"</span><span style="color: #800000;">pwdText</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span>></asp:TextBox>
  23.         <br />
  24.         <br />
  25.         <asp:Button ID=<span style="color: #800000;">"</span><span style="color: #800000;">Button1</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span> onclick=<span style="color: #800000;">"</span><span style="color: #800000;">Button1_Click</span><span style="color: #800000;">"</span> Text=<span style="color: #800000;">"</span><span style="color: #800000;">注册</span><span style="color: #800000;">"</span> />
  26.         <asp:Button ID=<span style="color: #800000;">"</span><span style="color: #800000;">Button2</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span> onclick=<span style="color: #800000;">"</span><span style="color: #800000;">Button2_Click</span><span style="color: #800000;">"</span> Text=<span style="color: #800000;">"</span><span style="color: #800000;">转向登录</span><span style="color: #800000;">"</span> />
  27.     </div>
  28.     </form>
  29. </body>
  30. </html>

 

注册界面逻辑代码 regeister.aspx.cs

技术分享 
  1. <span style="color: #008080;"> 1</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System;
  2. </span><span style="color: #008080;"> 2</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Collections.Generic;
  3. </span><span style="color: #008080;"> 3</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Linq;
  4. </span><span style="color: #008080;"> 4</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Web;
  5. </span><span style="color: #008080;"> 5</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Web.UI;
  6. </span><span style="color: #008080;"> 6</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Web.UI.WebControls;
  7. </span><span style="color: #008080;"> 7</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Data.SqlClient;
  8. </span><span style="color: #008080;"> 8</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> testDAO.Library;
  9. </span><span style="color: #008080;"> 9</span> 
  10. <span style="color: #008080;">10</span>     <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">partial</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> register : System.Web.UI.Page
  11. </span><span style="color: #008080;">11</span> <span style="color: #000000;">    {
  12. </span><span style="color: #008080;">12</span>         <span style="color: #0000ff;">protected</span> <span style="color: #0000ff;">void</span> Page_Load(<span style="color: #0000ff;">object</span><span style="color: #000000;"> sender, EventArgs e)
  13. </span><span style="color: #008080;">13</span> <span style="color: #000000;">        {
  14. </span><span style="color: #008080;">14</span> 
  15. <span style="color: #008080;">15</span> <span style="color: #000000;">        }
  16. </span><span style="color: #008080;">16</span> 
  17. <span style="color: #008080;">17</span>         <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> CreateTable()
  18. </span><span style="color: #008080;">18</span> <span style="color: #000000;">        {         
  19. </span><span style="color: #008080;">19</span>             String connectionString = <span style="color: #800000;">"</span><span style="color: #800000;">server=.;Trusted_Connection=SSPI;database=easylife</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  20. </span><span style="color: #008080;">20</span>             SqlConnection connection = <span style="color: #0000ff;">new</span><span style="color: #000000;"> SqlConnection(connectionString);
  21. </span><span style="color: #008080;">21</span> <span style="color: #000000;">            connection.Open();
  22. </span><span style="color: #008080;">22</span>             SqlCommand command = <span style="color: #0000ff;">new</span><span style="color: #000000;"> SqlCommand();
  23. </span><span style="color: #008080;">23</span>             command.Connection =<span style="color: #000000;"> connection;
  24. </span><span style="color: #008080;">24</span> <span style="color: #000000;">            command.ExecuteNonQuery();
  25. </span><span style="color: #008080;">25</span> <span style="color: #000000;">            connection.Close();
  26. </span><span style="color: #008080;">26</span> <span style="color: #000000;">        }
  27. </span><span style="color: #008080;">27</span>         <span style="color: #0000ff;">protected</span> <span style="color: #0000ff;">void</span> Button1_Click(<span style="color: #0000ff;">object</span><span style="color: #000000;"> sender, EventArgs e)
  28. </span><span style="color: #008080;">28</span> <span style="color: #000000;">        {
  29. </span><span style="color: #008080;">29</span>             String userName =<span style="color: #000000;"> nameText.Text;
  30. </span><span style="color: #008080;">30</span>             String userLogin =<span style="color: #000000;"> loginText.Text;
  31. </span><span style="color: #008080;">31</span>             String userPwd =<span style="color: #000000;"> pwdText.Text;
  32. </span><span style="color: #008080;">32</span> 
  33. <span style="color: #008080;">33</span>             User user = <span style="color: #0000ff;">new</span><span style="color: #000000;"> User();
  34. </span><span style="color: #008080;">34</span>             user.UserName =<span style="color: #000000;"> userName;
  35. </span><span style="color: #008080;">35</span>             user.UserLogin =<span style="color: #000000;"> userLogin;
  36. </span><span style="color: #008080;">36</span>             user.UserPwd =<span style="color: #000000;"> userPwd;
  37. </span><span style="color: #008080;">37</span> 
  38. <span style="color: #008080;">38</span>             <span style="color: #0000ff;">bool</span> result = <span style="color: #0000ff;">false</span><span style="color: #000000;">;
  39. </span><span style="color: #008080;">39</span>             UserManager manager = <span style="color: #0000ff;">new</span><span style="color: #000000;"> UserManager();
  40. </span><span style="color: #008080;">40</span>             result =<span style="color: #000000;"> manager.AddUser(user);
  41. </span><span style="color: #008080;">41</span> <span style="color: #000000;">            Response.Write(result);
  42. </span><span style="color: #008080;">42</span>             <span style="color: #0000ff;">if</span><span style="color: #000000;"> (result)
  43. </span><span style="color: #008080;">43</span> <span style="color: #000000;">            {
  44. </span><span style="color: #008080;">44</span>                 Response.Write(<span style="color: #800000;">"</span><span style="color: #800000;">注册成功</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  45. </span><span style="color: #008080;">45</span> <span style="color: #000000;">            }
  46. </span><span style="color: #008080;">46</span>             <span style="color: #0000ff;">else</span>
  47. <span style="color: #008080;">47</span> <span style="color: #000000;">            {
  48. </span><span style="color: #008080;">48</span>                 Response.Write(<span style="color: #800000;">"</span><span style="color: #800000;">注册失败</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  49. </span><span style="color: #008080;">49</span> <span style="color: #000000;">            }
  50. </span><span style="color: #008080;">50</span> <span style="color: #000000;">        }
  51. </span><span style="color: #008080;">51</span>         <span style="color: #0000ff;">protected</span> <span style="color: #0000ff;">void</span> Button2_Click(<span style="color: #0000ff;">object</span><span style="color: #000000;"> sender, EventArgs e)
  52. </span><span style="color: #008080;">52</span> <span style="color: #000000;">        {
  53. </span><span style="color: #008080;">53</span>             Response.Redirect(<span style="color: #800000;">"</span><span style="color: #800000;">login.aspx</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  54. </span><span style="color: #008080;">54</span> <span style="color: #000000;">        }
  55. </span><span style="color: #008080;">55</span>     }
regeister.aspx.cs

登录界面代码 login.aspx

技术分享 
  1. <span style="color: #008080;"> 1</span> <%@ Page Language=<span style="color: #800000;">"</span><span style="color: #800000;">C#</span><span style="color: #800000;">"</span> AutoEventWireup=<span style="color: #800000;">"</span><span style="color: #800000;">true</span><span style="color: #800000;">"</span> CodeFile=<span style="color: #800000;">"</span><span style="color: #800000;">login.aspx.cs</span><span style="color: #800000;">"</span> Inherits=<span style="color: #800000;">"</span><span style="color: #800000;">login</span><span style="color: #800000;">"</span> %>
  2. <span style="color: #008080;"> 2</span> 
  3. <span style="color: #008080;"> 3</span> <!DOCTYPE html>
  4. <span style="color: #008080;"> 4</span> 
  5. <span style="color: #008080;"> 5</span> <html xmlns=<span style="color: #800000;">"</span><span style="color: #800000;">http://www.w3.org/1999/xhtml</span><span style="color: #800000;">"</span>>
  6. <span style="color: #008080;"> 6</span> <head runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span>>
  7. <span style="color: #008080;"> 7</span> <meta http-equiv=<span style="color: #800000;">"</span><span style="color: #800000;">Content-Type</span><span style="color: #800000;">"</span> content=<span style="color: #800000;">"</span><span style="color: #800000;">text/html; charset=utf-8</span><span style="color: #800000;">"</span>/>
  8. <span style="color: #008080;"> 8</span>     <title></title>
  9. <span style="color: #008080;"> 9</span> </head>
  10. <span style="color: #008080;">10</span> <body>
  11. <span style="color: #008080;">11</span>     <form id=<span style="color: #800000;">"</span><span style="color: #800000;">form1</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span>>
  12. <span style="color: #008080;">12</span>     <div>
  13. <span style="color: #008080;">13</span>         <br />
  14. <span style="color: #008080;">14</span>         <asp:Label ID=<span style="color: #800000;">"</span><span style="color: #800000;">Label1</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span> Text=<span style="color: #800000;">"</span><span style="color: #800000;">帐号：</span><span style="color: #800000;">"</span>></asp:Label>
  15. <span style="color: #008080;">15</span>         <asp:TextBox ID=<span style="color: #800000;">"</span><span style="color: #800000;">loginText</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span>></asp:TextBox>
  16. <span style="color: #008080;">16</span>         <br />
  17. <span style="color: #008080;">17</span>         <br />
  18. <span style="color: #008080;">18</span>         <asp:Label ID=<span style="color: #800000;">"</span><span style="color: #800000;">Label2</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span> Text=<span style="color: #800000;">"</span><span style="color: #800000;">密码：</span><span style="color: #800000;">"</span>></asp:Label>
  19. <span style="color: #008080;">19</span>         <asp:TextBox ID=<span style="color: #800000;">"</span><span style="color: #800000;">pwdText</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span>></asp:TextBox>
  20. <span style="color: #008080;">20</span>         <br />
  21. <span style="color: #008080;">21</span>         <br />
  22. <span style="color: #008080;">22</span>         <asp:Button ID=<span style="color: #800000;">"</span><span style="color: #800000;">loginButton</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span> onclick=<span style="color: #800000;">"</span><span style="color: #800000;">loginButton_Click</span><span style="color: #800000;">"</span> 
  23. <span style="color: #008080;">23</span>             Text=<span style="color: #800000;">"</span><span style="color: #800000;">登录</span><span style="color: #800000;">"</span> />
  24. <span style="color: #008080;">24</span>         <asp:Button ID=<span style="color: #800000;">"</span><span style="color: #800000;">Button1</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span> Text=<span style="color: #800000;">"</span><span style="color: #800000;">转向注册</span><span style="color: #800000;">"</span> OnClick=<span style="color: #800000;">"</span><span style="color: #800000;">Button1_Click</span><span style="color: #800000;">"</span> />
  25. <span style="color: #008080;">25</span>     </div>
  26. <span style="color: #008080;">26</span>     </form>
  27. <span style="color: #008080;">27</span> </body>
  28. <span style="color: #008080;">28</span> </html>
login.aspx

 

登录界面逻辑代码 login.aspx.cs

技术分享 
  1. <span style="color: #008080;"> 1</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System;
  2. </span><span style="color: #008080;"> 2</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Collections.Generic;
  3. </span><span style="color: #008080;"> 3</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Linq;
  4. </span><span style="color: #008080;"> 4</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Web;
  5. </span><span style="color: #008080;"> 5</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Web.UI;
  6. </span><span style="color: #008080;"> 6</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Web.UI.WebControls;
  7. </span><span style="color: #008080;"> 7</span> <span style="color: #0000ff;">using</span><span style="color: #000000;"> testDAO.Library;
  8. </span><span style="color: #008080;"> 8</span> 
  9. <span style="color: #008080;"> 9</span> <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">partial</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> login : System.Web.UI.Page
  10. </span><span style="color: #008080;">10</span> <span style="color: #000000;">{
  11. </span><span style="color: #008080;">11</span>     <span style="color: #0000ff;">protected</span> <span style="color: #0000ff;">void</span> Page_Load(<span style="color: #0000ff;">object</span><span style="color: #000000;"> sender, EventArgs e)
  12. </span><span style="color: #008080;">12</span> <span style="color: #000000;">    {
  13. </span><span style="color: #008080;">13</span> 
  14. <span style="color: #008080;">14</span> <span style="color: #000000;">    }
  15. </span><span style="color: #008080;">15</span>     <span style="color: #0000ff;">protected</span> <span style="color: #0000ff;">void</span> Button1_Click(<span style="color: #0000ff;">object</span><span style="color: #000000;"> sender, EventArgs e) 
  16. </span><span style="color: #008080;">16</span> <span style="color: #000000;">    {
  17. </span><span style="color: #008080;">17</span>         Response.Redirect(<span style="color: #800000;">"</span><span style="color: #800000;">register.aspx</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  18. </span><span style="color: #008080;">18</span> <span style="color: #000000;">    }
  19. </span><span style="color: #008080;">19</span> 
  20. <span style="color: #008080;">20</span>     <span style="color: #0000ff;">protected</span> <span style="color: #0000ff;">void</span> loginButton_Click(<span style="color: #0000ff;">object</span><span style="color: #000000;"> sender, EventArgs e)
  21. </span><span style="color: #008080;">21</span> <span style="color: #000000;">    {
  22. </span><span style="color: #008080;">22</span>         User user = <span style="color: #0000ff;">new</span><span style="color: #000000;"> User();    
  23. </span><span style="color: #008080;">23</span> 
  24. <span style="color: #008080;">24</span>         user.UserLogin =<span style="color: #000000;"> loginText.Text;
  25. </span><span style="color: #008080;">25</span>         user.UserPwd =<span style="color: #000000;"> pwdText.Text;
  26. </span><span style="color: #008080;">26</span> 
  27. <span style="color: #008080;">27</span>         UserManager manager = <span style="color: #0000ff;">new</span><span style="color: #000000;"> UserManager();
  28. </span><span style="color: #008080;">28</span>         <span style="color: #0000ff;">bool</span> result =<span style="color: #000000;"> manager.Login(user);
  29. </span><span style="color: #008080;">29</span>         <span style="color: #0000ff;">if</span><span style="color: #000000;"> (result)
  30. </span><span style="color: #008080;">30</span> <span style="color: #000000;">        {
  31. </span><span style="color: #008080;">31</span>             Response.Redirect(<span style="color: #800000;">"</span><span style="color: #800000;">list.aspx</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  32. </span><span style="color: #008080;">32</span> <span style="color: #000000;">        }
  33. </span><span style="color: #008080;">33</span>         <span style="color: #0000ff;">else</span> 
  34. <span style="color: #008080;">34</span> <span style="color: #000000;">        {
  35. </span><span style="color: #008080;">35</span>             Response.Write(<span style="color: #800000;">"</span><span style="color: #800000;">登录失败,请输入正确的用户名和密码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  36. </span><span style="color: #008080;">36</span> <span style="color: #000000;">        }
  37. </span><span style="color: #008080;">37</span> 
  38. <span style="color: #008080;">38</span> 
  39. <span style="color: #008080;">39</span> <span style="color: #000000;">    }
  40. </span><span style="color: #008080;">40</span> }
login.aspx.cs

 

显示界面代码：

显示界面相关说明：

显示界面图片是这样：技术分享

当点击修改时图片如下：

技术分享

点击修改时通过table获得table中的行数，从而改变行数中相应的内容，相关代码在javascript中

参数传值通过URL获取

技术分享 
  1. <span style="color: #008080;"> 1</span> <%@ Page Language=<span style="color: #800000;">"</span><span style="color: #800000;">C#</span><span style="color: #800000;">"</span> AutoEventWireup=<span style="color: #800000;">"</span><span style="color: #800000;">true</span><span style="color: #800000;">"</span> CodeFile=<span style="color: #800000;">"</span><span style="color: #800000;">list.aspx.cs</span><span style="color: #800000;">"</span> Inherits=<span style="color: #800000;">"</span><span style="color: #800000;">list</span><span style="color: #800000;">"</span> %>
  2. <span style="color: #008080;"> 2</span> 
  3. <span style="color: #008080;"> 3</span> <%@ Import Namespace=<span style="color: #800000;">"</span><span style="color: #800000;">testDAO.Library</span><span style="color: #800000;">"</span> %>
  4. <span style="color: #008080;"> 4</span> <!DOCTYPE html>
  5. <span style="color: #008080;"> 5</span> 
  6. <span style="color: #008080;"> 6</span> <html xmlns=<span style="color: #800000;">"</span><span style="color: #800000;">http://www.w3.org/1999/xhtml</span><span style="color: #800000;">"</span>>
  7. <span style="color: #008080;"> 7</span> <head runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span>>
  8. <span style="color: #008080;"> 8</span> <meta http-equiv=<span style="color: #800000;">"</span><span style="color: #800000;">Content-Type</span><span style="color: #800000;">"</span> content=<span style="color: #800000;">"</span><span style="color: #800000;">text/html; charset=utf-8</span><span style="color: #800000;">"</span>/>
  9. <span style="color: #008080;"> 9</span>     <title></title>
  10. <span style="color: #008080;">10</span> </head>
  11. <span style="color: #008080;">11</span> <body>
  12. <span style="color: #008080;">12</span>     <form id=<span style="color: #800000;">"</span><span style="color: #800000;">form1</span><span style="color: #800000;">"</span> runat=<span style="color: #800000;">"</span><span style="color: #800000;">server</span><span style="color: #800000;">"</span>>
  13. <span style="color: #008080;">13</span>     <div>
  14. <span style="color: #008080;">14</span>         <table id=<span style="color: #800000;">"</span><span style="color: #800000;">test</span><span style="color: #800000;">"</span> width=<span style="color: #800000;">"</span><span style="color: #800000;">1000</span><span style="color: #800000;">"</span> align=<span style="color: #800000;">"</span><span style="color: #800000;">center</span><span style="color: #800000;">"</span> border = <span style="color: #800000;">"</span><span style="color: #800000;">1</span><span style="color: #800000;">"</span> cellpadding=<span style="color: #800000;">"</span><span style="color: #800000;">1</span><span style="color: #800000;">"</span> cellspacing=<span style="color: #800000;">"</span><span style="color: #800000;">1</span><span style="color: #800000;">"</span> bordercolordark=<span style="color: #800000;">"</span><span style="color: #800000;">#808080</span><span style="color: #800000;">"</span> bordercolorlight=<span style="color: #800000;">"</span><span style="color: #800000;">#ffffff</span><span style="color: #800000;">"</span> >
  15. <span style="color: #008080;">15</span> <tr>
  16. <span style="color: #008080;">16</span>   <td align=<span style="color: #800000;">"</span><span style="color: #800000;">center</span><span style="color: #800000;">"</span>>序号</td>
  17. <span style="color: #008080;">17</span>   <td align=<span style="color: #800000;">"</span><span style="color: #800000;">center</span><span style="color: #800000;">"</span>>姓名</td>
  18. <span style="color: #008080;">18</span>   <td align=<span style="color: #800000;">"</span><span style="color: #800000;">center</span><span style="color: #800000;">"</span>>帐号</td>
  19. <span style="color: #008080;">19</span>   <td align=<span style="color: #800000;">"</span><span style="color: #800000;">center</span><span style="color: #800000;">"</span>>密码</td>
  20. <span style="color: #008080;">20</span>   <td align=<span style="color: #800000;">"</span><span style="color: #800000;">center</span><span style="color: #800000;">"</span>>修改</td>
  21. <span style="color: #008080;">21</span>   <td align=<span style="color: #800000;">"</span><span style="color: #800000;">center</span><span style="color: #800000;">"</span>>删除</td>
  22. <span style="color: #008080;">22</span> </tr>
  23. <span style="color: #008080;">23</span> <%
  24. <span style="color: #008080;">24</span>     UserManager manager = <span style="color: #0000ff;">new</span><span style="color: #000000;"> UserManager();
  25. </span><span style="color: #008080;">25</span>     List<User> list =<span style="color: #000000;"> manager.GetAllUsers();
  26. </span><span style="color: #008080;">26</span> 
  27. <span style="color: #008080;">27</span>     <span style="color: #0000ff;">for</span> (<span style="color: #0000ff;">int</span> i = <span style="color: #800080;">0</span>; i < list.Count; i++<span style="color: #000000;">)
  28. </span><span style="color: #008080;">28</span> <span style="color: #000000;">    {
  29. </span><span style="color: #008080;">29</span>         Response.Write(<span style="color: #800000;">"</span><span style="color: #800000;"><tr ></span><span style="color: #800000;">"</span><span style="color: #000000;">);
  30. </span><span style="color: #008080;">30</span>         Response.Write(<span style="color: #800000;">"</span><span style="color: #800000;"><td align=‘center‘></span><span style="color: #800000;">"</span> + i + <span style="color: #800000;">"</span><span style="color: #800000;"></td></span><span style="color: #800000;">"</span><span style="color: #000000;">);
  31. </span><span style="color: #008080;">31</span>         Response.Write(<span style="color: #800000;">"</span><span style="color: #800000;"><td align=‘center‘></span><span style="color: #800000;">"</span> + list[i].UserName + <span style="color: #800000;">"</span><span style="color: #800000;"></td></span><span style="color: #800000;">"</span><span style="color: #000000;">);
  32. </span><span style="color: #008080;">32</span>         Response.Write(<span style="color: #800000;">"</span><span style="color: #800000;"><td align=‘center‘ id=‘loginText‘></span><span style="color: #800000;">"</span> + list[i].UserLogin + <span style="color: #800000;">"</span><span style="color: #800000;"></td></span><span style="color: #800000;">"</span><span style="color: #000000;">);
  33. </span><span style="color: #008080;">33</span>         Response.Write(<span style="color: #800000;">"</span><span style="color: #800000;"><td align=‘center‘></span><span style="color: #800000;">"</span> + list[i].UserPwd + <span style="color: #800000;">"</span><span style="color: #800000;"></td></span><span style="color: #800000;">"</span><span style="color: #000000;">);
  34. </span><span style="color: #008080;">34</span>        
  35. <span style="color: #008080;">35</span>         Response.Write(<span style="color: #800000;">"</span><span style="color: #800000;"><td align=‘center‘><input type=‘Button‘ value=‘修改‘ onclick=‘test1(</span><span style="color: #800000;">"</span>+i+<span style="color: #800000;">"</span><span style="color: #800000;">)‘  >修改</td></span><span style="color: #800000;">"</span><span style="color: #000000;">);
  36. </span><span style="color: #008080;">36</span>         Response.Write(<span style="color: #800000;">"</span><span style="color: #800000;"><td align=‘center‘><a href=‘userDelete.aspx?userLogin=</span><span style="color: #800000;">"</span> + list[i].UserLogin + <span style="color: #800000;">"</span><span style="color: #800000;">‘>删除</a></td></span><span style="color: #800000;">"</span><span style="color: #000000;">);
  37. </span><span style="color: #008080;">37</span>               
  38. <span style="color: #008080;">38</span>         Response.Write(<span style="color: #800000;">"</span><span style="color: #800000;"></tr></span><span style="color: #800000;">"</span><span style="color: #00000                    </div>
  39.                   
  40.  
  41.                     <div class=" "="">
  42.                         <ul class="m-news-opt fix">
  43.                             <li class="opt-item">
  44.                                 <a href="/sql_question-460548.html" target="_blank"><p>< 上一篇</p><p class="ellipsis">execute sp_executesql 用变量获取返回值</p></a>
  45.                             </li>
  46.                             <li class="opt-item ta-r">
  47.                                  <a href="/sql_question-460550.html" target="_blank"><p>下一篇 ></p><p class="ellipsis">mysql主从复制的简单配置</p></a>
  48.                             </li>
  49.                         </ul>
  50.                     </span>

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！