_CommandPtr

阿杰

1. _ConnectionPtr链接集链接即打开数据库
   
2. m_SqlConnection.CreateInstance("ADODB.Connection");
   
3. //strWay="driver={SQLServer};Server="+sqlname+";DATABASE=MyDataBase;UID="+sqluser+";PWD="+sqlpass;
   
4. strWay="driver={SQLServer};Server="+sqlname+";DATABASE=调度信息库";
   
5. m_SqlConnection->ConnectionTimeout=10;//设置超时时间为10秒
   
6. m_SqlConnection->CursorLocation=adUseClient;
   
7. m_SqlConnection->Open((_bstr_t)strWay,(_bstr_t)sqluser,(_bstr_t)sqlpass,adModeUnknown);
   
8. _RecordsetPtr记录集打开数据表(中的记录)
   
9. m_SqlRecordset.CreateInstance("ADODB.Recordset");
   
10. m_SqlRecordset->Open((_variant_t)("SELECT*FROM城市表WHERE省份='"+str+"'AND城市ISNOTNULL"),
    
11. (IDispatch*)m_SqlConnection,
    
12. adOpenStatic,
    
13. adLockOptimistic,
    
14. adCmdText);
    
15. _CommandPtr命令集打开数据表即执行命令
    
16. m_pCommand.CreateInstance("ADODB.Command");
    
17. m_pCommand->ActiveConnection=m_SqlConnection;
    
18. m_pCommand->CommandType=adCmdText;
    
19. vNULL.vt=VT_ERROR;
    
20. vNULL.scode=DISP_E_PARAMNOTFOUND;
    
21. sprintf(buf,"DELETEFROM接收短信WHEREID=%d",index);
    
22. m_pCommand->CommandText=buf;//命令字串。
    
23. m_pCommand->Execute(&vNULL,&vNULL,adCmdText);///执行命令。
    
24. _ParameterPtr参数集主要用于存储过程
    
25. _ParameterPtrparam;
    
26. param=m_pCommand->CreateParameter(_bstr_t("@user"),adVarChar,adParamInput,20);
    
27. param->Value=_variant_t(logname);.
    
28. m_pCommand->Parameters->Append(param);
    
29. _variant_tvNULL;
    
30. vNULL.vt=VT_ERROR;
    
31. vNULL.scode=DISP_E_PARAMNOTFOUND;
    
32. m_pCommand->Execute(&vNULL,&vNULL,adCmdStoredProc);
    
33. 建议用属性更简单
    
34. m_pCommand->Parameters->Refresh();
    
35. m_pCommand->Parameters->Item["@user"]->Value=_variant_t(logname);
    
36. m_pCommand->Parameters->Item["@operation"]->Value=_variant_t(operation);
    
37. m_pCommand->Parameters->Item["@oper_type"]->Value=_variant_t(oper_type);
    
38. 再如：
    
39. //四种操作字段的写入方法
    
40. m_pRecordset->Collect["名称"]=_variant_t(m_strName);
    
41. //m_pRecordset->Fields->Item["名称"]->Value=_variant_t(m_strName);
    
42. //m_pRecordset->PutCollect("名称",_variant_t(m_strName));
    
43. //m_pRecordset->GetFields()->GetItem("名称")->PutValue(_variant_t(m_strName));
    
44. //四种操作字段的读取方法
    
45. m_cmbCity.AddString((_bstr_t)m_SqlRecordset->Collect["城市"]);
    
46. //m_cmbCity.AddString((_bstr_t)m_SqlRecordset->Fields->Item["城市"]->Value);
    
47. //m_cmbCity.AddString((_bstr_t)m_SqlRecordset->GetCollect("城市"));
    
48. //m_cmbCity.AddString((_bstr_t)m_SqlRecordset->GetFields()->GetItem("城市")->GetValue());
    
49. m_SqlRecordset.CreateInstance("ADODB.Recordset");
    
50. m_SqlRecordset->CursorLocation=adUseClient;
    
51. m_SqlRecordset->Open(_variant_t(str),
    
52. _variant_t((IDispatch*)m_SqlConnection),
    
53. adOpenStatic,
    
54. adLockOptimistic,
    
55. adCmdText);
    
56. CStringstrFind;
    
57. strFind.Format("主叫号码=%s",m_strCheck);
    
58. strFind.Format("主叫号码LIKE\'%%%s%%\'",m_strCheck);
    
59. m_SqlRecordset->Fields->Item["主叫号码"]->Properties->Item["Optimize"]->Value="True";
    
60. m_SqlRecordset->Find((_bstr_t)strFind,1,adSearchForward);

复制代码