




版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
1、系统源代码一、登录界面代码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;using system.data.sqlclient;public
2、partial class login : system.web.ui.pageprotected void txtid_click(object sender, eventargs e)txtid.text =;txtpassword.text =;protected void button1_click(object sender, eventargs e)string strconn = configurationmanager.appsettingsconnstr;sqlconnection conn = new sqlconnection(strconn);conn.open();d
3、ataset ds=new dataset ();sqldataadapter da = new sqldataadapter(select * from users where userid= +txtid.text+ and userpwd= + txtpassword.text + , conn);da.fill(ds);if (ds.tables0.rows.count=0)label3 .text =账号或密码错误,请重新输入!;elsesession userid=txtid .text ;sessionuserpwd = txtpassword.text;sessionusern
4、ame = ds.tables0.rows0username.tostring();sessionuserpowe门=ds.tables0.rows0userpower.tostring();if (sessionuserpower.tostring () = 0)response.redirect(admin/index.aspx);else if (sessionuserpower.tostring() = 1)response.redirect(student/index.aspx);elselabel3.text = 对不起,权限验证失败;conn.close();ds.clear (
5、);二、添加课程页面代码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;using system.data.sqlclient;public p
6、artial class addcourse : system.web.ui.pagesqlcommand mycmd;sqlconnection conn;protected void page_load(object sender, eventargs e)courseid.attributes.add(onblur, checkcourseid();string strconn = configurationmanager.appsettingsconnstr;conn = new sqlconnection(strconn);protected void button1_click(o
7、bject sender, eventargs e)if (courseid.text.tostring()=)label7.text =课程号不能为空;elsestring sqlstr =;sqlstr = insert intocourse(courseid,coursename,coursetime,fen,type,teacher)values( + courseid.text + , + coursename.text + , + coursetime.text + , + fen.text + , + type.text + ,+teacher.text + );conn.ope
8、n();mycmd = new sqlcommand(sqlstr, conn);mycmd.dispose();try mycmd.executenonquery(); response.write(javascript:alert(添力口成功!!););catch (sqlexception) response.write(javascript:alert(添加失败!);); finally conn.close(); sqlstr =;protected void button2_click(object sender, eventargs e)courseid.text =;cours
9、ename.text =;coursetime.text =;fen.text =;type.text =protected void button3_click(object sender, eventargs e)response.redirect(course.aspx);三、添加成绩程序代码using system;using system.data;using system.configuration;using system.collections;using system.web;using system.web.security;using system.web.ui;usin
10、g system.web.ui.webcontrols;using system.web.ui.webcontrols.webparts;using system.web.ui.htmlcontrols;using system.data.sqlclient;public partial class addscore : system.web.ui.pagesqlcommand mycmd;sqlconnection conn;protected void page_load(object sender, eventargs e)string strconn = configurationma
11、nager.appsettingsconnstr;conn = new sqlconnection(strconn);protected void button1_click(object sender, eventargs e)if (userid.selectedvalue .tostring ()=)labelll.text = 学号不能为空;elsestring sqlstr =;sqlstr = insert intoscore(userid,username,courseid,coursename,score,year)values( + userid.selectedvalue
12、+, + username.text + , + txtcourseid.selectedvalue + , + coursename.text + , + score.text + , + txtyear.selectedvalue + );conn.open();mycmd = new sqlcommand(sqlstr, conn);mycmd.dispose();trymycmd.executenonquery();response.write(javascript:alert(添力口成功!!););catch (sqlexception)response.write(javascri
13、pt:alert(添力口失败!!););finallyconn.close();sqlstr =;protected void button2_click(object sender, eventargs e)username.text =;coursename.text =;score.text =;txtyear.text =;protected void button3_click(object sender, eventargs e)response.redirect(score.aspx);protected void userid_selectedindexchanged(obje
14、ct sender, eventargs e)string sqlstr =;sqlstr = select username from students where userid= + userid.selectedvalue + ; ;conn.open();mycmd = new sqlcommand(sqlstr, conn);mycmd.dispose();sqldatareader da;da = mycmd.executereader();while (da.read()username.text = dausername.tostring();protected void tx
15、tcourseid_selectedindexchanged(object sender, eventargs e)string sqlstr =;sqlstr = select coursename from course where courseid= +txtcourseid.selectedvalue + ;conn.open();mycmd = new sqlcommand(sqlstr, conn);mycmd.dispose();sqldatareader da;da = mycmd.executereader();while (da.read()coursename.text
16、= dacoursename.tostring();四、添加学生程序代码using system;using system.。using system.text;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.
17、web.ui.htmlcontrols;using system.data.sqlclient;public partial class addstudent : system.web.ui.pagesqlcommand mycmd;protected void page_load(object sender, eventargs e)userid.attributes.add(onblur, checkuserid();string strconn = configurationmanager.appsettingsconnstr; sqlconnection conn = new sqlc
18、onnection(strconn);protected void button1_click(object sender, eventargs e) if (userid.text.tostring()=) return;string strconn = configurationmanager.appsettingsconnstr;sqlconnection conn = new sqlconnection(strconn);string sqlstr =;string sql =;sqlstr = insert intostudents(userid,username,sex,minzu
19、,birthday,class,comefrom,beizhu,xuey,zhuany,tel,idc,zh engzmm,zhiw,huoj,weij)values( + userid.text + , + txtusername.text + , + txtsex.selecteditem.value + , + txtminzu.text + , + txtbirthday.text + , + txtclass.text + , + txtcomefrom.text + , + txtbeizhu.text + , + txtxuey.selectedvalue + , + txtzh
20、uany.selectedvalue + , + txttel.text + , + txtidc.text + , + txtzzmm.selectedvalue + , + txtzhiw.text + , + txthuoj.text + , + txtweij.text + );conn.open();mycmd = new sqlcommand(sqlstr, conn);mycmd.dispose();string name = this. 获取上传文件的名称string type = name.substring(name.lastindexof() + 1);/获取上传文件的后
21、缀string ipath = server.mappath(images/) + datetime.now.tostring(yyyymmddhhmmss) + name;string wpath = images + datetime.now.tostring(yyyymmddhhmmss) +name;string query1 = insert into images(userid,path) values。 + userid.text +,path);(ipath);/服务器保存路径sqlcommand cm = new sqlcommand(queryl);cm.connectio
22、n = conn;cm.parameters.add(path, sqldbtype.varchar, 50);cm.parameterspath.value = wpath;cm.executenonquery();/ this.lb_info.text =上传成功!;trymycmd.executenonquery();string sqlstr1 =;sqls任1 = insert into users(userid,username)values( + userid.text + , + txtusername.text + );sqlcommand mycmd1 = new sqlc
23、ommand(sqlstr1, conn);mycmd1.dispose();trymycmd1.executenonquery();response.write(javascript:alert(添力口成功!!););catch (sqlexception)response.write(javascript:alert(添力口失败!!););finallysqlstr1 =; catch (sqlexception)response.write(javascript:alert(添力口失败!!););finallyconn.close();sqlstr =;protected void bu
24、tton2_click(object sender, eventargs e)userid.text =;txtusername.text =;txtminzu.text =;txtbirthday.text =;txtclass.text =;txtcomefrom.text =;txtbeizhu.text =;protected void button3_click(object sender, eventargs e)response.redirect(student.aspx);五、检查课程号唯一性程序代码using system;using system.data;using sy
25、stem.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;using system.data.sqlclient;public partial class checkcourseid : system.web.ui.pageprot
26、ected void page_load(object sender, eventargs e)response.expires = 0;string strconn = configurationmanager.appsettingsconnstr;sqlconnection conn = new sqlconnection(strconn);string nam = request.querystringname.tostring();string sql = select courseid from course where courseid= + nam + ;sqlcommand d
27、bhelper;dbhelper = new sqlcommand(sql, conn);conn.open();sqldatareader dr = dbhelper.executereader(); if (dr.read() response.write( 该课程号已经存在,请换一个); elseresponse.write(该课程号可以使用);dr.close();六、检查学号唯一性程序代码using system;using system.data;using system.configuration;using system.collections;using system.web
28、;using system.web.security;using system.web.ui;using system.web.ui.webcontrols;using system.web.ui.webcontrols.webparts;using system.web.ui.htmlcontrols;using system.data.sqlclient;public partial class checkuser : system.web.ui.page protected void page_load(object sender, eventargs e)response.expire
29、s = 0;string strconn = configurationmanager.appsettingsconnstr;sqlconnection conn = new sqlconnection(strconn);string nam = request.querystringname.tostring();string sql = select userid from students where userid= + nam +sqlcommand dbhelper;dbhelper = new sqlcommand(sql, conn);conn.open();sqldatarea
30、der dr = dbhelper.executereader();if (dr.read()response.write(该学号已经存在,请换一个);elseresponse.write(该学号可以使用);dr.close();七、课程信息程序代码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.webcontro
31、ls;using system.web.ui.webcontrols.webparts;using system.web.ui.htmlcontrols;using system.data.sqlclient;public partial class course : system.web.ui.pagesqlconnection conn;sqldatareader getdata;protected void page_load(object sender, eventargs e)string strconn = configurationmanager.appsettingsconns
32、tr;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);conn.open();getdata = mycmd.executereader();grdmain.datasource = getdata;grdmain.databind();mycmd.connect
33、ion.close();conn.close();mycmd.dispose();protected void button1_click(object sender, eventargs e)dataset ds;sqldatareader da;string strsql =;sqlcommand cmd;conn.open();strsql = select * from course where courseid= + courseid.text + or coursename like + coursename.text + ;cmd = new sqlcommand(strsql,
34、 conn);da = cmd.executereader();datagrid1.datasource = da;datagrid1.databind();conn.close();cmd.dispose();cmd.connection.close();八、编辑、删除学生信息程序代码using system;using system.data;using system.configuration;using system.collections;using system.web;using system.web.security;using system.web.ui;using syst
35、em.web.ui.webcontrols;using system.web.ui.webcontrols.webparts;using system.web.ui.htmlcontrols;using system.data.sqlclient;public partial class images_editstudent : system.web.ui.page sqlcommand cmd;sqlcommand cmd2;protected void page_load(object sender, eventargs e) if (!this.ispostback)string sql
36、 =;sqldatareader reader;string uid =;uid = page.requestid;string strconn = configurationmanager.appsettingsconnstr;sqlconnection conn = new sqlconnection(strconn);sql = select * from students where userid= + uid + ”;sqlcommand cmd;cmd = new sqlcommand(sql, conn);conn.open();reader = cmd.executereade
37、r();while (reader.read()userid.text = readeruserid.tostring();txtusername.text = readerusername.tostring();txtsex.selectedvalue = readersex.tostring();txtminzu.text = readerminzu.tostring();txtbirthday.text = readerbirthday.tostring();txtclass.text = readerclass.tostring();txtcomefrom.text = readerc
38、omefrom.tostring();txtxuey.text = readerxuey.tostring();txtzhuany.text = readerzhuany.tostring();txttel.text = readertel.tostring();txtidc.text = readeridc.tostring();cmd.dispose();sql =;conn.close();protected void button1_click(object sender, eventargs e)string uid=;uid=page .request id;string strc
39、onn = configurationmanager.appsettingsconnstr;sqlconnection conn = new sqlconnection(strconn);string sql=;sql = update students set userid= + userid.text + ,username= + txtusername.text + ,minzu= + txtminzu.text + ,sex= + txtsex.selecteditem.value + ,birthday= + txtbirthday.text + ,class= + txtclass
40、.text + ,comefrom= + txtcomefrom.text + ,beizhu= + txtbeizhu.text + ,xuey= + txtxuey.text +,zhuany= + txtzhuany.text + ,tel= + txttel.text + ,idc= + txtidc.text +,zhengzmm= + txtzzmm.selectedvalue + where userid= + uid + ;cmd=new sqlcommand (sql,conn );conn.open();trycmd.executenonquery();label11.st
41、ylecolor = blue;labelll.text = 编辑成功;response.write(javascript:alert(编辑成功!!););catch(sqlexception )labelll.text = 编辑失败;label11.stylecolor = red;cmd.dispose();conn.close();protected void button2_click(object sender, eventargs e)string sql =;string uid =;string sqlall =;uid = page.requestid;string strc
42、onn = configurationmanager.appsettingsconnstr;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);conn.open();trycmd.executenonquery();s
43、tring sqll =;sqll = delete from users where userid= + uid + ”;sqlcommand cmd1 = new sqlcommand(sql1, conn);cmd1.dispose();trycmd1.executenonquery();label11.stylecolor = blue;label11.text = 删除成功;response.write(javascript:alert( 删除成功!!););catch (sqlexception)label11.text = 删除失败;response.write(javascri
44、pt:alert( 删除失败!!););finallysql1 =;catch(sqlexception )labelll.text = 删除失败;label11.stylecolor = red;cmd.dispose();conn.close();userid.text =;txtusername.text =;txtminzu.text =;txtbirthday.text =;txtclass.text =;txtcomefrom.text =;txtbeizhu.text =;txtxuey.text =;txtzhuany.text =;txttel.text =;txtidc.t
45、ext =;protected void button3_click(object sender, eventargs e)response.redirect(student.aspx);九、编辑、删除课程信息程序代码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.
46、web.ui.webcontrols.webparts;using system.web.ui.htmlcontrols;using system.data.sqlclient;public partial class editcourse : system.web.ui.pagesqlcommand cmd;protected void page_load(object sender, eventargs e) if (!this.ispostback)string sql =;sqldatareader reader;string uid =;uid = page.requestid;st
47、ring strconn = configurationmanager.appsettingsconnstr;sqlconnection conn = new sqlconnection(strconn);sql = select * from course where courseid= + uid + ”;sqlcommand cmd;cmd = new sqlcommand(sql, conn);conn.open();reader = cmd.executereader();while (reader.read()courseid.text = readercourseid.tostr
48、ing();coursename.text = readercoursename.tostring();coursetime.text = readercoursetime.tostring();fen.text = readerfen.tostring();type.text = readertype.tostring();type.text = readerteacher.tostring();cmd.dispose();sql =;conn.close();protected void button1_click(object sender, eventargs e)string uid
49、 =;uid = page.requestid;string strconn = configurationmanager.appsettingsconnstr;sqlconnection conn = new sqlconnection(strconn);string sql =;sql = update course set courseid= + courseid.text + ,coursename= + coursename.text + ,coursetime= + coursetime.text + ,fen= + fen.text + ,type= + type.text +
50、,teacher= + teacher.text + where courseid= + uid + ;cmd = new sqlcommand(sql, conn);conn.open();trycmd.executenonquery();label7.text = 编辑成功;response.write(javascript:alert(编辑成功!!););catch (sqlexception)label7.text = 编辑失败;cmd.dispose();conn.close();protected void button2_click(object sender, eventarg
51、s e) string sql =;string uid =;uid = page.requestid;string strconn = configurationmanager.appsettingsconnstr;sqlconnection conn = new sqlconnection(strconn);sql = delete from course where courseid= + uid + ;cmd = new sqlcommand(sql, conn);conn.open();trycmd.executenonquery();label7.text = 删除成功;response.write(javascript:alert(删除成功!!););catch (sqlexception)label7.text = 删除失败;cmd.dispose();conn.close();courseid.text =;coursename.text =;coursetime.text =;fen
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 医院禁烟制度管理制度
- 小区外来车辆管理制度
- 小学走读学生管理制度
- 党员跟踪培养管理制度
- 医院手术麻醉管理制度
- 国信证券风险管理制度
- 公司行政奖惩管理制度
- 医院花园活动管理制度
- 公司员工值日管理制度
- 公司培训进修管理制度
- 2025年江苏省常州市新北区外国语学校八下英语期末学业水平测试模拟试题含答案
- 2025年下半年广东汕尾市委组织部招聘政府聘员拟聘用人员易考易错模拟试题(共500题)试卷后附参考答案
- 关于Photoshop图像处理的试题及答案分享
- 2025-2030年中国运动轮椅行业市场现状供需分析及投资评估规划分析研究报告
- 2025年社会调查与统计分析考试题及答案
- 陪跑企业协议书
- 医学研究生课题研究中期进展报告
- 景区商户安全协议书
- 2024-2030全球超高压HPP灭菌设备行业调研及趋势分析报告
- 2025年军事理论课程考试试卷及答案
- 2025高考化学复习新题速递之有机合成(解答大题)(2025年4月)
评论
0/150
提交评论