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

系统源代码一、登录界面代码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 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();DataSetds=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;Sessionusername=ds.Tables0.Rows0username.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);elseLabel3.Text=对不起，权限验证失败;conn.Close();ds.Clear();二、添加课程页面代码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 partial 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(object 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.Open();mycmd=new SqlCommand(sqlstr,conn);mycmd.Dispose();trymycmd.ExecuteNonQuery();Response.Write(javascript:alert(添加成功!););catch(SqlException)Response.Write(javascript:alert(添加失败!););finallyconn.Close();sqlstr=;protected void Button2_Click(object sender,EventArgs e)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 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 addscore:System.Web.UI.PageSqlCommand mycmd;SqlConnection conn;protected void Page_Load(object sender,EventArgs e)string strconn=ConfigurationManager.AppSettingsconnStr;conn=new SqlConnection(strconn);protected void Button1_Click(object sender,EventArgs e)if(userid.SelectedValue.ToString()=)Label11.Text=学号不能为空;elsestring sqlstr=;sqlstr=insert intoscore(userid,username,courseid,coursename,score,year)values(+userid.SelectedValue+,+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(javascript: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(object sender,EventArgs e)string sqlstr=;sqlstr=select username from students where userid=+userid.SelectedValue+;conn.Open();mycmd=new SqlCommand(sqlstr,conn);mycmd.Dispose();SqlDataReaderda;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.SelectedValue+;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;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 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 SqlConnection(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,birthday,class,comefrom,beizhu,xuey,zhuany,tel,idc,zhengzmm,zhiw,huoj,weij)values(+userid.Text+,+txtusername.Text+,+txtsex.SelectedItem.Value+,+txtminzu.Text+,+txtbirthday.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.FileUpload1.FileName;/获取上传文件的名称string 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);FileUpload1.SaveAs(ipath);/服务器保存路径SqlCommand cm=new SqlCommand(query1);cm.Connection=conn;cm.Parameters.Add(path,SqlDbType.VarChar,50);cm.Parameterspath.Value=wpath;cm.ExecuteNonQuery();/this.lb_info.Text=上传成功！;trymycmd.ExecuteNonQuery();string sqlstr1=;sqlstr1=insert into users(userid,username)values(+userid.Text+,+txtusername.Text+);SqlCommand mycmd1=new SqlCommand(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 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;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 checkcourseid:System.Web.UI.Pageprotected void Page_Load(object sender,EventArgs e)Response.Expires=0;string strconn=ConfigurationManager.AppSettingsconnStr;SqlConnectionconn=new SqlConnection(strconn);string nam=Request.QueryStringname.ToString();string sql=select courseid from course where courseid=+nam+;SqlCommand DBHelper;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;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.Pageprotected void Page_Load(object sender,EventArgs e)Response.Expires=0;string strconn=ConfigurationManager.AppSettingsconnStr;SqlConnectionconn=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(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.WebControls;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.AppSettingsconnStr;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.Connection.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+orcoursename like +coursename.Text+;cmd=newSqlCommand(strsql,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 System.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.PageSqlCommand 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=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.ExecuteReader();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=readercomefrom.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 strconn=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.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.Stylecolor=blue;Label11.Text=编辑成功;Response.Write(javascript:alert(编辑成功!););catch(SqlException)Label11.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 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,conn);cmd2=new SqlCommand(sqlall,conn);conn.Open();trycmd.ExecuteNonQuery();string sql1=;sql1=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(javascript:alert(删除失败!););finallysql1=;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=;txtxuey.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;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.PageSqlCommand cmd;protected void Page_Load(object sender,EventArgs e)if(!this.IsPostBack)string sql=;SqlDataReader reader;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=readercourseid.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)string 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+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,EventArgs 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.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;