/////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////// //////////////////////////////
int DBPool::InsertDB(char *chSQL)
{
try
{
COleVariant vtOptional((long)DISP_E_PARAMNOTFOUND,VT_ERROR);
m_pConn->Execute(_bstr_t(chSQL),&vtOptional,-1);
}catch(_com_error e)
{
_bstr_t bstrErr=e.Description();
CString strErrInfo;
strErrInfo.Format("Error Information :%s\n", (LPCSTR)bstrErr);
//WriteLog(strErrInfo);
return -1;
}
/*
try
{
//设置查询命令
m_pCommand->CommandText = chSQL;
//执行查询命令
m_pCommand->Execute(NULL , NULL , NULL);
}
catch(_com_error e)
{
_bstr_t bstrErr=e.Description();
CString strErrInfo;
strErrInfo.Format("Error Information :%s\n", (LPCSTR)bstrErr);
//WriteLog(strErrInfo);
return -1;
}
*/
return 0;
}
/////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////// //////////////////////////////
int DBPool::QueryDB(char *chSQL)
{
try
{
COleVariant vtOptional((long)DISP_E_PARAMNOTFOUND,VT_ERROR);
m_pRS=m_pConn->Execute(_bstr_t(chSQL),&vtOptional,-1);
//printf("\r\n");
while(!m_pRS->EndOfFile)
{
CString s(m_pRS->Fields->GetItem(_variant_t("counter_name"))->Value.bstrVal);
int a=m_pRS->Fields->GetItem(_variant_t("cntr_value"))->Value.intVal;
//CString s1(m_pRS->Fields->GetItem(_variant_t("cntr_value"))->Value.);
m_pRS->MoveNext();
s.TrimRight(" ");
s.Replace(" ","_");
s.Replace("/","_");
// printf("%s=%d\r\n",s,a);
}
}catch(_com_error e)
{
_bstr_t bstrErr=e.Description();
CString strErrInfo;
strErrInfo.Format("Error Information :%s\n", (LPCSTR)bstrErr);
//WriteLog(strErrInfo);
return -1;
}
return 0;
}
//执行SQL更新语句，如插入、更新、删除
inline bool CRegisterDialog::ExcuteSQL(CString strSQL)
{
try
{
COleVariant vtOptional((long)DISP_E_PARAMNOTFOUND,VT_ERROR);
theApp.m_pConnection->Execute(_bstr_t(strSQL),&vtOptional,-1);
}
catch(_com_error e)
{
// AfxMessageBox(e->ErrorMessage());
throw e;
return false;
}
return true;
}
