fam_mem.cpp

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

// Fam_Mem.cpp: implementation of the CFam_Mem class.
//
//////////////////////////////////////////////////////////////////////

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

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

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


CFam_Mem::CFam_Mem()
{
	Stu_id = 0;
	Mem_Name = "";
	Relation = "";
	Birthday = "";
	Work_Place = "";
	Post = "";
	Pol_Lan = "";
	Telephone = "";
	xuehao = "" ;
}

CFam_Mem::~CFam_Mem()
{

}

int CFam_Mem::GetStu_id()
{
	return Stu_id;
}

void CFam_Mem::SetStu_id(int iStu_id)
{
	Stu_id = iStu_id;
}

CString CFam_Mem::getMem_Name()
{
	return Mem_Name;
}
void CFam_Mem::setMem_Name(CString vMem_Name)
{
	Mem_Name =  vMem_Name;
}
CString CFam_Mem::getRelation()
{
	return Relation;
}
void CFam_Mem::setRelation(CString vRelation)
{
	Relation = vRelation;
}
CString CFam_Mem::getBirthday()
{
	return Birthday;
}
void CFam_Mem::setBirthday(CString vBirthday)
{
	Birthday = vBirthday;
}
CString CFam_Mem::getWork_Place()
{
	return Work_Place;
}
void CFam_Mem::setWork_Place(CString vWork_Place)
{
	Work_Place = vWork_Place;
}
CString CFam_Mem::getPost()
{
	return Post;
}
void CFam_Mem::setPost(CString vPost)
{
	Post = vPost;
}
CString CFam_Mem::getPol_Lan()
{
	return Pol_Lan;
}
void CFam_Mem::setPol_Lan(CString vPol_Lan)
{
	Pol_Lan = vPol_Lan;
}
CString CFam_Mem::getTelephone()
{
	return Telephone;
}
void CFam_Mem::setTelephone(CString vTelephone)
{
	Telephone = vTelephone;
}
CString CFam_Mem::getXuehao()
{
	return xuehao ;
}
void CFam_Mem::setXuehao(CString cXuehao)
{
	xuehao = cXuehao;
}
		 
void CFam_Mem::sql_delete(CString cEmpId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Fam_Men WHERE xuehao ='" + cEmpId	+ "'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();


}

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

	_bstr_t vSQL;
	vSQL = "INSERT INTO Fam_Men VALUES("+cStu_id+",'" + Mem_Name + "','" + Relation + "','" 
		+ Birthday + "','"+Work_Place+"','"+Post+"','"+Pol_Lan+"','"+Telephone+"','"+xuehao+"')";	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}

void CFam_Mem::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 Fam_Men SET Mem_Name ='"+Mem_Name+"',Relation='"+Relation+"',Birthday='"+Birthday+"',Work_place='"+Work_Place+"',Post='"+Post+"',Pol_lan='"+Pol_Lan+"',Telephone='"+Telephone+"' WHERE xuehao ='" + cEmpId + "' and Mem_Name ='"+Mem_Name+"'";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}

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

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CFam_Mem();
	else
	{
		Stu_id = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Stu_id"));
        Mem_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Mem_Name");
		Relation = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Relation");
		Birthday = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Birthday");
		Work_Place = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Work_place");
        Post = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Post");
		Pol_Lan = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Pol_lan");
		Telephone = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Telephone");
		xuehao = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("xuehao");
        
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}