数据模型:
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 }