example.cpp

vc150例源码

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

#include "stdafx.h"
#include "Example.h"
#include "MyRecordSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// 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.
		CMyRecordSet m_MyRecordSet(NULL);
		CString str1="Select * from [Title Author] where Au_ID<100";
		m_MyRecordSet.Open(CMyRecordSet::dynaset,str1);
		m_MyRecordSet.MoveFirst();
		int nFieldCount=m_MyRecordSet.GetODBCFieldCount();
		for(int i=0;i<nFieldCount;i++)
		{
			CODBCFieldInfo FieldInfo;
			m_MyRecordSet.GetODBCFieldInfo(i,FieldInfo); 
			printf("%-25s",FieldInfo.m_strName);
		}
		while(!m_MyRecordSet.IsEOF())
		{
			printf("\n");
			for(int i=0;i<nFieldCount;i++)
			{
				CString strVar;
				m_MyRecordSet.GetFieldValue(i,strVar);
				printf("%-25s",strVar);			
			}
			m_MyRecordSet.MoveNext();
		}
	}
	getchar();
	return nRetCode;
}