jiangdlan19901020的博客

VC++ MFC 文本分析 正则表达式编程小例

正则表达式30分钟入门教程(第二版).

VC++数据库编程例子 void CTstADODlg::OnTestAdo() { //db:test, user:mas, password:mas, //表:table_test, aaaa(int), bbbb(char ) //初始化COM库 if(!AfxOleInit()) { AfxMessageBox("OLE初始化出错!"); return; } char *pDBINFO = "Provider=SQLOLEDB;Persist Security Info=True;User ID=mas;Password=mas;Initial Catalog=test;Data Source=192.168.0.198;"; _ConnectionPtr pConn; try { HRESULT hResult = pConn.CreateInstance(_T("ADODB.Connection")); //创建Connection对象 if(SUCCEEDED(hResult)) { pConn->Open(pDBINFO, "", "", adModeUnknown); } else { AfxMessageBox("Create Instance failed!"); return; } CString strSql; _variant_t RecordsAffected; //插入记录 //strSql.Format(_T("INSERT INTO table_test VALUES('10','testString');")); //pConn->Execute(_bstr_t(strSql), &RecordsAffected , adCmdUnknown); //update //strSql.Format(_T("update table_test set aaaa='20' where aaaa='111'")); //pConn->Execute(_bstr_t(strSql), &RecordsAffected , adCmdUnknown); //执行查询语句 _RecordsetPtr pRecordset = NULL; strSql.Format(_T("SELECT * FROM table_test")); pRecordset.CreateInstance(_uuidof(Recordset)); pRecordset = pConn->Execute (_bstr_t(strSql) , &RecordsAffected , adCmdUnknown); //判断是否为空 if (pRecordset->adoBOF && pRecordset->adoEOF) { } else { //存在记录 int iAaaa; CString strAaaa; CString strBbbb; _variant_t var; pRecordset->MoveFirst(); for(; !pRecordset->adoEOF; pRecordset->MoveNext()) { var = pRecordset->GetCollect(_T("aaaa")); strAaaa = (char *)_bstr_t(var); iAaaa = atoi(strAaaa); var = pRecordset->GetCollect(_T("bbbb")); strBbbb = (char *)_bstr_t(var); // CString strShow; strShow.Format("intA:%d, stringB:%s!", iAaaa, strBbbb); MessageBox(strShow); } } //关闭记录集 if(pRecordset != NULL && pRecordset->State) { pRecordset->Close(); pRecordset = NULL; } } catch(_com_error e)///捕捉异常 { CString errormessage; errormessage.Format(_T("连接数据库失败!\r\n错误信息:%s"), e.ErrorMessage()); AfxMessageBox(errormessage); pConn.Release(); return; } //close pConn->Close(); pConn.Release(); AfxOleTerm(); //和AfxOleInit成对出现，这个程序退出时，MFC框架会调用 //但必须保证退出前，没有重复调用AfxOleInit() //所以此处必须调用该函数 }