password.cpp

VC下基于SQL的图书管理系统源代码

// Password.cpp: implementation of the Password class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "BookAdmi.h"
#include "Password.h"
#include "ADOConn.h"

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

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

Password::Password()
{

}

Password::~Password()
{

}

void Password::GetData(CString PassId)
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	_bstr_t vSQL;
	vSQL="SELECT * from t_password where Id='"+PassId+"'";
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_AdoConn.GetRecordSet(vSQL);
	if(m_pRecordset->adoEOF)
		Password();
	else
	{//
		m_Password=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Password");	 
	}
	m_AdoConn.ExitConnect();

}