adotest.cpp

应用ADO技术编写的VC连接SQL的接口程序,具有广泛的适用性,也是学习基于VC的数据库编程的良好教程.

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

#include "stdafx.h"
#include "Adotest.h"
#include "AdotestDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAdotestApp

BEGIN_MESSAGE_MAP(CAdotestApp, CWinApp)
	//{{AFX_MSG_MAP(CAdotestApp)
		// 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()

/////////////////////////////////////////////////////////////////////////////
// CAdotestApp construction

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

/////////////////////////////////////////////////////////////////////////////
// The one and only CAdotestApp object

CAdotestApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CAdotestApp initialization

BOOL CAdotestApp::InitInstance()
{
	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

	if(!AfxOleInit())
	{
		AfxMessageBox("OLE初始化出错!");
		return FALSE;
	}
	m_pConnection.CreateInstance(_uuidof(Connection));//实例化连接对象
	try
	{ 
		
		m_pConnection->Open("Provider=SQLOLEDB;data souce=127.0.0.1;initial catalog=demo1;user id=fe;password=felix","","",adModeUnknown);//夏老师范例
		//m_pConnection->Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;User ID=fe;Persist Security Info=FALSE;Initial Catalog=demo1;Data Source=127.0.0.1","","",adModeUnknown);
		//m_pConnection->Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=FALSE;Initial Catalog=demo1;Data Source=127.0.0.1","","",adModeUnknown);//论文范例
	}                                       
	catch(_com_error e)
	{	
		AfxMessageBox("数据库连接失败!");
		return FALSE;
	}

	CAdotestDlg 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;
}