users.cpp

快餐管理系统 这个快餐管理系统,实现了实际数据库管理功能,能给相关开发的朋友提供很好的借鉴

// Users.cpp: implementation of the CUsers class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "FastSellStore.h"
#include "Users.h"
#include "ADOConn.h"

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

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CUsers::CUsers()
:UserName(),
 UserPwd(),
 UserType(0)
{

}

CUsers::~CUsers()
{

}

/* Database Operations */

/*

  返回由cUserName指定的数据段

*/
void CUsers::GetData (CString cUserName)
{
	// 连接数据库
	AccADOConn m_AdoConn;
	m_AdoConn.OnInitDBConnect();

	// 设置SQL语句
	_bstr_t vSql;
	vSql = "SELECT * FROM Users WHERE User_Name = '" + cUserName + "'";

	// 执行SQL语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet (vSql);

	if(!m_AdoConn.GetRecordCount())
	// 返回各列的值
	//if(m_pRecordset->adoEOF == 1)
	{
		CUsers();
	}
	else
	{
		this->UserName = m_AdoConn.GetFieldValue("User_Name");
		this->UserPwd  = m_AdoConn.GetFieldValue("User_Pwd");
		this->UserType = atoi(m_AdoConn.GetFieldValue("User_Type"));
	}

	// 断开数据库的连接
	m_AdoConn.ExitConnect();
}

/*
	-1, 没有此人；1，有此人
	根据cUserName，在数据库中查找
*/
int CUsers::HaveName (CString cUserName)
{
	AccADOConn m_AdoConn;

	// 连接数据库
	m_AdoConn.OnInitDBConnect ();
	
	// 设置SQL语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Users WHERE User_Name = '" + cUserName + "'";

	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet (vSQL);

	if(m_pRecordset->adoEOF)
		return -1;
	else
		return 1;

	// 断开数据库连接
	m_AdoConn.ExitConnect ();

}
void CUsers::sql_Delete (CString cUserName)
{
	// Create Database connection
	AccADOConn m_AdoConn;
	m_AdoConn.OnInitDBConnect();

	// SQL
	_bstr_t vSql;
	vSql = "DELECT FROM Users WHERE User_Name = '" + cUserName + "'";

	// Execute SQL
	m_AdoConn.ExecuteSQL(vSql);

	// disconnect
	m_AdoConn.ExitConnect();
}
void CUsers::sql_Insert ()
{
	// Create Database Connect
	AccADOConn m_AdoConn;
	m_AdoConn.OnInitDBConnect();

	CString strType;
	strType.Format("%d",UserType);

	// set sql statement
	_bstr_t vSql;
	vSql = "INSERT INTO Users VALUES('" + UserName + "','" + UserPwd + "'," + strType + ")";

	// Execute Sql Statement
	m_AdoConn.ExecuteSQL(vSql);

	// disconnect
	m_AdoConn.ExitConnect();
}
void CUsers::sql_UpdatePwd (CString cUserName)
{
	// Create Database Connection
	AccADOConn m_AdoConn;
	m_AdoConn.OnInitDBConnect();

	// Build sql statement
	_bstr_t vSql;
	vSql = "UPDATE Users SET User_Pwd = " + UserPwd + " WHERE User_Name = '" + UserName +"'";

	// Execute SQL
	m_AdoConn.ExecuteSQL(vSql);

	// Disconnection
	m_AdoConn.ExitConnect();
}

void CUsers::SetUserName  (CString cUserName)
{
	this->UserName = cUserName;
}

void CUsers::SetUserPwd (CString cUserPwd)
{
	this->UserPwd = cUserPwd;
}

void CUsers::SetUserType (int iType)
{
	this->UserType = iType;
}

CString CUsers::GetUserName ()
{
	return this->UserName;
}

CString CUsers::GetUserPwd ()
{
	return this->UserPwd;
}

int CUsers::GetUserType ()
{
	return this->UserType;
}