ADO相关代码(MFC中C++连接数据库).docVIP

(I)afx #pragma warning(disable: 4146) #import C:\Program Files\Common Files\system\ado\msado15.dll rename(EOF,adoEOF) using namespace ADODB; //(II)对话框建立之前：xxxApp--InitInstance CoInitialize(NULL); //::ExitInstance(创建虚函数). CoUninitialize(); //(III) //对话框头文件 _ConnectionPtr pConnection; _RecordsetPtr pQueryRecordSet; //OnInitDialog pConnection.CreateInstance(__uuidof(Connection)); //创建实例 pQueryRecordSet.CreateInstance(__uuidof(Recordset)); //(IV)放到对应的LIST对应位置 CString connectstr; HRESULT hr; connectstr = _T(Provider=Microsoft.Jet.OLEDB.4.0; \ Data Source=C:\\student.mdb; \ Jet OLEDB:Database Password=); hr = pConnection-Open((_bstr_t)connectstr, _T(admin), _T(), adModeUnknown); //(V) query放到按键的代码里(查询) CString sql(_T(SELECT * FROM stu_table)); pQueryRecordSet-Open(_variant_t(sql), pConnection.GetInterfacePtr(), adOpenDynamic, adLockPessimistic, adCmdText); int cnt = 0; while (!pQueryRecordSet-adoEOF) { CString name = (CString)pQueryRecordSet-GetCollect(姓名).bstrVal; //.bstrVal字符串类型 int age = pQueryRecordSet-GetCollect(年龄).intVal; //.intVal整形 CString strAge; strAge.Format(%d, age); CString num = pQueryRecordSet-GetCollect(学号).bstrVal; //insert into listctrl int idx = m_list.InsertItem(cnt++, name); m_list.SetItemText(idx, 1, strAge); m_list.SetItemText(idx, 2, num); pQueryRecordSet-MoveNext(); } ===================================================================================================== CString sql(_T(SELECT * FROM stu_table)); m_ctrData.DeleteAllItems(); try { if (adStateOpen == pQueryRecordSet-State) { pQueryRecordSet-Close(); } pQueryRecordSet-Open(_variant_t(sql), pConnection.GetInterfacePtr(), adOpenDynamic, adLockPessimistic, adCmdText); } catch(_com_error e) { AfxMessageBox(e.Descriptio