《數據庫》實驗報告（）學號：姓名：班級：成績：實驗名稱：學生成績管理系統(tǒng)實驗地點：所使用的開發(fā)工具及環(huán)境：硬件：奔騰4處理器，1.8GHz，512M內存操作系統(tǒng)軟件：WindowsXP數據庫系統(tǒng)：SQLServer2000桌面版數據庫用戶帳號：sa數據庫用戶口令：使用的數據庫：Northwind數據庫表：Student（學生基本信息表）、Course（課程基本信息表）、SC（成績表）開發(fā)工具：C#一、實驗目的：綜合性實驗目的是培養(yǎng)學生分析問題和解決問題的實際動手能力，本次試驗要求學生利用所學的數據庫基礎理論知識，結合編程技術完成簡單學生成績管理系統(tǒng)，從而加深對數據庫系統(tǒng)基本概念的理解與掌握，認識數據庫系統(tǒng)重要作用，為將來學習工作奠定一定基礎。二.實驗內容：1、建立Student、Course、SC表結構及其約束關系2、利用C#開發(fā)學生基本信息維護（錄入、修改、刪除、查詢）模塊3、利用C#開發(fā)課程基本信息維護（錄入、修改、刪除、查詢）模塊4、利用C#開發(fā)選課信息維護（錄入、修改、刪除、查詢）模塊5、利用C#開發(fā)學生成績維護（錄入、修改、刪除、查詢）模塊#include"stdafx.h"#include"StudentScore.h"#include"Course.h"#ifdef_DEBUG#definenewDEBUG_NEW#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;//CCourseIMPLEMENT_DYNAMIC(CCourse,CRecordset)CCourse::CCourse(CDatabase*pdb) :CRecordset(pdb){ //{{AFX_FIELD_INIT(CCourse) //}}AFX_FIELD_INIT m_nDefaultType=snapshot;CStringCCourse::GetDefaultConnect(){ return_T("ODBC;DSN=");}CStringCCourse::GetDefaultSQL(){ return_T("");}voidCCourse::DoFieldExchange(CFieldExchange*pFX){ //{{AFX_FIELD_MAP(CCourse) pFX->SetFieldType(CFieldExchange::outputColumn); //}}AFX_FIELD_MAP}//CCoursediagnosticsvoidCCourse::AssertValid()const{ CRecordset::AssertValid();}voidCCourse::Dump(CDumpContext&dc)const{ CRecordset::Dump(dc);}//MainFrm.h:interfaceoftheCMainFrameclassclassCMainFrame:publicCFrameWnd{protected://createfromserializationonly CMainFrame(); DECLARE_DYNCREATE(CMainFrame)//Attributespublic://Operationspublic://Overrides //ClassWizardgeneratedvirtualfunctionoverrides //{{AFX_VIRTUAL(CMainFrame) virtualBOOLPreCreateWindow(CREATESTRUCT&cs); //}}AFX_VIRTUAL//Implementationpublic: virtual~CMainFrame();protected://controlbarembeddedmembers //CStatusBarm_wndStatusBar; //CToolBarm_wndToolBar;//Generatedmessagemapfunctionsprotected: //{{AFX_MSG(CMainFrame) afx_msgintOnCreate(LPCREATESTRUCTlpCreateStruct); afx_msgvoidOnPassword(); afx_msgvoidOnUser(); afx_msgvoidOnStudent(); afx_msgvoidOnTeach(); afx_msgvoidOnTeacher(); afx_msgvoidOnScore(); afx_msgvoidOnQueryTeach(); afx_msgvoidOnQueryScore(); afx_msgvoidOnCourse(); //}}AFX_MSG DECLARE_MESSAGE_MAP()};//{{AFX_INSERT_LOCATION}}//MicrosoftVisualC++willinsertadditionaldeclarationsimmediatelybeforethepreviousline.//CScoreAddDlgdialogCScoreAddDlg::CScoreAddDlg(CWnd*pParent/*=NULL*/) :CDialog(CScoreAddDlg::IDD,pParent){/{{AFX_DATA_INIT(CScoreAddDlg) //}}AFX_DATA_INIT}voidCScoreAddDlg::DoDataExchange(CDataExchange*pDX){ CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CScoreAddDlg) DDX_Control(pDX,IDC_SCORE_STUDENT,m_cStudent); DDX_Control(pDX,IDC_SCORE_SCORE,m_cScore); DDX_Control(pDX,IDC_SCORE_COURSE,m_cCourse); //}}AFX_DATA_MAP}BEGIN_MESSAGE_MAP(CScoreAddDlg,CDialog) //{{AFX_MSG_MAP(CScoreAddDlg) //}}AFX_MSG_MAPEND_MESSAGE_MAP()voidCScoreAddDlg::OnOK(){ CStringstudent,course,score,student_no,course_no; m_cStudent.GetWindowText(student); m_cCourse.GetWindowText(course);m_cScore.GetWindowText(score); else//成績不為空 { CStringstrSQL; //查出該學生的學號 strSQL.Format("select*fromstudentwhereactive_status='Y'andstudent_name='%s'",student); CRecordsetm_recordSet=&m_database; m_recordSet.Open(CRecordset::forwardOnly,strSQL);m_recordSet.GetFieldValue("student_no",student_no); m_recordSet.Close(); //查出該課程的課程號strSQL.Format("select*fromcoursewhereactive_status='Y'andcourse_name='%s'",course); m_recordSet.Open(CRecordset::forwardOnly,strSQL);m_recordSet.GetFieldValue("course_no",course_no);; m_recordSet.Close();BOOLCScoreAddDlg::OnInitDialog(){ CDialog::OnInitDialog(); CRecordsetm_recordSet; if(!m_database.IsOpen()) { m_database.Open(_T("student")); m_recordSet.m_pDatabase=&m_database; } CStringstrSQL; strSQL.Format("selectcourse_namefromcoursewhereactive_status='Y'");m_recordSet.Open(CRecordset::forwardOnly,strSQL); for(inti=0;i<m_recordSet.GetRecordCount();i++){ CStringtemp; m_recordSet.GetFieldValue("course_name",temp); m_cCourse.AddString(temp);m_recordSet.MoveNext(); } m_recordSet.Close();m_cCourse.SetCurSel(1); strSQL.Format("selectstudent_namefromstudentwhereactive_status='Y'");m_recordSet.Open(CRecordset::forwardOnly,strSQL); for(intj=0;j<m_recordSet.GetRecordCount();j++){ CStringtemp; m_recordSet.GetFieldValue("student_name",temp); m_cStudent.AddString(temp);m_recordSet.MoveNext(); } m_recordSet.Close();m_cStudent.SetCurSel(1); { this->SetWindowText("成績窗口"); } returntrue;}voidCScoreAddDlg::OnCancel(){ //TODO:Addextracleanuphere CDialog::OnCancel();}在基本表S中檢索每一門課程成績都大于等于80分的學生學號、姓名和性別，并把檢索到的值送往另一個已存在的基本表STUDENT(SNO,SNAME,SEX)。INSERTINTOSTUDENT(SNO,SNAME,SEX)SELECTSNO,SNAME,SEXFROMSWHERESNOIN(SELECTSNOFROMSCWHERE80<=ALL(SELECTGRADEFROMSCGROUPBYSNO));在基本表SC中刪除尚無成績的選課元組。DELETEFROMSCWHEREGRADEISNULL;把張成民同學在SC中的選課記錄全部刪去。DELETEFROMSCWHERESNOIN(SELECTSNOFROMSWHERESNAME=’張成民’)把選修高等數學課程中不及格的成績全部改為空值。UPDATESCSETGRADE=NULLWHEREGRADE<60ANDCNOIN(SELECTCNOFROMCWHERECN