/// <summary> /// 窗体导入 /// </summary> private void StudentManagement_Load(object sender, EventArgs e) { //定义SQL语句 string mySQL1 = "select * from StuInfo"; //获取列名 ArrayList al = getColumnName(mySQL1); //初始化combobox1和4 comboBox1.Items.Clear(); comboBox4.Items.Clear(); for (int i = 0; i < al.Count; i++) { comboBox1.Items.Add(al[i]); //设置检索条件字段 comboBox4.Items.Add(al[i]); //设置排序字段 } //初始化单选按钮 radioButton1.Checked = false; radioButton2.Checked = false; //初始化combox2 comboBox2.Items.Clear(); comboBox2.Items.Add("="); comboBox2.Items.Add(">"); comboBox2.Items.Add("<"); comboBox2.Items.Add("like"); //初始化textbox1 textBox1.Text = ""; //设置数据dataGridView控件数据源 operateResult = Administrator.OperateDB(mySQL1); daSe = (DataSet)operateResult[1]; ada = (OleDbDataAdapter)operateResult[0]; //新建dataview对象 dv = daSe.Tables["information"].DefaultView; dataGridView1.DataSource = dv; }
/// <summary> /// 点击重置密码按钮 /// </summary> private void button1_Click(object sender, EventArgs e) { //获取更改的账户信息 string userName = textBox1.Text; string passWord = textBox2.Text; string newPasWrd = textBox3.Text; string reNewPasWrd = textBox4.Text; //SQL语句,账户查询 string mySQL1 = "select UserId from UserInfo where UserId = '" + userName + "'"; //SQL语句,账户密码查询 string mySQL2 = "select UserPwd from UserInfo where UserId = '" + userName + "'"; if (userName != "" && passWord != "" && newPasWrd != "" && reNewPasWrd != "") { //获取查询后的数据 operateResult = Administrator.OperateDB(mySQL1); daSe = (DataSet)operateResult[1]; if (daSe.Tables["information"].Rows.Count == 0) { MessageBox.Show("用户不存在!", "错误提示", MessageBoxButtons.OK); //重置窗体 textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox1.Focus(); } else if (textBox3.Text.Length > 10) { MessageBox.Show("密码长度超过10位,请重新输入!", "错误提示框", MessageBoxButtons.OK); textBox3.Text = ""; textBox4.Text = ""; textBox3.Focus(); } else if (textBox3.Text.Length < 6) { MessageBox.Show("密码长度不足6位,请重新输入!", "错误提示框", MessageBoxButtons.OK); textBox3.Text = ""; textBox4.Text = ""; textBox3.Focus(); } else if (newPasWrd != reNewPasWrd) { MessageBox.Show("两次输入的重设密码不一致!", "错误提示", MessageBoxButtons.OK); //初始化窗体 textBox3.Text = ""; textBox4.Text = ""; textBox3.Focus(); } else { operateResult = Administrator.OperateDB(mySQL2); daSe = (DataSet)operateResult[1]; if (daSe.Tables["information"].Rows[0][0].ToString() != passWord) { MessageBox.Show("原始密码错误,请重新输入!", "错误提示", MessageBoxButtons.OK); //初始化窗体 textBox2.Text = ""; textBox2.Focus(); } else { //SQL语句,更新密码 string mySQL3 = "update UserInfo set UserPwd = '" + textBox3.Text + "' where UserId = '" + userName + "'"; Administrator.OperateDBbyCom(mySQL3); MessageBox.Show("密码更改成功!", "提示", MessageBoxButtons.OK); //重置窗体 textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox1.Focus(); } } } else { MessageBox.Show("请填写完整的信息!", "错误提示", MessageBoxButtons.OK); } }