精选_基于MFC和Access数据库实现的学生学习成绩信息管理系统_源码打包

# 基于MFC和Access数据库实现的学生学习成绩信息管理系统 # 1 题目要求 设计一个学生学习成绩信息管理系统，ODBC方式连接。 # 2 功能需求 - **用户管理**：新增用户，删除用户 - **学生信息管理**：增加学生信息，删除学生信息，查询学生信息 - **学生成绩管理**：录入学生成绩，修改学生成绩，删除学生成绩 - **计算总评**：计算总评功能的实现 ```c++ void CStudentbaView::OnButton1() { // TODO: Add your control notification handler code here m_pSet->m_SumScore=long(m_pSet->m_NormalScore*0.1+m_pSet->m_MidScore*0.2+m_pSet->m_FinalScore*0.7); UpdateData(FALSE); } ``` # 3 总体设计 **系统模块**  # 4 详细设计 在原来的基础上进行了完善。实验指导书上有的内容省略。 学生成绩查改删功能的实现： 在资源视图下添加一个对话框，添加ID，添加相应控件，如下图：  为IDD_DIALOG_SEARCH添加一个新类 SEARCH 并添加相应映射变量：  重载OnInitDialog()函数： ```c++ BOOL SEARCH::OnInitDialog() { CDialog::OnInitDialog(); // TODO: Add extra initialization here m_ctrList.InsertColumn(0," 序号"); m_ctrList.InsertColumn(1," 学号"); m_ctrList.InsertColumn(2," 姓名"); m_ctrList.InsertColumn(3," 科目"); m_ctrList.InsertColumn(4," 成绩"); m_ctrList.InsertColumn(5," 补考成绩"); m_ctrList.InsertColumn(6," 缺考标志"); m_ctrList.SetColumnWidth(0,60); m_ctrList.SetColumnWidth(1,80); m_ctrList.SetColumnWidth(2,80); m_ctrList.SetColumnWidth(3,100); m_ctrList.SetColumnWidth(4,80); m_ctrList.SetColumnWidth(5,80); m_ctrList.SetColumnWidth(6,60); m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES); CString strSQL="select * from score"; RefreshData(strSQL); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE } ``` 为SEARCH类添加RefreshData(strSQL)函数： ```c++ void SEARCH::RefreshData(CString strSQL) { m_ctrList.DeleteAllItems(); m_ctrList.SetRedraw(FALSE); UpdateData(TRUE); if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)) { MessageBox(" 打开数据库失败!"," 数据库错误",MB_OK); return ; } int i=0; char buffer[20]; while(!m_recordset.IsEOF()) { _ltoa(m_recordset.m_ID,buffer,10); m_ctrList.InsertItem(i,buffer); m_ctrList.SetItemText(i,1,m_recordset.m_code); m_ctrList.SetItemText(i,2,m_recordset.m_name); m_ctrList.SetItemText(i,3,m_recordset.m_subject); _ltoa(m_recordset.m_score,buffer,10); m_ctrList.SetItemText(i,4,buffer); _ltoa(m_recordset.m_makeup_score,buffer,10); m_ctrList.SetItemText(i,5,buffer); m_ctrList.SetItemText(i,6,m_recordset.m_absent); i++; m_recordset.MoveNext(); } m_recordset.Close(); m_ctrList.SetRedraw(TRUE); } ``` 为查询添加消息响应函数： ```c++ void SEARCH::OnBnClickedButtonSearch() { // TODO: Add your control notification handler code here UpdateData(); CString strSQL,strTemp; strTemp=""; BOOL bHaveCon = FALSE; if(m_strSubject!="") { strSQL.Format("select * from score where subject = '%s' ",m_strSubject); bHaveCon = TRUE; } if(m_strName!="") { if(bHaveCon) { strTemp.Format(" name = '%s' ",m_strName); strSQL=strSQL+ " and " + strTemp; } else { strSQL.Format("select * from score where name = '%s' ",m_strName); } bHaveCon=TRUE; } if(m_strClass!="") { if(bHaveCon) { strTemp.Format(" class = '%s' ",m_strClass); strSQL=strSQL+ " and " + strTemp; } else { strSQL.Format("select * from score where class = '%s' ",m_strClass); } bHaveCon=TRUE; } if(!bHaveCon) { strSQL="select * from score"; } RefreshData(strSQL); } ``` 为删除添加消息响应函数： ```c++ void SEARCH::OnButton1Delete() { // TODO: Add your control notification handler code here int i = m_ctrList.GetSelectionMark(); if(0>i) { AfxMessageBox(" 请选择一条记录进行查看！"); return; } CString strSQL; /*strSQL.Format("select * from score where ID = '%s'",m_ctrList.GetItemText(i,0));*/ /* strSQL.Format("select * from score where ID = '%d'",m_ctrList.GetSelectionMark());*/ strSQL.Format("select * from score where ID=%s",m_ctrList.GetItemText(i,0)); if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)) { AfxMessageBox(" 打开数据库失败!"); return ; } m_recordset.Delete(); m_recordset.Close(); strSQL= "select * from score"; RefreshData(strSQL); } ``` 在资源视图下添加一个对话框IDD_DIALOG_SCORE_UP 添加相应控件，如下图：  为其添加一个类：SCORE_UP_Dialog 并对应相应变量：  - 在SEARCH.h添加：#include "ScoreSet.h" - 并声明一个变量：CScoreSet m_recordset; - 在SEARCH类添加：#include "SCORE_UP_Dialog.h" 为修改添加消息响应函数： ```c++ void SEARCH::OnButton1Modify() { // TODO: Add your control notification handler code here SCORE_UP_Dialog Dlg; UpdateData(); int i = m_ctrList.GetSelectionMark(); if(0>i) { AfxMessageBox(" 请选择一条记录进行修改！"); return; } /* Dlg.m_strCode=m_ctrList.GetItemText(i,0);*/ /* Dlg.m_ID=m_ctrList.GetItemText(i,0);*/ if(IDOK==Dlg.DoModal()) {// 修改记录 CString strSQL; /* strSQL.Format("select * from student where code = '%s'",Dlg.m_strCode);*/ strSQL.Format("select * from score where ID=%s",m_ctrList.GetItemText(i,0)); /* strSQL.Format("select * from score where ID=%s",Dlg.m_ID);*/ if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL)) { AfxMessageBox(" 打开数据库失败!"); return ; } m_recordset.Edit(); /* CString m_str_Score;*/ // m_recordset.m_code =Dlg.m_strCode ; // m_recordset.m_name =Dlg.m_strName ; // m_recordset.m_sex =Dlg.m_strSex ; // m_recordset.m_birthday =Dlg.m_tmBirth ; // m_recordset.m_department =Dlg.m_strDepartment ; // m_recordset.m_major =Dlg.m_strMajor ; // m_recordset.m_class =Dlg.m_strClass ; // m_recordset.m_phone =Dlg.m_strPhone ; // m_recordset.m_address =Dlg.m_strAddress ; /* m_recordset.m_ID=Dlg.Dlg.m_ID;*/ /* m_recordset.m_ID=m_ctrList.GetItemText(i,0);*/ /* itoa(Dlg.m_strSCore,m_strScore,10);*/ m_recordset.m_score=Dlg.m_str_Score; m_recordset.m_makeup_score=Dlg.m_str_Makeup; m_recordset.Update(); m_recordset.Close(); strSQL= "select * from score "; RefreshData(strSQL); } } ``` 调用该对话框： ```c++ 为 StudentView.cpp 添加包含“SEARCH.h”的语句。为 CStudentView 类添加菜单ID_SCORE_SEARCH 的命令消息响应函数： void CStudentView::OnScoreSearch() { // TODO: Add your command handler code here SEARCH dlg; dlg.DoModal(); } ``` # 5 测试与实现        ![](http://www.writebug.com/myres/static/uploads/2021/10/19/36