student.cpp

VC++做的学校收费管理系统,很有参考价值,附上源码与说明文档.

// Student.cpp: implementation of the CStudent class.
//
// 1 StuId int 学生编号 Identity = Yes Allow Null = False 主键
// 2 Name varchar(50) 姓名 Allow Null = False
// 3 Sex char(2) 性别 Allow Null = True
// 4 DepId int 所在院系编号 Allow Null = False
//
// 5 SpeId int 专业编号 Allow Null = False
// 6 ClassName varchar(20) 班级名称 Allow Null = True
// 7 iYear int 入学年度 Allow Null = True
// 8 IdCard varchar(20) 身份证号 Allow Null = True
//
// 9 ZhuSu char(2) 是否住宿 Allow Null = False
// 10 CunChe char(2) 是否存车 Allow Null = False
// 11 PinKun char(2) 是否贫困生 Allow Null = False
// 12 TeKun char(2) 是否特困生 Allow Null = False

// 13 FillinPerson varchar(30) 填表用户 Allow Null = False
// 14 FillinTime varchar(20) 填表日期和时间 Allow Null = False
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "ChargeManage.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()
{
	StuId = 0;
	Name = "";
	Sex = "";
	DepId = 0;
	
	SpeId = 0;
	ClassName = "";
	iYear = 2006;
	IdCard = "";
	
	ZhuSu = "是";
	CunChe = "是";
	PinKun = "否";
	TeKun = "否";

	FillinPerson = "";
	FillinTime = "";
}

CStudent::~CStudent()
{

}

// 根据学生编号得到其他信息
void CStudent::GetInfo(CString paraId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Student WHERE StuId = " + paraId;

	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CStudent();
	else
	{
		StuId = atol(paraId);
		Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Name");
		Sex = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sex");
		DepId = atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("DepId"));

		SpeId = atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("SpeId"));
		ClassName = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ClassName");
		iYear = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("iYear"));
		IdCard = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("IdCard");

		ZhuSu = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ZhuSu");
		CunChe = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("CunChe");
		PinKun = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PinKun");
		TeKun = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("TeKun");

		FillinPerson = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("FillinPerson");
		FillinTime = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("FillinTime");
	}

	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

//读取指定学生姓名
CString CStudent::GetName(CString paraId)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT Name FROM Student WHERE StuId = " + paraId;

	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return "";
	else
		return (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Name");

	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

// 插入操作
void CStudent::SqlInsert()
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	//设置INSERT语句
	CString strDepId;
	strDepId.Format("%ld", DepId);
	CString strSpeId;
	strSpeId.Format("%ld", SpeId);
	CString cYear;
	cYear.Format("%d", iYear);
	_bstr_t vSQL;
	vSQL = "INSERT INTO Student (Name, Sex, DepId, SpeId, ClassName, iYear,"
		" IdCard,  ZhuSu, CunChe, PinKun, TeKun,  FillinPerson, FillinTime)"
		" VALUES ('" + Name + "', '" + Sex + "', " + strDepId + ", " + strSpeId + ", '" + ClassName
		+ "', " + cYear + ", '"+ IdCard + "','" + ZhuSu + "', '" + CunChe + "', '" + PinKun + "', '" + TeKun
		+ "', '" + FillinPerson + "', '" + FillinTime + "')";

	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	

	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

// 修改操作
void CStudent::SqlUpdate(CString paraId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	//设置UPDATE语句
	CString cYear;
	cYear.Format("%d", iYear);
	_bstr_t vSQL;
	vSQL = "UPDATE Student SET Name = '" + Name + "', Sex = '" + Sex
		+ "', ClassName = '" + ClassName + "',iYear = " + cYear 
		+ ", IdCard = '" + IdCard+ "', ZhuSu = '" + ZhuSu
		+ "', CunChe = '" + CunChe + "', PinKun = '" + PinKun
		+ "', TeKun = '" + TeKun + "', FillinPerson = '" + FillinPerson 
		+ "', FillinTime = '" + FillinTime
		+ "' WHERE StuId = " + paraId;

	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);

	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

// 删除指定学生信息
void CStudent::SqlDelete(CString paraId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Student WHERE StuId = " + paraId;

	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	

	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}