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

1、學(xué)生信息管理系統(tǒng) 系統(tǒng)源代碼學(xué)生信息管理系統(tǒng) 系統(tǒng)源代碼學(xué)生信息管理系統(tǒng) 系統(tǒng)源代碼學(xué)生信息管理系統(tǒng) 系統(tǒng)源代碼編制僅供參考審核批準(zhǔn)生效日期地址： 電話：傳真: 郵編:系統(tǒng)源代碼一、登錄界面代碼using System;using ;using ;using ;using ;using partial class login : protected void txtid_Click(object sender, EventArgs e) = ; = ; protected void Button1_Click(object sender, EventArgs e) string strconn

2、 = connStr; SqlConnection conn = new SqlConnection(strconn); (); DataSet ds=new DataSet () ; SqlDataAdapter da = new SqlDataAdapter(select * from users where userid= + + and userpwd= + + , conn); (ds); if 0.=0) Label3 .Text =賬號或密碼錯誤，請重新輸入！; else Session userid=txtid .Text ; Sessionuserpwd = ; Sessio

3、nusername = 0.Rows0username.ToString(); Sessionuserpower = 0.Rows0userpower.ToString(); if (Sessionuserpower.ToString () = 0) (admin/); else if (Sessionuserpower.ToString() = 1) (student/); else = 對不起，權(quán)限驗證失敗; (); (); 二、添加課程頁面代碼using System;using ;using ;using ;using ;using partial class addcourse :

4、SqlCommand mycmd; SqlConnection conn; protected void Page_Load(object sender, EventArgs e) onblur, checkcourseid(); string strconn = connStr; conn = new SqlConnection(strconn); protected void Button1_Click(object sender, EventArgs e) if = ) = 課程號不能為空; else string sqlstr = ; sqlstr = insert into cour

5、se(courseid,coursename,coursetime,fen,type,teacher)values( + + , + + , + + , + + , + + , + + ); (); mycmd = new SqlCommand(sqlstr, conn); (); try (); (javascript:alert(添加成功!);); catch (SqlException) (javascript:alert(添加失敗!);); finally (); sqlstr = ; protected void Button2_Click(object sender, EventA

6、rgs e) = ; = ; = ; = ; = ; protected void Button3_Click(object sender, EventArgs e) (); 三、添加成績程序代碼using System;using ;using ;using ;using ;using partial class addscore : SqlCommand mycmd; SqlConnection conn; protected void Page_Load(object sender, EventArgs e) string strconn = connStr; conn = new Sq

7、lConnection(strconn); protected void Button1_Click(object sender, EventArgs e) if .ToString ()= ) = 學(xué)號不能為空; else string sqlstr = ; sqlstr = insert into score(userid,username,courseid,coursename,score,year)values( + + , + + , + + , + + , + + , + + ); (); mycmd = new SqlCommand(sqlstr, conn); (); try

8、(); (javascript:alert(添加成功!);); catch (SqlException) (javascript:alert(添加失敗!);); finally (); sqlstr = ; protected void Button2_Click(object sender, EventArgs e) = ; = ; = ; = ; protected void Button3_Click(object sender, EventArgs e) (); protected void userid_SelectedIndexChanged(object sender, Even

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

10、ct 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 ;using partial class addstudent : SqlCommand mycmd; protected void Page_Load(ob

11、ject 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 SqlConnection(strconn); string sqlstr = ; string sql

12、= ; sqlstr = insert into students(userid,username,sex,minzu,birthday,class,comefrom,beizhu,xuey,zhuany,tel,idc,zhengzmm,zhiw,huoj,weij)values( + + , + + , + + , + + , + + , + + , + + , + + , + + , + + , + + , + + , + + , + + , + + , + + ); (); mycmd = new SqlCommand(sqlstr, conn); (); string name =

13、獲取上傳文件的名稱 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 () (該課程號已經(jīng)存在，請換一個); else (該課程號可以使用); (); 六、檢查學(xué)號唯一性程序代碼using System;using ;using ;us

14、ing ;using ;using partial class checkuser : protected void Page_Load(object sender, EventArgs e) = 0; string strconn = connStr; SqlConnection conn = new SqlConnection(strconn); string nam = name.ToString(); string sql = select userid from students where userid= + nam + ; SqlCommand DBHelper; DBHelpe

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

16、; conn = 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)

17、DataSet ds; SqlDataReader da; string strsql = ; SqlCommand cmd; (); strsql = select * from course where courseid= + + or coursename like + + ; cmd = new SqlCommand(strsql, conn); da = (); = da; (); (); (); 八、編輯、刪除學(xué)生信息程序代碼using System;using ;using ;using ;using ;using partial class images_editstudent

18、 : SqlCommand cmd; SqlCommand cmd2; 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 students where userid= + uid + ; SqlCommand cmd;

19、 cmd = new SqlCommand(sql, conn); (); reader = (); while () = readeruserId.ToString(); = readerusername.ToString(); = readersex.ToString(); = readerminzu.ToString(); = readerbirthday.ToString(); = readerclass.ToString(); = readercomefrom.ToString(); = readerxuey.ToString(); = readerzhuany.ToString()

20、; = readertel.ToString(); = readeridc.ToString(); (); sql = ; (); protected void Button1_Click(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= + + ,

21、minzu= + + ,sex= + + ,birthday= + + ,class= + + ,comefrom= + + ,beizhu= + + ,xuey= + + ,zhuany= + + ,tel= + + ,idc= + + ,zhengzmm= + + where userid= + uid + ; cmd=new SqlCommand (sql,conn ); (); try (); color = blue; = 編輯成功; (javascript:alert(編輯成功!);); catch(SqlException ) = 編輯失敗; color = red; (); (

22、); protected void Button2_Click(object sender, EventArgs e) string sql = ; string uid = ; string sqlall = ; uid = id; string strconn = connStr; SqlConnection conn = new SqlConnection(strconn); sql = delete from students where userid= + uid + ; sqlall = delete from images where userid= + uid + ; cmd

23、= new SqlCommand(sql, conn); cmd2 = new SqlCommand(sqlall,conn); (); try (); string sql1 = ; sql1 = delete from users where userid= + uid + ; SqlCommand cmd1 = new SqlCommand(sql1, conn); (); try (); color = blue; = 刪除成功; (javascript:alert(刪除成功!);); catch (SqlException) = 刪除失敗; (javascript:alert(刪除失

24、敗!);); finally sql1 = ; catch(SqlException ) = 刪除失敗; color = red; (); (); = ; = ; = ; = ; = ; = ; = ; = ; = ; = ; = ; protected void Button3_Click(object sender, EventArgs e) (); 九、編輯、刪除課程信息程序代碼using System;using ;using ;using ;using ;using partial class editcourse : SqlCommand cmd; protected void P

25、age_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 course where courseid= + uid + ; SqlCommand cmd; cmd = new SqlCommand(sql, conn); (); reader = (); w

26、hile () = readercourseid.ToString(); = readercoursename.ToString(); = readercoursetime.ToString(); = readerfen.ToString(); = readertype.ToString(); = readerteacher.ToString(); (); sql = ; (); protected void Button1_Click(object sender, EventArgs e) string uid = ; uid = id; string strconn = connStr;

27、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 (); = 編輯成功; (javascript:alert(編輯成功!);); catch (SqlException) =

28、 編輯失敗; (); (); 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 SqlCommand(sql, conn); (); try (); = 刪除成功; (javascri

29、pt:alert(刪除成功!);); catch (SqlException) = 刪除失敗; (); (); = ; = ; = ; = ; = ; protected void Button3_Click(object sender, EventArgs e) (); 十、編輯、刪除成績信息程序代碼using System;using ;using ;using ;using ;using partial class editscore : SqlCommand cmd; SqlConnection conn; protected void Page_Load(object sender,

30、 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(); = readeruseri

31、d.ToString(); = 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

32、); sql = update score set userid= + + ,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

33、e) string sql = ; string uid = ; uid = id; string 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 But

34、ton3_Click(object sender, EventArgs e) (); protected void userid_SelectedIndexChanged(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); (); SqlD

35、ataReader da; da = (); while () = dausername.ToString(); protected void txtcourseid_SelectedIndexChanged(object sender, EventArgs e) string strconn = connStr; conn = new SqlConnection(strconn); string sqlstr = ; sqlstr = select coursename from course where courseid= + + ; (); cmd = new SqlCommand(sq

36、lstr, conn); (); SqlDataReader da; da = (); while () = dacoursename.ToString(); 十一、修改密碼程序代碼using System;using ;using ;using ;using ;using partial class modify_pwd : SqlConnection conn; protected void Page_Load(object sender, EventArgs e) string strconn = connStr; conn = new SqlConnection(strconn); p

37、rotected void Button1_Click(object sender, EventArgs e) string sql=; SqlCommand cmd; string uid; string pwd; uid = Sessionuserid.ToString (); pwd = Sessionuserpwd.ToString(); if = ) = 原密碼不能為空; else if = ) = 新密碼不能為空; else if != = 新密碼和確認(rèn)密碼不一致; else if != pwd) = 原密碼不正確; else sql = ; sql = update users

38、set userpwd= + + where userid= + uid + ; cmd = new SqlCommand(sql, conn); (); try (); = 密碼修改成功; catch (SqlException) = 密碼修改失敗; finally (); protected void Button2_Click(object sender, EventArgs e) (); 十二、學(xué)生身份操作主界面程序代碼using System;using ;using ;using ;using ;using partial class student : protected void Page_Load(object sender, 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 SqlD