title_exp.cpp

毕业生信息管理系统的基本功能是对毕业生的信息进行管理

// Title_Exp.cpp: implementation of the CTitle_Exp class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "BySys.h"
#include "Title_Exp.h"
#include "ADOConn.h"

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

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

CTitle_Exp::CTitle_Exp()
{
	Stu_Name = "";
	Tec_Qua = "";
	Get_Met = "";
	Get_Data = "";
	Fire_Spe = "";
	Fire_Sta = "";
	Fire_End = "";
	Fire_Whe = "";
	xuehao = "";
}

CTitle_Exp::~CTitle_Exp()
{

}

CString CTitle_Exp::GetStu_Name()
{
	return Stu_Name;
}

void CTitle_Exp::SetStu_Name(CString cStu_Name)
{
	Stu_Name=cStu_Name;
}

CString CTitle_Exp::getTec_Qua()
{
	return Tec_Qua;
}

void CTitle_Exp::setTec_Qua(CString vTec_Qua)
{
	Tec_Qua = vTec_Qua;
}

CString CTitle_Exp::getGet_Met()
{
	return Get_Met;
}

void CTitle_Exp::setGet_Met(CString vGet_Met)
{
	Get_Met = vGet_Met;
}

CString CTitle_Exp::getGet_Data()
{
	return Get_Data;
}

void CTitle_Exp::setGet_Data(CString vGet_Data)
{
	Get_Data = vGet_Data;
}

CString CTitle_Exp::getFire_Spe()
{
	return Fire_Spe;
}

void CTitle_Exp::setFire_Spe(CString vFire_Spe)
{
	Fire_Spe = vFire_Spe;
}

CString CTitle_Exp::getFire_Sta()
{
	return Fire_Sta;
}

void CTitle_Exp::setFire_Sta(CString vFire_Sta)
{
	Fire_Sta = vFire_Sta;
}

CString CTitle_Exp::getFire_End()
{
	return Fire_End;
}

void CTitle_Exp::setFire_End(CString vFire_End)
{
	Fire_End = vFire_End;
}

CString CTitle_Exp::getFire_Whe()
{
	return Fire_Whe;
}

void CTitle_Exp::setFire_Whe(CString vFire_Whe)
{
	Fire_Whe = vFire_Whe;
}

CString CTitle_Exp::getXuehao()
{
	return xuehao ;
}
void CTitle_Exp::setXuehao(CString cXuehao)
{
	xuehao = cXuehao;
}
void CTitle_Exp::sql_delete(CString cEmpId)
{
		//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Title_Exp WHERE xuehao ='" + cEmpId	+ "'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CTitle_Exp::sql_insert()
{
		//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句

	_bstr_t vSQL;
	vSQL = "INSERT INTO Title_Exp VALUES('"+Stu_Name+"','" + Tec_Qua + "','" + Get_Met + "','" 
		+ Get_Data + "','"+Fire_Spe+"','"+Fire_Sta+"','"+Fire_End+"','"+Fire_Whe+"','"+xuehao+"')";	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();


}

void CTitle_Exp::sql_update(CString cEmpId)
{
		//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置UPDATE语句

	_bstr_t vSQL;
	vSQL = "UPDATE Title_Exp SET Tec_Qua='"+Tec_Qua+"',Get_Met='"+Get_Met+"',Get_Data='"+Get_Data+"',Fire_Spe='"+Fire_Spe+"',Fire_Sta='"+Fire_Sta+"',Fire_End='"+Fire_End+"',Fire_Whe='"+Fire_Whe+"' WHERE xuehao ='" + cEmpId + "'";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CTitle_Exp::GetData(CString cEmpId)
{
		//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Title_Exp WHERE Stu_Name='" + cEmpId + "'";
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CTitle_Exp();
	else
	{
		Stu_Name = cEmpId;	
        Tec_Qua = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Tec_Qua");
		Get_Met = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Get_Met");
		Get_Data = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Get_Data");
		Fire_Spe = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Fire_Spe");
        Fire_Sta = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Fire_Sta");
        Fire_End = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Fire_End ");
        Fire_Whe = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Fire_Whe");
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();


}