例子应用

#include “shpopen.h”
#include “PPSAdo.h”
#include “CADOOP.h”

头文件.h

CAdoForPPS* g_mdbAdo;

CDataDlg::CDataDlg(CWnd* pParent /=NULL/): CDialog(CDataDlg::IDD, pParent)
{
g_mdbAdo = NULL;
m_vec3DModel.clear();
}

CDataDlg::~CDataDlg()
{
DisConnectDSmdb();
}

bool ::ConnectToDSmdb(CString strMdbPath)
{
DisConnectDSmdb();
g_mdbAdo = new CAdoForPPS;
if (!g_mdbAdo->OpenAccess(strMdbPath))
{
delete g_mdbAdo;
g_mdbAdo = NULL;
AfxMessageBox(_T(“mdb数据库连接失败！”));
return false;
}

return true;

}

void ::DisConnectDSmdb()
{
if(g_mdbAdo)
{
delete g_mdbAdo;
g_mdbAdo = NULL;
}
}

bool CInstoreDataDlg::AnalysMdbFile()
{
………………
CString strNodeSQL;
CStringArray aryContent;
strNodeSQL.Format(_T(“SELECT %s,%s,%s,%s FROM %s”), strSGElevenTemp, strNodeTypeTemp, strCodeNumTemp, strPos, strNodeSheet);
UINT nRecCount = g_mdbAdo->GetRecordFromDB(strNodeSQL, aryContent);
if (nRecCount==0)
{
AfxMessageBox(_T(“数据库字段错误，请检查！”));
return false;
}
CString strMark = m_curPipePlan->stuPipeData.sHorizFields.strDivMark;
int nCol = 4;
for (int n = 0; n < nRecCount; n++)
{
CString strGElev = aryContent[n*nCol];
}
}