read1.cpp

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

// read1.cpp: implementation of the Cread class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "图书管理.h"
#include "read1.h"
#include"ADOConn.h"
#include"borrow.h"
#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

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

Cread::Cread()
{
readno="";
readname="";
readsex="";
readadd="";
}

Cread::~Cread()
{

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

	_bstr_t vSQL;
	vSQL = "INSERT INTO reader (readno ,readname, readsex, readadd) VALUES('"
		+ readno + "','" + readname + "','" + readsex + "','" +readadd+"')";	
	//执行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 Cread::sql_update(CString str)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置UPDATE语句



	_bstr_t vSQL;
	vSQL = "UPDATE reader SET readname='" + readname+ "',readsex='" + readsex + "',readadd='" +readadd+"'where readno='"+str+"'";
    
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

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

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

	//返回各列的值
	if (m_pRecordset->adoEOF)
		Cread();
	else
	{
	    readno = cDepId;
		readname = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("readname");
		readsex = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("readsex");
		readadd= (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("readadd");
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}