student.cpp

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

// Student.cpp: implementation of the CStudent class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CStudent::CStudent()
{
	Stu_Id = 0;
	Stu_Name = "";
	Yard_Name = "";
	Dep_Name = "";
	Sep_Name = "";
	Base_Mat = "";
	Fam_Men = "";
	Work_Exp = "";
	Rew_Rec = "";
	Title_Exp = "";
	Train_Exp = "";
	Per_Res = "";
}

CStudent::~CStudent()
{

}

int CStudent::getStu_Id()
{
	return Stu_Id;
}

void CStudent::setStu_Id(int vStu_Id)
{
	Stu_Id = vStu_Id;
}

CString CStudent::getStu_Name()
{
	return Stu_Name;
}

void CStudent::setStu_Name(CString vStu_Name)
{
	Stu_Name = vStu_Name;
}

CString CStudent::getYard_Name()
{
	return Yard_Name;
}

void CStudent::setYard_Name(CString vYard_Name)
{
	Yard_Name = vYard_Name;
}

CString CStudent::getDep_Name()
{
	return Dep_Name;
}

void CStudent::setDep_Name(CString vDep_Name)
{
	Dep_Name = vDep_Name;
}

CString CStudent::getSep_Name()
{
	return Sep_Name;
}

void CStudent::setSep_Name(CString vSep_Name)
{
	Sep_Name = vSep_Name;
}

CString CStudent::getBase_Mat()
{
	return Base_Mat;
}

void CStudent::setBase_Mat(CString vBase_Mat)
{
	Base_Mat = vBase_Mat;
}

CString CStudent::getFam_Men()
{
	return Fam_Men;
}

void CStudent::setFam_Men(CString vFam_Men)
{
	Fam_Men = vFam_Men;
}

CString CStudent::getWork_Exp()
{
	return Work_Exp;
}

void CStudent::setWork_Exp(CString vWork_Exp)
{
	Work_Exp = vWork_Exp;
}

CString CStudent::getRew_Rec()
{
	return Rew_Rec;
}

void CStudent::setRew_Rec(CString vRew_Rec)
{
	Rew_Rec = vRew_Rec;
}

CString CStudent::getTitle_Exp()
{
	return Title_Exp;
}

void CStudent::setTitle_Exp(CString vTitle_Exp)
{
	Title_Exp = vTitle_Exp;
}

CString CStudent::getTrain_Exp()
{
	return Train_Exp;
}

void CStudent::setTrain_Exp(CString vTrain_Exp)
{
	Train_Exp = vTrain_Exp;
}

CString CStudent::getPer_Res()
{
	return Per_Res;
}

void CStudent::setPer_Res(CString vPer_Res)
{
	Per_Res = vPer_Res;
}

void CStudent::sql_delete(CString cEmpId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Students WHERE Stu_id='" + cEmpId	+ "'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();


}

void CStudent::sql_insert()
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	CString cStu_id;
	cStu_id.Format("%d", Stu_Id);

	_bstr_t vSQL;
	vSQL = "INSERT INTO Students VALUES("+cStu_id+",'" + Yard_Name + "','" + Dep_Name + "','" 
		+ Sep_Name + "','"+Base_Mat+"','"+Fam_Men+"','"+Work_Exp+"','"+Rew_Rec+"','"+Title_Exp+"','"+Train_Exp+"','"+Per_Res+"','"+Stu_Name+"')";	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();


}

void CStudent::sql_update(CString cEmpId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置UPDATE语句
	CString cStu_id;
	cStu_id.Format("%d", Stu_Id);

	_bstr_t vSQL;
	vSQL = "UPDATE Students SET Sch_id=" + cStu_id + ",Yard_name='"+Yard_Name+"',Dep_name='"+Dep_Name+"',Sep_name='"+Sep_Name+"',Base_Mat='"+Base_Mat+"',Fam_Men='"+Fam_Men+"',Work_Exp='"+Work_Exp+"',Rew_Rec='"+Rew_Rec+"',Title_Exp='"+Title_Exp+"',Train_Exp='"+Train_Exp+"',Per_Res='"+Per_Res+"',Stu_Name = '"+Stu_Name+"' WHERE Sch_id='" + cEmpId + "'";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}

void CStudent::GetData(CString cEmpId)
{

	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Students WHERE Sch_id='" + cEmpId + "'";
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CStudent();
	else
	{
		Stu_Id = atoi(cEmpId);	
        Yard_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Yard_name");
		Dep_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Dep_name");
		Sep_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sep_name");
		Base_Mat = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Base_Mat");
        Fam_Men = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Fam_Men");
        Work_Exp = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Work_Exp");
        Rew_Rec = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Rew_Rec");
		Title_Exp = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Title_Exp");
		Train_Exp = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Train_Exp");
		Per_Res = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Per_Res");
		Stu_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Stu_Name");
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();


}