?? 040410201lei.cpp
字號:
// 040410201lei.cpp : Defines the class behaviors for the application.
//
#include "stdafx.h"
#include "040410201lei.h"
#include "040410201leiDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CMy040410201leiApp
BEGIN_MESSAGE_MAP(CMy040410201leiApp, CWinApp)
//{{AFX_MSG_MAP(CMy040410201leiApp)
// 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()
/////////////////////////////////////////////////////////////////////////////
// CMy040410201leiApp construction
CMy040410201leiApp::CMy040410201leiApp()
{
// TODO: add construction code here,
// Place all significant initialization in InitInstance
}
/////////////////////////////////////////////////////////////////////////////
// The one and only CMy040410201leiApp object
/////////////////////////////////////////////////////////////////////////////
// CMy040410201leiApp initialization
BOOL CMy040410201leiApp::InitInstance()
{
AfxEnableControlContainer();
if( FAILED(::CoInitialize(NULL)) )
{
AfxMessageBox("ADO Init failed");
return false;
}
try/*在主文件的初始函數中對數據源及數據庫進行連接*/
{
ADOConn.CreateInstance(__uuidof(Connection));
ADOConn->Open("DSN=040410201;Provider=MSDASQL","","", adConnectUnspecified);
}/*連接數據庫,其中DSN為數據源名稱,兩個引號內的為數據庫的帳號和密碼*/
// Catch Exceptions
catch(_com_error &e)
{
CString err;
err.Format("%s", (char*)(e.Description()) );
AfxMessageBox(err);
}
catch(...)
{
AfxMessageBox("Unknown Error...");
}
/*以上為對數據庫的連接*/
// Init ADO RecordSet
m_pADOSet.CreateInstance(__uuidof(Recordset));
// 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
CMy040410201leiDlg 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;
}
bool CMy040410201leiApp::ADOExecute(_RecordsetPtr &ADOSet, _variant_t &strSQL)
{
if ( ADOSet->State == adStateOpen) ADOSet->Close();
try
{
ADOSet->Open(strSQL, ADOConn.GetInterfacePtr(), adOpenStatic, adLockOptimistic, adCmdUnknown);
return true;
}
catch(_com_error &e)
{
CString err;
err.Format("ADO Error: %s",(char*)e.Description());
AfxMessageBox(err);
return false;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -