MFC使用ADO在Oracle中查重

2014年3月29日15:33:28

MFC使用ADO在Oracle中查重

代码：

_bstr_t bstrPointSQL(_T("select SN from LWW_TEST where SN=774"));  try  {  pCenterRecordset->Open(bstrPointSQL, pCenterConnection.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText);  _variant_t var;  int nSn=0;int nX=0;int nY=0;  CString str;  bool bExist = false;if (!pCenterRecordset->EndOfFile)  {  bExist = true;}pCenterRecordset->Close();  }catch (_com_error  e)  {  exit(-1);  }