void CAADODlg::OnButton1()
{
if(m_list)
m_list.DeleteAllItems();
int intm; try
{
_variant_t RecordsAffected;
_bstr_t sno, sname,sage;
mysql.m_pRecordset = mysql.m_pConnection->Execute("select * from student",&RecordsAffected,adCmdText);
while(!mysql.m_pRecordset->adoEOF)
{//获取表中信息
sno= mysql.m_pRecordset->GetCollect("sno");
sname=mysql.m_pRecordset->GetCollect("sname");
sage=mysql.m_pRecordset->GetCollect("sage");
//显示表中信息
intm=m_list.InsertItem(0,(_bstr_t)sno);
m_list.SetItem(intm,1,1,(_bstr_t)sname,NULL,0,0,0);
m_list.SetItem(intm,2,1,(_bstr_t)sage,NULL,0,0,0);
mysql.m_pRecordset->MoveNext();
}
AfxMessageBox("查询成功!");
}
catch (_com_error e)
{
CString errormessage;
errormessage.Format("查询失败!\r\n错误信息:%s",e.ErrorMessage());
AfxMessageBox(errormessage);
return ;
}
我刚学MFC访问数据库SQL。有很多不懂,就照着这里试了一下,但是发现运行通不过,错误如下:
(具体可从这个博客中看一下,他错哪了?http://hi.baidu.com/bloodmonsterhl/blog/item/8d39f80e21cca4eaab6457b2.html我是按照这个博客上面去做的,最后运行错误如下,求高人解答呀)D:\Microsoft Visual Studio\MyProjects\AADO\AADODlg.cpp(207) : error C2065: 'mysql' : undeclared identifier
D:\Microsoft Visual Studio\MyProjects\AADO\AADODlg.cpp(207) : error C2228: left of '.m_pRecordset' must have class/struct/union type
D:\Microsoft Visual Studio\MyProjects\AADO\AADODlg.cpp(207) : error C2228: left of '.m_pConnection' must have class/struct/union type
D:\Microsoft Visual Studio\MyProjects\AADO\AADODlg.cpp(207) : error C2227: left of '->Execute' must point to class/struct/union
D:\Microsoft Visual Studio\MyProjects\AADO\AADODlg.cpp(208) : error C2228: left of '.m_pRecordset' must have class/struct/union type
D:\Microsoft Visual Studio\MyProjects\AADO\AADODlg.cpp(208) : error C2227: left of '->adoEOF' must point to class/struct/union
D:\Microsoft Visual Studio\MyProjects\AADO\AADODlg.cpp(208) : fatal error C1903: unable to recover from previous error(s); stopping compilation
执行 cl.exe 时出错.
}
{
if(m_list)
m_list.DeleteAllItems();
int intm; try
{
_variant_t RecordsAffected;
_bstr_t sno, sname,sage;
mysql.m_pRecordset = mysql.m_pConnection->Execute("select * from student",&RecordsAffected,adCmdText);
while(!mysql.m_pRecordset->adoEOF)
{//获取表中信息
sno= mysql.m_pRecordset->GetCollect("sno");
sname=mysql.m_pRecordset->GetCollect("sname");
sage=mysql.m_pRecordset->GetCollect("sage");
//显示表中信息
intm=m_list.InsertItem(0,(_bstr_t)sno);
m_list.SetItem(intm,1,1,(_bstr_t)sname,NULL,0,0,0);
m_list.SetItem(intm,2,1,(_bstr_t)sage,NULL,0,0,0);
mysql.m_pRecordset->MoveNext();
}
AfxMessageBox("查询成功!");
}
catch (_com_error e)
{
CString errormessage;
errormessage.Format("查询失败!\r\n错误信息:%s",e.ErrorMessage());
AfxMessageBox(errormessage);
return ;
}
我刚学MFC访问数据库SQL。有很多不懂,就照着这里试了一下,但是发现运行通不过,错误如下:
(具体可从这个博客中看一下,他错哪了?http://hi.baidu.com/bloodmonsterhl/blog/item/8d39f80e21cca4eaab6457b2.html我是按照这个博客上面去做的,最后运行错误如下,求高人解答呀)D:\Microsoft Visual Studio\MyProjects\AADO\AADODlg.cpp(207) : error C2065: 'mysql' : undeclared identifier
D:\Microsoft Visual Studio\MyProjects\AADO\AADODlg.cpp(207) : error C2228: left of '.m_pRecordset' must have class/struct/union type
D:\Microsoft Visual Studio\MyProjects\AADO\AADODlg.cpp(207) : error C2228: left of '.m_pConnection' must have class/struct/union type
D:\Microsoft Visual Studio\MyProjects\AADO\AADODlg.cpp(207) : error C2227: left of '->Execute' must point to class/struct/union
D:\Microsoft Visual Studio\MyProjects\AADO\AADODlg.cpp(208) : error C2228: left of '.m_pRecordset' must have class/struct/union type
D:\Microsoft Visual Studio\MyProjects\AADO\AADODlg.cpp(208) : error C2227: left of '->adoEOF' must point to class/struct/union
D:\Microsoft Visual Studio\MyProjects\AADO\AADODlg.cpp(208) : fatal error C1903: unable to recover from previous error(s); stopping compilation
执行 cl.exe 时出错.
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货