dao.cpp

编译成功

// Dao.cpp : Defines the entry point for the console application.
//

#include "stdafx.h"
#include "Dao.h"

#include "afxdao.h"

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

static TCHAR g_szDbFielename[] = _T("InSAR Data.mdb");
static TCHAR g_szTBname[] = _T("SARData");
BOOL CreateDB_TB(TCHAR* lpszDbFileName, TCHAR* lpszTBName);

/////////////////////////////////////////////////////////////////////////////
// The one and only application object

CWinApp theApp;

using namespace std;

int _tmain(int argc, TCHAR* argv[], TCHAR* envp[])
{
	int nRetCode = 0;

	// initialize MFC and print and error on failure
	if (!AfxWinInit(::GetModuleHandle(NULL), NULL, ::GetCommandLine(), 0))
	{
		// TODO: change error code to suit your needs
		cerr << _T("Fatal Error: MFC initialization failed") << endl;
		nRetCode = 1;
	}
	else
	{
		// TODO: code your application's behavior here.
		CString strHello;
		strHello.LoadString(IDS_HELLO);
		cout << (LPCTSTR)strHello << endl;

		if(CreateDB_TB(g_szDbFielename, g_szTBname))
			AfxMessageBox(_T("Create Success!"));
		else
			AfxMessageBox(_T("Create Failure!"));
	}

	return nRetCode;
}

BOOL CreateDB_TB(TCHAR* lpszDbFileName, TCHAR* lpszTBName)
{
	ASSERT(lpszDbFileName);
	ASSERT(lpszTBName);

	CFile f;
	if(f.Open(lpszDbFileName, CFile::modeRead))
	{
		cout << lpszDbFileName << " has already exist, please delete it!" << endl;
		f.Close();
		return FALSE;
	}

	CDaoDatabase db;
	db.Create(lpszDbFileName, dbLangGeneral, dbVersion30);
	
	CDaoTableDef tb(&db);
	tb.Create(lpszTBName);

	CDaoFieldInfo fieldinfo1;
	fieldinfo1.m_strName ="ID";
	fieldinfo1.m_nType = dbLong;
	fieldinfo1.m_lSize = 4;
	fieldinfo1.m_lAttributes = dbAutoIncrField | dbFixedField;
	fieldinfo1.m_nOrdinalPosition = 1;
	fieldinfo1.m_bRequired = TRUE;
	fieldinfo1.m_bAllowZeroLength = FALSE;
	tb.CreateField(fieldinfo1);

	CDaoFieldInfo fieldinfo2;
	fieldinfo2.m_strName ="文件名";
	fieldinfo2.m_nType = dbText;
	fieldinfo2.m_lSize = 50;
	fieldinfo2.m_lAttributes = dbVariableField;
	fieldinfo2.m_nOrdinalPosition = 2;
	fieldinfo2.m_bRequired = TRUE;
	fieldinfo2.m_bAllowZeroLength = FALSE;
	tb.CreateField(fieldinfo2);

	CDaoFieldInfo fieldinfo3;
	fieldinfo3.m_strName ="生成时间";
	fieldinfo3.m_nType = dbDate;
	fieldinfo3.m_lSize = 8;
	fieldinfo3.m_lAttributes = dbFixedField | dbUpdatableField;
	fieldinfo3.m_nOrdinalPosition = 3;
	fieldinfo3.m_bRequired = TRUE;
	fieldinfo3.m_bAllowZeroLength = FALSE;
	tb.CreateField(fieldinfo3);

	CDaoFieldInfo fieldinfo4;
	fieldinfo4.m_strName ="存储位置";
	fieldinfo4.m_nType = dbText;
	fieldinfo4.m_lSize = 50;
	fieldinfo4.m_lAttributes = dbVariableField;
	fieldinfo4.m_nOrdinalPosition = 4;
	fieldinfo4.m_bRequired = TRUE;
	fieldinfo4.m_bAllowZeroLength = FALSE;
	tb.CreateField(fieldinfo4);

	CDaoFieldInfo fieldinfo5;
	fieldinfo5.m_strName ="文件尺寸";
	fieldinfo5.m_nType = dbLong;
	fieldinfo5.m_lSize = 4;
	fieldinfo5.m_lAttributes = dbFixedField;
	fieldinfo5.m_nOrdinalPosition = 5;
	fieldinfo5.m_bRequired = TRUE;
	fieldinfo5.m_bAllowZeroLength = FALSE;
	tb.CreateField(fieldinfo5);

	CDaoFieldInfo fieldinfo6;
	fieldinfo6.m_strName ="备注";
	fieldinfo6.m_nType = dbText;
	fieldinfo6.m_lSize = 50;
	fieldinfo6.m_lAttributes = dbVariableField;
	fieldinfo6.m_nOrdinalPosition = 6;
	fieldinfo6.m_bRequired = FALSE;
	fieldinfo6.m_bAllowZeroLength = TRUE;
	tb.CreateField(fieldinfo6);

	tb.Append();

	tb.Close();
	db.Close();

	return TRUE;
}