数据库123.docx
- 文档编号:10203702
- 上传时间:2023-02-09
- 格式:DOCX
- 页数:3
- 大小:15.67KB
数据库123.docx
《数据库123.docx》由会员分享,可在线阅读,更多相关《数据库123.docx(3页珍藏版)》请在冰豆网上搜索。
数据库123
交谈中请勿轻信汇款、中奖信息,勿轻易拨打陌生电话。
周支松18:
34:
34
CStringerrormessage;
errormessage.Format(TEXT("读取数据失败!
\r\n错误信息:
%s"),e.ErrorMessage());
AfxMessageBox(errormessage);
周支松18:
42:
42
//数据库连接
try
{
HRESULThr;
hr=((CDataBaseProcessApp*)AfxGetApp())->m_pConnection.CreateInstance("ADODB.Connection");
if(SUCCEEDED(hr))
{
hr=((CDataBaseProcessApp*)AfxGetApp())->m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:
\\AccountBook.mdb",\
"","",adModeUnknown);
}
}
catch(_com_error&e)
{
CStringerrormessage;
errormessage.Format(TEXT("连接数据库失败!
\r\n错误信息:
%s"),e.ErrorMessage());
AfxMessageBox(errormessage);
}
王琪16:
36:
24
_variant_tvID,vDescription,vcID,vFigure,vRemark;
try
{
CStringstrSQL;
/*strSQL.Format(TEXT("SELECT*FROMItemWHERE(cID='%s')"),\
str_cID);*/
strSQL.Format(TEXT("SELECT*FROMItem"),\
str_cID);
//AfxMessageBox(strSQL);
((CDataBaseProcessApp*)AfxGetApp())->m_pRecorder.CreateInstance(TEXT("ADODB.Recordset"));
((CDataBaseProcessApp*)AfxGetApp())->m_pRecorder->Open((_bstr_t)strSQL,\
_variant_t((IDispatch*)(((CDataBaseProcessApp*)AfxGetApp())->m_pConnection),true),
adOpenStatic,
adLockOptimistic,
adCmdText);
CStringstr;
while(!
((CDataBaseProcessApp*)AfxGetApp())->m_pRecorder->adoEOF)
{
//从数据库中读取信息
nItem++;
vID=((CDataBaseProcessApp*)AfxGetApp())->m_pRecorder->GetCollect(TEXT("iID"));
vDescription=((CDataBaseProcessApp*)AfxGetApp())->m_pRecorder->GetCollect(TEXT("iDescription"));
vcID=((CDataBaseProcessApp*)AfxGetApp())->m_pRecorder->GetCollect(TEXT("cID"));
vRemark=((CDataBaseProcessApp*)AfxGetApp())->m_pRecorder->GetCollect(TEXT("iRemark"));
vFigure=((CDataBaseProcessApp*)AfxGetApp())->m_pRecorder->GetCollect(TEXT("iFigure"));
CStringstrtemp;
strtemp.Format(TEXT("%d:
%s|%s|%s|%s|%s|\n"),nItem,(LPCTSTR)((_bstr_t)vID),(LPCTSTR)((_bstr_t)vDescription),\
(LPCTSTR)((_bstr_t)vcID),(LPCTSTR)((_bstr_t)vRemark),(LPCTSTR)((_bstr_t)vFigure));
str+=strtemp;
//MessageBox(str);
((CDataBaseProcessApp*)AfxGetApp())->m_pRecorder->MoveNext();//移到下一条记录
}
m_MyRichEdit.SetWindowText(str);
}
catch(_com_error&e)
{
CStringerrormessage;
errormessage.Format(TEXT("读取数据失败!
\r\n错误信息:
%s"),e.ErrorMessage());
AfxMessageBox(errormessage);
}
((CDataBaseProcessApp*)AfxGetApp())->m_pRecorder->Close();
((CDataBaseProcessApp*)AfxGetApp())->m_pRecorder=NULL;
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 数据库 123