pwdchange.aspx.cs

学生选课管理系统 谁想要的找我qq564633432

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class admin_pwdchange : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void imgBtnConfirm_Click(object sender, ImageClickEventArgs e)
    {
        string userName = Session["Username"].ToString();
        string oldPwd = txtOldPwd.Text.Trim();
        string newPwd = txtNewPwd.Text.Trim();
        string selectStr = "";
        string updateStr = "";
        switch (Session["Userrole"].ToString())
        {
            case "tea":                       //身份为教师时              
                selectStr = "Select * from Teacher where Teaid = '" + userName + "' and Pwd='" + oldPwd + "'";
                updateStr = "update  Teacher set Pwd='" + newPwd + "' where Teaid='" + userName + "'";
                break;
            case "stu":                       //身份为学生时
                selectStr = "Select * from Student where Sno = '" + userName + "' and Pwd='" + oldPwd + "'";
                updateStr = "update  Student set Pwd='" + newPwd + "' where Sno='" + userName + "'";
                break;
            case "adm":                       //身份为管理员时
                selectStr = "Select * from admin where Name = '" + userName + "' and Pwd='" + oldPwd + "'";
                updateStr = "update  admin set Pwd='" + newPwd + "' where Name='" + userName + "'";
                break;
        }
        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["web"]);
        SqlCommand selectCmd = new SqlCommand(selectStr, conn);
        try
        {
            conn.Open();
            SqlDataReader sdr = selectCmd.ExecuteReader();
            if (sdr.Read())                 //如果用户存在且输入密码正确，修改密码
            {
                sdr.Close();
                SqlCommand updateCmd = new SqlCommand(updateStr, conn);
                int i = updateCmd.ExecuteNonQuery();
                if (i > 0)                  //根据修改后返回的结果给出提示
                {
                    Response.Write("成功修改密码！");
                }
                else
                {
                    Response.Write("修改密码失败！");
                }
            }
            else
            {
                Response.Write("您输入的密码错误，检查后重新输入！");
            }
        }
        catch (System.Exception ee)         //系统出错，错误处理
        {
            Response.Write("系统出错，错误原因：" + ee.Message.ToString());
        }
        finally
        {
            conn.Close();
        }
    }
    protected void imgBtnReset_Click(object sender, ImageClickEventArgs e)
    {
        txtOldPwd.Text = "";
        txtNewPwd.Text = "";
        txtConfirmPwd.Text = "";
    }
}