public void zhanghao_Leave(object sender, EventArgs e) { var regex2 = new Regex(@" (?=.*[0-9]) #必须包含数字 (?=.*[a-zA-Z]) #必须包含小写或大写字母 #必须包含特殊符号 .{6,20} #至少6个字符,最多20个字符 ", RegexOptions.Multiline | RegexOptions.IgnorePatternWhitespace); //校验密码是否符合 bool pwdIsMatch2 = regex2.IsMatch(zhanghao.Text); Console.WriteLine(pwdIsMatch2); if (pwdIsMatch2 == true) { MysqlDB mysqlDB; mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456"); try { string sql = "select 管理员账号 from management"; Console.WriteLine(sql); var res = mysqlDB.Get(sql); List <string> list = new List <string>(); while (res.Read()) { string str = res.GetString("管理员账号"); list.Add(str); } if (list.Contains(zhanghao.Text)) { errorProvider1.SetError(zhanghao, "管理员账号已存在!"); Console.WriteLine("正确"); } else if (string.IsNullOrEmpty(zhanghao.Text)) { errorProvider1.SetError(zhanghao, "不能为空!"); } else { errorProvider1.Clear(); } //var res1 = mysqlDB.Edit(sql1); } catch (System.FormatException) { MessageBox.Show("输入格式错误"); } } else if (pwdIsMatch2 == false) { errorProvider1.SetError(zhanghao, "账号必须在8-30位之间,且需要包含数字和字母!"); } //ErrorProvider errorProvider = new ErrorProvider(); }
public void showDate() { mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456"); string sql = "select * from well"; var reader = mysqlDB.Get(sql); while (reader.Read()) { int index = this.dataGridView1.Rows.Add(); for (int i = 0; i < dataGridView1.Columns.Count; i++) { this.dataGridView1.Rows[index].Cells[i].Value = reader[i]; } } }
private void lookup_Click(object sender, EventArgs e) { if (num.Text != "") { string sql = "select * from 井眼轨迹表 where 井号='" + num.Text + "'"; var reader = mysqlDB.Get(sql); dataGridView1.Rows.Clear(); while (reader.Read()) { int index = this.dataGridView1.Rows.Add(); for (int i = 0; i < dataGridView1.Columns.Count; i++) { this.dataGridView1.Rows[index].Cells[i].Value = reader[i]; } } } }
private void lookup_Click(object sender, EventArgs e) { mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456"); string sql = "select * from shuihua where 井号='" + num.Text + "'"; var reader = mysqlDB.Get(sql); dataGridView1.Rows.Clear(); while (reader.Read()) { int index = this.dataGridView1.Rows.Add(); for (int i = 0; i < dataGridView1.Columns.Count; i++) { this.dataGridView1.Rows[index].Cells[i].Value = reader[i]; } } }
public void showDate() { mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456"); string sql = "select * from 钻井液沿裂缝压力穿透效应及钻井液有效封堵性对井壁稳定性表"; var reader = mysqlDB.Get(sql); while (reader.Read()) { int index = this.dataGridView1.Rows.Add(); for (int i = 0; i < dataGridView1.Columns.Count; i++) { this.dataGridView1.Rows[index].Cells[i].Value = reader[i]; } } //绑定数据集 num.DataSource = mysqlDB.getWellNum(); }
public void showDate() { dataGridView1.Columns[6].DefaultCellStyle.Format = "yyyy-MM-dd hh:mm:ss"; mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456"); string sql = "select * from 井眼轨迹表"; var reader = mysqlDB.Get(sql); while (reader.Read()) { int index = this.dataGridView1.Rows.Add(); for (int i = 0; i < dataGridView1.Columns.Count; i++) { this.dataGridView1.Rows[index].Cells[i].Value = reader[i]; } } //绑定数据集 num.DataSource = mysqlDB.getWellNum(); }
//用户登录 private void button1_Click(object sender, EventArgs e) { //检查账户密码是否为空 if (textBox1.Text == "" || textBox2.Text == "" || (radioButton1.Checked == false && radioButton2.Checked == false)) { MessageBox.Show("你的账号,密码为空,或者你没用选择身份按钮"); } else { var regex1 = new Regex(@" (?=.*[0-9]) #必须包含数字 #(?=.*[a-zA-Z])必须包含小写或大写字母 .{6,20} #至少8个字符,最多30个字符 ", RegexOptions.Multiline | RegexOptions.IgnorePatternWhitespace); //校验密码是否符合 bool pwdIsMatch1 = regex1.IsMatch(textBox1.Text); var regex2 = new Regex(@" (?=.*[0-9]) #必须包含数字 (?=.*[a-zA-Z]) #必须包含小写或大写字母 (?=([\x21-\x7e]+)[^a-zA-Z0-9]) #必须包含特殊符号 .{6,20} #至少8个字符,最多30个字符 ", RegexOptions.Multiline | RegexOptions.IgnorePatternWhitespace); //校验密码是否符合 bool pwdIsMatch2 = regex2.IsMatch(textBox2.Text); if (pwdIsMatch2 == true && pwdIsMatch1 == true) { //登录数据库验证密码 MysqlDB mysqlDB; mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456"); //string type = null; string username = textBox1.Text.Trim(); string userpassword = textBox2.Text.Trim(); //sql语句(谨慎使用drop,delete!!!) string sql = "SELECT 管理员账号,管理员密码 FROM management"; string sql1 = "SELECT 用户账号,用户密码 FROM user"; if (textBox1.Text.Equals("") & textBox2.Text.Equals("")) { MessageBox.Show("用户名或密码不能为空"); } else { if (radioButton1.Checked) { var reader = mysqlDB.Get(sql); Dictionary <string, string> qqDict = new Dictionary <string, string>();// 用户密码字典 if (reader != null) { while (reader.Read()) { string name = reader.GetString("管理员账号"); string pwd = reader.GetString("管理员密码"); qqDict.Add(name, pwd); } if (textBox2.Text.Equals("")) { MessageBox.Show("密码不能为空"); } else { String loginName = textBox1.Text; //User.Name = textBox1.Text;//将登陆名的text创给类的静态字段 if (qqDict.ContainsKey(loginName)) { if (textBox2.Text.Equals(qqDict[textBox1.Text])) { //MessageBox.Show("密码正确"); //if(radioButton1.Checked) //管理员界面显示 kaiguan = true; Form1 a = new Form1(); a.ShowDialog(); this.Hide(); } else { MessageBox.Show("密码错误"); } } else { MessageBox.Show("无此用户名"); } } } else { MessageBox.Show("出现网络连接问题"); } } else { var reader = mysqlDB.Get(sql1); Dictionary <string, string> qqDict = new Dictionary <string, string>();// 用户密码字典 if (reader != null) { while (reader.Read()) { string name = reader.GetString("用户账号"); string pwd = reader.GetString("用户密码"); qqDict.Add(name, pwd); } if (textBox2.Text.Equals("")) { MessageBox.Show("密码不能为空"); } else { String loginName = textBox1.Text; //User.Name = textBox1.Text;//将登陆名的text创给类的静态字段 if (qqDict.ContainsKey(loginName)) { if (textBox2.Text.Equals(qqDict[textBox1.Text])) { //MessageBox.Show("密码正确"); //用户界面显示 Form1 form1 = new Form1(); form1.ShowDialog(); } else { MessageBox.Show("密码错误"); } } else { MessageBox.Show("无此用户名"); } } } else { MessageBox.Show("出现网络连接问题"); } } } //Console.WriteLine("") } else { MessageBox.Show("请检验你输入的密码中是否含有特殊字符或空格,密码长度在6-20位,请重新输入"); } } //检验输入的密码 }