usersset.cpp

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

// UsersSet.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "UsersSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CUsersSet

IMPLEMENT_DYNAMIC(CUsersSet, CRecordset)

CUsersSet::CUsersSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CUsersSet)
	m_Uid = _T("");
	m_Upassword = _T("");
	m_Upower = 0;
	m_Usex = FALSE;
	m_Uname = _T("");
	m_Uaddress = _T("");
	m_Utel = _T("");
	m_Uemail = _T("");
	m_Uclass = _T("");
	m_Udepartment = _T("");
	m_Umajor = _T("");
	m_Uclassno = _T("");
	m_Ucorporation = _T("");
	m_Ureadstat = FALSE;
	m_nFields = 14;
	//}}AFX_FIELD_INIT
	m_nDefaultType = dynaset;
}


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

CString CUsersSet::GetDefaultSQL()
{
	return _T("[dbo].[USERS]");
}

void CUsersSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CUsersSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[Uid]"), m_Uid);
	RFX_Text(pFX, _T("[Upassword]"), m_Upassword);
	RFX_Long(pFX, _T("[Upower]"), m_Upower);
	RFX_Bool(pFX, _T("[Usex]"), m_Usex);
	RFX_Text(pFX, _T("[Uname]"), m_Uname);
	RFX_Text(pFX, _T("[Uaddress]"), m_Uaddress);
	RFX_Text(pFX, _T("[Utel]"), m_Utel);
	RFX_Text(pFX, _T("[Uemail]"), m_Uemail);
	RFX_Text(pFX, _T("[Uclass]"), m_Uclass);
	RFX_Text(pFX, _T("[Udepartment]"), m_Udepartment);
	RFX_Text(pFX, _T("[Umajor]"), m_Umajor);
	RFX_Text(pFX, _T("[Uclassno]"), m_Uclassno);
	RFX_Text(pFX, _T("[Ucorporation]"), m_Ucorporation);
	RFX_Bool(pFX, _T("[Ureadstat]"), m_Ureadstat);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CUsersSet diagnostics

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

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