学生信息管理系统-系统源代码

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.AppSettings"connStr"SqlConnection conn = new Sql

3、Connection(strconn);conn.Open();DataSet ds=new DataSet ();txtid.TextSqlDataAdapter da = new SqlDataAdapter("select * from users where userid='" + "' and userpwd='" + txtpassword.Text + ""', conn);da.Fill(ds);if (ds.Tables0.Rows.Count=0)Label3 .Text =&quo

4、t;账号或密码错误，请重新输入！"elseSession "userid"=txtid .Text ;Session"userpwd" = txtpassword.Text;Session"username" = ds.Tables0.Rows0"username".ToString();Session"userpowe门=ds.Tables0.Rows0"userpower".ToString();if (Session"userpower".ToStr

5、ing () = "0")Response.Redirect("admin/index.aspx");else if (Session"userpower".ToString() = "1")Response.Redirect("student/index.aspx");elseLabel3.Text =" 对不起，权限验证失败"conn.Close();ds.Clear ();二、添加课程页面代码using System;using System.Data;using Sy

6、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 addcourse : System.Web.UI.PageSqlComma

7、nd mycmd;SqlConnection conn;protected void Page_Load(object sender, EventArgs e)courseid.Attributes.Add("onblur", "checkcourseid()");string strconn = ConfigurationManager.AppSettings"connStr"conn = new SqlConnection(strconn);protected void Button1_Click(object sender, E

8、ventArgs e)if (courseid.Text.ToString()="")Label7.Text ="课程号不能为空"elsestring sqlstr =""sqlstr = "insert intocourse(courseid,coursename,coursetime,fen,type,teacher)values("' + courseid.Text + "','" + coursename.Text + "',"'

9、; + coursetime.Text + "',"' + fen.Text + "','" + type.Text + "','"+teacher.Text + "')"conn.Open();mycmd = new SqlCommand(sqlstr, conn);mycmd.Dispose();try mycmd.ExecuteNonQuery(); Response.Write("<script>javascript:alert(

10、'添力口成功！!');</script>");catch (SqlException) Response.Write("<script>javascript:alert('添加失败!');</script>"); finally conn.Close(); sqlstr =""protected void Button2_Click(object sender, EventArgs e)courseid.Text =""coursename.Text =&q

11、uot;"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 S

12、ystem.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, E

13、ventArgs e)string strconn = ConfigurationManager.AppSettings"connStr"conn = new SqlConnection(strconn);protected void Button1_Click(object sender, EventArgs e)if (userid.SelectedValue .ToString ()="")Labelll.Text =" 学号不能为空"elsestring sqlstr =""sqlstr = "i

14、nsert intoscore(userid,username,courseid,coursename,score,year)values(" + userid.SelectedValue +"',"' + username.Text + "',"' + txtcourseid.SelectedValue + "','" + coursename.Text + "','" + score.Text + "',"&#

15、39; + txtyear.SelectedValue + "')"conn.Open();mycmd = new SqlCommand(sqlstr, conn);mycmd.Dispose();trymycmd.ExecuteNonQuery();Response.Write("<script>javascript:alert('添力口成功！!');</script>");catch (SqlException)Response.Write("<script>javascript:

16、alert('添力口失败！!');</script>");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, Event

17、Args 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.D

18、ispose();SqlDataReader da;da = mycmd.ExecuteReader();while (da.Read()username.Text = da"username".ToString();protected void txtcourseid_SelectedIndexChanged(object sender, EventArgs e)string sqlstr =""sqlstr = "select coursename from course where courseid='" +txtcou

19、rseid.SelectedValue + ""'conn.Open();mycmd = new SqlCommand(sqlstr, conn);mycmd.Dispose();SqlDataReader da;da = mycmd.ExecuteReader();while (da.Read()coursename.Text = da"coursename".ToString();四、添加学生程序代码using System;using System.。using System.Text;using System.Data;using Sys

20、tem.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.PageSqlComma

21、nd mycmd;protected void Page_Load(object sender, EventArgs e)userid.Attributes.Add("onblur", "checkuserid()");string strconn = ConfigurationManager.AppSettings"connStr" SqlConnection conn = new SqlConnection(strconn);protected void Button1_Click(object sender, EventArgs

22、 e) if (userid.Text.ToString()="") return;string strconn = ConfigurationManager.AppSettings"connStr"SqlConnection conn = new SqlConnection(strconn);string sqlstr =""string sql =""sqlstr = "insert intostudents(userid,username,sex,minzu,birthday,class,comef

23、rom,beizhu,xuey,zhuany,tel,idc,zh engzmm,zhiw,huoj,weij)values("' + userid.Text + "','" + txtusername.Text + "','" + txtsex.SelectedItem.Value + "',"' + txtminzu.Text + "','" + txtbirthday.Text + "',"'

24、 + txtclass.Text + "','" + txtcomefrom.Text + "','" + txtbeizhu.Text + "','" + txtxuey.SelectedValue + "','" + txtzhuany.SelectedValue + "','" + txttel.Text + "','" + txtidc.Text + "'

25、,"' + txtzzmm.SelectedValue + "','" + txtzhiw.Text + "','" + txthuoj.Text + "',"' + txtweij.Text + "')"conn.Open();mycmd = new SqlCommand(sqlstr, conn);mycmd.Dispose();string name = this. 获取上传文件的名称string type = name.Substri

26、ng(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,p

27、ath) values。' + userid.Text +"',path)"；(ipath)；/服务器保存路径SqlCommand cm = new SqlCommand(queryl);cm.Connection = conn;cm.Parameters.Add("path", SqlDbType.VarChar, 50);cm.Parameters"path".Value = wpath;cm.ExecuteNonQuery();/ this.lb_info.Text ="上传成功！"trymy

28、cmd.ExecuteNonQuery();string sqlstr1 =""sqls任1 = "insert into users(userid,username)values('" + userid.Text + "','" + txtusername.Text + "')"SqlCommand mycmd1 = new SqlCommand(sqlstr1, conn);mycmd1.Dispose();trymycmd1.ExecuteNonQuery();Response

29、.Write("<script>javascript:alert('添力口成功！!');</script>");catch (SqlException)Response.Write("<script>javascript:alert('添力口失败！!');</script>");finallysqlstr1 ="" catch (SqlException)Response.Write("<script>javascript:alert

30、('添力口失败！!');</script>");finallyconn.Close();sqlstr =""protected void Button2_Click(object sender, EventArgs e)userid.Text =""txtusername.Text =""txtminzu.Text =""txtbirthday.Text =""txtclass.Text =""txtcomefrom.Text =&quo

31、t;"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;usin

32、g 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.AppS

33、ettings"connStr"SqlConnection conn = new SqlConnection(strconn);string nam = Request.QueryString"name".ToString();string sql = "select courseid from course where courseid='" + nam + ""'SqlCommand DBHelper;DBHelper = new SqlCommand(sql, conn);conn.Open(

34、);SqlDataReader dr = DBHelper.ExecuteReader(); if (dr.Read() Response.Write("<b class='Error'> 该课程号已经存在，请换一个</b>"); elseResponse.Write("<b class='Right'>该课程号可以使用</b>");dr.Close();六、检查学号唯一性程序代码using System;using System.Data;using System.Conf

35、iguration;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.Page protected void P

36、age_Load(object sender, EventArgs e)Response.Expires = 0;string strconn = ConfigurationManager.AppSettings"connStr"SqlConnection conn = new SqlConnection(strconn);string nam = Request.QueryString"name".ToString();string sql = "select userid from students where userid='&q

37、uot; + nam +SqlCommand DBHelper;DBHelper = new SqlCommand(sql, conn);conn.Open();SqlDataReader dr = DBHelper.ExecuteReader();if (dr.Read()Response.Write("<b class='Error'>该学号已经存在，请换一个</b>");elseResponse.Write("<b class='Right'>该学号可以使用</b>")

38、;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.SqlClien

39、t;public partial class course : System.Web.UI.PageSqlConnection conn;SqlDataReader getdata;protected void Page_Load(object sender, EventArgs e)string strconn = ConfigurationManager.AppSettings"connStr"conn = new SqlConnection(strconn);SqlDataReader getdata;SqlCommand mycmd;DataSet ds = new

40、 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(

41、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, co

42、nn);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.

43、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 =&

44、quot;"SqlDataReader reader;string uid =""uid = Page.Request"id"string strconn = ConfigurationManager.AppSettings"connStr"SqlConnection conn = new SqlConnection(strconn);sql = "select * from students where userid='" + uid + "”'SqlCommand cmd;c

45、md = new SqlCommand(sql, conn);conn.Open();reader = cmd.ExecuteReader();while (reader.Read()userid.Text = reader"userId".ToString();txtusername.Text = reader"username".ToString();txtsex.SelectedValue = reader"sex".ToString();txtminzu.Text = reader"minzu".ToStr

46、ing();txtbirthday.Text = reader"birthday".ToString();txtclass.Text = reader"class".ToString();txtcomefrom.Text = reader"comefrom".ToString();txtxuey.Text = reader"xuey".ToString();txtzhuany.Text = reader"zhuany".ToString();txttel.Text = reader"t

47、el".ToString();txtidc.Text = reader"idc".ToString();cmd.Dispose();sql =""conn.Close();protected void Button1_Click(object sender, EventArgs e)string uid=""uid=Page .Request "id"string strconn = ConfigurationManager.AppSettings"connStr"SqlConnect

48、ion conn = new SqlConnection(strconn);string sql=""sql = "update students set userid='" + userid.Text + "',username='" + txtusername.Text + "',minzu='" + txtminzu.Text + "',sex='" + txtsex.SelectedItem.Value + "',

49、birthday='" + txtbirthday.Text + "',class='" + txtclass.Text + "',comefrom='" + txtcomefrom.Text + "',beizhu='" + txtbeizhu.Text + "',xuey='" + txtxuey.Text +"',zhuany="' + txtzhuany.Text + "'

50、,tel='" + txttel.Text + "',idc='" + txtidc.Text +"',zhengzmm="' + txtzzmm.SelectedValue + "'where userid='" + uid + ""'cmd=new SqlCommand (sql,conn );conn.Open();trycmd.ExecuteNonQuery();Label11.Style"color" = &qu

51、ot;blue"Labelll.Text =" 编辑成功"Response.Write("<script>javascript:alert('编辑成功！!');</script>");catch(SqlException )Labelll.Text =" 编辑失败"Label11.Style"color" = "red"cmd.Dispose();conn.Close();protected void Button2_Click(object s

52、ender, EventArgs e)string sql =""string uid =""string sqlall =""uid = Page.Request"id"string strconn = ConfigurationManager.AppSettings"connStr"SqlConnection conn = new SqlConnection(strconn);sql = "delete from students where userid='"

53、+ uid + ""'sqlall = "delete from images where userid='" + uid + ""'cmd = new SqlCommand(sql, conn);cmd2 = new SqlCommand(sqlall,conn);conn.Open();trycmd.ExecuteNonQuery();string sqll =""sqll = "delete from users where userid='" + uid

54、+ "”'SqlCommand cmd1 = new SqlCommand(sql1, conn);cmd1.Dispose();trycmd1.ExecuteNonQuery();Label11.Style"color" = "blue"Label11.Text =" 删除成功"Response.Write("<script>javascript:alert(' 删除成功！!');</script>");catch (SqlException)Label1

55、1.Text =" 删除失败"Response.Write("<script>javascript:alert(' 删除失败！!');</script>");finallysql1 =""catch(SqlException )Labelll.Text =" 删除失败"Label11.Style"color" = "red"cmd.Dispose();conn.Close();userid.Text =""txtus

56、ername.Text =""txtminzu.Text =""txtbirthday.Text =""txtclass.Text =""txtcomefrom.Text =""txtbeizhu.Text =""txtxuey.Text =""txtzhuany.Text =""txttel.Text =""txtidc.Text =""protected void Button3_Click(

57、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.WebP

58、arts;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.Request"

59、id"string strconn = ConfigurationManager.AppSettings"connStr"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 (r

60、eader.Read()courseid.Text = reader"courseid".ToString();coursename.Text = reader"coursename".ToString();coursetime.Text = reader"coursetime".ToString();fen.Text = reader"fen".ToString();type.Text = reader"type".ToString();type.Text = reader"teac

61、her".ToString();cmd.Dispose();sql =""conn.Close();protected void Button1_Click(object sender, EventArgs e)string uid =""uid = Page.Request"id"string strconn = ConfigurationManager.AppSettings"connStr"SqlConnection conn = new SqlConnection(strconn);string

62、sql =""sql = "update course set courseid='" + courseid.Text + "',coursename='" + coursename.Text + "',coursetime='" + coursetime.Text + "',fen='" + fen.Text + "',type='" + type.Text + "',teacher=

63、'" + teacher.Text + "' where courseid='" + uid + ""'cmd = new SqlCommand(sql, conn);conn.Open();trycmd.ExecuteNonQuery();Label7.Text =" 编辑成功"Response.Write("<script>javascript:alert('编辑成功！!');</script>");catch (SqlExcep

64、tion)Label7.Text =" 编辑失败"cmd.Dispose();conn.Close();protected void Button2_Click(object sender, EventArgs e) string sql =""string uid =""uid = Page.Request"id"string strconn = ConfigurationManager.AppSettings"connStr"SqlConnection conn = new SqlConne

65、ction(strconn);sql = "delete from course where courseid='" + uid + ""'cmd = new SqlCommand(sql, conn);conn.Open();trycmd.ExecuteNonQuery();Label7.Text =" 删除成功"Response.Write("<script>javascript:alert('删除成功！!');</script>");catch (SqlException)Label7.Text =" 删除失败"cmd.Dispose();conn.Close();courseid.Text =""coursename.Text ="