login.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 Login : System.Web.UI.Page
{
    
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    { 
        string connStr = System.Configuration .ConfigurationSettings.AppSettings["ConnectionString"];
        SqlConnection conn = new SqlConnection(connStr);
        try
        {
        string userName = txtUserName.Text.ToString().Trim();
        string userPwd = txtPwd.Text.ToString().Trim();
        string userRole = rblClass.SelectedValue.Trim();
        string selectStr = "";
        switch (userRole)
        {
            case "0":
                selectStr = "Select* from Teacher where teaID='" + userName + "'";
                break;
            case "1":
                selectStr = "Select* from Student where stuID='" + userName + "'";
                break;
            case "2":
                selectStr = "Select* from Users where adminName='" + userName + "'";
                break;
        }
       
        
       
            SqlCommand cmd = new SqlCommand(selectStr, conn);
            conn.Open();
            int i = cmd.ExecuteNonQuery();       
            SqlDataReader sdr = cmd.ExecuteReader();
            if (sdr.Read())
            {
                if (sdr.GetString(1) == userPwd)
                {
                    Session["userName"] = userName;
                    Session["userRole"] = userRole;
                    conn.Close();
                    switch (userRole)
                    {
                        case "0":
                            Response.Redirect("TeacherQueryElect.aspx");
                            break;
                        case "1":
                            Response.Redirect("xuesheng2.aspx");
                            break;
                        case "2":
                            Response.Redirect("Main.aspx");
                            break;
                    }
                }
                else
                    lblMessage.Visible = true;
                lblMessage.Text = "您输入的密码错误，请检查后重新输入！";
            }
            else
                lblMessage.Visible = true;
                lblMessage.Text = "该用户不存在或用户名输入错误，请检查后重新输入！";
        }
        catch (Exception ee)
        {
            Response.Write("<script language=javascript>alert('" + ee.Message.ToString() + "')</script>");
        }
        finally
        {
            conn.Close();
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        this.Button2.Attributes.Add("onclick", "window.close();"); 
    }
}