MFC(20)-ado-mysql

用C++对mysql进行增删改查
 

//1.初始化DB
::CoInitialize(NULL);

//2.连接数据库
_ConnectionPtr m_pConnection;
_RecordsetPtr m_pRecordset;
m_pConnection.CreateInstance(__uuidof(Connection));
CString strConnection;
strConnection = _T("Provider=MSDASQL.1;Persist Security Info=True;Driver=") + strServerDriver + _T(";SERVER=") + strServerAddress + _T(";PORT=") + strServerPort + _T(";DATABASE=") + strDatabaseName + _T(";UserID=") + strUserName + _T("Password=") + strPassword + _T(";UID=") + strUserName + _T(";PWD=") + strPassword + _T(";");
m_pConnection->ConnectionTimeout = 15;
if (m_pConnection->Open(_bstr_t(strConnection), "", "", adModeUnknown) == 0)
{
		return pConnection;
}

//3.数据集操作
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pRecordset->CursorLocation = adUseClient;
CString strSql ="";                    //此处为sql语句
m_pRecordset->Open
m_pConnection->BeginTrans();            //开始事务
for()                                    //..
{
    m_pRecordset->AddNew();
    m_pRecordset->PutCollect("TurbineID", _variant_t(strTurbineID));//写入数据
    _variant_t var = m_pRecordset->GetCollect("DATA");              //得到数据
}
m_pRecordset->UpdateBatch(adAffectAll);
m_pConnection->CommitTrans();           //结束事务
m_pRecordset->Close();
m_pRecordset.Release();
m_pRecordset = NULL;