bookdatasouce.cpp

一个小型的图书管理系统,用到了access数据库,其中有三种权限的用户登陆这个系统,每种用户将拥有不同的权限,用户密码和帐户打开程序中的access便可知道.

// BookDataSouce.cpp : implementation file
//

#include "stdafx.h"
#include "Book.h"
#include "BookDataSouce.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBookDataSouce

IMPLEMENT_DYNAMIC(CBookDataSouce, CRecordset)

CBookDataSouce::CBookDataSouce(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CBookDataSouce)
	m_column1 = 0;
	m_column2 = _T("");
	m_column3 = _T("");
	m_column4 = _T("");
	m_column5 = _T("");
	m_column8 = 0;
	m_column9 = 0;
	m_column7 = 0.0;
	m_nFields = 9;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CBookDataSouce::GetDefaultConnect()
{
	return _T("ODBC;DSN=bookuser");
}

CString CBookDataSouce::GetDefaultSQL()
{
	return _T("[tushu]");
}

void CBookDataSouce::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CBookDataSouce)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Int(pFX, _T("[书号]"), m_column1);
	RFX_Text(pFX, _T("[书名]"), m_column2);
	RFX_Text(pFX, _T("[类别]"), m_column3);
	RFX_Text(pFX, _T("[出版社]"), m_column4);
	RFX_Text(pFX, _T("[作者]"), m_column5);
	RFX_Date(pFX, _T("[出版日期]"), m_column6);
	RFX_Int(pFX, _T("[总数量]"), m_column8);
	RFX_Int(pFX, _T("[借出数量]"), m_column9);
	RFX_Double(pFX, _T("[价格]"), m_column7);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CBookDataSouce diagnostics

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

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