authorinfo.cpp

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

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

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

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

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

AuthorInfo::AuthorInfo()
{

}

AuthorInfo::~AuthorInfo()
{

}

bool AuthorInfo::sql_insert()
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	_bstr_t vSQL;
	vSQL="insert into t_author(AuthorId,AuthorAdr,AuthorName,City,PostNum,Tel,Fax,Email,Remark) values('"
		+a_AuthorId+"','"+a_AuthorAdr+"','"+a_AuthorName+"','"
		+a_City+"','"+a_PostNum+"','"+a_Tel+"','"
		+a_Fax+"','"+a_Email+"','"+a_Remark
		+"')";
	m_AdoConn.ExecuteSQL(vSQL);
	m_AdoConn.ExitConnect();
	return true;
}

void AuthorInfo::GetData(CString AuthorId)
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	_bstr_t vSQL;
	vSQL="SELECT * from t_author where AuthorId='"+AuthorId+"'";
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_AdoConn.GetRecordSet(vSQL);
	if(m_pRecordset->adoEOF)
		AuthorInfo();
	else
	{//
	 a_AuthorId=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("AuthorId");
	 a_AuthorName=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("AuthorName");
	 a_AuthorAdr=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("AuthorAdr");
	 a_City=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("City");	 
	 a_PostNum=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PostNum");
	 a_Tel=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Tel");
	 a_Fax=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Fax");
	 a_Email=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Email");
	 a_Remark=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Remark");
	 //a_PubNumber=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PubNum");
	}
	m_AdoConn.ExitConnect();
}