ASP.NET登錄以及注冊

數據模型：

 1 public class Model
 2 {
 3     public Model()
 4     {
 5         //
 6         // TODO: 在此處添加構造函數邏輯
 7         //
 8     }
 9     private string _Ucode;
10     /// <summary>
11     /// 賬號
12     /// </summary>
13     public string Ucode
14     {
15         get { return _Ucode; }
16         set { _Ucode = value; }
17     }
18     private string _Umima;
19     /// <summary>
20     /// 密碼
21     /// </summary>
22     public string Umima
23     {
24         get { return _Umima; }
25         set { _Umima = value; }
26     }
27     private string _Uname;
28     /// <summary>
29     /// 姓名
30     /// </summary>
31     public string Uname
32     {
33         get { return _Uname; }
34         set { _Uname = value; }
35     }
36     private bool _Usex;
37     /// <summary>
38     /// 性別
39     /// </summary>
40     public bool Usex
41     {
42         get { return _Usex; }
43         set { _Usex = value; }
44     }
45     /// <summary>
46     /// 輸出性別
47     /// </summary>
48     public string Sex
49     {
50         get { return _Usex ? "男" : "女"; }
51     }
52     private DateTime _Ubirth;
53     /// <summary>
54     /// 生日
55     /// </summary>
56     public DateTime Ubirth
57     {
58         get { return _Ubirth; }
59         set { _Ubirth = value; }
60     }
61     private string _Uminzu;
62     /// <summary>
63     /// 民族編號
64     /// </summary>
65     public string Uminzu
66     {
67         get { return _Uminzu; }
68         set { _Uminzu = value; }
69     }
70     private string _Umzz;
71     /// <summary>
72     /// 民族編號
73     /// </summary>
74     public string Umzz
75     {
76         get { return _Umzz; }
77         set { _Umzz = value; }
78     }
79     private string _Ummz;
80     /// <summary>
81     /// 民族名字
82     /// </summary>
83     public string Ummz
84     {
85         get { return _Ummz; }
86         set { _Ummz = value; }
87     }
88     /// <summary>
89     /// 輸出民族
90     /// </summary>
91     public string MINZU
92     {
93         get { return new Operation().selectminzu1(_Uminzu); }
94     }
95 }

數據訪問類：

  1 public class Operation
  2 {
  3     SqlConnection conn = null;
  4     SqlCommand com = null;
  5     public Operation()
  6     {
  7         conn = new SqlConnection("server=.;database=ChangYong;user=sa;pwd=123;");
  8         com = conn.CreateCommand();
  9     }
 10     /// <summary>
 11     /// 查詢全部數據
 12     /// </summary>
 13     /// <returns></returns>
 14     public List<Model> SelectUtb()
 15     {
 16         List<Model> list = new List<Model>();
 17         com.CommandText = "select * from Utb";
 18         conn.Open();
 19         SqlDataReader dr = com.ExecuteReader();
 20         if (dr.HasRows)
 21         {
 22             while (dr.Read())
 23             {
 24                 Model M = new Model();
 25                 M.Ucode = dr["Ucode"].ToString();
 26                 M.Umima = dr["Umima"].ToString();
 27                 M.Uname = dr["Uname"].ToString();
 28                 M.Usex = Convert.ToBoolean(dr["Usex"]);
 29                 M.Ubirth = Convert.ToDateTime(dr["Ubirth"]);
 30                 M.Uminzu = dr["Uminzu"].ToString();
 31                 list.Add(M);
 32             }
 33         }
 34         conn.Close();
 35         return list;
 36     }
 37 
 38     /// <summary>
 39     /// 登錄
 40     /// </summary>
 41     /// <param name="code"></param>
 42     /// <param name="mima"></param>
 43     /// <returns></returns>
 44     public bool Login(string code, string mima)
 45     {
 46         com.CommandText = "select * from Utb where Ucode = @code and Umima = @mima";
 47         com.Parameters.Clear();
 48         com.Parameters.Add("@code", code);
 49         com.Parameters.Add("@mima", mima);
 50         conn.Open();
 51         SqlDataReader dr = com.ExecuteReader();
 52         bool has = dr.HasRows;
 53         conn.Close();
 54         return has;
 55     }
 56 
 57 
 58     /// <summary>
 59     /// 查詢全部民族
 60     /// </summary>
 61     /// <returns></returns>
 62     public List<Model> selectminzu()
 63     {
 64         List<Model> list = new List<Model>();
 65         com.CommandText = "select * from Umz";
 66         conn.Open();
 67         SqlDataReader dr = com.ExecuteReader();
 68         if (dr.HasRows)
 69         {
 70             while (dr.Read())
 71             {
 72                 Model M = new Model();
 73                 M.Umzz = dr["Umzz"].ToString();
 74                 M.Ummz = dr["Ummz"].ToString();
 75                 list.Add(M);
 76             }
 77         }
 78         conn.Close();
 79         return list;
 80     }
 81 
 82     /// <summary>
 83     /// 注冊添加信息
 84     /// </summary>
 85     public void insertUtb(Model M)
 86     {
 87         com.CommandText = "insert into Utb values(@Ucode,@Umima,@Uname,@Usex,@UbirThday,@Uminzu)";
 88         com.Parameters.Clear();
 89         com.Parameters.Add("@Ucode", M.Ucode);
 90         com.Parameters.Add("@Umima", M.Umima);
 91         com.Parameters.Add("@Uname", M.Uname);
 92         com.Parameters.Add("@Usex", M.Usex);
 93         com.Parameters.Add("@Ubirthday", M.Ubirth);
 94         com.Parameters.Add("@Uminzu", M.Uminzu);
 95         conn.Open();
 96         com.ExecuteNonQuery();
 97         conn.Close();
 98     }
 99 
100 
101     /// <summary>
102     /// 查詢民族
103     /// </summary>
104     /// <returns></returns>
105     public string selectminzu1(string Umzz)
106     {
107         string minzu = "";
108         com.CommandText = "select * from Umz where Umzz = @Umzz";
109         com.Parameters.Clear();
110         com.Parameters.Add("@Umzz", Umzz);
111         conn.Open();
112         SqlDataReader dr = com.ExecuteReader();
113         if (dr.HasRows)
114         {
115             dr.Read();
116             minzu = dr["Ummz"].ToString();
117         }
118         conn.Close();
119         return minzu;
120     }
121 
122     /// <summary>
123     /// 查詢是否存在賬號
124     /// </summary>
125     /// <param name="code"></param>
126     /// <returns></returns>
127     public bool selectcode(string code)
128     {
129         com.CommandText = "select * from Utb where Ucode = @code";
130         com.Parameters.Clear();
131         com.Parameters.Add("@code", code);
132         conn.Open();
133         SqlDataReader dr = com.ExecuteReader();
134         bool has = dr.HasRows;
135         conn.Close();
136         return has;
137     }
138 }

1.登錄html界面

 1  <style>
 2         * {
 3             margin: 0px;
 4             padding: 0px;
 5         }
 6 
 7         #background {
 8             height: 600px;
 9             width: 100%;
10             position: relative;
11             background-image: url(圖片1.jpg);
12             background-repeat: no-repeat;
13             background-size: cover;
14         }
15 
16         #loginwindow {
17             width: 40%;
18             height: 40%;
19             left: 50%;
20             top: 35%;
21             position: relative;
22             background-color: #DCDCDC;
23             border: 10px outset white;
24         }
25 
26         #login {
27             font-family: 微軟雅黑;
28             font-size: 20px;
29             left: 20%;
30             top: 30%;
31             position: relative;
32         }
33 
34         #TextBox1 {
35             top: 22px;
36             left: 35%;
37             position: relative;
38         }
39 
40         #TextBox2 {
41             top: 27px;
42             left: 35%;
43             position: relative;
44         }
45 
46         #Button1 {
47             width: 70px;
48             height: 30px;
49             left: 5.5%;
50             top: 80px;
51             position: relative;
52             background-color: #00FF7F;
53         }
54 
55         #Button2 {
56             width: 70px;
57             height: 30px;
58             left: 6%;
59             top: 80px;
60             position: relative;
61             background-color: #FF6A6A;
62         }
63 
64         #Label1 {
65             color: red;
66             left: -15%;
67             top: 130px;
68             position: relative;
69         }
70     </style>
71 </head>
72 <body>
73     <form id="form1" runat="server">
74         <div id="background">
75             <div id="loginwindow">
76                 <div id="login">
77                     用戶名：<br />
78                     密&nbsp&nbsp 碼：
79                 </div>
80                 <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
81                 <asp:TextBox ID="TextBox2" runat="server" TextMode="Password"></asp:TextBox>
82                 <asp:Button ID="Button1" runat="server" Text="登錄" />
83                 <asp:Button ID="Button2" runat="server" Text="注冊" />
84                 <asp:Label ID="Label1" runat="server"></asp:Label>
85             </div>
86         </div>
87     </form>
88 </body>

2.登錄后臺

 1 protected void Page_Load(object sender, EventArgs e)
 2     {
 3         Button1.Click += Button1_Click;//登錄點擊事件
 4         Button2.Click += Button2_Click;//注冊點擊事件
 5     }
 6 
 7     void Button2_Click(object sender, EventArgs e)
 8     {
 9         Response.Redirect("Default2.aspx");
10     }
11 
12     void Button1_Click(object sender, EventArgs e)
13     {
14         bool Has = new Operation().Login(TextBox1.Text, TextBox2.Text);
15         if (Has)
16         {
17             Response.Redirect("Default3.aspx");
18         }
19         else
20         {
21             Label1.Text = "賬號密碼錯誤！";
22         }
23 
24     }

3.注冊html界面

 1 <style>
 2         * {
 3             margin: 0px;
 4             padding: 0px;
 5         }
 6 
 7         #background {
 8             width: 100%;
 9             height: 600px;
10             background-image: url(圖片2.jpg);
11             background-repeat: no-repeat;
12             background-size: cover;
13             position: relative;
14         }
15 
16         #title {
17             width: 30%;
18             height: 10%;
19             font-family: 微軟雅黑;
20             font-size: 60px;
21             color: #00EE76;
22             left: 40%;
23             top: 2%;
24             position: relative;
25         }
26 
27         #enrollwindow {
28             width: 60%;
29             height: 80%;
30             left: 20%;
31             top: 5%;
32             position: relative;
33             background-color: #DCDCDC;
34             border: 10px outset white;
35         }
36 
37         #enroll1 {
38             left: 32%;
39             top: 5%;
40             position: relative;
41             font-family: 微軟雅黑;
42             font-size: 20px;
43         }
44 
45         #enroll2 {
46             left: 32%;
47             top: 10%;
48             position: relative;
49             font-family: 微軟雅黑;
50             font-size: 20px;
51         }
52 
53         #Button1 {
54             height: 50px;
55             width: 80px;
56             background-color: green;
57             text-align: center;
58             left: 12%;
59             top: 100px;
60             position: relative;
61         }
62 
63         #Label1 {
64             top: 30px;
65             left: 10%;
66             color: red;
67             position: relative;
68         }
69     </style>
70 </head>
71 <body>
72     <form id="form1" runat="server">
73         <div id="background">
74             <div id="title">在線注冊</div>
75             <div id="enrollwindow" runat="server">
76                 <div id="enroll1">
77                     &nbsp&nbsp&nbsp 用戶名：<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
78                     &nbsp&nbsp&nbsp 密&nbsp&nbsp 碼：<asp:TextBox ID="TextBox2" runat="server" TextMode="Password"></asp:TextBox><br />
79                     確認密碼：<asp:TextBox ID="TextBox3" runat="server" TextMode="Password"></asp:TextBox>
80                 </div>
81                 <hr style="top: 30px; position: relative;" />
82                 <div id="enroll2">
83                     &nbsp&nbsp&nbsp 姓&nbsp&nbsp 名：<asp:TextBox ID="TextBox5" runat="server"></asp:TextBox><br />
84                     &nbsp&nbsp&nbsp 性&nbsp&nbsp 別：<asp:RadioButton ID="RadioButton1" runat="server" Checked="True" GroupName="sex" Text="男" /><asp:RadioButton ID="RadioButton2" runat="server" GroupName="sex" Text="女" /><br />
85                     &nbsp&nbsp&nbsp 生&nbsp&nbsp 日：<asp:DropDownList ID="DropDownList1" runat="server"></asp:DropDownList>年<asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True"></asp:DropDownList>月<asp:DropDownList ID="DropDownList3" runat="server"></asp:DropDownList>日<br />
86                     &nbsp&nbsp&nbsp 民&nbsp&nbsp 族：<asp:DropDownList ID="DropDownList4" runat="server"></asp:DropDownList><br />
87                     <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
88                     <asp:Button ID="Button1" runat="server" Text="注冊" />
89                 </div>
90             </div>
91         </div>
92     </form>
93 </body>

4.注冊后臺

 1 protected void Page_Load(object sender, EventArgs e)
 2     {
 3         Button1.Click += Button1_Click;
 4         if (IsPostBack == false)
 5         {
 6             Dt(1900, DateTime.Now.Year, DropDownList1);//添加年
 7             Dt(1, 12, DropDownList2);//添加月
 8             Dt(1, 31, DropDownList3);//添加日
 9 
10             List<Model> list = new Operation().selectminzu();
11             foreach (Model M in list)
12             {
13                 ListItem Li = new ListItem();
14                 Li.Text = M.Ummz;
15                 Li.Value = M.Umzz;
16                 DropDownList4.Items.Add(Li);//添加民族
17             }
18         }
19     }
20 
21     /// <summary>
22     /// 注冊點擊
23     /// </summary>
24     /// <param name="sender"></param>
25     /// <param name="e"></param>
26     void Button1_Click(object sender, EventArgs e)
27     {
28         foreach (Control Con in enrollwindow.Controls)
29         {
30             if (Con is TextBox)
31             {
32                 TextBox TB = Con as TextBox;
33                 if (TB.Text == "")
34                 {
35                     Label1.Text = "輸入不能為空！";
36                     return;
37                 }
38                 else
39                 {
40                     if (TextBox2.Text != TextBox3.Text)
41                     {
42                         Label1.Text = "兩次密碼輸入不一致！";
43                         return;
44                     }
45                     else
46                     {
47                         bool Has = new Operation().selectcode(TextBox1.Text);
48                         if (Has)
49                         {
50                             Label1.Text = "賬號已存在！";
51                             return;
52                         }
53                     }
54                 }
55             }
56         }
57         Model M = new Model();
58         M.Ucode = TextBox1.Text;
59         M.Umima = TextBox2.Text;
60         M.Uname = TextBox5.Text;
61         M.Usex = RadioButton1.Checked;
62         M.Ubirth = Convert.ToDateTime(DropDownList1.Text + "-" + DropDownList2.Text + "-" + DropDownList3.Text);
63         M.Uminzu = DropDownList4.SelectedValue;
64         Operation Op = new Operation();
65         Op.insertUtb(M);
66     }
67 
68     /// <summary>
69     /// 添加時間日期的方法
70     /// </summary>
71     /// <param name="start"></param>
72     /// <param name="end"></param>
73     /// <param name="Dr"></param>
74     public void Dt(int start, int end, DropDownList Dr)
75     {
76         for (int i = start; i <= end; i++)
77         {
78             ListItem Li = new ListItem();
79             Li.Text = i.ToString();
80             Li.Value = i.ToString();
81             Dr.Items.Add(Li);
82         }
83     }

5.登錄成功界面

 1 <body>
 2     <form id="form1" runat="server">
 3         <h1>登錄成功！</h1>
 4         <asp:Repeater ID="Repeater1" runat="server">
 5             <HeaderTemplate>
 6                 <table>
 7                     <tr>
 8                         <td>賬號</td>
 9                         <td>密碼</td>
10                         <td>姓名</td>
11                         <td>性別</td>
12                         <td>生日</td>
13                         <td>民族</td>
14                     </tr>
15                 </table>
16             </HeaderTemplate>
17             <ItemTemplate>
18                 <table>
19                     <tr>
20                         <td><%#Eval("Ucode") %></td>
21                         <td><%#Eval("Umima") %></td>
22                         <td><%#Eval("Uname") %></td>
23                         <td><%#Eval("Sex") %></td>
24                         <td><%#Eval("Ubirth","{0:yyyy年MM月dd日}") %></td>
25                         <td><%#Eval("MINZU") %></td>
26                     </tr>
27                 </table>
28             </ItemTemplate>
29             <AlternatingItemTemplate>
30                 <table>
31                     <tr style="background-color: #808080">
32                         <td><%#Eval("Ucode") %></td>
33                         <td><%#Eval("Umima") %></td>
34                         <td><%#Eval("Uname") %></td>
35                         <td><%#Eval("Sex") %></td>
36                         <td><%#Eval("Ubirth","{0:yyyy年MM月dd日}") %></td>
37                         <td><%#Eval("MINZU") %></td>
38                     </tr>
39                 </table>
40             </AlternatingItemTemplate>
41             <FooterTemplate></FooterTemplate>
42         </asp:Repeater>
43     </form>
44 </body>

6.登陸成功后臺

1 protected void Page_Load(object sender, EventArgs e)
2     {
3         List<Model> list = new Operation().SelectUtb();
4         Repeater1.DataSource = list;//指向要綁定的數據
5         Repeater1.DataBind();//綁定數據
6     }