exitlogin.aspx.cs

基于asp.net的网上选课系统

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;


public partial class ExitLogin : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string str;
        switch(Session["userident"].ToString())
        {
            //退出登录，置数据库中相应记录的登录状态为０
            case "student":
                 str = "update Students set StudentifLogin=0 where StudentID="+Session["userid"];
                StuSQL stu = new StuSQL();
                stu.Open();
                stu.ExecuteSQL(str);
                break;
            case "teacher":
                 str = "update Teachers set TeacherifLogin=0 where TeacherID=" + Session["userid"];
                 TeaSQL tea = new TeaSQL();
                 tea.Open();
                 tea.ExecuteSQL(str);
                break;
            case "admin":
                str = "update Admins set AdminifLogin=0 where AdminID=" + Session["userid"];
                AdminSQL admin = new AdminSQL();
                admin.Open();
                admin.ExecuteSQL(str);
                break;

        }
        //Session失效
        Session.Abandon();
        Response.Redirect("index.aspx");       

    }
}