一.密碼修改界面

（1）.結(jié)果展示

image.png

二. 登陸界面各控件的參數(shù)設(shè)置

控件A：Lable

控件B:TextBox

控件C:Button

三. 界面設(shè)計(jì)

1. 用戶通過點(diǎn)擊主界面上的"修改密碼"菜單，打開修改密碼界面

     private void tsmi_Password_Click(object sender, EventArgs e)
    {
        PwdForm pwdForm = new PwdForm();
        pwdForm.MdiParent = this;
        pwdForm.StartPosition = FormStartPosition.CenterScreen;
        pwdForm.Show();
    }

2. 密碼修改界面上，默認(rèn)顯示出當(dāng)前登錄的用戶名

    private void PwdForm_Load(object sender, EventArgs e)
    {
        this.tb_User.Text = UserInfo.userName;
    }

四. 實(shí)現(xiàn)密碼修改界面的密碼修改功能

  String connStr = "Data Source=.;Initial Catalog=SuperMarketSales;Integrated Security=True";
        SqlConnection sqlConn = new SqlConnection(connStr);
        try
        {
            // 連接數(shù)據(jù)庫(kù)
            sqlConn.Open();

            // 構(gòu)造命令
            String sqlStr = "update EMPLOYEE set PASSWORD=@pwd where ID=@id";
            SqlCommand cmd = new SqlCommand(sqlStr, sqlConn);

            // SQL字符串參數(shù)賦值
            cmd.Parameters.Add(new SqlParameter("@pwd", newPwd));
            cmd.Parameters.Add(new SqlParameter("@id", UserInfo.userId));

            // 將命令發(fā)送給數(shù)據(jù)庫(kù)
            int res = cmd.ExecuteNonQuery();

            // 根據(jù)返回值判斷是否修改成功
            if (res != 0)
            {
                MessageBox.Show("密碼修改成功");
                this.Close();
            }
            else
            {
                MessageBox.Show("密碼修改錯(cuò)誤");
            }
        }
        catch (Exception exp)
        {
            MessageBox.Show("訪問數(shù)據(jù)庫(kù)錯(cuò)誤：" + exp.ToString());
        }
        finally
        {
            sqlConn.Close();
        }
    }

五.修改密碼界面細(xì)節(jié)設(shè)計(jì)代碼

      // 在“新密碼”輸入框中按“回車”，光標(biāo)跳轉(zhuǎn)到“確認(rèn)密碼”輸入框
        private void tb_NewPwd_KeyPress(object sender, KeyPressEventArgs e)
    {
        if (e.KeyChar == (char)Keys.Enter)
        {
            SendKeys.Send("{tab}");
        }
    }

    // 在“確認(rèn)密碼”輸入框中按“回車”，則直接修改密碼
    private void tb_ConfirmPwd_KeyPress(object sender, KeyPressEventArgs e)
    {
        if (e.KeyChar == (char)Keys.Enter)
        {
            this.bt_Ok_Click(sender, e);
        }
    }
}