我的本意是在程序启动时如果有则不创建，没有则，创建demo.mdb数据库 并且插入数据。我把『 CDaoDatabase db; //数据库
CDaoRecordset RecSet(&db); //记录集 //获取主程序所在路径,存在sPath中
CString sPath;
GetModuleFileName(NULL,sPath.GetBufferSetLength (MAX_PATH+1),MAX_PATH);
// MessageBox(sPath);
sPath.ReleaseBuffer ();
int nPos;
.......
AfxMessageBox("Access文件写入成功！");
}
else
AfxMessageBox("Demo.mdb数据库已经创建！");
}』 是可以编译通过的 不知道怎么解决 谢谢各位
// s5.cpp : Defines the class behaviors for the application.
//
//#include "dao.h"
#include "stdafx.h"
#include "s5.h"#include "MainFrm.h"
#include "ChildFrm.h"
#include "s5Doc.h"
#include "s5View.h"
#include "Passwd.h"#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif/////////////////////////////////////////////////////////////////////////////
// CS5AppBEGIN_MESSAGE_MAP(CS5App, CWinApp)
//{{AFX_MSG_MAP(CS5App)
ON_COMMAND(ID_APP_ABOUT, OnAppAbout)
// NOTE - the ClassWizard will add and remove mapping macros here.
// DO NOT EDIT what you see in these blocks of generated code!
//}}AFX_MSG_MAP
// Standard file based document commands
ON_COMMAND(ID_FILE_NEW, CWinApp::OnFileNew)
ON_COMMAND(ID_FILE_OPEN, CWinApp::OnFileOpen)
// Standard print setup command
ON_COMMAND(ID_FILE_PRINT_SETUP, CWinApp::OnFilePrintSetup)
END_MESSAGE_MAP()/////////////////////////////////////////////////////////////////////////////
// CS5App constructionCS5App::CS5App()
{
// TODO: add construction code here,
// Place all significant initialization in InitInstance
}/////////////////////////////////////////////////////////////////////////////
// The one and only CS5App objectCS5App theApp;/////////////////////////////////////////////////////////////////////////////
// CS5App initializationBOOL CS5App::InitInstance()
{
AfxEnableControlContainer(); // 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
/*
CPasswd pp;
if (pp.DoModal()==IDOK)
{
if (pp.m_passwd!=12345)
{
MessageBox(NULL,"passwd is error!","错误",MB_OK|MB_ICONERROR);
return false;
}
}
else
return false;
*/ CDaoDatabase db; //数据库
CDaoRecordset RecSet(&db); //记录集 //获取主程序所在路径,存在sPath中
CString sPath;
GetModuleFileName(NULL,sPath.GetBufferSetLength (MAX_PATH+1),MAX_PATH);
// MessageBox(sPath);
sPath.ReleaseBuffer ();
int nPos;
nPos=sPath.ReverseFind ('\\');
sPath=sPath.Left (nPos);
//MessageBox(sPath);
//默认创建数据名：Demo.mdb，内部表名：DemoTable，表内有二个字段：姓名、年龄
CString lpszFile = sPath + "\\Demo.mdb";
CFileFind fFind;
BOOL bSuccess;
bSuccess=fFind.FindFile(lpszFile);
fFind.Close ();
//是否已有创建好的Demo.mdb文件，没有则创建它
if(!bSuccess)
{
db.Create(lpszFile);
CString SqlCmd = "CREATE TABLE DemoTable(Name VARCHAR(20),Age VARCHAR(3));";
db.Execute(SqlCmd);
//打开已创建的数据表
RecSet.Open(AFX_DAO_USE_DEFAULT_TYPE,
"SELECT * FROM DemoTable", 0);
//加入第一个记录，用SQL语句
db.Execute("INSERT INTO DemoTable (Name,Age) VALUES ('cc',26)");
//加入第二个记录，用DAO涵数
RecSet.AddNew();
RecSet.SetFieldValue("Name","bb");
RecSet.SetFieldValue("Age","21");
RecSet.Update();
//加入第三个记录，用DAO涵数
RecSet.AddNew();
RecSet.SetFieldValue("Name","aa");
RecSet.SetFieldValue("Age","27");
RecSet.Update();
//关闭记录集及库
RecSet.Close();
db.Close();
AfxMessageBox("Access文件写入成功！");
}
else
AfxMessageBox("Demo.mdb数据库已经创建！");
} // Change the registry key under which our settings are stored.
// TODO: You should modify this string to be something appropriate
// such as the name of your company or organization.
SetRegistryKey(_T("Local AppWizard-Generated Applications")); LoadStdProfileSettings(); // Load standard INI file options (including MRU) // Register the application's document templates. Document templates
// serve as the connection between documents, frame windows and views. CMultiDocTemplate* pDocTemplate;
pDocTemplate = new CMultiDocTemplate(
IDR_S5TYPE,
RUNTIME_CLASS(CS5Doc),
RUNTIME_CLASS(CChildFrame), // custom MDI child frame
RUNTIME_CLASS(CS5View));
AddDocTemplate(pDocTemplate); // create main MDI Frame window
CMainFrame* pMainFrame = new CMainFrame;
if (!pMainFrame->LoadFrame(IDR_MAINFRAME))
return FALSE;
m_pMainWnd = pMainFrame; // Parse command line for standard shell commands, DDE, file open
CCommandLineInfo cmdInfo;
ParseCommandLine(cmdInfo); // Dispatch commands specified on the command line
if (!ProcessShellCommand(cmdInfo))
return FALSE; // The main window has been initialized, so show and update it.
pMainFrame->ShowWindow(m_nCmdShow);
pMainFrame->UpdateWindow(); return TRUE;
}
/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App Aboutclass 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)
// No message handlers
//}}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()// App command to run the dialog
void CS5App::OnAppAbout()
{
CAboutDlg aboutDlg;
aboutDlg.DoModal();
}/////////////////////////////////////////////////////////////////////////////
// CS5App message handlers
CDaoRecordset RecSet(&db); //记录集 //获取主程序所在路径,存在sPath中
CString sPath;
GetModuleFileName(NULL,sPath.GetBufferSetLength (MAX_PATH+1),MAX_PATH);
// MessageBox(sPath);
sPath.ReleaseBuffer ();
int nPos;
.......
AfxMessageBox("Access文件写入成功！");
}
else
AfxMessageBox("Demo.mdb数据库已经创建！");
}』 是可以编译通过的 不知道怎么解决 谢谢各位
// s5.cpp : Defines the class behaviors for the application.
//
//#include "dao.h"
#include "stdafx.h"
#include "s5.h"#include "MainFrm.h"
#include "ChildFrm.h"
#include "s5Doc.h"
#include "s5View.h"
#include "Passwd.h"#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif/////////////////////////////////////////////////////////////////////////////
// CS5AppBEGIN_MESSAGE_MAP(CS5App, CWinApp)
//{{AFX_MSG_MAP(CS5App)
ON_COMMAND(ID_APP_ABOUT, OnAppAbout)
// NOTE - the ClassWizard will add and remove mapping macros here.
// DO NOT EDIT what you see in these blocks of generated code!
//}}AFX_MSG_MAP
// Standard file based document commands
ON_COMMAND(ID_FILE_NEW, CWinApp::OnFileNew)
ON_COMMAND(ID_FILE_OPEN, CWinApp::OnFileOpen)
// Standard print setup command
ON_COMMAND(ID_FILE_PRINT_SETUP, CWinApp::OnFilePrintSetup)
END_MESSAGE_MAP()/////////////////////////////////////////////////////////////////////////////
// CS5App constructionCS5App::CS5App()
{
// TODO: add construction code here,
// Place all significant initialization in InitInstance
}/////////////////////////////////////////////////////////////////////////////
// The one and only CS5App objectCS5App theApp;/////////////////////////////////////////////////////////////////////////////
// CS5App initializationBOOL CS5App::InitInstance()
{
AfxEnableControlContainer(); // 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
/*
CPasswd pp;
if (pp.DoModal()==IDOK)
{
if (pp.m_passwd!=12345)
{
MessageBox(NULL,"passwd is error!","错误",MB_OK|MB_ICONERROR);
return false;
}
}
else
return false;
*/ CDaoDatabase db; //数据库
CDaoRecordset RecSet(&db); //记录集 //获取主程序所在路径,存在sPath中
CString sPath;
GetModuleFileName(NULL,sPath.GetBufferSetLength (MAX_PATH+1),MAX_PATH);
// MessageBox(sPath);
sPath.ReleaseBuffer ();
int nPos;
nPos=sPath.ReverseFind ('\\');
sPath=sPath.Left (nPos);
//MessageBox(sPath);
//默认创建数据名：Demo.mdb，内部表名：DemoTable，表内有二个字段：姓名、年龄
CString lpszFile = sPath + "\\Demo.mdb";
CFileFind fFind;
BOOL bSuccess;
bSuccess=fFind.FindFile(lpszFile);
fFind.Close ();
//是否已有创建好的Demo.mdb文件，没有则创建它
if(!bSuccess)
{
db.Create(lpszFile);
CString SqlCmd = "CREATE TABLE DemoTable(Name VARCHAR(20),Age VARCHAR(3));";
db.Execute(SqlCmd);
//打开已创建的数据表
RecSet.Open(AFX_DAO_USE_DEFAULT_TYPE,
"SELECT * FROM DemoTable", 0);
//加入第一个记录，用SQL语句
db.Execute("INSERT INTO DemoTable (Name,Age) VALUES ('cc',26)");
//加入第二个记录，用DAO涵数
RecSet.AddNew();
RecSet.SetFieldValue("Name","bb");
RecSet.SetFieldValue("Age","21");
RecSet.Update();
//加入第三个记录，用DAO涵数
RecSet.AddNew();
RecSet.SetFieldValue("Name","aa");
RecSet.SetFieldValue("Age","27");
RecSet.Update();
//关闭记录集及库
RecSet.Close();
db.Close();
AfxMessageBox("Access文件写入成功！");
}
else
AfxMessageBox("Demo.mdb数据库已经创建！");
} // Change the registry key under which our settings are stored.
// TODO: You should modify this string to be something appropriate
// such as the name of your company or organization.
SetRegistryKey(_T("Local AppWizard-Generated Applications")); LoadStdProfileSettings(); // Load standard INI file options (including MRU) // Register the application's document templates. Document templates
// serve as the connection between documents, frame windows and views. CMultiDocTemplate* pDocTemplate;
pDocTemplate = new CMultiDocTemplate(
IDR_S5TYPE,
RUNTIME_CLASS(CS5Doc),
RUNTIME_CLASS(CChildFrame), // custom MDI child frame
RUNTIME_CLASS(CS5View));
AddDocTemplate(pDocTemplate); // create main MDI Frame window
CMainFrame* pMainFrame = new CMainFrame;
if (!pMainFrame->LoadFrame(IDR_MAINFRAME))
return FALSE;
m_pMainWnd = pMainFrame; // Parse command line for standard shell commands, DDE, file open
CCommandLineInfo cmdInfo;
ParseCommandLine(cmdInfo); // Dispatch commands specified on the command line
if (!ProcessShellCommand(cmdInfo))
return FALSE; // The main window has been initialized, so show and update it.
pMainFrame->ShowWindow(m_nCmdShow);
pMainFrame->UpdateWindow(); return TRUE;
}
/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App Aboutclass 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)
// No message handlers
//}}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()// App command to run the dialog
void CS5App::OnAppAbout()
{
CAboutDlg aboutDlg;
aboutDlg.DoModal();
}/////////////////////////////////////////////////////////////////////////////
// CS5App message handlers
具体报错
--------------------Configuration: s5 - Win32 Debug--------------------
Compiling...
s5.cpp
D:\studio\test\s5\s5.cpp(117) : error C2501: 'SetRegistryKey' : missing storage-class or type specifiers
D:\studio\test\s5\s5.cpp(117) : error C2440: 'initializing' : cannot convert from 'char [39]' to 'int'
This conversion requires a reinterpret_cast, a C-style cast or function-style cast
D:\studio\test\s5\s5.cpp(125) : error C2501: 'pDocTemplate' : missing storage-class or type specifiers
D:\studio\test\s5\s5.cpp(125) : error C2040: 'pDocTemplate' : 'int' differs in levels of indirection from 'class CMultiDocTemplate *'
D:\studio\test\s5\s5.cpp(129) : error C2440: 'initializing' : cannot convert from 'class CMultiDocTemplate *' to 'int'
This conversion requires a reinterpret_cast, a C-style cast or function-style cast
D:\studio\test\s5\s5.cpp(130) : error C2501: 'AddDocTemplate' : missing storage-class or type specifiers
D:\studio\test\s5\s5.cpp(130) : error C2440: 'initializing' : cannot convert from 'class CMultiDocTemplate *' to 'int'
This conversion requires a reinterpret_cast, a C-style cast or function-style cast
D:\studio\test\s5\s5.cpp(134) : error C2143: syntax error : missing ';' before 'if'
D:\studio\test\s5\s5.cpp(136) : error C2501: 'm_pMainWnd' : missing storage-class or type specifiers
D:\studio\test\s5\s5.cpp(136) : error C2440: 'initializing' : cannot convert from 'class CMainFrame *' to 'int'
This conversion requires a reinterpret_cast, a C-style cast or function-style cast
D:\studio\test\s5\s5.cpp(140) : error C2501: 'ParseCommandLine' : missing storage-class or type specifiers
D:\studio\test\s5\s5.cpp(140) : error C2440: 'initializing' : cannot convert from 'class CCommandLineInfo' to 'int'
No user-defined-conversion operator available that can perform this conversion, or the operator cannot be called
D:\studio\test\s5\s5.cpp(143) : error C2143: syntax error : missing ';' before 'if'
D:\studio\test\s5\s5.cpp(147) : error C2143: syntax error : missing ';' before '->'
D:\studio\test\s5\s5.cpp(147) : error C2501: 'pMainFrame' : missing storage-class or type specifiers
D:\studio\test\s5\s5.cpp(147) : error C2040: 'pMainFrame' : 'int' differs in levels of indirection from 'class CMainFrame *'
D:\studio\test\s5\s5.cpp(147) : error C2143: syntax error : missing ';' before '->'
D:\studio\test\s5\s5.cpp(148) : error C2143: syntax error : missing ';' before '->'
D:\studio\test\s5\s5.cpp(148) : error C2501: 'pMainFrame' : missing storage-class or type specifiers
D:\studio\test\s5\s5.cpp(148) : error C2040: 'pMainFrame' : 'int' differs in levels of indirection from 'class CMainFrame *'
D:\studio\test\s5\s5.cpp(148) : error C2143: syntax error : missing ';' before '->'
D:\studio\test\s5\s5.cpp(150) : error C2143: syntax error : missing ';' before 'return'
D:\studio\test\s5\s5.cpp(151) : error C2143: syntax error : missing ';' before '}'
D:\studio\test\s5\s5.cpp(151) : error C2143: syntax error : missing ';' before '}'
D:\studio\test\s5\s5.cpp(151) : error C2143: syntax error : missing ';' before '}'
D:\studio\test\s5\s5.cpp(157) : error C2143: syntax error : missing ';' before 'public'
D:\studio\test\s5\s5.cpp(158) : error C2143: syntax error : missing ';' before '{'
D:\studio\test\s5\s5.cpp(158) : error C2447: missing function header (old-style formal list?)
D:\studio\test\s5\s5.cpp(181) : error C2653: 'CAboutDlg' : is not a class or namespace name
D:\studio\test\s5\s5.cpp(181) : error C2653: 'CAboutDlg' : is not a class or namespace name
D:\studio\test\s5\s5.cpp(181) : error C2065: 'IDD' : undeclared identifier
D:\studio\test\s5\s5.cpp(182) : error C2550: 'CAboutDlg' : constructor initializer lists are only allowed on constructor definitions
D:\studio\test\s5\s5.cpp(185) : warning C4508: 'CAboutDlg' : function should return a value; 'void' return type assumed
D:\studio\test\s5\s5.cpp(187) : error C2653: 'CAboutDlg' : is not a class or namespace name
D:\studio\test\s5\s5.cpp(189) : error C2248: 'DoDataExchange' : cannot access protected member declared in class 'CWnd'
c:\program files\microsoft visual studio\vc98\mfc\include\afxwin.h(2414) : see declaration of 'DoDataExchange'
D:\studio\test\s5\s5.cpp(189) : error C2352: 'CWnd::DoDataExchange' : illegal call of non-static member function
c:\program files\microsoft visual studio\vc98\mfc\include\afxwin.h(2414) : see declaration of 'DoDataExchange'
D:\studio\test\s5\s5.cpp(194) : error C2653: 'CAboutDlg' : is not a class or namespace name
D:\studio\test\s5\s5.cpp(194) : error C2248: 'messageMap' : cannot access protected member declared in class 'CDialog'
c:\program files\microsoft visual studio\vc98\mfc\include\afxwin.h(2667) : see declaration of 'messageMap'
D:\studio\test\s5\s5.cpp(194) : error C2653: 'CAboutDlg' : is not a class or namespace name
D:\studio\test\s5\s5.cpp(194) : error C2270: 'GetMessageMap' : modifiers not allowed on nonmember functions
D:\studio\test\s5\s5.cpp(194) : error C2653: 'CAboutDlg' : is not a class or namespace name
D:\studio\test\s5\s5.cpp(194) : error C2065: 'messageMap' : undeclared identifier
D:\studio\test\s5\s5.cpp(194) : error C2653: 'CAboutDlg' : is not a class or namespace name
D:\studio\test\s5\s5.cpp(194) : error C2373: 'messageMap' : redefinition; different type modifiers
D:\studio\test\s5\s5.cpp(194) : error C2653: 'CAboutDlg' : is not a class or namespace name
D:\studio\test\s5\s5.cpp(194) : error C2653: 'CAboutDlg' : is not a class or namespace name
D:\studio\test\s5\s5.cpp(194) : error C2065: '_messageEntries' : undeclared identifier
D:\studio\test\s5\s5.cpp(194) : error C2109: subscript requires array or pointer type
D:\studio\test\s5\s5.cpp(194) : error C2102: '&' requires l-value
D:\studio\test\s5\s5.cpp(194) : error C2653: 'CAboutDlg' : is not a class or namespace name
D:\studio\test\s5\s5.cpp(194) : error C2040: '_messageEntries' : 'const struct AFX_MSGMAP_ENTRY []' differs in levels of indirection from 'int'
D:\studio\test\s5\s5.cpp(203) : error C2146: syntax error : missing ';' before identifier 'aboutDlg'
D:\studio\test\s5\s5.cpp(203) : warning C4551: function call missing argument list
D:\studio\test\s5\s5.cpp(203) : error C2065: 'aboutDlg' : undeclared identifier
D:\studio\test\s5\s5.cpp(204) : error C2228: left of '.DoModal' must have class/struct/union type
Error executing cl.exe.
Creating browse info file...s5.exe - 53 error(s), 2 warning(s)
CPasswd pp;
if (pp.DoModal()==IDOK)
{
if (pp.m_passwd!=12345)
{
MessageBox(NULL,"passwd is error!","错误",MB_OK ¦MB_ICONERROR);
return false;
}
}
else
return false;
*/
这段去掉注释是可以运行的
去掉 『 CDaoDatabase db; //数据库
CDaoRecordset RecSet(&db); //记录集//获取主程序所在路径,存在sPath中
CString sPath;
GetModuleFileName(NULL,sPath.GetBufferSetLength (MAX_PATH+1),MAX_PATH);
// MessageBox(sPath);
sPath.ReleaseBuffer ();
int nPos;
.......AfxMessageBox("Access文件写入成功！");
}
else
AfxMessageBox("Demo.mdb数据库已经创建！");}』 是可以编译通过的
D:\studio\test\s5\s5.cpp(117) : error C2501: 'SetRegistryKey' : missing storage-class or type specifiers 类没有对应的方法 D:\studio\test\s5\s5.cpp(117) : error C2440: 'initializing' : cannot convert from 'char [39]' to 'int'参数要求int型，你却传了个字符串等等
CDaoDatabase db; //数据库
CDaoRecordset RecSet(&db); //记录集//获取主程序所在路径,存在sPath中
CString sPath;
GetModuleFileName(NULL,sPath.GetBufferSetLength (MAX_PATH+1),MAX_PATH);
// MessageBox(sPath);
sPath.ReleaseBuffer ();
int nPos;
.......AfxMessageBox("Access文件写入成功！");
}
else
AfxMessageBox("Demo.mdb数据库已经创建！");}』 是可以编译通过的 为什么？