商业编程-源码-数据库连接演示.zip

// DBLinkDemoDlg.cpp : implementation file // #include "stdafx.h" #include "DBLinkDemo.h" #include "DBLinkDemoDlg.h" #include "DlgProxy.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // CAboutDlg dialog used for App About class CAboutDlg : public CDialog { public: CAboutDlg(); // Dialog Data //{{AFX_DATA(CAboutDlg) enum { IDD = IDD_ABOUTBOX }; //}}AFX_DATA // ClassWizard generated virtual function overrides //{{AFX_VIRTUAL(CAboutDlg) protected: virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support //}}AFX_VIRTUAL // Implementation protected: //{{AFX_MSG(CAboutDlg) //}}AFX_MSG DECLARE_MESSAGE_MAP() }; CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD) { //{{AFX_DATA_INIT(CAboutDlg) //}}AFX_DATA_INIT } void CAboutDlg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CAboutDlg) //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CAboutDlg, CDialog) //{{AFX_MSG_MAP(CAboutDlg) // No message handlers //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CDBLinkDemoDlg dialog IMPLEMENT_DYNAMIC(CDBLinkDemoDlg, CDialog); CDBLinkDemoDlg::CDBLinkDemoDlg(CWnd* pParent /*=NULL*/) : CDialog(CDBLinkDemoDlg::IDD, pParent) { //{{AFX_DATA_INIT(CDBLinkDemoDlg) m_ConnectionString = _T(""); //}}AFX_DATA_INIT // Note that LoadIcon does not require a subsequent DestroyIcon in Win32 m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME); m_pAutoProxy = NULL; } CDBLinkDemoDlg::~CDBLinkDemoDlg() { // If there is an automation proxy for this dialog, set // its back pointer to this dialog to NULL, so it knows // the dialog has been deleted. if (m_pAutoProxy != NULL) m_pAutoProxy->m_pDialog = NULL; } void CDBLinkDemoDlg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CDBLinkDemoDlg) DDX_Control(pDX, IDC_LIST1, m_tblList); DDX_Text(pDX, IDC_EDIT1, m_ConnectionString); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CDBLinkDemoDlg, CDialog) //{{AFX_MSG_MAP(CDBLinkDemoDlg) ON_WM_SYSCOMMAND() ON_WM_PAINT() ON_WM_QUERYDRAGICON() ON_WM_CLOSE() ON_BN_CLICKED(IDC_BUTTON_LINK, OnButtonLink) ON_BN_CLICKED(IDC_BUTTON_CLOSE, OnButtonClose) ON_BN_CLICKED(IDC_BUTTON_ABOUT, OnButtonAbout) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CDBLinkDemoDlg message handlers BOOL CDBLinkDemoDlg::OnInitDialog() { CDialog::OnInitDialog(); // Add "About..." menu item to system menu. // IDM_ABOUTBOX must be in the system command range. ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX); ASSERT(IDM_ABOUTBOX < 0xF000); CMenu* pSysMenu = GetSystemMenu(FALSE); if (pSysMenu != NULL) { CString strAboutMenu; strAboutMenu.LoadString(IDS_ABOUTBOX); if (!strAboutMenu.IsEmpty()) { pSysMenu->AppendMenu(MF_SEPARATOR); pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu); } } // Set the icon for this dialog. The framework does this automatically // when the application's main window is not a dialog SetIcon(m_hIcon, TRUE); // Set big icon SetIcon(m_hIcon, FALSE); // Set small icon // TODO: Add extra initialization here pConn=NULL; ::CoInitialize(NULL); return TRUE; // return TRUE unless you set the focus to a control } void CDBLinkDemoDlg::OnSysCommand(UINT nID, LPARAM lParam) { if ((nID & 0xFFF0) == IDM_ABOUTBOX) { CAboutDlg dlgAbout; dlgAbout.DoModal(); } else { CDialog::OnSysCommand(nID, lParam); } } // If you add a minimize button to your dialog, you will need the code below // to draw the icon. For MFC applications using the document/view model, // this is automatically done for you by the framework. void CDBLinkDemoDlg::OnPaint() { if (IsIconic()) { CPaintDC dc(this); // device context for painting SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0); // Center icon in client rectangle int cxIcon = GetSystemMetrics(SM_CXICON); int cyIcon = GetSystemMetrics(SM_CYICON); CRect rect; GetClientRect(&rect); int x = (rect.Width() - cxIcon + 1) / 2; int y = (rect.Height() - cyIcon + 1) / 2; // Draw the icon dc.DrawIcon(x, y, m_hIcon); } else { CDialog::OnPaint(); } } // The system calls this to obtain the cursor to display while the user drags // the minimized window. HCURSOR CDBLinkDemoDlg::OnQueryDragIcon() { return (HCURSOR) m_hIcon; } // Automation servers should not exit when a user closes the UI // if a controller still holds on to one of its objects. These // message handlers make sure that if the proxy is still in use, // then the UI is hidden but the dialog remains around if it // is dismissed. void CDBLinkDemoDlg::OnClose() { if (CanExit()) { if(pConn!=NULL) { if(pConn->GetState()!=adStateOpen) pConn->Close(); pConn.Release(); } ::CoUninitialize(); CDialog::OnClose(); } } void CDBLinkDemoDlg::OnOK() { if (CanExit()) CDialog::OnOK(); } void CDBLinkDemoDlg::OnCancel() { if (CanExit()) CDialog::OnCancel(); } BOOL CDBLinkDemoDlg::CanExit() { // If the proxy object is still around, then the automation // controller is still holding on to this application. Leave // the dialog around, but hide its UI. if (m_pAutoProxy != NULL) { ShowWindow(SW_HIDE); return FALSE; } return TRUE; } void CDBLinkDemoDlg::OnButtonLink() { // TODO: Add your control notification handler code here HRESULT hr; IDataSourceLocatorPtr dlPrompt=NULL; _RecordsetPtr rs=NULL; try { // 初始化DataLinks对象 hr=dlPrompt.CreateInstance(__uuidof(DataLinks)); if(FAILED(hr)) throw(_com_error(hr,NULL)); // 建立连接 pConn=dlPrompt->PromptNew(); // 如果 conn 为 NULL if(pConn==NULL) return; m_ConnectionString=(char*)pConn->ConnectionString; UpdateData(FALSE); // 打开连接 pConn->Open(pConn->ConnectionString,L"",L"",-1); // 清除列表框 while(m_tblList.GetCount()>0) m_tblList.DeleteString(0); // 获取数据库中表集 rs=pConn->OpenSchema(adSchemaTables); while(!rs->adoEOF) { m_tblList.AddString((char*)(_bstr_t)rs->Fields->Item[L"TABLE_NAME"]->Value); rs->MoveNext(); } rs=NULL; dlPrompt.Release(); } catch (_com_error &e) { AfxMessageBox(e.ErrorMessage()); } } void CDBLinkDemoDlg::OnButtonClose() { // TODO: Add your control notification handler code here SendMessage(WM_CLOSE); } void CDBLinkDemoDlg::OnButtonAbout() { // TODO: Add your control notification handler code here CAboutDlg dlg; dlg.DoModal(); }