logindlg.cpp

vc数据库编程程序

// LoginDlg.cpp : implementation file
//

#include "stdafx.h"
#include "MySqlPlus.h"
#include "LoginDlg.h"
#include "mysqlplus.h"
#include "common.h"

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

/////////////////////////////////////////////////////////////////////////////
// CLoginDlg dialog

extern CMySqlPlusApp theApp;

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


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


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

/////////////////////////////////////////////////////////////////////////////
// CLoginDlg message handlers


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

	UpdateData();
	CString strConnection = "Provider=MSDAORA;Data Source=" + m_dbserver + 
							";User ID=" + m_username + "; Password=" + 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;
		}
	}
	
}