try
{
if(!m_pRecordset->BOF)
{
m_pRecordset->MoveFirst();
}
else
{
cout<<"表内为空"<<endl;
}
while(!m_pRecordset->adoEOF)
{
//var1=m_pRecordset->Fields->GetItem("USERNAME")->GetValue();
var1=m_pRecordset->GetCollect("USERNAME");
m_pRecordset->MoveNext();
if(var1.vt!=VT_NULL)
{
content=_com_util::ConvertBSTRToString((_bstr_t)var1);
}
cout<<"从数据库得到数据："<<content<<endl;
}
}
catch(_com_error *e)
{
cout<<e->ErrorMessage()<<endl;
}
break;
case 'd':
try
{
_variant_t RecordsAffected;
CString sql;
sql="delete * from DB_USER where USERID='3'";
m_pConnection->Execute((_bstr_t)sql，&RecordsAffected，adCmdText);
cout<<"删除成功！"<<endl;
}
catch(_com_error *e)
{
cout<<e->ErrorMessage()<<endl;
return 0;
}
break;
case 'u':
try
{
_variant_t RecordsAffected;
CString sql;
sql="update DB_USER set EMAIL='cupt5634@126.com' where USERID=1";
m_pConnection->Execute((_bstr_t)sql，&RecordsAffected，adCmdText);
cout<<"更新成功！"<<endl;
break;
}
catch(_com_error *e)
{
cout<<e->ErrorMessage()<<endl;
return 0;
}
case 'a':
try
{
_variant_t  RecordsAffected;
CString sql;
sql="insert into DB_USER (USERNAME，PWD1，SEX，EMAIL，USERID)values ('Allen'，'1235698'，'女'，'698797@qq.com'，'3')";
m_pConnection->Execute((_bstr_t)sql，&RecordsAffected，adCmdText);
cout<<"数据添加成功！"<<endl;
}
catch(_com_error *e)
{
cout<<e->ErrorMessage()<<endl;
return 0;
}
break;
}
}