users.cpp

管理员登录功能；读者借阅模块；读者归还模块；书籍信息模块

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

#include "stdafx.h"
#include "db.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()
{
	m_UserName = "";
	m_Pwd = "";
	m_User_type = 0;
}

CUsers::~CUsers()
{

}

CString CUsers::GetUserName()
{
	return m_UserName;
}

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

CString CUsers::GetPwd()
{
	return m_Pwd;
}

void CUsers::SetPwd(CString cPwd)
{
	m_Pwd = cPwd;
}

int CUsers::GetUser_type()
{
	return m_User_type;
}

void CUsers::SetUser_type(int iUser_type)
{
	m_User_type = iUser_type;
}

//数据库操作
int CUsers::HaveName(CString cUserName)
{	
	int iRet = -1;
	try
	{
	//连接数据库
	ADOConn adoConn;
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM UserInfo WHERE UserID='" + cUserName + "'";
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = adoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		iRet = -1;
	else
		iRet = 1;
	
	//断开与数据库的连接
	adoConn.ExitConnect();
	}
	catch(_com_error e)
	{
		iRet = -1;
		// 显示错误信息
		AfxMessageBox(e.Description());
	}

	return iRet;
}

	
void CUsers::Insert()
{	
	try
	{
		//连接数据库
		ADOConn adoConn;
		//设置INSERT语句
		CString strType;
		strType.Format("%d", m_User_type);
		
		_bstr_t vSQL;
		vSQL = "INSERT INTO UserInfo VALUES('" + m_UserName + "','" 
			+ m_Pwd + "'," + strType + ")";	
		//执行INSERT语句
		adoConn.ExecuteSQL(vSQL);	
		//断开与数据库的连接
		adoConn.ExitConnect();
	}
	catch(_com_error e)
	{
		// 显示错误信息
		AfxMessageBox(e.Description());
	}
}

void CUsers::UpdatePwd(CString cUserName)
{
	try
	{
		//连接数据库
		ADOConn adoConn;
		//设置UPDATE语句
		_bstr_t vSQL;
		vSQL = "UPDATE UserInfo SET UserPwd='" + m_Pwd + 
			"' WHERE UserID='" + cUserName + "'";
		//执行UPDATE语句
		adoConn.ExecuteSQL(vSQL);	
		//断开与数据库的连接
		adoConn.ExitConnect();
	}
	catch(_com_error e)
	{
		// 显示错误信息
		AfxMessageBox(e.Description());
	}
}

void CUsers::Delete(CString cUserName)
{
	try
	{
		//连接数据库
		ADOConn adoConn;
		//设置DELETE语句
		_bstr_t vSQL;
		vSQL = "DELETE FROM UserInfo WHERE UserID='" + cUserName	+ "'";
		//执行DELETE语句
		adoConn.ExecuteSQL(vSQL);	
		//断开与数据库的连接
		adoConn.ExitConnect();
	}
	// 捕捉异常
	catch(_com_error e)
	{
		// 显示错误信息
		AfxMessageBox(e.Description());
	}
}

//根据用户名读取所有字段值
void CUsers::GetData(CString cUserName)
{
	//连接数据库
	ADOConn adoConn;
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM UserInfo WHERE UserID='" 
		+ cUserName + "'";
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = adoConn.GetRecordSet(vSQL);
	
	//返回各列的值
	if (m_pRecordset->adoEOF)
	{
		m_UserName = "";
		m_Pwd = "";
		m_User_type = 0;
	}
	else
	{
		m_UserName = cUserName;
		m_Pwd = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("UserPwd");
		m_User_type = atoi((LPCTSTR)
			(_bstr_t)m_pRecordset->GetCollect("UserType"));
	}
	//断开与数据库的连接
	adoConn.ExitConnect();
}