关于C++中编程问题：将链接oracle改为链接access

麻烦各位大神们帮忙改一代码：

这是一个叫做KMS的知识库应用（之前一个学长自己编写做的），他的知识库用的是和oracle连接的，我的毕业设计题目和他基本完全一样，就是需要把oracle数据库换成access数据库。但是我自己本身不是学软件或者计算机的（本专业是机械。。。），所以真心不会c++...在书上网上查看了很多，链接数据库都是有标准的这样的模块的，但是这个变成和那些出入很大。。。就无从下手了，还麻烦大家帮忙看看，原来他的代码如下（这是连接oracle的）：

// KMS.cpp : Defines the class behaviors for the application.

//

 

#include "stdafx.h"

#include "KMS.h"

 

#include "MainFrm.h"

#include "KMSDoc.h"

#include "KMSView.h"

#include "WelcomeDlg.h"

 

#ifdef _DEBUG

#define new DEBUG_NEW

#undef THIS_FILE

static char THIS_FILE[] = __FILE__;

#endif

 

long m_lLastKnowledgeTextID;

/////////////////////////////////////////////////////////////////////////////

// CKMSApp

 

BEGIN_MESSAGE_MAP(CKMSApp, CWinApp)

         //{{AFX_MSG_MAP(CKMSApp)

         ON_COMMAND(ID_APP_ABOUT, OnAppAbout)

         ON_COMMAND(ID_FILE_NEW, OnFileNew)

         //}}AFX_MSG_MAP

         // Standard file bbsed document commands

         ON_COMMAND(ID_FILE_NEW, CWinApp::OnFileNew)

         ON_COMMAND(ID_FILE_OPEN, CWinApp::OnFileOpen)

         // Standard print setup command

         ON_COMMAND(ID_FILE_PRINT_SETUP, CWinApp::OnFilePrintSetup)

END_MESSAGE_MAP()

 

/////////////////////////////////////////////////////////////////////////////

// CKMSApp construction

 

CKMSApp::CKMSApp()

{

         // TODO: add construction code here,

         // Place all significant initialization in InitInstance

         m_pDocTemplate = NULL;

         m_lLastKnowledgeTextID = -1;  // 初始化上一次被操作的知识文件的ID号为-1

         GetDefaultConnect();  // 得到程序初始构造时的File dsn的目录

}

 

/////////////////////////////////////////////////////////////////////////////

// The one and only CKMSApp object

 

CKMSApp theApp;

CString FileName = getenv("TEMP");

/////////////////////////////////////////////////////////////////////////////

// CKMSApp initialization

 

BOOL CKMSApp::InitInstance()

{

         AfxOleInit();

         // Initialize OLE libraries

         if (!AfxOleInit())

         {

                   AfxMessageBox(IDP_OLE_INIT_FAILED);

                   return FALSE;

         }

 

         AfxEnableControlContainer();

         // Standard initialization

         // If you are not using these features and wish to reduce the size

         //  of your final executable, you should remove from the following

         //  the specific initialization routines you do not need.

 

#ifdef _AFXDLL

         Enable3dControls();                            // Call this when using MFC in a shared DLL

#else

         Enable3dControlsStatic();        // Call this when linking to MFC statically

#endif

 

         // Change the registry key under which our settings are stored.

         // TODO: You should modify this string to be something appropriate

         // such as the name of your company or organization.

         SetRegistryKey(_T("Local AppWizard-Generated Applications"));

 

         LoadStdProfileSettings(0);  // Load standard INI file options (including MRU)

 

         // Register the application's document templates.  Document templates

         //  serve as the connection between documents, frame windows and views.

 

         CSingleDocTemplate* pDocTemplate;

         pDocTemplate = new CSingleDocTemplate(

                   IDR_MAINFRAME,

                   RUNTIME_CLASS(CKMSDoc),

                   RUNTIME_CLASS(CMainFrame),       // main SDI frame window

                   RUNTIME_CLASS(CKMSView));

         pDocTemplate->SetContainerInfo(IDR_CNTR_INPLACE);

         AddDocTemplate(pDocTemplate);

         m_pDocTemplate = pDocTemplate;

 

         // Parse command line for standard shell commands, DDE, file open

         CCommandLineInfo cmdInfo;

         ParseCommandLine(cmdInfo);

 

         // Dispatch commands specified on the command line

         if (!ProcessShellCommand(cmdInfo))

                   return FALSE;

 

         // The one and only window has been initialized, so show and update it.

         m_pMainWnd->ShowWindow(SW_SHOWMAXIMIZED);

         m_pMainWnd->UpdateWindow();

 

         ConnectRecordsets();  //打开数据库中的记录

 

         return TRUE;

}

/////////////////////////////////////////////////////////////////////////////

// CAboutDlg dialog used for App About

 

class CAboutDlg : public CDialog

{

public:

         CAboutDlg();

 

// Dialog Data

         //{{AFX_DATA(CAboutDlg)

         enum { IDD = IDD_ABOUTBOX };

         CAnimateCtrl  m_animate;

         //}}AFX_DATA

 

         // ClassWizard generated virtual function overrides

         //{{AFX_VIRTUAL(CAboutDlg)

         protected:

         virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support

         //}}AFX_VIRTUAL

 

// Implementation

protected:

         //{{AFX_MSG(CAboutDlg)

         virtual BOOL OnInitDialog();

         //}}AFX_MSG

         DECLARE_MESSAGE_MAP()

};

 

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)

{

         //{{AFX_DATA_INIT(CAboutDlg)

         //}}AFX_DATA_INIT

}

 

void CAboutDlg::DoDataExchange(CDataExchange* pDX)

{

         CDialog::DoDataExchange(pDX);

         //{{AFX_DATA_MAP(CAboutDlg)

         DDX_Control(pDX, IDC_ANIMATE_MOUSE, m_animate);

         //}}AFX_DATA_MAP

}

 

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)

         //{{AFX_MSG_MAP(CAboutDlg)

         //}}AFX_MSG_MAP

END_MESSAGE_MAP()

 

// App command to run the dialog

void CKMSApp::OnAppAbout()

{

         CAboutDlg aboutDlg;

         aboutDlg.DoModal();

}

 

/////////////////////////////////////////////////////////////////////////////

// CKMSApp message handlers

void CKMSApp::OnFileNew()

{

         // TODO: Add your command handler code here

         CWinApp::OnFileNew();

}

 

 

void CKMSApp::GetDefaultConnect()

{

         char* buffer = new char[40];

         ::GetCurrentDirectory(40, buffer);

         m_strCurrentDirectory = buffer;

         m_strDefaultConnect += m_strCurrentDirectory;

 

//      m_strDefaultConnect+="\FileSource.dsn";//m_strDefaultConnect;

 //   AfxMessageBox(m_strDefaultConnect);

//      m_strDefaultConnect="ODBC;FILEDSN="+m_strDefaultConnect+";UID=KMS;PWD=KMS;";

    m_strDefaultConnect = "ODBC;DSN=KMS;UID=KMS;PWD=KMS;";

 

    delete []buffer;

}

void CKMSApp::ConnectRecordsets()

{

         CWelcomeDlg welDlg;

         welDlg.Create(IDD_WELCOME_DLG, NULL);

         CRect rect;

         theApp.m_pMainWnd->GetClientRect(&rect);

        

         welDlg.MoveWindow(rect.right/2 - 150,rect.bottom/2 - 30 , 300, 60, TRUE);

         SetDlgItemText(welDlg.GetSafeHwnd(), IDC_TEXT, "正在检查数据库是否连通，请稍后...");

         welDlg.ShowWindow(SW_SHOW);

 

         CDatabbse db;

         m_ptreeRecordSet = new CTreeRecordSet;

         m_pknowledgeRecordSet = new CKnowledgeRecordSet;

         m_pkTextRecordSet = new CKTextRecordSet;

 

         try

         {

                   m_ptreeRecordSet->Open(CRecordset::snapshot, "select * from KNOWLEDGE_TREE", CRecordset::none);

                   m_pknowledgeRecordSet->Open(CRecordset::snapshot, "select * from KNOWLEDGE", CRecordset::none);

                   m_pkTextRecordSet->Open(CRecordset::snapshot, "select * from KNOWLEDGE_TEXT", CRecordset::none);                              

 

                   db.Open(NULL, FALSE, FALSE, _T(((CKMSApp*)AfxGetApp())->m_strDefaultConnect), FALSE); //如果未连通数据库

                  

         }

         catch(CDBException* e)

         {

                   e->Delete();

         }

         if (!db.IsOpen())

         {

                   welDlg.DestroyWindow();

                   AfxMessageBox("数据库未连通,请检查网络是否连接");

                   return;

         }

         db.Close();

 

         welDlg.DestroyWindow();

}

 

 

 

BOOL CAboutDlg::OnInitDialog()

{

         CDialog::OnInitDialog();

        

         // TODO: Add extra initialization here

         m_animate.Open(IDR_MOUSE_AVI);

 

         return TRUE;  // return TRUE unless you set the focus to a control

                       // EXCEPTION: OCX Property Pages should return FALSE

}