学生信息系统管理系统 系统源代码.doc

《学生信息系统管理系统 系统源代码.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、系统源代码一、登录界面代码usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClien

2、t;publicpartialclasslogin:System.Web.UI.Page{protectedvoidtxtid_Click(objectsender,EventArgse){txtid.Text="";txtpassword.Text="";}protectedvoidButton1_Click(objectsender,EventArgse){stringstrconn=ConfigurationManager.AppSettings["connStr"];SqlConnectionconn=newSqlConnection(strco

3、nn);conn.Open();DataSetds=newDataSet();SqlDataAdapterda=newSqlDataAdapter("select*fromuserswhereuserid='"+txtid.Text+"'anduserpwd='"+txtpassword.Text+"'",conn);da.Fill(ds);if(ds.Tables[0].Rows.Count==0){Label3.Text="账号或密码错误，请重新输入！";}else{Session["userid"]=txtid.Text;Session["user

4、pwd"]=txtpassword.Text;Session["username"]=ds.Tables[0].Rows[0]["username"].ToString();Session["userpower"]=ds.Tables[0].Rows[0]["userpower"].ToString();if(Session["userpower"].ToString()=="0"){Response.Redirect("admin/index.aspx");}elseif(Session["userpower"].ToString()=="1"){Re

5、sponse.Redirect("student/index.aspx");}else{Label3.Text="对不起，权限验证失败";}}conn.Close();ds.Clear();}}二、添加课程页面代码usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usi

6、ngSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;publicpartialclassaddcourse:System.Web.UI.Page{SqlCommandmycmd;SqlConnectionconn;protectedvoidPage_Load(objectsender,EventArgse){courseid.Attributes.Add("onblur","checkcourseid()");str

7、ingstrconn=ConfigurationManager.AppSettings["connStr"];conn=newSqlConnection(strconn);}protectedvoidButton1_Click(objectsender,EventArgse){if(courseid.Text.ToString()==""){Label7.Text="课程号不能为空";}else{stringsqlstr="";sqlstr="insertintocourse(courseid,coursename,coursetime,fen,type

8、,teacher)values('"+courseid.Text+"','"+c