學(xué)生信息管理系統(tǒng)系統(tǒng)源代碼

1、系統(tǒng)源代碼一、登錄界面代碼using System;using ;using ;using ;using ;usingpartial class login :protected void txtid_Click(objectsender, EventArgs e);protected void Button1_Click(object sender, EventArgs e)string strconn = connStr;SqlConnection conn = new SqlConnection(strconn);();DataSetds=new DataSet () ;SqlDataA

2、dapter da = new SqlDataAdapter(select * from users whereuserid= + and userpwd= + + , conn);(ds);if 0.=0)Label3 .Text =賬號(hào)或密碼錯(cuò)誤，請(qǐng)重新輸入！;elseSession userid=txtid .Text ;Sessionuserpwd = ;Sessionusername = 0.Rows0username.ToString();Sessionuserpower = 0.Rows0userpower.ToString();if (Sessionuserpower.ToSt

3、ring () = 0)(admin/);else if (Sessionuserpower.ToString() = 1)(student/);else= 對(duì)不起，權(quán)限驗(yàn)證失敗;();();二、添加課程頁(yè)面代碼using System;using ;using ;using ;using ;usingpartial class addcourse :SqlCommand mycmd;SqlConnection conn;protected void Page_Load(object sender, EventArgs e)onblur, checkcourseid();string strc

4、onn = connStr;conn = new SqlConnection(strconn);protected void Button1_Click(object sender, EventArgs e)if = )= 課程號(hào)不能為空;elsestring sqlstr = ;sqlstr = insert intocourse(courseid,coursename,coursetime,fen,type,teacher)values( + + ,+ , + + , + + , + + , + + ); ();mycmd = new SqlCommand(sqlstr, conn); (

5、);try();(javascript:alert(添加成功!););catch (SqlException)(javascript:alert(添加失敗!););finally();sqlstr = ;protected void Button2_Click(object sender, EventArgs e);protected void Button3_Click(object sender, EventArgs e)();三、添加成績(jī)程序代碼using System;using ;using ;using ;using ;usingpartial class addscore :Sq

6、lCommand mycmd;SqlConnection conn;protected void Page_Load(object sender, EventArgs e)string strconn = connStr;conn = new SqlConnection(strconn);protected void Button1_Click(object sender, EventArgs e)if .ToString ()= )= 學(xué)號(hào)不能為空;elsestring sqlstr = ;sqlstr = insert intoscore(userid,username,courseid,

7、coursename,score,year)values( + + ,+ , + + , + + , + + , + + ); ();mycmd = new SqlCommand(sqlstr, conn); ();try();(javascript:alert(添加成功!););catch (SqlException)(javascript:alert(添加失敗!););finally();sqlstr = ;protected void Button2_Click(object sender, EventArgs e);protected void Button3_Click(object

8、 sender, EventArgs e)();protected void userid_SelectedIndexChanged(object sender, EventArgs e)string sqlstr = ;sqlstr = select username from students where userid= + + ;();mycmd = new SqlCommand(sqlstr, conn);();SqlDataReader da;da = ();while ()= dausername.ToString();protectedvoidtxtcourseid_Select

9、edIndexChanged(objectsender,EventArgse)string sqlstr = ;sqlstr = select coursename from course where courseid= + + ;();mycmd = new SqlCommand(sqlstr, conn);();SqlDataReader da;da = ();while ()= dacoursename.ToString();四、添加學(xué)生程序代碼using System;using ;using ;using ;using ;using ;using ;usingpartial clas

10、s addstudent :SqlCommand mycmd;protected void Page_Load(object sender, EventArgs e)onblur, checkuserid();string strconn = connStr;SqlConnection conn = new SqlConnection(strconn);protected void Button1_Click(object sender, EventArgs e)if = )return;string strconn = connStr;SqlConnection conn = new Sql

11、Connection(strconn);string sqlstr = ;string sql = ;sqlstr = insert intostudents(userid,username,sex,minzu,birthday,class,comefrom,beizhu,xuey,zhuany,tel,idc,zhengzmm,zhiw,huoj,weij)values( + + , + + , + +, + + , + + , + + , + + , + + , + + , + +, + + , + + , + + , + + , + + , + + );();mycmd = new Sq

12、lCommand(sqlstr, conn);();string name =獲取上傳文件的名稱(chēng)string type = () + 1);alue = wpath;();oString();string sql = select courseid from course where courseid= + nam +;SqlCommand DBHelper;DBHelper = new SqlCommand(sql, conn);();SqlDataReader dr = ();if ()(該課程號(hào)已經(jīng)存在，請(qǐng)換一個(gè));else(該課程號(hào)可以使用);();六、檢查學(xué)號(hào)唯一性程序代碼using

13、 System;using ;using ;using ;using ;usingpartial class checkuser :protected void Page_Load(objectsender, EventArgs e)= 0;string strconn = connStr;SqlConnection conn = new SqlConnection(strconn);string nam = name.ToString();stringsql= selectuseridfromstudentswhere userid=+ nam + ;SqlCommand DBHelper;

14、DBHelper = new SqlCommand(sql, conn);();SqlDataReader dr = ();if ()(該學(xué)號(hào)已經(jīng)存在，請(qǐng)換一個(gè));else(該學(xué)號(hào)可以使用);();七、課程信息程序代碼using System;using ;using ;using ;using ;usingpartial class course :SqlConnection conn;SqlDataReader getdata;protected void Page_Load(object sender, EventArgs e)string strconn = connStr;conn

15、= new SqlConnection(strconn);SqlDataReader getdata;SqlCommand mycmd;DataSet ds = new DataSet();string sql = ;sql = select * from course order by courseid;mycmd = new SqlCommand(sql, conn);();getdata = ();getdata;();();();protected void Button1_Click(object sender, EventArgs e)DataSet ds;SqlDataReade

16、r da;string strsql = ;SqlCommand cmd;();strsql = select * from course where courseid= + + or coursenamelike + + ;cmd = new SqlCommand(strsql, conn);da = ();da;();();();八、編輯、刪除學(xué)生信息程序代碼using System;using ;using ;using ;using ;usingpartial class images_editstudent :SqlCommand cmd;SqlCommand cmd2;protec

17、ted void Page_Load(object sender, EventArgs e)if (!string sql = ;SqlDataReader reader;string uid = ;uid = id;string strconn = connStr;SqlConnection conn = new SqlConnection(strconn);sql = select * from students where userid= + uid + ;SqlCommand cmd;cmd = new SqlCommand(sql, conn);();reader = ();whil

18、e ()= readeruserId.ToString();readerusername.ToString();readersex.ToString();readerminzu.ToString();readerbirthday.ToString();readerclass.ToString();readercomefrom.ToString();readerxuey.ToString();readerzhuany.ToString();readertel.ToString();readeridc.ToString();();sql = ;();protected void Button1_C

19、lick(object sender, EventArgs e)string uid=;uid=Page .Request id;string strconn = connStr;SqlConnection conn = new SqlConnection(strconn);string sql=;sql = update students set userid= + + ,username= + +,minzu= + + ,sex= + + ,birthday= + + ,class= + +,comefrom= + + ,beizhu= + + ,xuey= + + ,zhuany= +

20、+,tel= + + ,idc= + + ,zhengzmm= + + where userid= + uid +;cmd=new SqlCommand (sql,conn );();try();color = blue;= 編輯成功;(javascript:alert(編輯成功!););catch(SqlException )= 編輯失敗;color = red;();();protected void Button2_Click(object sender, EventArgs e)string sql = ;string uid = ;string sqlall = ;uid = id;

21、string strconn = connStr;SqlConnection conn = new SqlConnection(strconn);sql = delete from students where userid= + uid + ;sqlall = delete from images where userid= + uid + ;cmd = new SqlCommand(sql, conn);cmd2 = new SqlCommand(sqlall,conn);();try();string sql1 = ;sql1 = delete from users where user

22、id= + uid + ;SqlCommand cmd1 = new SqlCommand(sql1, conn);();try();color = blue;= 刪除成功;(javascript:alert(刪除成功!););catch (SqlException)= 刪除失敗;(javascript:alert(刪除失敗!););finallysql1 = ;catch(SqlException )= 刪除失敗;color = red;();();= ;protected void Button3_Click(object sender, EventArgs e)();九、編輯、刪除課程信

23、息程序代碼using System;using ;using ;using ;using ;usingpartial class editcourse :SqlCommand cmd;protected void Page_Load(object sender, EventArgs e)if (!string sql = ;SqlDataReader reader;string uid = ;uid = id;string strconn = connStr;SqlConnection conn = new SqlConnection(strconn);sql = select * from

24、course where courseid= + uid + ;SqlCommand cmd;cmd = new SqlCommand(sql, conn);();reader = ();while ()readercourseid.ToString();readercoursename.ToString();readercoursetime.ToString();readerfen.ToString();readertype.ToString();readerteacher.ToString();();sql = ;();protected void Button1_Click(object

25、 sender, EventArgs e)string uid = ;uid = id;string strconn = connStr;SqlConnection conn = new SqlConnection(strconn);string sql = ;sql = update course set courseid= + + ,coursename= + +,coursetime= + + ,fen= + + ,type= + + ,teacher= + + where courseid= + uid + ;cmd = new SqlCommand(sql, conn);();try

26、();= 編輯成功;(javascript:alert(編輯成功!););catch (SqlException)= 編輯失敗;();();protected void Button2_Click(object sender, EventArgs e)string sql = ;string uid = ;uid = id;string strconn = connStr;SqlConnection conn = new SqlConnection(strconn);sql = delete from course where courseid= + uid + ;cmd = new SqlC

27、ommand(sql, conn);();try();= 刪除成功;(javascript:alert(刪除成功!););catch (SqlException)= 刪除失敗;();();protected void Button3_Click(object sender, EventArgs e)();十、編輯、刪除成績(jī)信息程序代碼using System;using ;using ;using ;using ;usingpartial class editscore :SqlCommand cmd;SqlConnection conn;protected void Page_Load(ob

28、ject sender, EventArgs e)if (!string sql = ;SqlDataReader reader;string uid = ;uid = id;string strconn = connStr;conn = new SqlConnection(strconn);sql = select * from score where id= + uid + ;SqlCommand cmd;cmd = new SqlCommand(sql, conn);();reader = ();while ()readerid.ToString();readeruserid.ToStr

29、ing();readerusername.ToString();readercourseid.ToString();readercoursename.ToString();readerscore.ToString();();sql = ;();protected void Button1_Click(object sender, EventArgs e)string uid = ;uid = id;string sql = ;string strconn = connStr;conn = new SqlConnection(strconn);sql = update score set use

30、rid= + + ,username= +,courseid= + + ,coursename= + + ,score= + + ,year= + +where id= + uid + ;cmd = new SqlCommand(sql,conn );();try();= 編輯成功;(javascript:alert(編輯成功!););catch (SqlException)= 編輯失敗;();();protected void Button2_Click(object sender, EventArgs e)string sql = ;string uid = ;uid = id;strin

31、g strconn = connStr;conn = new SqlConnection(strconn);sql = delete from score where id= + uid + ;cmd = new SqlCommand(sql, conn);();try();= 刪除成功;(javascript:alert(刪除成功!););catch (SqlException)= 刪除失敗;();();protected void Button3_Click(object sender, EventArgs e)();protected void userid_SelectedIndexC

32、hanged(object sender, EventArgs e)string strconn = connStr;conn = new SqlConnection(strconn);string sqlstr = ;sqlstr = select username from students where userid= + + ;();cmd = new SqlCommand(sqlstr, conn);();SqlDataReader da;da = ();while ()= dausername.ToString();protectedvoidtxtcourseid_SelectedI

33、ndexChanged(objectsender,EventArgse)string strconn = connStr;conn = new SqlConnection(strconn);string sqlstr = ;sqlstr = select coursename from course where courseid= + + ;();cmd = new SqlCommand(sqlstr, conn);();SqlDataReader da;da = ();while ()= dacoursename.ToString();十一、修改密碼程序代碼using System;usin

34、g ;using ;using ;using ;usingpartial class modify_pwd :SqlConnection conn;protected void Page_Load(object sender, EventArgs e)string strconn = connStr;conn = new SqlConnection(strconn);protected void Button1_Click(object sender, EventArgs e)string sql=;SqlCommand cmd;string uid;string pwd;uid = Sess

35、ionuserid.ToString ();pwd = Sessionuserpwd.ToString();if = )= 原密碼不能為空;else if = )= 新密碼不能為空;else if != 新密碼和確認(rèn)密碼不一致;else if != pwd)= 原密碼不正確;elsesql = ;sql = update users set userpwd= + + where userid= + uid+ ;cmd = new SqlCommand(sql, conn);();try();= 密碼修改成功;catch (SqlException)= 密碼修改失敗;finally();prot

36、ected void Button2_Click(object sender, EventArgs e)();十二、學(xué)生身份操作主界面程序代碼using System;using ;using ;using ;using ;usingpartial class student :protected void Page_Load(objectsender, EventArgs e)string strconn = connStr;SqlConnection conn = new SqlConnection(strconn);string strsql = ;string a = Sessionuserid.ToString();();strsql = select * from students where userid=+a+;DataSet ds=new DataSet () ;SqlDataAdapter da= new SqlDa