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

数据库技术及应用项目设计汇报学生成绩管理系统姓名：CeliaYan-01-07

一．设计目标及意义在现在高校日常管理中，学生成绩管理系统是其中很关键一环，尤其是目前学校规模不停扩大，学生人数日益增加，课程门类多，校区分散等实际情况，学生成绩统计功效越来越繁重，稍有疏忽就会出现差错。所以，学生成绩管理系统更含有很大实际应用意义。在互联网快速崛起今天，改革传统手工录入方法，公正，正确，立即反应学生信息和成绩情况，以适应信息时代要求，是学生成绩管理系统一个新理念。经过成绩管理能够大大提升学校工作效率。学生成绩管理系统应该完成以下两个方面内容：学生档案资料管理、学生成绩管理。经过学生成绩管理系统能够做到信息规范管理，科学统计和快速查询、修改、增加、删除等，降低管理方面工作量。二．关键功效该系统关键用于学校学生信息管理，总体任务是实现学生信息关系系统化、规范化和自动化，其关键任务是用计算机对学生信息进行日常管理，如查询、修改、增加、删除，另外还考虑到用户登录权限，针对学生信息和权限登录学生成绩管理系统。本系统关键包含注册管理、老师管理、学生信息查询、添加、修改、删除等部分。其关键功效有：学生信息添加，包含输入学生基础信息和成绩。学生信息查询，包含查询学生基础信息和成绩。学生信息修改，包含修改学生基础信息和成绩。学生信息删除，包含删除学生基础信息和成绩。登录用户密码修改，用户登录到系统可进行对应用户密码修改。管理员用户对用户名管理，包含添加新用户、删除用户。学生成绩管理系统是经典信息管理系统，其开发关键包含后台数据库建立和维护和前端应用程序开发两个方面。对于前者要求建立起数据一致性和完整性强、数据安全性好数据库。对于后者则要求应用程序功效完备，易使用。该管理系统我使用是MicrosoftVisualStudio及MicrosoftSQLServer。系统功效步骤图图2.1系统功效步骤三．数据库设计3.1本系统数据库采取是SQLServer。该数据库包含学生成绩表、用户登录表用于纪录学生基础信息数据库表结构以下：成绩表物理结构图3.1图3.2用户登录表物理结构：图3.3图3.43.2触发器删除DLB中统计时同时删除CJB中姓名相同统计USE[studentscore]GO/******Object:Trigger[dbo].[dlb_delete]ScriptDate:01/07/12:42:17******/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOALTERtrigger[dbo].[dlb_delete]on[dbo].[dlb]afterdeleteasbegindeclare@leibvarchar(50)select@leib='学生'fromdeleteddeletefromcjbwhere姓名in(select用户名fromdeleted)End3.3数据库连接stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);stringsqlstr="select*fromcjb";SqlCommandcmd=newSqlCommand(sqlstr,conn);SqlDataReaderreader=cmd.ExecuteReader();DataSetds=newDataSet();while(reader.Read()){stringid=reader["学号"].ToString();stringname=reader["姓名"].ToString();MessageBox.Show(string.Format("id={0},name={1},学号，姓名"));}四．系统实现4.1.登录界面图4.1该界面是学生成绩管理系统登录界面，能够选择作为学生，管理员或老师身份登录。每一个进入系统人全部会看到目前时间，在登录时只有用户名，密码，和身份相符合时才能进入系统，不然登录无法成功。usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceWindowsFormsApplication1{publicpartialclassForm1:Form{staticpublicstringsn,sub;publicForm1(){InitializeComponent();}Form2fr2=newForm2();Form3fr3=newForm3();Form4fr4=newForm4();privatevoidForm1_Load(objectsender,EventArgse){timer1.Start();}privatevoidlabel1_Click(objectsender,EventArgse){}privatevoidbutton1_Click(objectsender,EventArgse){stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();if(textname.Text==""||textpassword.Text=="")MessageBox.Show("信息不全，请不要遗漏信息！");if(rbtnmanager.Checked){stringcstr="select*fromdlbwhere类别='管理员'and用户名='"+textname.Text.Trim()+"'and密码='"+textpassword.Text.Trim()+"'";SqlCommandcomm=newSqlCommand(cstr,conn);SqlDataReaderdr=comm.ExecuteReader();if(dr.Read()){sn=textname.Text.Trim();fr4.Show();this.Visible=false;;}else{MessageBox.Show("密码或用户名犯错，请重新输入！");textname.Text="";textpassword.Text="";}}if(rbtnteacher.Checked){stringcstr="select*fromdlbwhere类别='老师'and用户名='"+textname.Text.Trim()+"'and密码='"+textpassword.Text.Trim()+"'";SqlCommandcomm=newSqlCommand(cstr,conn);SqlDataReaderdr=comm.ExecuteReader();if(dr.Read()){sn=textname.Text.Trim();sub=dr.GetValue(3).ToString();fr3.Show();this.Visible=false;}else{MessageBox.Show("密码或用户名犯错，请重新输入！");textname.Text="";textpassword.Text="";}}if(rbtnstudent.Checked){stringcstr="select*fromdlbwhere类别='学生'and用户名='"+textname.Text.Trim()+"'and密码='"+textpassword.Text.Trim()+"'";SqlCommandcomm=newSqlCommand(cstr,conn);SqlDataReaderdr=comm.ExecuteReader();if(dr.Read()){sn=textname.Text.Trim();fr2.Show();this.Visible=false;}else{MessageBox.Show("密码或用户名犯错，请重新输入！");textname.Text="";textpassword.Text="";}}conn.Close();conn.Dispose();}privatevoidbutton2_Click(objectsender,EventArgse){Application.Exit();}privatevoidtimer1_Tick(objectsender,EventArgse){label4.Text="目前时间："+DateTime.Now.ToLongDateString()+""+DateTime.Now.ToLongTimeString();}}}4.2学生成绩管理图4.2设计过程：

此部分关键针对学生信息管理，能够查询学生全部成绩信息，实现成绩添加、删除、修改、计算平均分等功效。还能够修改目前用户下密码。privatevoidForm2_Load(objectsender,EventArgse){label1.Text=Form1.sn+"同学，欢迎你进入成绩管理系统！";timer1.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){}privatevoidtoolStripButton4_Click(objectsender,EventArgse){groupBox1.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!=textpassword.Text){MessageBox.Show("密码输入有误，请重新输入");}if(textnpd.Text==""&&textpassword.Text==""){MessageBox.Show("密码不许可为空！");}if(textnpd.Text==textpassword.Text&&textnpd.Text!=""){SqlCommandcom=newSqlCommand("updatedlbset密码='"+textpassword.Text.Trim()+"'where用户名='"+Form1.sn.Trim()+"'",conn);if(com.ExecuteNonQuery()==1){MessageBox.Show("密码更改成功");groupBox1.Visible=false;}}conn.Close();conn.Dispose();}privatevoiddataGridView1_CellContentClick(objectsender,DataGridViewCellEventArgse){}privatevoidtoolStripButton5_Click(objectsender,EventArgse){this.Close();Form1l=newForm1();l.Visible=true;}privatevoidtoolStripButton6_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");//strings;//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());//}}privatevoidgroupBox2_Enter(objectsender,EventArgse){dataGridView1.Visible=false;groupBox1.Visible=false;}privatevoidtoolStripButton3_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姓名='"+Form1.sn.Trim()+"'",conn);DataSetds=newDataSet();da.Fill(ds,"usertable");intmax=0,min=1001;doubleave=0.0;for(inti=2;i<=6;i++){if(int.Parse(ds.Tables["usertable"].Rows[0][i].ToString())>max)max=int.Parse(ds.Tables["usertable"].Rows[0][i].ToString());if(int.Parse(ds.Tables["usertable"].Rows[0][i].ToString())<min)min=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();}privatevoidtimer1_Tick(objectsender,EventArgse){label2.Text="目前时间："+DateTime.Now.ToLongDateString()+DateTime.Now.ToLongTimeString();}4.3老师管理界面图4.3设计过程：

此部分关键针对老师信息管理，能够查询学生全部成绩信息，实现成绩添加、删除、修改、成绩升序排序等功效。还能够修改目前用户下密码。privatevoidbutton1_Click(objectsender,EventArgse)//查找{stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();if(comboBox1.Text=="学号"){SqlCommandcm=newSqlCommand("select学号,"+Form1.sub+"fromcjbwhere学号='"+textBox1.Text+"'",conn);if(cm.ExecuteScalar()==null){MessageBox.Show("用户名不存在");}else{SqlDataAdapterda=newSqlDataAdapter("select学号,"+Form1.sub+"fromcjbwhere学号='"+textBox1.Text+"'",conn);DataSetds=newDataSet();da.Fill(ds,"chaxun");dataGridView1.DataSource=ds.Tables["chaxun"].DefaultView;}}if(comboBox1.Text=="姓名"){SqlCommandcm=newSqlCommand("select姓名,"+Form1.sub+"fromcjbwhere姓名='"+textBox1.Text+"'",conn);if(cm.ExecuteScalar()==null){MessageBox.Show("该用户不存在");}else{SqlDataAdapterda=newSqlDataAdapter("select姓名,"+Form1.sub+"fromcjbwhere姓名='"+textBox1.Text+"'",conn);DataSetds=newDataSet();da.Fill(ds,"table");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;stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();SqlDataAdapterda=newSqlDataAdapter("select学号,姓名,"+Form1.sub+"fromcjb",conn);DataSetds=newDataSet();da.Fill(ds,"table");dataGridView1.DataSource=ds.Tables["table"].DefaultView;conn.Close();conn.Dispose();}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);if(com.ExecuteNonQuery()==1){MessageBox.Show("修改成功");}elseMessageBox.Show("信息有误，请重新输入");conn.Close();conn.Dispose();}privatevoidtoolStripButton3_Click(objectsender,EventArgse)//修改学生成绩{groupBox3.Visible=false;groupBox2.Enabled=true;groupBox1.Enabled=false;groupBox3.Visible=false;}privatevoidtextBox3_TextChanged(objectsender,EventArgse){}privatevoidgroupBox2_Enter(objectsender,EventArgse){}privatevoidbutton3_Click(objectsender,EventArgse)//确定修改密码{stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();if(txtnpd.Text!=txtnpassword.Text){MessageBox.Show("两次输入密码不一致，请重新输入");}if(txtnpd.Text==""&&txtnpassword.Text==""){MessageBox.Show("密码不许可为空，请输入密码");}if(txtnpd.Text==txtnpassword.Text&&txtnpd.Text!=""){SqlCommandcom=newSqlCommand("updatedlbset密码='"+txtnpassword.Text.Trim()+"'where用户名='"+Form1.sn.Trim()+"'",conn);if(com.ExecuteNonQuery()==1){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+"fromcjborderby"+Form1.sub+"desc",conn);DataSetds=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管理员管理界面图4.4设计过程：

此部分关键针对管理员，能够添加和删除全部用户账号和密码。

privatevoidForm4_Load(objectsender,EventArgse){timer1.Start();label1.Text=Form1.sn+"管理员，欢迎进入成绩管理系统！";groupBox2.Enabled=false;}privatevoidlabel1_Click(objectsender,EventArgse){}privatevoidradioButton1_CheckedChanged(objectsender,EventArgse){if(radioButton1.Checked){groupBox2.Enabled=true;txtkm.Enabled=true;}}privatevoidradioButton2_CheckedChanged(objectsender,EventArgse){if(radioButton2.Checked){groupBox2.Enabled=true;txtkm.Enabled=false;}}privatevoidtxtyhm_TextChanged(objectsender,EventArgse){}privatevoidbutton2_Click(objectsender,EventArgse){txtkm.Text=txtmm.Text=txtyhm.Text="";}privatevoidbutton3_Click(objectsender,EventArgse){this.Close();Form1l=newForm1();l.Visible=true;}privatevoidlabel5_Click(objectsender,EventArgse){}privatevoidtimer1_Tick(objectsender,EventArgse){label5.Text="目前时间："+DateTime.Now.ToLongDateString()+DateTime.Now.ToShortTimeString();}privatevoidbutton1_Click(objectsender,EventArgse){stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();if(radioButton1.Checked){System.Console.Out.WriteLine("");if(txtyhm.Text!=""&&txtmm.Text!=""&&txtkm.Text!=""){SqlCommandcom=newSqlCommand("select*fromdlbwhere用户名='"+txtyhm.Text.Trim()+"'",conn);if(com.ExecuteScalar()!=null){MessageBox.Show("用户已存在");}else{SqlCommandcm=newSqlCommand("insertintodlb(用户名,密码,类别,科目)values('"+txtyhm.Text+"','"+txtmm.Text+"','老师','"+txtkm.Text+"')",conn);if(cm.ExecuteNonQuery()==1){MessageBox.Show("添加成功");}}}elseMessageBox.Show("信息有误，请仔细查对信息");}elseif(radioButton2.Checked){if(txtyhm.Text!=""&&txtmm.Text!="")