数据模型:
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 密   码: 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     用户名:<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br /> 78     密   码:<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     姓   名:<asp:TextBox ID="TextBox5" runat="server"></asp:TextBox><br /> 84     性   别:<asp:RadioButton ID="RadioButton1" runat="server" Checked="True" GroupName="sex" Text="男" /><asp:RadioButton ID="RadioButton2" runat="server" GroupName="sex" Text="女" /><br /> 85     生   日:<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     民   族:<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 }