admin.cpp

图书管理系统 带源码 文档

// Admin.cpp: implementation of the CAdmin class.
//
////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Library.h"
#include "Admin.h"
#include "ADOConn.h"

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

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

CAdmin::CAdmin()
{
	Adn_Name = "";
	Adn_No = "";
	Adn_PW = "";
	Adn_Sex = "";
	Adn_Tel = "";
	Adn_Email = "";
	Adn_Address = "";
	Adn_Demo = "";
}

CAdmin::~CAdmin()
{

}

CString CAdmin::GetNo()
{
	return Adn_No;
}

CString CAdmin::GetName()
{
	return Adn_Name;
}

CString CAdmin::GetPW()
{
	return Adn_PW;
}

CString CAdmin::GetAddress()
{
	return Adn_Address;
}

CString CAdmin::GetDemo()
{
	return Adn_Demo;
}

CString CAdmin::GetEmail()
{
	return Adn_Email;
}

CString CAdmin::GetSex()
{
	return Adn_Sex;
}

CString CAdmin::GetTel()
{
	return Adn_Tel;
}

void CAdmin::SetAddress(CString vAddress)
{
	Adn_Address = vAddress;
}

void CAdmin::SetDemo(CString vDemo)
{
	Adn_Demo = vDemo;
}

void CAdmin::SetEmail(CString vEmail)
{
	Adn_Email = vEmail;
}

void CAdmin::SetName(CString vName)
{
	Adn_Name = vName;
}

void CAdmin::SetNo(CString vNo)
{
	Adn_No = vNo;
}

void CAdmin::SetPW(CString vPW)
{
	Adn_PW = vPW;
}

void CAdmin::SetSex(CString vSex)
{
	Adn_Sex = vSex;
}

void CAdmin::SetTel(CString vTel)
{
	Adn_Tel = vTel;
}

void CAdmin::GetData(CString vNo)
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	_bstr_t vSQL;
	vSQL = "SELECT * FROM Admin WHERE ANo='" + vNo + "'";
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	if (m_pRecordset->adoEOF)
		CAdmin();
	else
	{
		Adn_No = vNo;
		Adn_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("AName");
		Adn_PW = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PW");
		Adn_Sex = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sex");
		Adn_Tel = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Tel");
		Adn_Email = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Email");
		Adn_Address = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Address");
		Adn_Demo = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Demo");

		m_AdoConn.ExitConnect();
	}
}

void CAdmin::SQL_Insert()
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	_bstr_t vSQL;
	vSQL = "INSERT INTO Admin VALUES('"+Adn_No+"','"+Adn_Name+"','"+Adn_PW+"','"+Adn_Sex
		+"','"+Adn_Tel+"','"+Adn_Email+"','"+Adn_Address+"','"+Adn_Demo+"')";
	m_AdoConn.ExecuteSQL(vSQL);
	m_AdoConn.ExitConnect();
}

void CAdmin::SQL_Update(CString vNo)
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	_bstr_t vSQL;
	vSQL = "UPDATE Admin SET AName='"+Adn_Name+"',PW='"+Adn_PW+"',Sex='"+Adn_Sex
		+"',Tel='"+Adn_Tel+"',Email='"+Adn_Email+"',Address='"+Adn_Address+
		"',Demo='"+Adn_Demo+"' WHERE ANo='"+vNo+"'";
	m_AdoConn.ExecuteSQL(vSQL);
	m_AdoConn.ExitConnect();
}

void CAdmin::SQL_Delete(CString vNo)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Admin WHERE ANo='" + vNo +"'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}