数据库作业set.cpp

用vc实现的连接sql数据库程序

// 数据库作业Set.cpp : implementation of the CMySet class
//

#include "stdafx.h"
#include "数据库作业.h"
#include "数据库作业Set.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMySet implementation

IMPLEMENT_DYNAMIC(CMySet, CRecordset)

CMySet::CMySet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CMySet)
	m_CNO = 0;
/*	m_CName = _T("");
	m_CPrve = 0;
	m_CCredit = 0;
	m_SNO = _T("");
	m_SName = _T("");
	m_SAge = 0;
	m_SSex = _T("");
	m_SDept = _T("");
	m_S_NO = _T("");
	m_C_NO = _T("");
	m_Grade = 0;*/
	m_nFields = 1;
	//}}AFX_FIELD_INIT
	m_nDefaultType = dynaset;
}

CString CMySet::GetDefaultConnect()
{
	return _T("ODBC;DSN=MS Access Database");
}

CString CMySet::GetDefaultSQL()
{
	return _T("[C],[S],[SC]");
}

void CMySet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CMySet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	
	RFX_Long(pFX, _T("[CNO]"), m_CNO);
/*	RFX_Text(pFX, _T("[CName]"), m_CName);
	RFX_Long(pFX, _T("[CPrve]"), m_CPrve);
	RFX_Long(pFX, _T("[CCredit]"), m_CCredit);
	RFX_Text(pFX, _T("[SNO]"), m_SNO);
	RFX_Text(pFX, _T("[SName]"), m_SName);
	RFX_Int(pFX, _T("[SAge]"), m_SAge);
	RFX_Text(pFX, _T("[Sex]"), m_SSex);
	RFX_Text(pFX, _T("[Dept]"), m_SDept);
	RFX_Text(pFX, _T("[S_NO]"), m_S_NO);
	RFX_Text(pFX, _T("[C_NO]"), m_C_NO);
	RFX_Int(pFX, _T("[Grade]"), m_Grade);*/
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CMySet diagnostics

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

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