bookinfo.cpp

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

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

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

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

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

BookInfo::BookInfo()
{
	 a_BookId="";
	 a_BookClaId="";
	 a_AuthorId="";
	 a_BookName="错误";
	 a_BookPrice="";
	 a_Copyright="";
	 a_PubCompany="";
	 a_PageAmount="";
	 a_PubDate="";
	 a_PubNumber="";
}

BookInfo::~BookInfo()
{

}

void BookInfo::sql_delete(CString BookId)
{
	ADOConn m_adoconn;
	m_adoconn.OnInitADOConn();
	_bstr_t vSQL;
	vSQL="delete from t_book where BookId='"+BookId+"'";
	m_adoconn.ExecuteSQL(vSQL);
	m_adoconn.ExitConnect();
}

void BookInfo::sql_update(CString BookId)
{
	ADOConn m_adoconn;
	m_adoconn.OnInitADOConn();
	_bstr_t vSQL;
	vSQL="update t_book set BookName='yym' where BookId='"+BookId+"'";
	m_adoconn.ExecuteSQL(vSQL);
	m_adoconn.ExitConnect();
}

bool BookInfo::sql_insert()
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	_bstr_t vSQL;
	vSQL="insert into t_book(BookId,BookClaId,AuthorId,BookName,PubDate,PubNum,PubCompany,BookPrice,PageAmount,Copyright) values('"
		+a_BookId+"','"+a_BookClaId+"','"+a_AuthorId+"','"
		+a_BookName+"','"+a_PubDate+"','"+a_PubNumber+"','"
		+a_PubCompany+"',"+a_BookPrice+","+a_PageAmount
		+",'"+a_Copyright+"')";
	m_AdoConn.ExecuteSQL(vSQL);
	m_AdoConn.ExitConnect();
	return true;
}

void BookInfo::GetData(CString BookId)
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	_bstr_t vSQL;
	vSQL="SELECT * from t_book where BookId='"+BookId+"'";
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_AdoConn.GetRecordSet(vSQL);
	if(m_pRecordset->adoEOF)
		BookInfo();
	else
	{//
	 a_BookId=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BookId");
	 a_BookName=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BookName");
	 a_BookClaId=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BookClaId");
	 a_AuthorId=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("AuthorId");	 
	 a_BookPrice=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BookPrice");
	 a_Copyright=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Copyright");
	 a_PubCompany=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PubCompany");
	 a_PageAmount=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PageAmount");
	 a_PubDate=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PubDate");
	 a_PubNumber=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PubNum");
	}
	m_AdoConn.ExitConnect();

}