consoleview.cpp

ADO查看数据库工具的原码

// ConsoleView.cpp : implementation file
//

#include "stdafx.h"
#include "DHDBView.h"
#include "ConsoleView.h"
#include "DHDBViewDoc.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CConsoleView

IMPLEMENT_DYNCREATE(CConsoleView, CFormView)

CConsoleView::CConsoleView()
	: CFormView(CConsoleView::IDD)
{
	//{{AFX_DATA_INIT(CConsoleView)
	m_nDBType = 0;
	m_strPwd = _T("");
	m_strUid = _T("");
	m_strDBName = _T("");
	m_strSerName = _T("");
	m_strCmd = _T("");
	m_strCon = _T("driver={SQL Server};server=AUTODEAL;uid=sa;pwd=;database=WANDERDB;");
	m_nPageNum = 50;
	//}}AFX_DATA_INIT
}

CConsoleView::~CConsoleView()
{
}

void CConsoleView::DoDataExchange(CDataExchange* pDX)
{
	CFormView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CConsoleView)
	DDX_Control(pDX, IDC_CONNECTION, m_btnCon);
	DDX_CBIndex(pDX, IDC_COMBODBTYPE, m_nDBType);
	DDX_Text(pDX, IDC_EDITPWD, m_strPwd);
	DDV_MaxChars(pDX, m_strPwd, 30);
	DDX_Text(pDX, IDC_EDITUID, m_strUid);
	DDV_MaxChars(pDX, m_strUid, 30);
	DDX_Text(pDX, IDC_EDITDBNAME, m_strDBName);
	DDV_MaxChars(pDX, m_strDBName, 100);
	DDX_Text(pDX, IDC_EDITSERNAME, m_strSerName);
	DDV_MaxChars(pDX, m_strSerName, 30);
	DDX_Text(pDX, IDC_EDITCMD, m_strCmd);
	DDX_Text(pDX, IDC_EDITPAGENUM, m_nPageNum);
	DDV_MinMaxUInt(pDX, m_nPageNum, 1, 4294967295);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CConsoleView, CFormView)
	//{{AFX_MSG_MAP(CConsoleView)
	ON_BN_CLICKED(IDC_CONNECTION, OnConnection)
	ON_CBN_SELCHANGE(IDC_COMBODBTYPE, OnSelchangeCombodbtype)
	ON_EN_CHANGE(IDC_EDITPAGENUM, OnChangeEditpagenum)
	ON_BN_CLICKED(IDC_QUERY_TABLE, OnQueryTable)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CConsoleView diagnostics

#ifdef _DEBUG
void CConsoleView::AssertValid() const
{
	CFormView::AssertValid();
}

void CConsoleView::Dump(CDumpContext& dc) const
{
	CFormView::Dump(dc);
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CConsoleView message handlers

void CConsoleView::OnConnection() 
{
	//driver={SQL Server};server=AUTODEAL;uid=sa;pwd=;database=WANDERDB;
	UpdateData();
	CString strMes;
	m_strDBName.TrimLeft();
	m_strDBName.TrimRight();
	if(m_strDBName.IsEmpty())
	{
		MessageBox("数据源名不能为空！", "错误", 0);
		return;
	}
	switch(m_nDBType)
	{
	case 0:
		m_strSerName.TrimLeft();
		m_strSerName.TrimRight();
		if(m_strSerName.IsEmpty())
		{
			MessageBox("服务器名不能为空！", "错误", 0);
			return;
		}
		m_strCon.Format("driver={SQL Server};server=%s;uid=%s;pwd=%s;database=%s;" ,m_strSerName,m_strUid,m_strPwd,m_strDBName);
		break;
	case 1:
		m_strCon.Format("DSN=%s;UID=%s;PWD=%s;" ,m_strDBName,m_strUid,m_strPwd);
		break;
	case 2:
		m_strCon.Format("Data Source=%s;User ID=%s;Password=%s;" ,m_strDBName,m_strUid,m_strPwd);
		break;
	}
	m_btnCon.EnableWindow(FALSE);
	UpdateData(true);
	((CDHDBViewDoc*)GetDocument())->m_strCon = m_strCon;
	GetDocument()->UpdateAllViews (this, 0x5A, NULL);
}

void CConsoleView::OnUpdate(CView* pSender, LPARAM lHint, CObject* pHint) 
{
	if (lHint == 0x6A) 
	{
		m_btnCon.EnableWindow(TRUE);
		return;
	}
	if(lHint == 0x8A)
	{
		m_strCmd = ((CDHDBViewDoc*)GetDocument())->m_strCmd;
		UpdateData(false);
	}
}
#include <afxdb.h>
void CConsoleView::OnSelchangeCombodbtype() 
{
	UpdateData(true);
	if(m_nDBType ==0)
	{
		GetDlgItem(IDC_STATICSER)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_EDITSERNAME)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_STATICPROMAT)->SetWindowText("数据库名");
	}
	else
	{
		CDatabase db;
		if(db.Open(""))
		{
			m_strCon = db.GetConnect().Mid(5);
			m_btnCon.EnableWindow(FALSE);
			UpdateData(true);
			((CDHDBViewDoc*)GetDocument())->m_strCon = m_strCon;
			GetDocument()->UpdateAllViews (this, 0x5A, NULL);
			m_strDBName=db.GetDatabaseName();
		}
		GetDlgItem(IDC_STATICSER)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_EDITSERNAME)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_STATICPROMAT)->SetWindowText("数据源名");
		db.Close();
	}
	UpdateData(false);
}



void CConsoleView::OnChangeEditpagenum() 
{
	UpdateData();
	((CDHDBViewDoc*)GetDocument())->m_nPageNum = m_nPageNum;
}

void CConsoleView::OnQueryTable() 
{
	UpdateData();
	((CDHDBViewDoc*)GetDocument())->m_strCmd = m_strCmd;
	GetDocument()->UpdateAllViews (this, 0x7C, NULL);
}