private void store_button_Click(object sender, EventArgs e) { String username = this.store_login1.Text; String password = this.store_login2.Text; Database2 db = new Database2(); MySqlConnection conn = db.getConn(); if (username.Equals("") || password.Equals("")) { MessageBox.Show("账号或密码为空"); } else { try { conn.Open(); String sql1 = String.Format("select * from user_store where username= '******' ", username); MySqlCommand comm2 = new MySqlCommand(sql1, conn); if (Convert.ToInt32(comm2.ExecuteScalar()) > 0) { String sql = String.Format("select username,password from user_store where username = '******' limit 1", username); MySqlCommand comm1 = new MySqlCommand(sql, conn); MySqlDataReader reader = comm1.ExecuteReader(); while (reader.Read()) { String username1 = reader[0].ToString(); String password1 = reader[1].ToString(); if (username1 != null && password.Equals(password1)) { MessageBox.Show("登录成功"); } else { MessageBox.Show("密码错误,请重新输入"); } } reader.Close(); } else { MessageBox.Show("账户不存在,请注册"); } } catch (Exception exception) { Console.WriteLine(exception); MessageBox.Show(exception.Message.ToString()); } finally { conn.Close(); } } }
private void 店铺注册_button_Click(object sender, EventArgs e) { String username = this.store_register_box1.Text; String password = this.store_register_box2.Text; Database2 db2 = new Database2(); MySqlConnection conn = db2.getConn(); if (username.Equals("") || password.Equals("")) { MessageBox.Show("账号密码为空"); } else { try { conn.Open(); String sql1 = String.Format("select * from `c#_store`.user_store where username= '******'", username); MySqlCommand comm1 = new MySqlCommand(sql1, conn); String sql2 = String.Format("insert into `c#_store`.user_store (username,password) values ('{0}','{1}')", username, password); MySqlCommand comm2 = new MySqlCommand(sql2, conn); if (Convert.ToInt32(comm1.ExecuteScalar()) > 0) { MessageBox.Show("账号已经注册,请登录"); Form1.form1.登录ToolStripMenuItem_Click(null, null); } else { comm2.ExecuteNonQuery(); db2.insert("注册成功"); MessageBox.Show("注册成功"); Form1.form1.登录ToolStripMenuItem_Click(null, null); } } catch (Exception exception) { Console.WriteLine(exception); } finally { conn.Close(); } } }