newbook.cpp

图书管理系统 带源码 文档

// NewBook.cpp: implementation of the CNewBook class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "library.h"
#include "NewBook.h"
#include "ADOConn.h"

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

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

CNewBook::CNewBook()
{
	Nb_Name = "";
	Nb_Type = "";
	Nb_Author = "";
	Nb_Press = "";
	Nb_PublicDate = "";
	Nb_About = "";
}

CNewBook::~CNewBook()
{

}

CString CNewBook::GetAbout()
{
	return Nb_About;
}

CString CNewBook::GetAuthor()
{
	return Nb_Author;
}

CString CNewBook::GetName()
{
	return Nb_Name;
}

CString CNewBook::GetPress()
{
	return Nb_Press;
}

CString CNewBook::GetPublicDate()
{
	return Nb_PublicDate;
}

CString CNewBook::GetType()
{
	return Nb_Type;//分类:1.社会科学 2.自然科学 3艺术类 4综合类 
}

void CNewBook::SetAbout(CString vAbout)
{
	Nb_About = vAbout;
}

void CNewBook::SetAuthor(CString vAuthor)
{
	Nb_Author = vAuthor;
}

void CNewBook::SetName(CString vName)
{
	Nb_Name = vName;
}

void CNewBook::SetPress(CString vPress)
{
	Nb_Press = vPress;
}

void CNewBook::SetPublicDate(CString vPDate)
{
	Nb_PublicDate = vPDate;
}

void CNewBook::SetType(CString vType)
{
	Nb_Type = vType;
}

void CNewBook::GetData(CString vName)
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	_bstr_t vSQL;
	vSQL = "SELECT * FROM NewBook WHERE NName='" + vName + "'";
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	if (m_pRecordset->adoEOF)
		CNewBook();
	else
	{
		Nb_Name = vName;
		Nb_Type = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Type");
		Nb_Author = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Author");
		Nb_Press = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Press");
		Nb_PublicDate = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PublicDate");
		Nb_About = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("About");

		m_AdoConn.ExitConnect();
	}
}

void CNewBook::SQL_Insert()
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	_bstr_t vSQL;
	vSQL = "INSERT INTO NewBook VALUES('"+Nb_Name+"','"+Nb_Type+"','"
		+Nb_Author+"','"+Nb_Press+"','"+Nb_PublicDate+"','"+Nb_About+"')";
	m_AdoConn.ExecuteSQL(vSQL);
	m_AdoConn.ExitConnect();
}

void CNewBook::SQL_Update(CString vName)
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	_bstr_t vSQL;
	vSQL = "UPDATE NewBook SET Type='"+Nb_Type+"',Author='"+Nb_Author+"',Press='"+Nb_Press
		+"',PublicDate='"+Nb_PublicDate+"',About='"+Nb_About +"' WHERE NName='" + vName+"'";  
	m_AdoConn.ExecuteSQL(vSQL);
	m_AdoConn.ExitConnect();
}

void CNewBook::SQL_Delete(CString vName)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	_bstr_t vSQL;
	//设置DELETE语句
	vSQL = "DELETE FROM NewBook WHERE NName='" + vName +"'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	

	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}