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

《学生信息管理系统系统源代码.pdf》由会员分享，可在线阅读，更多相关《学生信息管理系统系统源代码.pdf（34页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

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;publ

2、ic partial class login:System.Web.UI.Page protected 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();DataSet

3、 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=账号或密码错误，请重新输入！;else Session userid=txtid.Text;Sessionuserpwd=txtpassword.Text;Sessionusername=ds.Tables0.Rows0u

4、sername.ToString();Sessionuserpower=ds.Tables0.Rows0userpower.ToString();if(Sessionuserpower.ToString()=0)Response.Redirect(admin/index.aspx);else if(Sessionuserpower.ToString()=1)Response.Redirect(student/index.aspx);else Label3.Text=对不起，权限验证失败;conn.Close();ds.Clear();.二、添加课程页面代码 using System;using

5、 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 partial class addcourse:System.

6、Web.UI.Page SqlCommand 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(object sender,EventArgs e)if(courseid.

7、Text.ToString()=)Label7.Text=课程号不能为空;else .string sqlstr=;sqlstr=insert into course(courseid,coursename,coursetime,fen,type,teacher)values(+courseid.Text+,+coursename.Text+,+coursetime.Text+,+fen.Text+,+type.Text+,+teacher.Text+);conn.Open();mycmd=new SqlCommand(sqlstr,conn);mycmd.Dispose();try mycm

8、d.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=;coursename.Text=;coursetime.Text=;fen.Text=;type.Text=;.protected void Button3_C

9、lick(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;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using Sy

10、stem.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class addscore:System.Web.UI.Page SqlCommand mycmd;SqlConnection conn;protected void Page_Load(object sender,EventArgs e)string strconn=ConfigurationManager.AppSettingsconnStr;conn=new SqlConnection(strconn);protected void Button1_C

11、lick(object sender,EventArgs e).if(userid.SelectedValue.ToString()=)Label11.Text=学号不能为空;else string sqlstr=;sqlstr=insert into score(userid,username,courseid,coursename,score,year)values(+userid.SelectedValue+,+username.Text+,+txtcourseid.SelectedValue+,+coursename.Text+,+score.Text+,+txtyear.Select

12、edValue+);conn.Open();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).username.Text=

13、;coursename.Text=;score.Text=;txtyear.Text=;protected void Button3_Click(object sender,EventArgs e)Response.Redirect(score.aspx);protected void userid_SelectedIndexChanged(object sender,EventArgs e)string sqlstr=;sqlstr=select username from students where userid=+userid.SelectedValue+;conn.Open();my

14、cmd=new SqlCommand(sqlstr,conn);mycmd.Dispose();SqlDataReader da;da=mycmd.ExecuteReader();while(da.Read()username.Text=dausername.ToString();protected void txtcourseid_SelectedIndexChanged(object sender,EventArgs e)string sqlstr=;sqlstr=select coursename from course where courseid=+txtcourseid.Selec

15、tedValue+;conn.Open();.mycmd=new SqlCommand(sqlstr,conn);mycmd.Dispose();SqlDataReader da;da=mycmd.ExecuteReader();while(da.Read()coursename.Text=dacoursename.ToString();四、添加学生程序代码 using System;using System.IO;using System.Text;using System.Data;using System.Configuration;using System.Collections;us

16、ing 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 addstudent:System.Web.UI.Page SqlCommand mycmd;protected void Page_Load(object sende

17、r,EventArgs e).userid.Attributes.Add(onblur,checkuserid();string strconn=ConfigurationManager.AppSettingsconnStr;SqlConnection conn=new SqlConnection(strconn);protected void Button1_Click(object sender,EventArgs e)if(userid.Text.ToString()=)return;string strconn=ConfigurationManager.AppSettingsconnS

18、tr;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(+userid.Text+,+txtusername.Text+,+txtsex.SelectedItem.Value+,+txtminzu.Text+,+txtbirthda

19、y.Text+,+txtclass.Text+,+txtcomefrom.Text+,+txtbeizhu.Text+,+txtxuey.SelectedValue+,+txtzhuany.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.获取上传文件的名称 str

20、ing type=name.Substring(name.LastIndexOf()+1);/获取上传文件的后缀 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

21、 cm=new SqlCommand(query1);cm.Connection=conn;cm.Parameters.Add(path,SqlDbType.VarChar,50);cm.Parameterspath.Value=wpath;cm.ExecuteNonQuery();/this.lb_info.Text=上传成功！;try mycmd.ExecuteNonQuery();string sqlstr1=;sqlstr1=insert into users(userid,username)values(+userid.Text+,+txtusername.Text+);SqlCom

22、mand mycmd1=new SqlCommand(sqlstr1,conn);mycmd1.Dispose();try mycmd1.ExecuteNonQuery();Response.Write(javascript:alert(添加成功!););catch(SqlException)Response.Write(javascript:alert(添加失败!););finally sqlstr1=;catch(SqlException).Response.Write(javascript:alert(添加失败!););finally conn.Close();sqlstr=;prote

23、cted void Button2_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;usin

24、g 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 partial class checkcourseid:System.Web.UI.Page

25、protected 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 DBHelper;DBH

26、elper=new SqlCommand(sql,conn);conn.Open();SqlDataReader dr=DBHelper.ExecuteReader();if(dr.Read()Response.Write(该课程号已经存在，请换一个);else Response.Write(该课程号可以使用);dr.Close();.六、检查学号唯一性程序代码 using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.

27、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.Expires=0;string strconn=Co

28、nfigurationManager.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();SqlDataReader dr=DBHelper.ExecuteReader();if(d

29、r.Read()Response.Write(该学号已经存在，请换一个);.else Response.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.WebControls;using System.Web.UI.WebControls.W

30、ebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class course:System.Web.UI.Page SqlConnection conn;SqlDataReader getdata;protected void Page_Load(object sender,EventArgs e)string strconn=ConfigurationManager.AppSettingsconnStr;conn=new SqlConnection(strconn);SqlDa

31、taReader 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.Connection.Close();conn.Close();mycmd.Dispose();protected void

32、 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,conn);da=cmd.ExecuteReader();Datagrid1.DataSource=da;Datagrid1.DataBin

33、d();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 System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using Syst

34、em.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=;SqlDataReader reader;string uid=;uid=Page.Requestid;string strconn=Configura

35、tionManager.AppSettingsconnStr;SqlConnection conn=new SqlConnection(strconn);sql=select*from students where userid=+uid+;SqlCommand cmd;cmd=new SqlCommand(sql,conn);.conn.Open();reader=cmd.ExecuteReader();while(reader.Read()userid.Text=readeruserId.ToString();txtusername.Text=readerusername.ToString

36、();txtsex.SelectedValue=readersex.ToString();txtminzu.Text=readerminzu.ToString();txtbirthday.Text=readerbirthday.ToString();txtclass.Text=readerclass.ToString();txtcomefrom.Text=readercomefrom.ToString();txtxuey.Text=readerxuey.ToString();txtzhuany.Text=readerzhuany.ToString();txttel.Text=readertel

37、.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 strconn=ConfigurationManager.AppSettingsconnStr;SqlConnection conn=new SqlConnection(strconn);string sql=;sql=update students set

38、 userid=+userid.Text+,username=+txtusername.Text+,minzu=+txtminzu.Text+,sex=+txtsex.SelectedItem.Value+,birthday=+txtbirthday.Text+,class=+txtclass.Text+,comefrom=+.txtcomefrom.Text+,beizhu=+txtbeizhu.Text+,xuey=+txtxuey.Text+,zhuany=+txtzhuany.Text+,tel=+txttel.Text+,idc=+txtidc.Text+,zhengzmm=+txt

39、zzmm.SelectedValue+where userid=+uid+;cmd=new SqlCommand(sql,conn);conn.Open();try cmd.ExecuteNonQuery();Label11.Stylecolor=blue;Label11.Text=编辑成功;Response.Write(javascript:alert(编辑成功!););catch(SqlException)Label11.Text=编辑失败;Label11.Stylecolor=red;cmd.Dispose();conn.Close();protected void Button2_Cl

40、ick(object sender,EventArgs e)string sql=;string uid=;string sqlall=;uid=Page.Requestid;string strconn=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

41、,conn);.cmd2=new SqlCommand(sqlall,conn);conn.Open();try cmd.ExecuteNonQuery();string sql1=;sql1=delete from users where userid=+uid+;SqlCommand cmd1=new SqlCommand(sql1,conn);cmd1.Dispose();try cmd1.ExecuteNonQuery();Label11.Stylecolor=blue;Label11.Text=删除成功;Response.Write(javascript:alert(删除成功!);)

42、;catch(SqlException)Label11.Text=删除失败;Response.Write(javascript:alert(删除失败!););finally sql1=;catch(SqlException).Label11.Text=删除失败;Label11.Stylecolor=red;cmd.Dispose();conn.Close();userid.Text=;txtusername.Text=;txtminzu.Text=;txtbirthday.Text=;txtclass.Text=;txtcomefrom.Text=;txtbeizhu.Text=;txtxue

43、y.Text=;txtzhuany.Text=;txttel.Text=;txtidc.Text=;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;.

44、using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class editcourse:System.Web.UI.Page SqlCommand cmd;protected void Page_Load(object sender,EventArgs e)if(!this.IsPostBack)string sql=;SqlDataReader rea

45、der;string uid=;uid=Page.Requestid;string 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=read

46、ercourseid.ToString();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)strin

47、g uid=;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+,teacher=+teacher.Text+wh

48、ere courseid=+uid+;cmd=new SqlCommand(sql,conn);conn.Open();try cmd.ExecuteNonQuery();Label7.Text=编辑成功;Response.Write(javascript:alert(编辑成功!););catch(SqlException)Label7.Text=编辑失败;cmd.Dispose();conn.Close();.protected void Button2_Click(object sender,EventArgs e)string sql=;string uid=;uid=Page.Requ

49、estid;string strconn=ConfigurationManager.AppSettingsconnStr;SqlConnection conn=new SqlConnection(strconn);sql=delete from course where courseid=+uid+;cmd=new SqlCommand(sql,conn);conn.Open();try cmd.ExecuteNonQuery();Label7.Text=删除成功;Response.Write(javascript:alert(删除成功!););catch(SqlException)Label

50、7.Text=删除失败;cmd.Dispose();conn.Close();courseid.Text=;coursename.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