1 题目要求

设计一个学生学习成绩信息管理系统，ODBC方式连接。

2 功能需求

用户管理：新增用户，删除用户
学生信息管理：增加学生信息，删除学生信息，查询学生信息
学生成绩管理：录入学生成绩，修改学生成绩，删除学生成绩
计算总评：计算总评功能的实现

voidCStudentbaView::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()函数：

BOOLSEARCH::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);
  CStringstrSQL="select * from score";
  RefreshData(strSQL);
  returnTRUE;// return TRUE unless you set the focus to a control
                // EXCEPTION: OCX Property Pages should return FALSE
}

为SEARCH类添加RefreshData(strSQL)函数：

voidSEARCH::RefreshData(CStringstrSQL){
  m_ctrList.DeleteAllItems();
  m_ctrList.SetRedraw(FALSE);
  UpdateData(TRUE);
  if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  {
    MessageBox(" 打开数据库失败!"," 数据库错误",MB_OK);
    return;
  }
  inti=0;
  charbuffer[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);}

为查询添加消息响应函数：

voidSEARCH::OnBnClickedButtonSearch(){
  // TODO: Add your control notification handler code here
  UpdateData();
  CStringstrSQL,strTemp;
  strTemp="";
  BOOLbHaveCon=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);}

为删除添加消息响应函数：

voidSEARCH::OnButton1Delete(){
  // TODO: Add your control notification handler code here
  inti=m_ctrList.GetSelectionMark();
  if(0>i)
  {
    AfxMessageBox(" 请选择一条记录进行查看！");
    return;
  }
  CStringstrSQL;
  /*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"

为修改添加消息响应函数：

voidSEARCH::OnButton1Modify(){
  // TODO: Add your control notification handler code here
  SCORE_UP_DialogDlg;
  UpdateData();
  inti=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())
  {// 修改记录
    CStringstrSQL;
  /*  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);
  }}

调用该对话框：

为StudentView.cpp添加包含“SEARCH.h”的语句。为CStudentView类添加菜单ID_SCORE_SEARCH的命令消息响应函数：voidCStudentView::OnScoreSearch(){
  // TODO: Add your command handler code here
  SEARCHdlg;
  dlg.DoModal();}