sqllogdlg.cpp

用C++编写的数据库软件

// SqlLogDlg.cpp : implementation file
//

#include "stdafx.h"
#include "MySqlPlus.h"
#include "SqlLogDlg.h"
#include "Common.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSqlLogDlg dialog

extern CMySqlPlusApp theApp;

CSqlLogDlg::CSqlLogDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSqlLogDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSqlLogDlg)
	m_username = _T("");
	m_passwd = _T("");
	m_dbserver = _T("");
	m_initDb = _T("");
	//}}AFX_DATA_INIT
}


void CSqlLogDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSqlLogDlg)
	DDX_Text(pDX, IDC_USERNAME, m_username);
	DDX_Text(pDX, IDC_PASSWORD, m_passwd);
	DDX_Text(pDX, IDC_DBSERVER, m_dbserver);
	DDX_Text(pDX, IDC_DBTABLE, m_initDb);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSqlLogDlg, CDialog)
	//{{AFX_MSG_MAP(CSqlLogDlg)
	ON_BN_CLICKED(IDOK, OnLogin)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSqlLogDlg message handlers

void CSqlLogDlg::OnLogin() 
{
	HRESULT hr;
    _ConnectionPtr m_pConnTemp = theApp.m_pConnection;

	UpdateData();
	CString strConnection = "Provider=SQLOLEDB.1;Data Source=" + m_dbserver + 
							";Initial Catalog=" + m_initDb  +
							";User ID=" + m_username + "; PWD=" + m_passwd;
	try
	{
		hr = m_pConnTemp.CreateInstance("ADODB.Connection");

		if(SUCCEEDED(hr))
		{
			hr=m_pConnTemp->Open((_bstr_t)strConnection,"","",-1);
			OnOK();
		}
	}
	catch(_com_error e)
	{
		CCommon common;
		AfxMessageBox(common.DisplayAdoError(m_pConnTemp));
	}  


	if (m_pConnTemp != NULL)
	{
		if (m_pConnTemp->State)
		{
			
			if (theApp.m_pConnection != NULL)
			{
				if (theApp.m_pConnection->State)
				{
					theApp.m_pConnection->Close ();
				}
			}
			theApp.m_pConnection = m_pConnTemp;
		}
	}
		
}