数据库课程设计报告（员工培训管理系统）

//

}

}

AfxMessageBox(m_Edit2_cidValue+\if( strcmp(m_Edit2_cidValue,tmp1)==0 ) cnt++; m_pRecordset->MoveNext();

if( OK ){ }

CString _cid;

str = \

m_pRecordset = m_pConnection->Execute(str.AllocSysString(),NULL,adCmdText); UpdateData(TRUE); OK=0;

while( !m_pRecordset->adoEOF ) {

_cid=str = (LPCSTR)(_bstr_t)m_pRecordset->GetCollect(\if(m_Edit2_cidValue==_cid) {

str = (LPCSTR)(_bstr_t)m_pRecordset->GetCollect(\break;

AfxMessageBox(\已选修了该课程!\m_pRecordset->Close(); m_pConnection->Close(); return ;

//

}

}

m_pRecordset->MoveNext();

AfxMessageBox(pa); if( str != \ }

AfxMessageBox(\课程已经开始或结束,不能选课\m_pRecordset->Close(); m_pConnection->Close(); return ;

str = \

m_pRecordset = m_pConnection->Execute(str.AllocSysString(),NULL,adCmdText); UpdateData(TRUE); OK=0;

while( !m_pRecordset->adoEOF ) {

CString tmp2 = (LPCSTR)(_bstr_t)m_pRecordset->GetCollect(\CString tmp1 = (LPCSTR)(_bstr_t)pcid; if( strcmp(tmp1,tmp2)==0 ) {

pa=(LPCSTR)(_bstr_t)m_pRecordset->GetCollect(\OK=1; break;

}

}

m_pRecordset->MoveNext();

sum=atoi(pa); if( cnt>=sum ){ }

AfxMessageBox(\该课已满人！\m_pRecordset->Close(); m_pConnection->Close(); return ;

//

_variant_t ra;

_bstr_t strAdd = \ALUES('\strAdd = strAdd + personid + \strAdd = strAdd + m_Edit2_cidValue + \strAdd = strAdd + \//AfxMessageBox(strAdd);

m_pConnection->Execute(strAdd,&ra,adCmdText);

m_Adodc2.SetRecordSource(\ m_Adodc2.Refresh();

}

}

UpdateData(FALSE); m_pRecordset->Close(); m_pConnection->Close(); AfxMessageBox(\成功选课\

void DailogForSelectCourse::OnButtonDEL() {

// TODO: Add your control notification handler code here CString tmp=personid;

if( ::MessageBox(NULL,\确定要删除这门课吗？\提示\

//

AfxMessageBox(\

UpdateData(TRUE);

_ConnectionPtr m_pConnection; _RecordsetPtr m_pRecordset; ::CoInitialize(NULL);

//在ADO操作中建议语句中要常用try?catch()来捕获错误信息 //因为它有时会经常出现一些想不到的错误 try {

m_pConnection.CreateInstance(\_bstr_t strConn=LinkSql.AllocSysString();

m_pConnection->Open(strConn,\

//if(m_pConnection->State == adStateOpen) MessageBox(\成功连接数据