users.cpp

用于图书馆开发的期刊登记源程序

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

#include "stdafx.h"
#include "QKDJ.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()
{
	UserId=0;
	UserName="";
	UserPwd="";

}

CUsers::~CUsers()
{

}





void CUsers::sql_insert()
{
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitDBConnect();
	// 设置INSERT语句
	_bstr_t vSQL;
	vSQL="insert into admin(UserName,UserPwd) values('"+UserName+"','"+UserPwd+"')";
	m_AdoConn.ExecuteSQL(vSQL);  // 执行INSERT语句
	m_AdoConn.ExitConnect();     // 断开与数据库的连接
}

void CUsers::sql_update(CString cUserId)
{

}

void CUsers::sql_delete(CString cUserId)
{

}

void CUsers::GetData(CString cUserName)
{
	// 连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitDBConnect();
	// 设置SELECT语句
	_bstr_t vSQL;
	vSQL="select * from admin where UserName='"+cUserName+"'";
	// 执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_AdoConn.GetRecordSet(vSQL);
	// 返回各列的值
	if(m_pRecordset->adoEOF)
		CUsers();
	else
	{
		UserId=atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("UserId"));
		UserName=cUserName;
		UserPwd=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("UserPwd");
	}
	// 断开与数据库的连接
	m_AdoConn.ExitConnect();
}