private void submit_Click(object sender, EventArgs e) { string ac = account.Text; string passwd = password.Text; string rep = repasswd.Text; if (passwd == rep) { MYSQL mYSQL = new MYSQL(); MySqlConnection conn = mYSQL.Connection(); conn.Open(); string sql = string.Format("INSERT INTO Login VALUES('{0}', 'kkk', '{1}', 'User');", ac, passwd); MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); MessageBox.Show("注册成功,即将返回登陆界面..."); login login = new login(); this.Dispose(); login.ShowDialog(); } else { MessageBox.Show("密码不一致,请重新输入!"); } }
private void admindex_Load(object sender, EventArgs e) { AdminIndexTable.Enabled = false; AdminIndexTable.Visible = false; MYSQL mYSQL = new MYSQL(); MySqlConnection conn = mYSQL.Connection(); conn.Open(); string [] sql = { "SELECT COUNT(*) Num FROM Person WHERE HealthStatus = 'Sick';", "SELECT COUNT(*) Num FROM Person WHERE HealthStatus = 'Fever';", "SELECT COUNT(*) Num FROM Situation WHERE RiskLevel = 'L1';", "SELECT COUNT(*) Num FROM Login WHERE Type = 'Admin';" }; string[] res = new string[4]; for (int i = 0; i < 4; i++) { MySqlCommand cmd = new MySqlCommand(sql[i], conn); MySqlDataAdapter adapter = new MySqlDataAdapter(cmd); DataSet dataSet = new DataSet(); adapter.Fill(dataSet); res[i] = dataSet.Tables[0].Rows[0]["Num"].ToString(); } conn.Close(); ConfirmedCases.Text += res[0]; LikelyInfection.Text += res[1]; HighRiskArea.Text += res[2]; AdminCounts.Text += res[3]; }
private void Exec_SQL(string sql) { MYSQL mYSQL = new MYSQL(); MySqlConnection conn = mYSQL.Connection(); conn.Open(); MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); conn.Close(); }
private int Exec_SQL(string sql) { MYSQL mYSQL = new MYSQL(); MySqlConnection conn = mYSQL.Connection(); conn.Open(); MySqlCommand cmd = new MySqlCommand(sql, conn); int res = cmd.ExecuteNonQuery(); conn.Close(); return(res); }
//登陆 private void button1_Click(object sender, EventArgs e) { string account = textBox1.Text; string type = loginType.Text; string passwd = textBox2.Text; MYSQL mYSQL = new MYSQL(); MySqlConnection conn = mYSQL.Connection(); conn.Open(); string sql = string.Format("SELECT * FROM Login WHERE Account='{0}' AND Passwd='{1}';", account, passwd); MySqlCommand cmd = new MySqlCommand(sql, conn); object result = cmd.ExecuteScalar(); if (result != null) { if (type == "User") { user user = new user(); this.Dispose(); user.ShowDialog(); } else if (type == "Admin") { admin admin = new admin(); this.Dispose(); admin.ShowDialog(); } else { MessageBox.Show("请选择账户类型!"); } } else { MessageBox.Show("账号或密码错误,请重新输入!"); } conn.Close(); }