private void button1_Click(object sender, EventArgs e) { try { username = user_tb.Text.Trim(); string cha = "select * from contractUser where userName='******'"; DataSet ds = tools.ExceDS(cha); if (user_tb.Text.Length <= 0 || pass_tb.Text.Length <= 0 || pass_tb2.Text.Length <= 0)//检查用户名密码是否为空 { MessageBox.Show("用户名或密码不可为空,请重新输入", "用户名密码不可为空"); } else if (user_tb.Text.Length < 6 || pass_tb.Text.Length < 6 || pass_tb2.Text.Length < 6) { MessageBox.Show("用户名密码需要大于六个字符,请重新输入用户名密码", "注册错误"); //检查用户名密码是否小于六个字符 } else if (ds.Tables[0].Rows.Count >= 0) //验证用户名是否重复 { MessageBox.Show("用户名已被注册,请更改用户名", "注册失败", MessageBoxButtons.OK); } else if (password1 != password2)//验证重复密码和密码是否相同 { MessageBox.Show("两次密码不相同,请重新输入密码", "注册失败", MessageBoxButtons.OK); pass_tb.Clear(); pass_tb2.Clear(); } else//向数据库添加数据,即注册功能 { string zc = "insert into contractUser (userName,userMiMa) values ('" + username + "','" + password1 + "')"; tools.ExecuteNonQuery(zc); MessageBox.Show("恭喜你注册账号成功\n正在进行跳转,请稍后。。。。"); this.Hide(); frmLogin f = new frmLogin(); f.Show(); } } catch (SqlException ex) { MessageBox.Show("系统错误,请稍后再试", "系统错误"); } finally { } }//注册功能
public void pdModify() { string user = u_tb.Text.Trim(); string oldpass = old_pass.Text.Trim(); string newpass = new_pass.Text.Trim(); string lookintoUser = "******" + user + "'"; string lookintoPass = "******" + user + "' and userPd = '" + oldpass + "'"; DataSet lkuser = tools.ExceDS(lookintoUser); DataSet lkpass = tools.ExceDS(lookintoPass); if (lkuser.Tables[0].Rows.Count <= 0) //验证用户名是否存在 { MessageBox.Show("您输入的账户有误,请输入正确的账户", "账号错误"); } else if (lkpass.Tables[0].Rows.Count <= 0) //验证密码是否正确 { MessageBox.Show("您输入的密码有误,请核对后重新输入密码", "密码错误"); old_pass.Clear(); } else if (oldpass == newpass) //验证新旧密码不能相同 { MessageBox.Show("新密码不能与旧密码相同", "密码错误"); new_pass.Clear(); new_pass2.Clear(); } else if (new_pass.Text.Trim() != new_pass2.Text.Trim()) //验证重复密码与新密码相同 { MessageBox.Show("重复密码与新密码不相同,请重新输入", "新密码出错"); } else //修改密码功能 { string revisePass = "******" + newpass + "' where userName='******'"; tools.ExecuteNonQuery(revisePass); MessageBox.Show("恭喜你,密码更改成功\n正在跳转前往登录界面。。。。", "更改成功"); frmLogin f = new frmLogin(); f.Show(); this.Close(); } }
private void button1_Click(object sender, EventArgs e) { string user = user_tb.Text.Trim(); string pass = pass_tb.Text.Trim(); string lookinto = "select * from contractUser where userName='******' and userMiMa = '" + pass + "'"; DataSet lkinto = tools.ExceDS(lookinto); if (lkinto.Tables[0].Rows.Count <= 0) { MessageBox.Show("您的账号或密码有误,请查验后在试", "错误"); } else { DialogResult TorF = MessageBox.Show("您真的要注销账户吗???(注销账户后,一切资料将丢失)", "请确认", MessageBoxButtons.OKCancel); if (TorF == DialogResult.OK) { string del = "delete from contractUser where userName='******' and userMiMa = '" + pass + "'"; tools.ExecuteNonQuery(del); MessageBox.Show("您的账号已注销", "注销成功"); } } }