users.cpp

一个简易超市系统,有进货,销售.等功能 对学习有C++数据库操作有一定的帮助

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

#include "stdafx.h"
#include "PosClient.h"
#include "Users.h"
#include "ADOConn.h"
#include "MD5C.h"
#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

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

CUsers::CUsers()
{

}

CUsers::~CUsers()
{

}

CString CUsers::GetUserId()
{
	return cId;
}
void CUsers::SetUserID(CString cUserID)
{
	cId=cUserID;
}
CString CUsers::GetUserName()
{
	return cName;
}

void CUsers::SetUserName(CString cUserName)
{
	cName = cUserName;
}

CString CUsers::GetUserPwd()
{
	return cPwd;
}

void CUsers::SetUserPwd(CString cUserPwd)
{
	cPwd = cUserPwd;
}

int CUsers::GetUserType()
{
	return cType;
}
void CUsers::SetUserType(int cUserType)
{
	cType=cUserType;
}

void CUsers::SetUserInfo(CString cUserInfo)
{
	cInfo=cUserInfo;
}
CString CUsers::GetUserInfo()
{
	return cInfo;
}

//数据库操作
int CUsers::HaveName(CString cUserId)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM users WHERE userID='" + cUserId + "'";
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;

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

	
void CUsers::sql_insert()
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	CString strType;
	strType.Format("%d", cType);
	CString strPwd=cPwd;
	strPwd = MD5Binary((const unsigned char *)(LPCSTR)strPwd, strPwd.GetLength());
	_bstr_t vSQL;
	vSQL = "INSERT INTO users VALUES('" + cId+ "','"+ cName + "','" + strPwd + "'," 
		+ strType + ",'" + cInfo + "')";	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CUsers::sql_updatePwd(CString cUserId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置UPDATE语句
	CString strType;
	strType.Format("%d", cType);
	CString strPwd=cPwd;
	strPwd = MD5Binary((const unsigned char *)(LPCSTR)strPwd, strPwd.GetLength());

	_bstr_t vSQL;
	vSQL = "UPDATE users SET userPWD='" + strPwd + "' WHERE userID='" + cUserId + "'";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CUsers::sql_delete(CString cUserId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM users WHERE userID='" + cUserId	+ "'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CUsers::sql_delall()
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE * FROM users";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

//根据员工编号读取所有字段值
void CUsers::GetData(CString cUserId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM users WHERE userID='" + cUserId + "'";
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CUsers();
	else
	{
		cId = cUserId;
		cName = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("userNAME");
		cPwd = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("userPWD");
		cType = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("userTYPE"));
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}