📄 base_mat.cpp

📁 毕业生信息管理系统的基本功能是对毕业生的信息进行管理
💻 CPP
字号:
// Base_Mat.cpp: implementation of the CBase_Mat class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CBase_Mat::CBase_Mat()
{
       Stu_id=0;
	   Stu_Name="";
	   Stu_Nat="";
       Birthday="";
       Age=0;
       Education="";
       Mat_Sta="";
       Sex=""; 
       Pol_Lan="";
       Ide_Num="";
       Origin="";
       Stu_Type="";
       Sep="";
       For_Lan="";
       Lan_Lev="";
       Com_Cla="";
       Post ="";
       Other_Exp="";
       Emp_Whe="";
       Emp_Req="";
       Telephone="";
       MoblieP="";
       E_Mail="";
       Post_Add="";
       Postal="";
       Gra_Sch="";
       Gra_Time="";
       Address="";
}

CBase_Mat::~CBase_Mat()
{

}

int CBase_Mat::GetStu_id()
{
	return Stu_id;
}
void CBase_Mat::SetStu_id(int vStu_id)
{
	Stu_id=vStu_id;
}
CString CBase_Mat::GetStu_Name()
{
	return Stu_Name;
}
void CBase_Mat::SetStu_Name(CString vStu_Name)
{
	Stu_Name=vStu_Name;
}
CString CBase_Mat::GetStu_Nat()
{
	return Stu_Nat;
}
void CBase_Mat::SetStu_Nat(CString vStu_Nat)
{
	Stu_Nat=vStu_Nat;
}
CString CBase_Mat::Get_Birthday()
{
	return Birthday;
}
void CBase_Mat::SetBirthday(CString vBirthday)
{
	Birthday=vBirthday;
}
int CBase_Mat::GetAge()
{
	return Age;
}
void CBase_Mat::SetAge(int vAge)
{
	Age=vAge;
}
CString CBase_Mat::GetEducation()
{
	return Education;
}
void CBase_Mat::SetEducation(CString vEducation)
{
	Education=vEducation;
}
CString CBase_Mat::GetMat_Sta()
{
	return Mat_Sta;
}
void CBase_Mat::SetMat_Sta(CString vMat_Sta)
{
	Mat_Sta=vMat_Sta;
}
CString CBase_Mat::GetSex()
{
	return Sex;
}
void CBase_Mat::SetSex(CString vSex)
{
	Sex=vSex;
}
CString CBase_Mat::GetPol_Lan()
{
	return Pol_Lan;
}
void CBase_Mat::SetPol_Lan(CString vPolLan)
{
	Pol_Lan=vPolLan;
}
CString CBase_Mat::GetIde_Num()
{
	return Ide_Num;
}
void CBase_Mat::SetIde_Num(CString vIdeNum)
{
	Ide_Num=vIdeNum;
}
CString CBase_Mat::GetOrigin()
{
	return Origin;
}
void CBase_Mat::SetOrigin(CString vOrigin)
{
	Origin=vOrigin;
}
CString CBase_Mat::GetStu_Type()
{
	return Stu_Type;
}
void CBase_Mat::SetStu_Type(CString vStu_Type)
{
	Stu_Type=vStu_Type;
}
CString CBase_Mat::GetSep()
{
	return Sep;
}
void CBase_Mat::SetSep(CString vSep)
{
	Sep=vSep;
}
CString CBase_Mat::GetFor_Lan()
{
	return For_Lan;
}
void CBase_Mat::SetFor_Lan(CString vFor_Lan)
{
	For_Lan=vFor_Lan;
}
CString CBase_Mat::GetLan_Lev()
{
	return Lan_Lev;
}
void CBase_Mat::SetLan_Lev(CString vLan_Lev)
{
	Lan_Lev=vLan_Lev;
}
CString CBase_Mat::GetCom_Cla()
{
	return Com_Cla;
}
void CBase_Mat::SetCom_Cla(CString vCom_Cla)
{
	Com_Cla=vCom_Cla;
}
CString CBase_Mat::GetPost()
{
	return Post;
}
void CBase_Mat::SetPost(CString vPost)
{
	Post=vPost;
}
CString CBase_Mat::GetOther_Exp()
{
	return Other_Exp;
}
void CBase_Mat::SetOther_Exp(CString vOther_Exp)
{
	Other_Exp=vOther_Exp;
}
CString CBase_Mat::GetEmp_Whe()
{
	return Emp_Whe;
}
void CBase_Mat::SetEmp_Whe(CString vEmp_Whe)
{
	Emp_Whe = vEmp_Whe;
}
CString CBase_Mat::GetEmp_Req()
{
	return Emp_Req;
}
void CBase_Mat::SetEmp_Req(CString vEmp_Req)
{
	Emp_Req = vEmp_Req;
}
CString CBase_Mat::GetTelephone()
{
	return Telephone;
}
void CBase_Mat::SetTelephone(CString vTelephone)
{
	Telephone = vTelephone;
}
CString CBase_Mat::GetMoblieP()
{
	return MoblieP;
}
void CBase_Mat::SetMoblieP(CString vMoblieP)
{
	MoblieP = vMoblieP;
}
CString CBase_Mat::GetE_Mail()
{
	return E_Mail;
}
void CBase_Mat::SetE_Mail(CString vE_Mail)
{
	E_Mail = vE_Mail;
}
CString CBase_Mat::GetPost_Add()
{
	return Post_Add;
}

void CBase_Mat::SetPost_Add(CString vPost_Add)
{
	Post_Add = vPost_Add;
}
CString CBase_Mat::GetPostal()
{
	return Postal;
}
void CBase_Mat::SetPostal(CString vPostal)
{
	Postal = vPostal;
}
CString CBase_Mat::GetGra_Sch()
{
	return Gra_Sch;
}
void CBase_Mat::SetGra_Sch(CString vGra_Sch)
{
	Gra_Sch = vGra_Sch;
}
CString CBase_Mat::GetGra_Time()
{
	return Gra_Time;
}
void CBase_Mat::SetGra_Time(CString vGra_Time)
{
	Gra_Time = vGra_Time;
}
CString CBase_Mat::GetAddress()
{
	return Address;
}
void CBase_Mat::SetAddress(CString vAddress)
{
	Address = vAddress;
}

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

}

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

	_bstr_t vSQL;
	vSQL = "INSERT INTO Base_Mat VALUES(" + cStu_id + ",'"+Stu_Name+"','"+Stu_Nat+"','"+Birthday+"',"+cAge+",'"+Education+"','"+Mat_Sta+"','"+Sex+"','"+Pol_Lan+"','"+Ide_Num+"','"+Origin+"','"+Stu_Type+"','"+Sep+"','"+For_Lan+"','"+Lan_Lev+"','"+Com_Cla+"','"+Post+"','"+Other_Exp+"','"+Emp_Whe+"','"+Emp_Req+"','"+Telephone+"','"+MoblieP+"','"+E_Mail+"','"+Post_Add+"','"+Postal+"','"+Gra_Sch+"','"+Gra_Time+"','"+Address+"')";	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();


}

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

	_bstr_t vSQL;
	vSQL = "UPDATE Base_Mat SET Stu_id="+cStu_id+",Stu_Name='"+Stu_Name+"',Stu_Nat='"+Stu_Nat+"',Birthday='"+Birthday+"',Age="+cAge+",Education='"+Education+"',Mar_Sta='"+Mat_Sta+"',Sex='"+Sex+"',Pol_lan='"+Pol_Lan+"',Ide_Num='"+Ide_Num+"',Origin='"+Origin+"',Stu_Type='"+Stu_Type+"',Sep='"+Sep+"',For_lan='"+For_Lan+"',Lan_Lev='"+Lan_Lev+"',Com_Cla='"+Com_Cla+"',Post='"+Post+"',Other_Exp='"+Other_Exp+"',Emp_Whe='"+Emp_Whe+"',Emp_Req='"+Emp_Req+"',Telephone='"+Telephone+"',MoblieP='"+MoblieP+"',E_Mail='"+E_Mail+"',Post_Add='"+Post_Add+"',Postal='"+Postal+"',Gra_Sch='"+Gra_Sch+"',Gra_Time='"+Gra_Time+"',Address='"+Address+"' WHERE Stu_id='" + cEmpId + "'";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}

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

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CBase_Mat();
	else
	{
		Stu_id = atoi(cEmpId);
		Stu_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Stu_Name");
        Stu_Nat = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Stu_Nat");
		Birthday = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Birthday");
		Age = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Age"));
		Education = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Education");
        Mat_Sta = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Mar_Sta");
        Sex = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sex");
        Pol_Lan = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Pol_lan");
		Ide_Num = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Ide_Num");
		Origin = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Origin");
		Stu_Type = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Stu_Type");
		Sep = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sep");
		For_Lan = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("For_lan");
		Lan_Lev = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Lan_Lev");
		Com_Cla = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Com_Cla");
		Post = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Post");
		Other_Exp = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Other_Exp");
		Emp_Whe = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Emp_Whe");
		Emp_Req = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Emp_Req");
		Telephone = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Telephone");
		MoblieP = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("MoblieP");
		E_Mail = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("E_Mail");
		Post_Add = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Post_Add");
		Postal = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Postal");
		Gra_Sch = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Gra_Sch");
		Gra_Time = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Gra_Time");
		Address = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Address");
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -