从外部配置文件中读数据库语句查询数据库

最新推荐文章于 2022-07-04 16:59:01 发布

爷就是这个范儿

最新推荐文章于 2022-07-04 16:59:01 发布

阅读量680

点赞数

CC 4.0 BY-SA版权

分类专栏：个人兴趣

本文链接：https://blog.youkuaiyun.com/syytem004/article/details/38583011

个人兴趣专栏收录该内容

24 篇文章

订阅专栏

本文介绍了一种通过读取INI配置文件中的SQL语句来执行数据库查询的方法，并展示了如何使用C++实现这一过程，包括连接数据库、执行SQL语句及处理查询结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

void CMfclofintestDlg::OnButton1()
{
// TODO: Add your control notification handler code here
CString str1,str2;
CString str3 = "1";
int n = ::GetPrivateProfileString("test","test1","error",str1.GetBuffer(250),250,".\\test.ini");
str2.Format(str1,str3);
//AfxMessageBox(str2);
CoInitialize(NULL);
_ConnectionPtr sqlSp;
HRESULT hr=sqlSp.CreateInstance(_uuidof(Connection));
if(FAILED(hr))
{
AfxMessageBox("指针实例化失败 ");
return ;
}
else
{
try
{
_bstr_t strConnect="Driver={sql server};server=127.0.0.1,1433;uid=sa;pwd=1234567;database=DataCollection;";
sqlSp->Open(strConnect,"","",adModeUnknown);
}
catch(_com_error &e)
{
AfxMessageBox("打开数据库失败！");
}
}
_RecordsetPtr m_pRecordset; //记录集对象指针，用来执行SQL语句并记录查询结果
if(FAILED(m_pRecordset.CreateInstance( _uuidof( Recordset ))))
{
AfxMessageBox("指针实例化失败 ");
return ;
}
m_pRecordset = sqlSp->Execute(_bstr_t(str2),NULL,adCmdText);
while(!m_pRecordset->adoEOF)
{
string UserName=(char*)(_bstr_t)(m_pRecordset->Fields->GetItem(_variant_t("UserName"))->Value);
string Password=(char*)(_bstr_t)(m_pRecordset->Fields->GetItem(_variant_t("Password"))->Value);
CString strname,strpass;
strname = UserName.c_str();
strpass = Password.c_str();
AfxMessageBox(strname +" " +strpass);
m_pRecordset->MoveNext();
}

}

文件中的格式：

[test]
test1 = select * from t_User where UserType = '%s'

或者

void CMfclofintestDlg::OnButton1()
{
// TODO: Add your control notification handler code here
CString str1,str2;
int n = ::GetPrivateProfileString("test","test1","error",str1.GetBuffer(250),250,".\\test.ini");
n = ::GetPrivateProfileString("test","test2","error",str2.GetBuffer(250),250,".\\test.ini");
//str2.Format(str1,str3);
//AfxMessageBox(str2);
CoInitialize(NULL);
_ConnectionPtr sqlSp;
HRESULT hr=sqlSp.CreateInstance(_uuidof(Connection));
if(FAILED(hr))
{
AfxMessageBox("指针实例化失败 ");
return ;
}
else
{
try
{
_bstr_t strConnect="Driver={sql server};server=127.0.0.1,1433;uid=sa;pwd=1234567;database=DataCollection;";
sqlSp->Open(strConnect,"","",adModeUnknown);
}
catch(_com_error &e)
{
AfxMessageBox("打开数据库失败！");
}
}
_RecordsetPtr m_pRecordset; //记录集对象指针，用来执行SQL语句并记录查询结果
if(FAILED(m_pRecordset.CreateInstance( _uuidof( Recordset ))))
{
AfxMessageBox("指针实例化失败 ");
return ;
}
m_pRecordset = sqlSp->Execute(_bstr_t(str2),NULL,adCmdText);
while(!m_pRecordset->adoEOF)
{
string UserName=(char*)(_bstr_t)(m_pRecordset->Fields->GetItem(_variant_t("UserName"))->Value);
string Password=(char*)(_bstr_t)(m_pRecordset->Fields->GetItem(_variant_t("Password"))->Value);
CString strname,strpass;
strname = UserName.c_str();
strpass = Password.c_str();
AfxMessageBox(strname +" " +strpass);
m_pRecordset->MoveNext();
}
}