好的，下面是一个简单的示例代码，演示如何使用C++封装
ADO连接SQL Server进行增删查改操作：
```cpp
#include <iostream>
#include <windows.h>
#include <comdef.h>
#include <atlbase.h>
#import "C:\Program Files\Common Files\System\
ado\ms
ado15.dll" no_namespace rename("EOF", "
adoEOF")
class C
SQLServer
{
public:
C
SQLServer();
~C
SQLServer();
bool Connect(const std::string& str
Server, const std::string& strDatabase,
const std::string& strUser, const std::string& strPassword);
void Disconnect();
bool ExecuteNonQuery(const std::string& str
SQL);
bool ExecuteScalar(const std::string& str
SQL, _variant_t& vtResult);
private:
bool Init
ADO();
void Uninit
ADO();
private:
_ConnectionPtr m_pConnection;
};
C
SQLServer::C
SQLServer()
{
Init
ADO();
}
C
SQLServer::~C
SQLServer()
{
Uninit
ADO();
}
bool C
SQLServer::Connect(const std::string& str
Server, const std::string& strDatabase,
const std::string& strUser, const std::string& strPassword)
{
try
{
std::string strConnString = "Provider=
SQLOLEDB.1;";
strConnString += "Persist Security Info=False;";
strConnString += "Data Source=" + str
Server + ";";
strConnString += "Initial Catalog=" + strDatabase + ";";
strConnString += "User ID=" + strUser + ";";
strConnString += "Password=" + strPassword + ";";
m_pConnection->Open(strConnString.c_str(), "", "", adConnectUnspecified);
return true;
}
catch (_com_error& e)
{
std::cout << "Connect failed, error message: " << e.Description() << std::endl;
return false;
}
}
void C
SQLServer::Disconnect()
{
m_pConnection->Close();
}
bool C
SQLServer::ExecuteNonQuery(const std::string& str
SQL)
{
try
{
_RecordsetPtr pRecordset;
pRecordset = m_pConnection->Execute(str
SQL.c_str(), NULL, adCmdText);
return true;
}
catch (_com_error& e)
{
std::cout << "ExecuteNonQuery failed, error message: " << e.Description() << std::endl;
return false;
}
}
bool C
SQLServer::ExecuteScalar(const std::string& str
SQL, _variant_t& vtResult)
{
try
{
_RecordsetPtr pRecordset;
pRecordset = m_pConnection->Execute(str
SQL.c_str(), NULL, adCmdText);
if (pRecordset->
adoEOF == true)
{
vtResult.Clear();
return false;
}
vtResult = pRecordset->Fields->GetItem((long)0)->Value;
return true;
}
catch (_com_error& e)
{
std::cout << "ExecuteScalar failed, error message: " << e.Description() << std::endl;
return false;
}
}
bool C
SQLServer::Init
ADO()
{
try
{
HRESULT hr = CoInitialize(NULL);
if (FAILED(hr))
{
std::cout << "CoInitialize failed" << std::endl;
return false;
}
hr = m_pConnection.CreateInstance(__uuidof(Connection));
if (FAILED(hr))
{
std::cout << "CreateInstance failed" << std::endl;
CoUninitialize();
return false;
}
return true;
}
catch (_com_error& e)
{
std::cout << "Init
ADO failed, error message: " << e.Description() << std::endl;
return false;
}
}
void C
SQLServer::Uninit
ADO()
{
m_pConnection.Release();
CoUninitialize();
}
int main()
{
C
SQLServer sqlServer;
if (!
sqlServer.Connect("localhost", "MyDatabase", "sa", "123456"))
{
return 0;
}
// 插入数据
std::string str
SQL = "INSERT INTO MyTable (Name, Age) VALUES ('Tom', 20)";
sqlServer.ExecuteNonQuery(str
SQL);
// 修改数据
str
SQL = "UPDATE MyTable SET Age = 21 WHERE Name = 'Tom'";
sqlServer.ExecuteNonQuery(str
SQL);
// 查询数据
str
SQL = "SELECT Age FROM MyTable WHERE Name = 'Tom'";
_variant_t vtResult;
if (
sqlServer.ExecuteScalar(str
SQL, vtResult))
{
std::cout << "Tom's age is " << (int)vtResult.intVal << std::endl;
}
else
{
std::cout << "Tom not found!" << std::endl;
}
// 删除数据
str
SQL = "DELETE FROM MyTable WHERE Name = 'Tom'";
sqlServer.ExecuteNonQuery(str
SQL);
sqlServer.Disconnect();
return 0;
}
```
上述代码使用`C
SQLServer`类封装了
ADO连接SQL Server的操作，并提供了插入、修改、查询、删除数据的方法。在使用时，只需要创建一个`C
SQLServer`对象，调用`Connect`方法
连接数据库，然后调用相应的方法执行
SQL语句即可。
注意：上述代码使用了`#import`指令引入了`ms
ado15.dll`库，需要确保该库已经安装在您的系统中。另外，需要链接`comsupp.lib`库。
4882
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
