testdb.cpp

连接并使用Oracle。可以创建表、预览数据集、删除、修改数据集。将这些操作封装在类里

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

#include "stdafx.h"
#include "TestDB.h"
#include "TestDBDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CTestDBApp

BEGIN_MESSAGE_MAP(CTestDBApp, CWinApp)
	//{{AFX_MSG_MAP(CTestDBApp)
		// NOTE - the ClassWizard will add and remove mapping macros here.
		//    DO NOT EDIT what you see in these blocks of generated code!
	//}}AFX_MSG
	ON_COMMAND(ID_HELP, CWinApp::OnHelp)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTestDBApp construction

CTestDBApp::CTestDBApp()
{
	// TODO: add construction code here,
	// Place all significant initialization in InitInstance
}

/////////////////////////////////////////////////////////////////////////////
// The one and only CTestDBApp object

CTestDBApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CTestDBApp initialization

BOOL CTestDBApp::InitInstance()
{
	AfxEnableControlContainer();

	BOOL bSucc=m_conn.connect("scott","tiger","");
	if(!bSucc)
	{
		MessageBox(NULL,"连接数据库失败!","错误",MB_ICONERROR);
		return FALSE;
	}

	bSucc=m_db.OpenEx("DSN=testdsn;UID=scott;PWD=tiger",CDatabase::useCursorLib|CDatabase::noOdbcDialog);
	if(!bSucc)
	{
		MessageBox(NULL,"连接数据库失败!","错误",MB_ICONERROR);
		return FALSE;
	}

	// 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

	CTestDBDlg dlg;
	m_pMainWnd = &dlg;
	int nResponse = dlg.DoModal();
	if (nResponse == IDOK)
	{
		// TODO: Place code here to handle when the dialog is
		//  dismissed with OK
	}
	else if (nResponse == IDCANCEL)
	{
		// TODO: Place code here to handle when the dialog is
		//  dismissed with Cancel
	}

	// Since the dialog has been closed, return FALSE so that we exit the
	//  application, rather than start the application's message pump.
	return FALSE;
}