newbook.cpp

图书管理系统可进行查询,添加,修改,等操作 用树行结构为图书馆进行图书分类

// newbook.cpp: implementation of the Cnewbook class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "图书管理.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()
{
	bussname="";
	bookname="";
	time="";
	shumu="";
	leixing=0;
	
}

Cnewbook::~Cnewbook()
{

}
int Cnewbook::HaveName(CString str)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM newbook WHERE bookname='" + str + "'";
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

int Cnewbook::Havebuss(CString str)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM newbook WHERE bussname='" + str+"' ";
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
void Cnewbook::sql_insert()
{	
	//连接数据库
	CString str;
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
//	CString strUpperId;
//	strUpperId.Format("%d", UpperId);
  str.Format("%d",leixing);
	_bstr_t vSQL;
	vSQL = "INSERT INTO  newbook (bookname,bussname , shumu, tim,leixing) VALUES('" + bookname + "','"+ bussname + "','" + shumu + "','" +time+"','"+str+"')";	
	//执行INSERT语句
     m_AdoConn.ExecuteSQL(vSQL);	
     
	//读取最大编号
//	long lDepId;
//	vSQL = "SELECT MAX(Dep_id) AS MaxId FROM Departments";	
	//执行SELETE语句
//	_RecordsetPtr m_pRecordset;
//	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	//返回各列的值
//	if (m_pRecordset->adoEOF)
//		lDepId = 0;
//	else
//		lDepId = atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("MaxId"));
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

//	return lDepId;
}

void Cnewbook::sql_update(CString str)
{
	//连接数据库
	CString str2;
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置UPDATE语句
   str2.Format("%d",leixing);


	_bstr_t vSQL;
	vSQL = "UPDATE newbook SET bussname='" + bussname+ "',shumu='" + shumu + "',tim='" +time+"',leixing='"+str2+"'WHERE bookname='" + str+"'";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void Cnewbook::sql_delete(CString cDepId,CString str)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM newbook WHERE bookname='" + cDepId+"'AND bussname='"+str+"'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

//根据员工编号读取所有字段值
void Cnewbook::GetData(CString cDepId)
{
	//连接数据库
	CString str;
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM newbook WHERE bookname='" + cDepId+"'";
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		Cnewbook();
	else
	{
		bookname = cDepId;
		bussname = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("bussname");
		shumu = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("shumu");
		time = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("tim");
		str= (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("leixing");
		leixing=atoi(str);
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}