C與SQL數(shù)據(jù)庫學(xué)生成績(jī)標(biāo)準(zhǔn)管理系統(tǒng)完整代碼

數(shù)據(jù)庫技術(shù)及應(yīng)用項(xiàng)目設(shè)計(jì)匯報(bào)學(xué)生成績(jī)管理系統(tǒng)姓名：CeliaYan-01-07

一．設(shè)計(jì)目標(biāo)及意義在現(xiàn)在高校日常管理中，學(xué)生成績(jī)管理系統(tǒng)是其中很關(guān)鍵一環(huán)，尤其是目前學(xué)校規(guī)模不停擴(kuò)大，學(xué)生人數(shù)日益增加，課程門類多，校區(qū)分散等實(shí)際情況，學(xué)生成績(jī)統(tǒng)計(jì)功效越來越繁重，稍有疏忽就會(huì)出現(xiàn)差錯(cuò)。所以，學(xué)生成績(jī)管理系統(tǒng)更含有很大實(shí)際應(yīng)用意義。在互聯(lián)網(wǎng)快速崛起今天，改革傳統(tǒng)手工錄入方法，公正，正確，立即反應(yīng)學(xué)生信息和成績(jī)情況，以適應(yīng)信息時(shí)代要求，是學(xué)生成績(jī)管理系統(tǒng)一個(gè)新理念。經(jīng)過成績(jī)管理能夠大大提升學(xué)校工作效率。學(xué)生成績(jī)管理系統(tǒng)應(yīng)該完成以下兩個(gè)方面內(nèi)容：學(xué)生檔案資料管理、學(xué)生成績(jī)管理。經(jīng)過學(xué)生成績(jī)管理系統(tǒng)能夠做到信息規(guī)范管理，科學(xué)統(tǒng)計(jì)和快速查詢、修改、增加、刪除等，降低管理方面工作量。二．關(guān)鍵功效該系統(tǒng)關(guān)鍵用于學(xué)校學(xué)生信息管理，總體任務(wù)是實(shí)現(xiàn)學(xué)生信息關(guān)系系統(tǒng)化、規(guī)范化和自動(dòng)化，其關(guān)鍵任務(wù)是用計(jì)算機(jī)對(duì)學(xué)生信息進(jìn)行日常管理，如查詢、修改、增加、刪除，另外還考慮到用戶登錄權(quán)限，針對(duì)學(xué)生信息和權(quán)限登錄學(xué)生成績(jī)管理系統(tǒng)。本系統(tǒng)關(guān)鍵包含注冊(cè)管理、老師管理、學(xué)生信息查詢、添加、修改、刪除等部分。其關(guān)鍵功效有：學(xué)生信息添加，包含輸入學(xué)生基礎(chǔ)信息和成績(jī)。學(xué)生信息查詢，包含查詢學(xué)生基礎(chǔ)信息和成績(jī)。學(xué)生信息修改，包含修改學(xué)生基礎(chǔ)信息和成績(jī)。學(xué)生信息刪除，包含刪除學(xué)生基礎(chǔ)信息和成績(jī)。登錄用戶密碼修改，用戶登錄到系統(tǒng)可進(jìn)行對(duì)應(yīng)用戶密碼修改。管理員用戶對(duì)用戶名管理，包含添加新用戶、刪除用戶。學(xué)生成績(jī)管理系統(tǒng)是經(jīng)典信息管理系統(tǒng)，其開發(fā)關(guān)鍵包含后臺(tái)數(shù)據(jù)庫建立和維護(hù)和前端應(yīng)用程序開發(fā)兩個(gè)方面。對(duì)于前者要求建立起數(shù)據(jù)一致性和完整性強(qiáng)、數(shù)據(jù)安全性好數(shù)據(jù)庫。對(duì)于后者則要求應(yīng)用程序功效完備，易使用。該管理系統(tǒng)我使用是MicrosoftVisualStudio及MicrosoftSQLServer。系統(tǒng)功效步驟圖圖2.1系統(tǒng)功效步驟三．?dāng)?shù)據(jù)庫設(shè)計(jì)3.1本系統(tǒng)數(shù)據(jù)庫采取是SQLServer。該數(shù)據(jù)庫包含學(xué)生成績(jī)表、用戶登錄表用于紀(jì)錄學(xué)生基礎(chǔ)信息數(shù)據(jù)庫表結(jié)構(gòu)以下：成績(jī)表物理結(jié)構(gòu)圖3.1圖3.2用戶登錄表物理結(jié)構(gòu)：圖3.3圖3.43.2觸發(fā)器刪除DLB中統(tǒng)計(jì)時(shí)同時(shí)刪除CJB中姓名相同統(tǒng)計(jì)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='學(xué)生'fromdeleteddeletefromcjbwhere姓名in(select用戶名fromdeleted)End3.3數(shù)據(jù)庫連接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["學(xué)號(hào)"].ToString();stringname=reader["姓名"].ToString();MessageBox.Show(string.Format("id={0},name={1},學(xué)號(hào)，姓名"));}四．系統(tǒng)實(shí)現(xiàn)4.1.登錄界面圖4.1該界面是學(xué)生成績(jī)管理系統(tǒng)登錄界面，能夠選擇作為學(xué)生，管理員或老師身份登錄。每一個(gè)進(jìn)入系統(tǒng)人全部會(huì)看到目前時(shí)間，在登錄時(shí)只有用戶名，密碼，和身份相符合時(shí)才能進(jìn)入系統(tǒng)，不然登錄無法成功。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("信息不全，請(qǐng)不要遺漏信息！");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("密碼或用戶名犯錯(cuò)，請(qǐng)重新輸入！");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("密碼或用戶名犯錯(cuò)，請(qǐng)重新輸入！");textname.Text="";textpassword.Text="";}}if(rbtnstudent.Checked){stringcstr="select*fromdlbwhere類別='學(xué)生'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("密碼或用戶名犯錯(cuò)，請(qǐng)重新輸入！");textname.Text="";textpassword.Text="";}}conn.Close();conn.Dispose();}privatevoidbutton2_Click(objectsender,EventArgse){Application.Exit();}privatevoidtimer1_Tick(objectsender,EventArgse){label4.Text="目前時(shí)間："+DateTime.Now.ToLongDateString()+""+DateTime.Now.ToLongTimeString();}}}4.2學(xué)生成績(jī)管理圖4.2設(shè)計(jì)過程：

此部分關(guān)鍵針對(duì)學(xué)生信息管理，能夠查詢學(xué)生全部成績(jī)信息，實(shí)現(xiàn)成績(jī)添加、刪除、修改、計(jì)算平均分等功效。還能夠修改目前用戶下密碼。privatevoidForm2_Load(objectsender,EventArgse){label1.Text=Form1.sn+"同學(xué)，歡迎你進(jìn)入成績(jī)管理系統(tǒng)！";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("密碼輸入有誤，請(qǐng)重新輸入");}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="目前時(shí)間："+DateTime.Now.ToLongDateString()+DateTime.Now.ToLongTimeString();}4.3老師管理界面圖4.3設(shè)計(jì)過程：

此部分關(guān)鍵針對(duì)老師信息管理，能夠查詢學(xué)生全部成績(jī)信息，實(shí)現(xiàn)成績(jī)添加、刪除、修改、成績(jī)升序排序等功效。還能夠修改目前用戶下密碼。privatevoidbutton1_Click(objectsender,EventArgse)//查找{stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();if(comboBox1.Text=="學(xué)號(hào)"){SqlCommandcm=newSqlCommand("select學(xué)號(hào),"+Form1.sub+"fromcjbwhere學(xué)號(hào)='"+textBox1.Text+"'",conn);if(cm.ExecuteScalar()==null){MessageBox.Show("用戶名不存在");}else{SqlDataAdapterda=newSqlDataAdapter("select學(xué)號(hào),"+Form1.sub+"fromcjbwhere學(xué)號(hào)='"+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)//全部成績(jī){groupBox3.Visible=true;stringconstr="Password=617804;PersistSecurityInfo=True;UserID=ywj;InitialCatalog=studentscore;DataSource=YANJING";SqlConnectionconn=newSqlConnection(constr);conn.Open();SqlDataAdapterda=newSqlDataAdapter("select學(xué)號(hào),姓名,"+Form1.sub+"fromcjb",conn);DataSetds=newDataSet();da.Fill(ds,"table");dataGridView1.DataSource=ds.Tables["table"].DefaultView;conn.Close();conn.Dispose();}privatevoidbutton2_Click(objectsender,EventArgse)//修改成績(jī){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("信息有誤，請(qǐng)重新輸入");conn.Close();conn.Dispose();}privatevoidtoolStripButton3_Click(objectsender,EventArgse)//修改學(xué)生成績(jī){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("兩次輸入密碼不一致，請(qǐng)重新輸入");}if(txtnpd.Text==""&&txtnpassword.Text==""){MessageBox.Show("密碼不許可為空，請(qǐng)輸入密碼");}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學(xué)號(hào),姓名,"+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="目前時(shí)間:"+DateTime.Now.ToLongDateString()+DateTime.Now.ToLongTimeString();}4.4管理員管理界面圖4.4設(shè)計(jì)過程：

此部分關(guān)鍵針對(duì)管理員，能夠添加和刪除全部用戶賬號(hào)和密碼。

privatevoidForm4_Load(objectsender,EventArgse){timer1.Start();label1.Text=Form1.sn+"管理員，歡迎進(jìn)入成績(jī)管理系統(tǒng)！";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="目前時(shí)間："+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("信息有誤，請(qǐng)仔細(xì)查對(duì)信息");}elseif(radioButton2.Checked){if(txtyhm.Text!=""&&txtmm.Text!="")