_CommandPtr
_ConnectionPtr链接集链接即打开数据库m_SqlConnection.CreateInstance("ADODB.Connection");
//strWay="driver={SQLServer};Server="+sqlname+";DATABASE=MyDataBase;UID="+sqluser+";PWD="+sqlpass;
strWay="driver={SQLServer};Server="+sqlname+";DATABASE=调度信息库";
m_SqlConnection->ConnectionTimeout=10;//设置超时时间为10秒
m_SqlConnection->CursorLocation=adUseClient;
m_SqlConnection->Open((_bstr_t)strWay,(_bstr_t)sqluser,(_bstr_t)sqlpass,adModeUnknown);
_RecordsetPtr记录集打开数据表(中的记录)
m_SqlRecordset.CreateInstance("ADODB.Recordset");
m_SqlRecordset->Open((_variant_t)("SELECT*FROM城市表WHERE省份='"+str+"'AND城市ISNOTNULL"),
(IDispatch*)m_SqlConnection,
adOpenStatic,
adLockOptimistic,
adCmdText);
_CommandPtr命令集打开数据表即执行命令
m_pCommand.CreateInstance("ADODB.Command");
m_pCommand->ActiveConnection=m_SqlConnection;
m_pCommand->CommandType=adCmdText;
vNULL.vt=VT_ERROR;
vNULL.scode=DISP_E_PARAMNOTFOUND;
sprintf(buf,"DELETEFROM接收短信WHEREID=%d",index);
m_pCommand->CommandText=buf;//命令字串。
m_pCommand->Execute(&vNULL,&vNULL,adCmdText);///执行命令。
_ParameterPtr参数集主要用于存储过程
_ParameterPtrparam;
param=m_pCommand->CreateParameter(_bstr_t("@user"),adVarChar,adParamInput,20);
param->Value=_variant_t(logname);.
m_pCommand->Parameters->Append(param);
_variant_tvNULL;
vNULL.vt=VT_ERROR;
vNULL.scode=DISP_E_PARAMNOTFOUND;
m_pCommand->Execute(&vNULL,&vNULL,adCmdStoredProc);
建议用属性更简单
m_pCommand->Parameters->Refresh();
m_pCommand->Parameters->Item["@user"]->Value=_variant_t(logname);
m_pCommand->Parameters->Item["@operation"]->Value=_variant_t(operation);
m_pCommand->Parameters->Item["@oper_type"]->Value=_variant_t(oper_type);
再如：
//四种操作字段的写入方法
m_pRecordset->Collect["名称"]=_variant_t(m_strName);
//m_pRecordset->Fields->Item["名称"]->Value=_variant_t(m_strName);
//m_pRecordset->PutCollect("名称",_variant_t(m_strName));
//m_pRecordset->GetFields()->GetItem("名称")->PutValue(_variant_t(m_strName));
//四种操作字段的读取方法
m_cmbCity.AddString((_bstr_t)m_SqlRecordset->Collect["城市"]);
//m_cmbCity.AddString((_bstr_t)m_SqlRecordset->Fields->Item["城市"]->Value);
//m_cmbCity.AddString((_bstr_t)m_SqlRecordset->GetCollect("城市"));
//m_cmbCity.AddString((_bstr_t)m_SqlRecordset->GetFields()->GetItem("城市")->GetValue());
m_SqlRecordset.CreateInstance("ADODB.Recordset");
m_SqlRecordset->CursorLocation=adUseClient;
m_SqlRecordset->Open(_variant_t(str),
_variant_t((IDispatch*)m_SqlConnection),
adOpenStatic,
adLockOptimistic,
adCmdText);
CStringstrFind;
strFind.Format("主叫号码=%s",m_strCheck);
strFind.Format("主叫号码LIKE\'%%%s%%\'",m_strCheck);
m_SqlRecordset->Fields->Item["主叫号码"]->Properties->Item["Optimize"]->Value="True";
m_SqlRecordset->Find((_bstr_t)strFind,1,adSearchForward);
页:
[1]