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

#include "stdafx.h"
#include "RemoteDB.h"
#include "RemoteDBDlg.h"

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












/////////////////////////////////////////////////////////////////////////////
// CRemoteDBApp

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

/////////////////////////////////////////////////////////////////////////////
// CRemoteDBApp construction

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

/////////////////////////////////////////////////////////////////////////////
// The one and only CRemoteDBApp object

CRemoteDBApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CRemoteDBApp initialization

BOOL CRemoteDBApp::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

//////////////////////////////////////////////////////////////////////////////
//初始化COM，創建ADO連接等操作
//////////////////////////////////////////////////////////////////////////////
	AfxOleInit();
	m_pConnection.CreateInstance(__uuidof(Connection));
	//在ADO操作中建議語句中要常用try...catch()來捕獲錯誤信息，
	//因為它有時會經常出現一些想不到的錯誤
	try                 
	{	
	
		//打開172.16.80.85上的SQL數據庫DEMO
		m_pConnection->Open("driver={SQL Server};Server=172.16.80.85;DATABASE=DEMO,UID=sa,PWD=sa","","",adModeUnknown);

		//打開本地上的SQL數據庫DEMO
		//m_pConnection->Open("driver={SQL Server};Server=(local);DATABASE=DEMO","","",adModeUnknown);

		//打開本地上的ACCESS數據庫DEMO
		//m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DEMO.mdb","","",adModeUnknown);


	}
	catch(_com_error e)
	{
		AfxMessageBox("數據庫連接失敗，確認數據庫是否在當前路徑下!");
		return FALSE;
	} 
	try
	{
		m_pCommand.CreateInstance(__uuidof(Command));
		m_pRecordset.CreateInstance(__uuidof(Recordset));
	}
	catch (_com_error &e)
	{
		AfxMessageBox("創立_CommandPtr和_RecordsetPtr實例失敗！");
		AfxMessageBox(e.ErrorMessage()); 
	}
//////////////////////////////////////////////////////////////////////////////
	CRemoteDBDlg 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;
}

int CRemoteDBApp::ExitInstance() 
{
	// TODO: Add your specialized code here and/or call the base class
	// 關閉ADO連接狀態
	if(m_pConnection->State)
		m_pConnection->Close();
	m_pConnection= NULL;

	if( m_pCommand->State )
		m_pCommand->Release();
	m_pCommand = NULL;

	if( m_pRecordset->State )
 		m_pRecordset->Close();
 	m_pRecordset = NULL;
	
	
	return CWinApp::ExitInstance();
}

//執行SQL語句
_RecordsetPtr CRemoteDBApp::ExcuteCommandADO(CString strSQL)
{
	if(strSQL == "")
		{
			AfxMessageBox("空SQL語句！");
			return NULL;
		}
	_bstr_t strQuery=strSQL;

	try
	{
		m_pCommand->ActiveConnection=m_pConnection;
		m_pCommand->CommandText = strQuery;
		m_pRecordset = m_pCommand->Execute(NULL,NULL,adCmdText);
	}
	catch(_com_error &e)
	{
		CString strErr;
		strErr="執行"+strSQL+"語句失敗";
		AfxMessageBox(strErr);
		AfxMessageBox(e.ErrorMessage());// 錯誤信息
		AfxMessageBox(e.Source());// 錯誤源
		AfxMessageBox(e.Description());// 錯誤描述

	}
	return m_pRecordset;
}