sturecordset.cpp

VC++一个数据库的开发

// StuRecordSet.cpp : implementation file
//

#include "stdafx.h"
#include "ODBC.h"
#include "StuRecordSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CStuRecordSet

IMPLEMENT_DYNAMIC(CStuRecordSet, CRecordset)

CStuRecordSet::CStuRecordSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CStuRecordSet)
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CStuRecordSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=stu_scores;UID=sa;PWD=111111");
}

CString CStuRecordSet::GetDefaultSQL()
{
	//return _T("[dbo].[scores]");
	return _T("select * from scores");
}

void CStuRecordSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CStuRecordSet)
	RFX_Text(pFX,_T("stu_name"),m_strStuName,8+1);
	RFX_Text(pFX,_T("stu_id"),m_strStuID,8+1);
	RFX_Int(pFX,_T("Chinese"),m_iChinese);
	RFX_Int(pFX,_T("Math"),m_iMath);
	RFX_Int(pFX,_T("English"),m_iEnglish);
	RFX_Int(pFX,_T("total"),m_iTotal);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CStuRecordSet diagnostics

#ifdef _DEBUG
void CStuRecordSet::AssertValid() const
{
	CRecordset::AssertValid();
}

void CStuRecordSet::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG