学生信息标准管理系统系统源代码样本(共80页)
《学生信息标准管理系统系统源代码样本(共80页)》由会员分享,可在线阅读,更多相关《学生信息标准管理系统系统源代码样本(共80页)(78页珍藏版)》请在装配图网上搜索。
1、学生信息标准管理系统系统源代码系统源代码一、登录界面代码using System;using ;using ;using ;using ;using ;using ;using ;using ;using ;using ;public partial class login : protected void txtid_Click(object sender, EventArgs e) = ; = ; protected void Button1_Click(object sender, EventArgs e) string strconn = connStr; SqlConnection
2、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 = ; Sessionusername = 0.Rows0userna
3、me.ToString(); Sessionuserpower = 0.Rows0userpower.ToString(); if (Sessionuserpower.ToString () = 0) (admin/); else if (Sessionuserpower.ToString() = 1) (student/); else = 对不起,权限验证失败; (); (); 二、添加课程页面代码using System;using ;using ;using ;using ;using ;using ;using ;using ;using ;using ;public partial
4、class addcourse : 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 = ; sql
5、str = insert into course(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
6、(object sender, EventArgs e) = ; = ; = ; = ; = ; protected void Button3_Click(object sender, EventArgs e) (); 三、添加成绩程序代码using System;using ;using ;using ;using ;using ;using ;using ;using ;using ;using ;public partial class addscore : SqlCommand mycmd; SqlConnection conn; protected void Page_Load(ob
7、ject sender, EventArgs e) string strconn = connStr; conn = new SqlConnection(strconn); protected void Button1_Click(object sender, EventArgs e) if ( .ToString ()= ) = 学号不能为空; else string sqlstr = ; sqlstr = insert into score(userid,username,courseid,coursename,score,year)values( + + , + + , + + , +
8、+ , + + , + + ); (); 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 sender, EventArgs e)
9、 (); 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(); protected void txtcourseid_SelectedIndex
10、Changed(object sender, EventArgs e) string sqlstr = ; sqlstr = select coursename from course where courseid= + + ; (); mycmd = new SqlCommand(sqlstr, conn); (); SqlDataReader da; da = (); while () = dacoursename.ToString(); 四、添加学生程序代码using System;using ;using ;using ;using ;using ;using ;using ;usin
11、g ;using ;using ;using ;using ;public partial class 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 () =
12、) return; string strconn = connStr; SqlConnection conn = new SqlConnection(strconn); string sqlstr = ; string sql = ; sqlstr = insert into students(userid,username,sex,minzu,birthday,class,comefrom,beizhu,xuey,zhuany,tel,idc,zhengzmm,zhiw,huoj,weij)values( + + , + + , + + , + + , + + , + + , + + , +
13、 + , + + , + + , + + , + + , + + , + + , + + , + + ); (); mycmd = new SqlCommand(sqlstr, conn); (); string name = ;/获取上传文件的名称 string type = () + 1);/获取上传文件的后缀 string ipath = (images/) + (yyyyMMddhhmmss) + name; string wpath = images + (yyyyMMddhhmmss) + name; string query1 = insert into images(useri
14、d,path) values( + + ,path); (ipath); /服务器保存路径 SqlCommand cm = new SqlCommand(query1); = conn; (path, , 50); path.Value = wpath; (); / = 上传成功!; try (); string sqlstr1 = ; sqlstr1 = insert into users(userid,username)values( + + , + + ) ; SqlCommand mycmd1 = new SqlCommand(sqlstr1, conn); (); try (); (
15、javascript:alert(添加成功!);); catch (SqlException) (javascript:alert(添加失败!);); finally sqlstr1 = ; catch (SqlException) (javascript:alert(添加失败!);); finally (); sqlstr = ; protected void Button2_Click(object sender, EventArgs e) = ; = ; = ; = ; = ; = ; = ; protected void Button3_Click(object sender, Eve
16、ntArgs e) (); 五、检查课程号唯一性程序代码using System;using ;using ;using ;using ;using ;using ;using ;using ;using ;using ;public partial class checkcourseid : protected void Page_Load(object sender, EventArgs e) = 0; string strconn = connStr; SqlConnection conn = new SqlConnection(strconn); string nam = name.T
17、oString(); string sql = select courseid from course where courseid= + nam + ; SqlCommand DBHelper; DBHelper = new SqlCommand(sql, conn); (); SqlDataReader dr = (); if () (该课程号已经存在,请换一个); else (该课程号可以使用); (); 六、检查学号唯一性程序代码using System;using ;using ;using ;using ;using ;using ;using ;using ;using ;usi
18、ng ;public 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; DBHelper = new
19、 SqlCommand(sql, conn); (); SqlDataReader dr = (); if () (该学号已经存在,请换一个); else (该学号可以使用); (); 七、课程信息程序代码using System;using ;using ;using ;using ;using ;using ;using ;using ;using ;using ;public partial class course : SqlConnection conn; SqlDataReader getdata; protected void Page_Load(object sender, E
20、ventArgs e) string strconn = connStr; 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 Bu
21、tton1_Click(object sender, EventArgs e) DataSet ds; SqlDataReader da; string strsql = ; SqlCommand cmd; (); strsql = select * from course where courseid= + + or coursename like + + ; cmd = new SqlCommand(strsql, conn); da = (); = da; (); (); (); (); 八、编辑、删除学生信息程序代码using System;using ;using ;using ;u
22、sing ;using ;using ;using ;using ;using ;using ;public partial class images_editstudent : 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 SqlC
23、onnection(strconn); sql = select * from students where userid= + uid + ; SqlCommand cmd; cmd = new SqlCommand(sql, conn); (); reader = (); while () = readeruserId.ToString(); = readerusername.ToString(); = readersex.ToString(); = readerminzu.ToString(); = readerbirthday.ToString(); = readerclass.ToS
24、tring(); = readercomefrom.ToString(); = readerxuey.ToString(); = readerzhuany.ToString(); = 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 Sql
25、Connection(strconn); string sql=; sql = update students set userid= + + ,username= + + ,minzu= + + ,sex= + + ,birthday= + + ,class= + + ,comefrom= + + ,beizhu= + + ,xuey= + + ,zhuany= + + ,tel= + + ,idc= + + ,zhengzmm= + + where userid= + uid + ; cmd=new SqlCommand (sql,conn ); (); try (); color = b
26、lue; = 编辑成功; (javascript:alert(编辑成功!);); catch(SqlException ) = 编辑失败; color = red; (); (); 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 s
27、tudents 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 userid= + uid + ; SqlCommand cmd1 = new SqlCommand(sql1, conn); (); try (); color = blue
28、; = 删除成功; (javascript:alert(删除成功!);); catch (SqlException) = 删除失败; (javascript:alert(删除失败!);); finally sql1 = ; catch(SqlException ) = 删除失败; color = red; (); (); = ; = ; = ; = ; = ; = ; = ; = ; = ; = ; = ; protected void Button3_Click(object sender, EventArgs e) (); 九、编辑、删除课程信息程序代码using System;using
29、 ;using ;using ;using ;using ;using ;using ;using ;using ;using ;public partial 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 SqlConnectio
30、n(strconn); sql = select * from course where courseid= + uid + ; SqlCommand cmd; cmd = new SqlCommand(sql, conn); (); reader = (); while () = readercourseid.ToString(); = readercoursename.ToString(); = readercoursetime.ToString(); = readerfen.ToString(); = readertype.ToString(); = readerteacher.ToSt
31、ring(); (); sql = ; (); protected void Button1_Click(object 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= +
32、 + where courseid= + 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; string strconn = connStr; SqlConnection conn = new SqlCo
33、nnection(strconn); sql = delete from course where courseid= + uid + ; cmd = new SqlCommand(sql, conn); (); try (); = 删除成功; (javascript:alert(删除成功!);); catch (SqlException) = 删除失败; (); (); = ; = ; = ; = ; = ; protected void Button3_Click(object sender, EventArgs e) (); 十、编辑、删除成绩信息程序代码using System;usi
34、ng ;using ;using ;using ;using ;using ;using ;using ;using ;using ;public partial class editscore : SqlCommand cmd; SqlConnection conn; protected void Page_Load(object sender, EventArgs e) if (!) string sql = ; SqlDataReader reader; string uid = ; uid = id; string strconn = connStr; conn = new SqlCo
35、nnection(strconn); sql = select * from score where id= + uid + ; SqlCommand cmd; cmd = new SqlCommand(sql, conn); (); reader = (); while () = readerid.ToString(); = readeruserid.ToString(); = readerusername.ToString(); = readercourseid.ToString(); = readercoursename.ToString(); = readerscore.ToStrin
36、g(); (); 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 userid= + + ,username= + + ,courseid= + + ,coursename= + + ,score= + + ,year= + + where id= + uid
37、+ ; cmd = new SqlCommand(sql,conn ); (); try (); = 编辑成功; (javascript:alert(编辑成功!);); catch (SqlException) = 编辑失败; (); (); protected void Button2_Click(object sender, EventArgs e) string sql = ; string uid = ; uid = id; string strconn = connStr; conn = new SqlConnection(strconn); sql = delete from sc
38、ore where id= + uid + ; cmd = new SqlCommand(sql, conn); (); try (); = 删除成功; (javascript:alert(删除成功!);); catch (SqlException) = 删除失败; (); (); = ; = ; = ; = ; protected void Button3_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); (); SqlDataReader
- 温馨提示:
1: 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
2: 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
3.本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 装配图网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。