注册-登录等功能的综合运用(有数据库的)

如图所示布局

数据库布局如上图所示

 

连接数据库的字符串：

private const string CONNSTRING = @"Data Source=./SQLEXPRESS;AttachDBFilename=|DataDirectory|users.mdf;Integrated Security=True;User Instance=True";

增加写死的用户按钮代码：

using (SqlConnection conn = new SqlConnection(CONNSTRING)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "insert users(username,passwords) values('安超','anchao')"; cmd.ExecuteNonQuery(); MessageBox.Show("加入成功"); }

显示用户按钮代码：

using (SqlConnection conn = new SqlConnection(CONNSTRING)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from users"; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string name = reader.GetString(reader.GetOrdinal("username")); string password = reader.GetString(reader.GetOrdinal("passwords")); textBox1.AppendText(name + "的密码为：" + password + "/r/n"); } }

增加用户按钮代码一：

using (SqlConnection conn = new SqlConnection(CONNSTRING)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select count(*) from users where username=@username"; cmd.Parameters.Add(new SqlParameter("username",usernamebox.Text)); //返回第一行第一列的内容 int count = Convert.ToInt32(cmd.ExecuteScalar()); if (count > 0) { MessageBox.Show("此用户已注册"); } else { cmd.CommandText = "insert into users(username,passwords) values(@ue,@pd)"; cmd.Parameters.AddWithValue("ue", usernamebox.Text); cmd.Parameters.Add(new SqlParameter("pd", passwordbox.Text)); cmd.ExecuteNonQuery(); MessageBox.Show("注册成功"); } }

增加用户按钮代码二：

using (SqlConnection conn = new SqlConnection(CONNSTRING)) { conn.Open(); SqlCommand checkcmd = conn.CreateCommand(); checkcmd.CommandText = "select * from users where username=@un"; checkcmd.Parameters.AddWithValue("un", usernamebox.Text); SqlDataReader checkreader = checkcmd.ExecuteReader(); bool isExist = checkreader.Read(); checkreader.Dispose(); checkcmd.Dispose(); if (isExist) { MessageBox.Show("此用户已注册"); } else { SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "insert into users(username,passwords) values(@un,@pd)"; cmd.Parameters.AddWithValue("un", usernamebox.Text); cmd.Parameters.AddWithValue("pd", passwordbox.Text); cmd.ExecuteNonQuery(); MessageBox.Show("注册成功"); } }

登录按钮代码：

//错误次数+1函数 private void addErrortimes() { const string CONNSTRING = @"Data Source=./SQLEXPRESS;AttachDBFilename=|DataDirectory|users.mdf;Integrated Security=True;User Instance=True"; using (SqlConnection conn = new SqlConnection(CONNSTRING)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "update users set errortimes=errortimes+1 where username=@ue"; cmd.Parameters.Add(new SqlParameter("ue", usernamebox.Text.Trim())); cmd.ExecuteNonQuery(); } } //错误次数置0函数 private void resetErrortimes() { const string CONNSTRING = @"Data Source=./SQLEXPRESS;AttachDBFilename=|DataDirectory|users.mdf;Integrated Security=True;User Instance=True"; using (SqlConnection conn = new SqlConnection(CONNSTRING)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "update users set errortimes=0 where username=@ue"; cmd.Parameters.Add(new SqlParameter("ue", usernamebox.Text.Trim())); cmd.ExecuteNonQuery(); } } private void btnlogin_Click(object sender, EventArgs e) { const string CONNSTRING = @"Data Source=./SQLEXPRESS;AttachDBFilename=|DataDirectory|users.mdf;Integrated Security=True;User Instance=True"; using (SqlConnection conn = new SqlConnection(CONNSTRING)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from users where username=@ue"; cmd.Parameters.Add(new SqlParameter("ue", usernamebox.Text.Trim())); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { string db_password = reader.GetString(reader.GetOrdinal("passwords")); int db_errortimes=reader.GetInt32(reader.GetOrdinal("errortimes")); if (db_password == passwordbox.Text.Trim()) { //数据库内错误次数置0 resetErrortimes(); MessageBox.Show("登录成功"); } else { //数据库内错误次数+1 addErrortimes(); if (db_errortimes >= 3) { MessageBox.Show("程序即将退出"); Application.Exit(); } MessageBox.Show("密码错误，还剩" + (3-db_errortimes) + "次机会"); } } else { MessageBox.Show("用户名不存在"); usernamebox.Focus(); } } } }  

 

没数据库连接的文章：http://blog.csdn.net/pvfhv/archive/2010/12/20/6086909.aspx