//点击登陆时事件处理 private void register_Click(object sender, EventArgs e) { try { if (username.Text != "" && password.Text != "") { MySqlCommand command = Con.CreateCommand(); command.CommandText = string.Format("insert into users values('{0}','{1}')", username.Text, password.Text); command.ExecuteNonQuery(); MessageBox.Show("注册成功!"); page = new user_page(Con); this.Hide(); page.ShowDialog(); } else { MessageBox.Show("请输入用户名和密码!"); } } catch (Exception exp) { MessageBox.Show(exp.Message); } }
//private void windowClose(object sender, EventArgs e) //{ // try // { // Con.Close(); // Application.ExitThread(); // } // catch (Exception exp) // { // MessageBox.Show(exp.Message); // } //} //点击登陆时事件处理 private void yes_Click(object sender, EventArgs e) { MySqlCommand command; MySqlDataReader reader; bool flag = false; try { //MessageBox.Show("success"); string select = "select username,password from users"; //从数据库中打开users表格 command = new MySqlCommand(select, Con); //得到查询结果, reader = command.ExecuteReader(); //read()方法每次读取一行,循环遍历数据表 while (reader.Read()) { string user = reader["username"].ToString(); string pwd = reader["password"].ToString(); if (username.Text.ToString() == user.Trim() && password.Text.ToString() == pwd.Trim()) { flag = true; } } if (flag) { //关闭数据表读取操作 reader.Close(); //新窗体实例化 page = new user_page(Con); //当前窗体隐藏 this.Hide(); page.ShowDialog(); } else { MessageBox.Show("用户名或密码输入错误!"); reader.Close(); //清空控件内容 username.Clear(); password.Clear(); //设置该控件为光标焦点 username.Focus(); } }catch (Exception exp) { MessageBox.Show(exp.Message); } }
private void exit_Click(object sender, EventArgs e) { page = new user_page(con); this.Hide(); page.ShowDialog(); }