default.aspx.cs

教务管理系统

using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Title = "登录系统";
        txtUsername.Focus();
    }
    protected void TextBox2_TextChanged(object sender, EventArgs e)
    {

    }
    protected void btnLogin_Click(object sender, EventArgs e)
    {
        //string connsql = ConfigurationSettings.AppSettings["connstring"];
        if (txtUsername.Text == "" || txtPassword.Text == "")
        { 
            Response.Write("<script language=javascript>alert('用户名或密码不得为空！');</script>");
            return;
        }
        string connsql = System.Configuration.ConfigurationManager.AppSettings["connstring"];
        SqlConnection conn = new SqlConnection(connsql);
        conn.Open();//连接数据库

        string strSql = "select * from users where User_id='" + txtUsername.Text + "'and User_password='" + txtPassword.Text + "'";
        SqlCommand com = new SqlCommand(strSql, conn);
        SqlDataReader dr = com.ExecuteReader();
        if (dr.Read())
        {
            Session["User_id"] = dr["User_id"];
            Session["user_lever"] = dr["User_lever"];
            if ((int)Session["User_lever"] == 0)
            {
                Response.Redirect("stu_info.aspx");
            }
            else
            {
                Response.Redirect("admin_stu.aspx");
            }
        }
        else
        {
            Response.Write("<script language=javascript>alert('登录失败！');</script>");

        }
        dr.Close();
        conn.Close();
    }
    protected void btnRepwd_Click(object sender, EventArgs e)
    {
        if (txtUsername.Text == "" || txtPassword.Text=="")
        { 
            Response.Write("<script language=javascript>alert('请输入用户名和现有密码！');</script>");
            return;
        }
        string connsql = System.Configuration.ConfigurationManager.AppSettings["connstring"];
        SqlConnection conn = new SqlConnection(connsql);
        conn.Open();//连接数据库

        string strSql = "select * from users where User_id='" + txtUsername.Text + "'and User_password='" + txtPassword.Text + "'";
        SqlCommand com = new SqlCommand(strSql, conn);
        SqlDataReader dr = com.ExecuteReader();
        if (dr.Read())
        {
            if ((int)dr["User_lever"] == 0)
            {
                Response.Write("<script language=javascript>alert('你无权使用本功能');</script>");
            }
            else
            { 
                dr.Close();
                conn.Close();
                Session["User_id"] = txtUsername.Text;
                Response.Redirect("admin_repwd.aspx");
            }            
        }
        else
        {            
            Response.Write("<script language=javascript>alert('用户名或密码错！');</script>");
        }
        
    }
}