bookset.cpp

采用MFC+SQLSERVER 2000的图书管理系统,ODBC方式连接数据库。功能包括 书籍管理

// BookSet.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "BookSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBookSet

IMPLEMENT_DYNAMIC(CBookSet, CRecordset)

CBookSet::CBookSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CBookSet)
	m_Bid = _T("");
	m_Bisbn = _T("");
	m_Bname = _T("");
	m_Bauthor = _T("");
	m_Bpress = _T("");
	m_Btheme = _T("");
	m_Bclassify = _T("");
	m_Binds = _T("");
	m_Bprice = _T("");
	m_Bseriesname = _T("");
	m_Bdescribe = _T("");
	m_Btiaoma = _T("");
	m_nFields = 12;
	//}}AFX_FIELD_INIT
	m_nDefaultType = dynaset;
}


CString CBookSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=MySQL");
}

CString CBookSet::GetDefaultSQL()
{
	return _T("[dbo].[BOOK]");
}

void CBookSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CBookSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[Bid]"), m_Bid);
	RFX_Text(pFX, _T("[Bisbn]"), m_Bisbn);
	RFX_Text(pFX, _T("[Bname]"), m_Bname);
	RFX_Text(pFX, _T("[Bauthor]"), m_Bauthor);
	RFX_Text(pFX, _T("[Bpress]"), m_Bpress);
	RFX_Text(pFX, _T("[Btheme]"), m_Btheme);
	RFX_Text(pFX, _T("[Bclassify]"), m_Bclassify);
	RFX_Text(pFX, _T("[Binds]"), m_Binds);
	RFX_Text(pFX, _T("[Bprice]"), m_Bprice);
	RFX_Text(pFX, _T("[Bseriesname]"), m_Bseriesname);
	RFX_Text(pFX, _T("[Bdescribe]"), m_Bdescribe);
	RFX_Text(pFX, _T("[Btiaoma]"), m_Btiaoma);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CBookSet diagnostics

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

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