C#与SQL数据库学生成绩管理系统完整代码

C#与SQL数据库学生成绩管理系统完整代码 2015-01-071在如今的高校日常管理中，学生成绩管理系统是其中非常重要的一环，特别是当前学校规模不断扩大，学生人数日益增加，课程门类多，校区分散等实际情况，学生成绩统计功能越来越繁重，稍有疏忽就会出现差错。因此，学生成绩管理系统更具有非常大的实际应用意义。在互联网快速崛起的今天，改革传统的手工录入方式，公正，准确，及时反映学生的信息和成绩的情况，以适应信息时代的要求，是学生成绩管理系统的一个新的理念。通过成绩管理可以大大提高学校的工作效率。学生成绩管理系统应该完成以下两个方面的内容：学生档案资料的管理、学生成绩的管理。通过学生成绩管理系统可以做到信息和自动化，其主要任务是用计算机对学生信息进行日常管理，如查询、修改、增加、删除，另外还考虑到用户登录的权限，针对学生信息和权限登录的学生成绩管理系统。本系统主要包括注册管理、教师管理、学生信息查询、添加、修改、删除等部分。其主要功能有：（2）学生信息的查询，包括查询学生的基本信息和成绩。（4）学生信息的删除，包括删除学生基本信息和成绩。（5）登录用户密码修改，用户登录到系统可进行相应的用户密码修改。学生成绩管理系统是典型的信息管理系统，其开发主要包括后台数据库的建立和维护性好的数据库。对于后者则要求应用程序功能完备，易使用。该管理系统我使用的是MicrosoftVisualStudio2012及MicrosoftSQLServer2008。2系统功能流程图3.1本系统的数据库采用的是SQLServer2008。该数据库包括学生成绩表、用户登录表用于纪录学生的基本信息数据库表结构如下：成绩表物理结构343.2触发器/******Object:Trigger[dbo].[dlb_delete]ScriptDate:01/07/201512:42:17******/stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);stringstringsqlstr="selSqlCommandcmd=newSqlCommand(sqlstr,conn);SqlDataReaderreader=cmd.ExecuteReader();DataSetds=newDataSet();{5stringstringid=reader["学号"].ToString();stringname=reader["姓名"].ToString();MessageBox.Show(string.Format("id={0},name={1},学号，姓名"));}该界面是学生成绩管理系统的登录界面，可以选择作为学生，管理员或者教师身份登录。每一个进入系统的人都会看到当前的时间，在登录时只有用户名，密码，与身份相符合时才能进入系统，否则登录无法成功。usingusingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication16{{publicpartialclassForm1:Form{publicForm1(){InitializeComponent();}Form2fr2=newForm2();Form3fr3=newForm3();Form4fr4=newForm4();privateprivatevoidForm1_Load(objectsender,EventArgse){timer1.Start();}privatevoidlabel1_Click(objectsender,EventArgse){}privatevoidbutton1_Click(objectsender,EventArgse){stringstringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();{stringcstr="select*fromdlbwhere类别='管理员'and用户名='"+textname.Text.Trim()+"'and密码='"+textpassword.Text.Trim()+"'";SqlCommandcomm=newSqlCommand(cstr,conn);SqlDataReaderdr=comm.ExecuteReader();{sn=textname.Text.Trim();fr4.Show();this.Visible=false;;}{textname.Text="";}7}}{stringcstr="select*fromdlbwhere类别='教师'and用户名='"+textname.Text.Trim()+"'and密码='"+textpassword.Text.Trim()+"'";SqlCommandcomm=newSqlCommand(cstr,conn);SqlDataReaderdr=comm.ExecuteReader();{sn=textname.Text.Trim();sub=dr.GetValue(3).ToString();fr3.Show();this.Visible=false;}}{textname.Text="";}}{stringcstr="select*fromdlbwhere类别='学生'and用户名='"+textname.Text.Trim()+"'and密码='"+textpassword.Text.Trim()+"'";SqlCommandcomm=newSqlCommand(cstr,conn);SqlDataReaderdr=comm.ExecuteReader();{sn=textname.Text.Trim();fr2.Show();this.Visible=false;}}{textname.Text="";}}conn.Close();conn.Dispose();}privateprivatevoidbutton2_Click(objectsender,EventArgse){Application.Exit();}privatevoidtimer1_Tick(objectsender,EventArgse)8{DateTime.Now.ToLongTimeString();}}设计过程：?此部分主要针对学生信息的管理，可以查询学生的所有成绩信息，实现成绩的添加、删除、修改、计算平均分等功能。还可以修改当前用户下的密码。privateprivatevoidForm2_Load(objectsender,EventArgse){9timer1.Start();groupBox1.Visible=false;groupBox2.Visible=false;}privatevoidbutton1_Click(objectsender,EventArgse){}}privatevoidbutton3_Click(objectsender,EventArgse){//stringconstr="Password=null;PersistSecurityInfo=True;UserID=BINIANDOUKOU\administrator;InitialCatalog=studentscore;DataSource=BINIANDOUKOU\\SQLEXPRESS";//SqlConnectionconn=newSqlConnection(constr);//conn.Open();//SqlDataAdapterda=newSqlDataAdapter("Select*fromcjbwhere姓名="+textBox1.Text,conn);//DataSetds=newDataSet();//da.Fill(ds,"usertable");//dataGridView1.DataSource=;}}privatevoidtoolStripButton1_Click(objectsender,EventArgse){dataGridView1.Visible=true;groupBox1.Visible=false;groupBox2.Visible=false;stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();SqlDataAdapterda=newSqlDataAdapter("select*fromcjbwhere姓名='"+Form1.sn.Trim()+"'",conn);//----详细信息DataSetds=newDataSet();da.Fill(ds,"usertable");dataGridView1.DataSource=ds.Tables["usertable"].DefaultView;conn.Close();conn.Dispose();}privatevoidtoolStripButton2_Click(objectsender,EventArgse){}privateprivatevoidtoolStripButton4_Click(objectsender,EventArgse){groupBoxgroupBox1.Visible=true;}privatevoidbutton1_Click_1(objectsender,EventArgse){stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();有误，请重新输入");}if(textnpd.Text==""&if(textnpd.Text==textpassword.Tex{SqlCommandcom=newSqlCommand("updatedlbset密码='"+textpassword.Text.Trim()+"'where用户名='"+Form1.sn.Trim()+"'",conn);{MessageBox.Show("密码更改成功");groupBox1.Visible=false;}}conn.Close();conn.Dispose();}privatevoiddataGridView1_CellContentClick(objectsender,DataGridViewCellEventArgse){}privatevoidtoolStripButton5_Click(objectsender,EventArgse){this.Close();Form1l=newForm1();l.Visible=true;}privateprivatevoidtoolStripButton6_Click(objectsender,EventArgse){//stringconstr="Password=null;PersistSecurityInfo=True;UserID=BINIANDOUKOU\administrator;InitialCatalog=studentscore;DataSource=BINIANDOUKOU\\SQLEXPRESS";//SqlConnectionconn=newSqlConnection(constr);//conn.Open();//SqlDataAdapterda=newSqlDataAdapter("Select*fromcjbwhere姓名="+textBox1.Text,conn);//DataSetds=newDataSet();////da.Fill(ds,"usertable");//for(inti=2;i<=6;i++)//if(int.Parse(ds.Tables["usertable"].Rows[0][i].ToString())<60)//s=int.Parse(ds.Tables["usertable"].Rows[0][i].ToString());}privateprivatevoidgroupBox2_Enter(objectsender,EventArgse){dataGridView1.Visible=false;groupBox1.Visible=false;}privateprivatevoidtoolStripButton3_Click(objectsender,EventArgse){groupBox2.Visible=true;stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();SqlDataAdapterda=newSqlDataAdapter("Select*fromcjbwhere姓DataSetds=newDataSet();da.Fill(ds,"usertable");intmax=0,min=1001;for(inti=2;i<=6;i++){ifif(int.Parse(ds.Tables["usertable"].Rows[0][i].ToString())>max)max=int.Parse(ds.Tables["usertable"].Rows[0][i].ToString());(int.Parse(ds.Tables["usertable"].Rows[0][i].ToString())<min)minmin=int.Parse(ds.Tables["usertable"].Rows[0][i].ToString());}txthscore.Text=max.ToString();txtlscore.Text=min.ToString();txtall.Text=ds.Tables["usertable"].Rows[0]["总分"].ToString();ave=int.Parse(ds.Tables["usertable"].Rows[0]["总分"].ToString())/(double)5;txtave.Text=ave.ToString();conn.Close();conn.Dispose();}privateprivatevoidtimer1_Tick(objectsender,EventArgse){"+DateTime.Now.ToLongDateString()+DateTime.Now.ToLongTimeString();}设计过程：?此部分主要针对教师信息管理，可以查询学生的所有成绩信息，实现成绩的添加、删除、修改、成绩升序排序等功能。还可以修改当前用户下的密码。privatevoidbutton1_Click(objectsender,EventArgse)//查找{stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();{SqlCommandcm=newSqlCommand("select学号,"+Form1.sub+"fromcjbwhere学号='"+textBox1.Text+"'",conn);if(cm.ExecuteScalar()==null){MessageBox.Show("用户名不存在");}{SqlDataAdapterda=newSqlDataAdapter("select学号,"+Form1.sub+"fromcjbwhere学号='"+textBox1.Text+"'",conn);DataSetds=newDataSet();dataGridView1.DataSource=ds.Tables["chaxun"].DefaultView;}}{SqlCommandcm=newSqlCommand("select姓名,"+Form1.sub+"fromcjbwhere姓名='"+textBox1.Text+"'",conn);if(cm.ExecuteScalar()==null){MessageBox.Show("该用户不存在");}{SqlDataAdapterda=newSqlDataAdapter("select姓名,"+Form1.sub+"fromcjbwhere姓名='"+textBox1.Text+"'",conn);DataSetds=newDataSet();dataGridView1.DataSource=ds.Tables["table"].DefaultView;}}conn.Close();conn.Dispose();}privatevoidtextBox1_TextChanged(objectsender,EventArgse){}privatevoidtoolStripButton2_Click(objectsender,EventArgse)//查找{groupBox3.Visible=false;groupBox1.Enabled=true;groupBox2.Enabled=false;}privatevoidtoolStripButton1_Click(objectsender,EventArgse)//所有成绩{groupBox3.Visible=true;stringstringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();SqlDataAdapterda=newSqlDataAdapter("select学号,姓名,"+Form1.sub+"fromcjb",conn);DataSetDataSetds=newDataSet();da.Fill(ds,"table");dataGridView1.DataSource=ds.Tables["table"].DefaultView;}privatevoidbutton2_Click(objectsender,EventArgse)//修改成绩{stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();SqlCommandcom=newSqlCommand("updatecjbset"+Form1.sub+"='"+textBox3.Text+"'where姓名='"+textBox4.Text+"'",conn);{MessageBox.Show("修改成功");}MessageBox.Show("信息有误，请重新输入");conn.Close();conn.Dispose();}privatevoidtoolStripButton3_Click(objectsender,EventArgse)//修改学生成绩{groupBox3.Visible=false;groupBox2.Enabled=true;groupBox1.Enabled=false;groupBox3.Visible=false;}private{}private{}private{voidtextBox3_TextChanged(objectsender,EventArgse)voidgroupBox2_Enter(objectsender,EventArgse)voidbutton3_Click(objectsender,EventArgse)//确认修改密码stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();码不一致，请重新输入");}if(txtnpd.Text=="{MessageBox.Show("密码不允许为空，请输入密码");}{SqlCommandcom=newSqlCommand("updatedlbset密码='"+txtnpassword.Text.Trim()+"'where用户名='"+Form1.sn.Trim()+"'",conn);{MessageBox.Show("密码更改成功");groupBox1.Visible=true;}}conn.Close();conn.Dispose();}privatevoidtoolStripButton5_Click(objectsender,EventArgse){groupBox4.Visible=true;groupBox3.Visible=true;dataGridView1.Visible=false;}privatevoidtoolStripButton4_Click(objectsender,EventArgse)//升序排序{groupBox3.Visible=true;stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();SqlDataAdapterda=newSqlDataAdapter("select学号,姓名,"+Form1.sub+"fromcDataSetds=newDataSet();da.Fill(ds,"table");dataGridView1.DataSource=ds.Tables["table"].DefaultView;conn.Close();conn.Dispose();}privatevoidtoolStripButton6_Click(objectsender,EventArgse){this.Close();Form1l=newForm1();l.Visible=true;}privatevoidtimer1_Tick(objectsender,EventArgse){label8.Text="当前时间:"+DateTime.Now.ToLongDateString()+DateTime.Now.ToLongTimeString();}4.4管理员管理界面设计过程：?privatevoidForm4_Load(objectsender,EventArgse){timer1.Start();groupBox2.Enabled=false;}privatevoidlabel1_Click(objectsender,EventArgse){}privatevoidradioButton1_CheckedChanged(objectsender,EventArgse){if(radioButton1.Checked){groupBox2.Enabled=true;txtkm.En}privatevoidradioButton2_CheckedChanged(objectsender,EventArgse){if(radioButton2.Checked){groupBox2.Enabled=true;txtkm.Ena}privatevoidtxtyhm_TextChanged(objectsender,EventArgse){}privatevoidbutton2_Click(objectsender,EventArgse){txtkm.Text=txtmm.Text=txtyhm.Text="";}privateprivatevoidbutton3_Click(objectsender,EventArgse){}privatevoidlabel5_Click(objectsender,EventArgse){}privatevoidtimer1_Tick(objectsender,EventArgse){DateTime.Now.ToShortTimeString();}privateprivatevoidbutton1_Click(objectsender,EventArgse){stringstringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();{System.Console.Out.WriteLine("");{SqlCommandSqlCommandcom=newSqlCommand("select*fromdlbwhere用户在");}{名,密码,类别,科目)values('"+txtyhm.Text+"','"+txt