userset.cpp

Visual C++ 入门、进阶、与应用 如何使用链表末尾追加节点实例 可学习操作链表

// UserSet.cpp : implementation file
//

#include "stdafx.h"
#include "Ex080201.h"
#include "UserSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CUserSet
IMPLEMENT_DYNAMIC(CUserSet, CRecordset)

CUserSet::CUserSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CUserSet)
	m_ID = 0;
	m_UserName = _T("");
	m_Popedom = 0;
	m_Password = _T("");
	m_Comment = _T("");
	m_nFields = 5;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CUserSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=Ex080201");
}

CString CUserSet::GetDefaultSQL()
{
	return _T("[UserTable]");
}

void CUserSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CUserSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[ID]"), m_ID);
	RFX_Text(pFX, _T("[UserName]"), m_UserName);
	RFX_Text(pFX, _T("[Password]"), m_Password);
	RFX_Long(pFX, _T("[Popedom]"), m_Popedom);
	RFX_Text(pFX, _T("[Comment]"), m_Comment);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CUserSet diagnostics

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

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

#include "UserManage.h"

bool CUserSet::AddUser(const CUser &newUser)
{
	Open();
	CString strSql ;
	strSql.Format("insert into UserTable Values(%d,\'%s\',\'%s\',%d,\'%s\')",
		newUser.m_uID,newUser.m_strUserName,newUser.m_strPassWord,newUser.m_uPopedom,newUser.m_strComment);
	m_pDatabase->ExecuteSQL(strSql);
	Close();
	return true ;
}

bool CUserSet::DeleteUser(UINT uID)
{
	Open();
	CString strSql ;
	strSql.Format("delete * from UserTable where ID = %d " , uID);
	m_pDatabase->ExecuteSQL(strSql);
	Close();
	
	return true ;
}

bool CUserSet::EditUser(CUser newUser)
{
	Open();
	CString strSql ;
	strSql.Format("update UserTable set UserName=\'%s\',Password=\'%s\',Popedom=%d,Comment=\'%s\' WHERE ID= %d",
		newUser.m_strUserName,newUser.m_strPassWord,newUser.m_uPopedom,newUser.m_strComment,newUser.m_uID);
	m_pDatabase->ExecuteSQL(strSql);
	Close();
	
	return true ;
}

/*
 bool CUserSet::AddUser(const CUser &newUser)
 {
	Open();
	AddNew();
	m_ID = newUser.m_uID ;
	m_UserName	= newUser.m_strUserName ;
	m_Password	= newUser.m_strPassWord ;
	m_Popedom	= newUser.m_uPopedom ;
	m_Comment	= newUser.m_strComment ;
	if(!Update())
	{
	Close();
	return false ;
	}
	Close();
	return true ;
	}
	
	  bool CUserSet::DeleteUser(UINT uID)
	  {
	  CString strSql ;
	  strSql.Format("select * from UserTable where ID = %d " , uID);
	  Open(AFX_DB_USE_DEFAULT_TYPE,strSql);
	  Delete();
	  Close();
	  
		return true ;
		}
		
		  bool CUserSet::EditUser(CUser newUser)
		  {
		  CString strSql ;
		  strSql.Format("select * from UserTable where ID = %d " , newUser.m_uID);
		  Open(AFX_DB_USE_DEFAULT_TYPE,strSql);
		  if(!IsEOF())
		  {
		  Edit();
		  m_ID = newUser.m_uID ;
		  m_UserName = newUser.m_strUserName ;
		  m_Password = newUser.m_strPassWord ;
		  m_Popedom  = newUser.m_uPopedom ;
		  m_Comment   = newUser.m_strComment ;
		  if(!Update())
		  {
		  Close();
		  return false ;
		  }
		  }
		  Close();
		  
			return true ;
			}
			
*/