book.cpp

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

// book.cpp: implementation of the Cbook class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "图书管理.h"
#include "book.h"
#include "ADOConn.h"
#include"bookedit.h"
#include"borrow.h"
#include"selbook9.h"

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

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

Cbook::Cbook()
{
	bookno="";
	bookname="";
	publish="";
	weizi="";
	writer="";

}

Cbook::~Cbook()
{

}




//读取和设置成员变量
CString Cbook::Getbookno()
{
	return bookno;
}
void Cbook::Setbookno(CString no)
{
	bookno=no;
}
void Cbook::Setbookname(CString name)
{
	bookname=name;
}

CString Cbook::Getbookname()
{
	return bookname;
}
CString Cbook::Getpublish()
{
	return publish;
}
void Cbook::Setpublish( CString str)
{
	publish=str;
}

CString Cbook::Getwriter()
{
	return writer;
}
void Cbook::Setwriter(CString str)
{
	writer=str;
}
CString Cbook::Getweizi()
{
	return weizi;
}
void Cbook::Setweizi(CString str)
{
	weizi=str;
}
CString Cbook::Setleixing()
{
	return leixing;
}
void Cbook::Getleixing(CString str)
{
	leixing=str;
}


//数据库操作
int Cbook::HaveName(CString str)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM book 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 Cbook::Haveno(CString str)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM book WHERE bookno='" + str+"' ";
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
void Cbook::sql_insert()
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
//	CString strUpperId;
//	strUpperId.Format("%d", UpperId);

	_bstr_t vSQL;
	vSQL = "INSERT INTO book (bookno ,bookname, writer, publish,leixing,weizi) VALUES('"
		+ bookno + "','" + bookname + "','" + writer + "','" +publish+"','"+ leixing+"','"+ weizi +"')";	
	//执行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 Cbook::sql_update(CString bookno)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置UPDATE语句
   
  

	_bstr_t vSQL;
	vSQL = "UPDATE book SET bookname='" + bookname+ "',writer='" + writer + "',publish='" +publish+"',leixing='"+ leixing+"'";
    vSQL= vSQL+",weizi='"+ weizi +"'WHERE bookno='" + bookno+"'";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void Cbook::sql_delete(CString cDepId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM book WHERE bookno='" + cDepId+"'";
	//执行DELETE语句
	Cborrow b;
	CString str="";
	b.sql_delete(cDepId,str);
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}

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

	//返回各列的值
	if (m_pRecordset->adoEOF)
		Cbook();
	else
	{
		bookno = cDepId;
		bookname = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("bookname");
		writer = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("writer");
		publish = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("pubish");
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
void Cbook::sql_select(CString cDepId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM book WHERE bookno='" + cDepId+"'";
	//执行DELETE语句
    //m_AdoConn.ExecuteSQL(vSQL);	
	CString csql="jun";
	selbook9 b;
    csql+="jun";
	b.m_adoc.SetRecordSource(vSQL);
	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}