发布时间 : 星期日 文章数据库课程设计报告(员工培训管理系统)更新完毕开始阅读cac1efb265ce0508763213b8
_variant_t _personid;
m_pRecordset = m_pConnection->Execute(str.AllocSysString(),NULL,adCmdText); UpdateData(TRUE);
while( !m_pRecordset->adoEOF ) { } if(!OK ){ }
if(m_Edit9_cscode!=\{ }
//以下插入数据
AfxMessageBox(\状态输入有误,请确认!\return ;
AfxMessageBox(\不存在该任课老师,请重新确认!\m_pRecordset->Close(); m_pConnection->Close(); return ;
_personid = m_pRecordset->GetCollect(\CString tmp1 = (LPCSTR)(_bstr_t)_personid; if( strcmp(m_Edit3_personid,tmp1)==0 ){ }
m_pRecordset->MoveNext();
OK=1; break;
_variant_t ra;
_bstr_t strAdd = \ course VALUES('\strAdd= strAdd +m_Edit1_cid+\strAdd= strAdd +m_Edit2_cname+\strAdd= strAdd +m_Edit3_personid+\strAdd= strAdd +m_Edit4_intro+\strAdd= strAdd +m_Edit5_book+\
strAdd= strAdd +m_Edit6_classroom+\其实还要考虑哪些数据为可以为空,
不能为空的进行提示 }
void DailogForMGcourse::OnDEL() {
}
strAdd= strAdd +m_Edit7_number+\strAdd= strAdd +m_Edit8_classtime+\strAdd= strAdd +m_Edit9_cscode+\strAdd= strAdd +m_Edit10_exam_date+\//AfxMessageBox(strAdd);
m_pConnection->Execute(strAdd,&ra,adCmdText); m_adodc1.Refresh(); UpdateData(FALSE); m_pRecordset->Close(); m_pConnection->Close(); AfxMessageBox(\成功插入课程\
// TODO: Add your control notification handler code here UpdateData(TRUE); if(m_Edit1_cid==\ AfxMessageBox(\请输入要删除的课程号\
else
if( ::MessageBox(NULL,\确定要删除这门课吗?\ //
AfxMessageBox(\
_ConnectionPtr m_pConnection; _RecordsetPtr m_pRecordset; ::CoInitialize(NULL);
//在ADO操作中建议语句中要常用try?catch()来捕获错误信息 //因为它有时会经常出现一些想不到的错误
try { m_pConnection.CreateInstance(\ CString strConn=LinkSql;
m_pConnection->Open(strConn.AllocSysString
(),\
//if(m_pConnection->State == adStateOpen) MessageBox(\成功
连接数据库\
}
catch (_com_error e)
{
\提示
}
::CoUninitialize();
AfxMessageBox(e.ErrorMessage()); return;
CString str; _variant_t pcid; int OK=0;
str = \
m_pRecordset.CreateInstance(\m_pRecordset = m_pConnection->Execute(str.AllocSysString
(),NULL,adCmdText);
UpdateData(TRUE); CString pa;
while( !m_pRecordset->adoEOF ) { } if( !OK ){
AfxMessageBox(\不存在该课程\pcid = m_pRecordset->GetCollect(\CString tmp1 = (LPCSTR)(_bstr_t)pcid; if( strcmp(m_Edit1_cid,tmp1)==0 ){ }
m_pRecordset->MoveNext();
OK=1; break;