4,011
社区成员
发帖
与我相关
我的任务
分享
CoInitialize(NULL);
_ConnectionPtr m_pConnection;
m_pConnection.CreateInstance(__uuidof(Connection));
m_pConnection->Open("Provider=OraOLEDB.Oracle.1;User ID=scheduler;Password=scheduler;Data Source=151;", "", "", adModeUnknown );
_RecordsetPtr m_pRecordset;
m_pRecordset.CreateInstance(__uuidof(Recordset));
for (int i=0;i<10;i++)
{
m_pRecordset->Open("select * from rules", m_pConnection.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText);
if(m_pRecordset!=NULL)
{
if (m_pRecordset->State) m_pRecordset->Close();
}
}
if(m_pConnection!=NULL)
{
if(m_pConnection->State) m_pConnection->Close();
}
CoUninitialize();
CoInitialize(NULL);
int iPeriod=60*1000;
// 创建定时器并启动定时器
LARGE_INTEGER liStartTime;
liStartTime.QuadPart=-10*10000000;
HANDLE m_hTime=CreateWaitableTimer(NULL,FALSE,NULL);
SetWaitableTimer(m_hTime,&liStartTime,iPeriod,NULL,NULL,FALSE);
int i=0;
MSG msg;
while(!PeekMessage(&msg, NULL, WM_QUIT, WM_QUIT, PM_REMOVE))
{
if(WaitForSingleObject(m_hTime,iPeriod) == WAIT_OBJECT_0)
{
/*setchar();
bbb();
ccc();*/
//if (i<30)
{
aaa();
}
i++;
}
}
CoUninitialize();
void aaa()
{
_ConnectionPtr m_pConnection;
m_pConnection.CreateInstance(__uuidof(Connection));
m_pConnection->Open("Provider=OraOLEDB.Oracle.1;User ID=scheduler;Password=scheduler;Data Source=151;", "", "", adModeUnknown );
_RecordsetPtr m_pRecordset;
m_pRecordset.CreateInstance(__uuidof(Recordset));
//for (int i=0;i<10;i++)
{
m_pRecordset->Open("select * from rules", m_pConnection.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText);
if(m_pRecordset!=NULL)
{
if (m_pRecordset->State)
m_pRecordset->Close();
m_pRecordset.Release();
m_pRecordset=NULL;
}
}
if(m_pConnection!=NULL)
{
if(m_pConnection->State)
m_pConnection->Close();
m_pConnection.Release();
m_pConnection=NULL;
}
}