repassword.aspx.cs

教务管理系统

using System;
using System.Data;
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;
using System.Data.SqlClient;

public partial class repassword : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Title = "教务管理系统——修改密码";
        lbtnRepwd.Enabled = false;
        if (Session["user_id"] == null)
        {
            Response.Redirect("default.aspx");
        }
    }
    protected void lbtnOK_Click(object sender, EventArgs e)
    {
        if (txtOldpwd.Text == "" || txtNewpwd.Text == "" || txtRepwd.Text == "")
        {
            lblMsg.Text = "<b>数据输入不完整，请重新输入！</b>";
            return;
        }
        if(txtNewpwd.Text != txtRepwd.Text)
        {
            lblMsg.Text = "<b>两次输入的密码不相同！</b>";
            return;
        }
        string connsql = System.Configuration.ConfigurationManager.AppSettings["connstring"];
        SqlConnection connections = new SqlConnection(connsql);
        connections.Open();
        string sqlstrings = "update users set User_password='" + txtNewpwd.Text + "' where User_id=@id";
        SqlCommand sqlcmd = new SqlCommand(sqlstrings, connections);
        sqlcmd.Parameters.Add(new SqlParameter("@id", SqlDbType.VarChar, 50));
        sqlcmd.Parameters["@id"].Value = Session["user_id"].ToString();
        try
        {
            sqlcmd.ExecuteNonQuery();
            lblMsg.Text = "<b>修改成功！</b>";
        }
        catch (SqlException)
        {
            lblMsg.Text = "<b>修改失败！</b>";

        }
        connections.Close();
    }

    protected void lbtnBack_Click(object sender, EventArgs e)
    {
        Response.Redirect("default.aspx");
    }

    protected void lbtnStuInfo_Click(object sender, EventArgs e)
    {
        Response.Redirect("stu_info.aspx");
    }

    protected void lbtnCourse_info_Click(object sender, EventArgs e)
    {
        Response.Redirect("stu_course.aspx");
    }
    
    protected void lbtnChoose_Click(object sender, EventArgs e)
    {
        Response.Redirect("choosecourse.aspx");
    }
    
    protected void lbtnGrade_Click(object sender, EventArgs e)
    {
        Response.Redirect("stu_grade.aspx");
    }
}