jlself.cpp

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

// JLSelf.cpp: implementation of the CJLSelf class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CJLSelf::CJLSelf()
{
	Stu_id = 0;
	JianLi = " ";

}

CJLSelf::~CJLSelf()
{

}

int CJLSelf::GetStu_id()
{
	return Stu_id;
}
void CJLSelf::SetStu_id(int iStu_id)
{
	Stu_id = iStu_id;
}

CString CJLSelf::GetJianLi()
{
	return JianLi;
}
void CJLSelf::SetJianLi(CString cJianLi)
{
	JianLi = cJianLi;
}

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

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

	_bstr_t vSQL;
	vSQL = "INSERT INTO JLSelf VALUES('" + cStuid + "','" + JianLi + "')";	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

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

	_bstr_t vSQL;
	vSQL = "UPDATE JLSelf SET JianLi ='" + JianLi + "' WHERE Stu_id ='" + cEmpId + "'";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

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

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CJLSelf();
	else
	{
		Stu_id = atoi(cEmpId);
		JianLi = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("JianLi");
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}