base_imfo.cpp

一个简单的学生成绩管理系统,在VC和SQL 2000下测试成功,(里面有数据库备份文件,直接还原即可,还原数据库后可以在USERS表里找到帐号和密码.

// Base_Imfo.cpp: implementation of the CBase_Imfo class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "student.h"
#include "Base_Imfo.h"
#include "ADOConn.h"

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

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

CBase_Imfo::CBase_Imfo()
{
	Stu_Id=0;
	BadgeID="";
	Stu_Name="";
	Sex="";
	Birth="";
	Major="";

}

CBase_Imfo::~CBase_Imfo()
{
	
}

int CBase_Imfo::GetStu_Id()
{
	return Stu_Id;
}

void CBase_Imfo::SetStu_Id(int iStu_Id)
{
	Stu_Id=iStu_Id;
}

CString CBase_Imfo::GetBadgeID()
{
	return BadgeID;
}

void CBase_Imfo::SetBadgeID(CString CBadgeID)
{
	BadgeID=CBadgeID;
}

CString CBase_Imfo::GetStu_Name()
{
	return Stu_Name;
}

void CBase_Imfo::SetStu_Name(CString CStu_Name)
{
	Stu_Name=CStu_Name;
}
	
CString CBase_Imfo::GetSex()
{
	return Sex;
}

void CBase_Imfo::SetSex(CString CSex)
{
	Sex=CSex;
}

CString CBase_Imfo::GetBirth()
{
	return Birth;
}

void CBase_Imfo::SetBirth(CString CBirth)
{
	Birth=CBirth;
}

CString CBase_Imfo::GetMajor()
{
	return Major;
}

void CBase_Imfo::SetMajor(CString CMajor)
{
	Major=CMajor;
}

//数据库操作
int CBase_Imfo::HaveBadgeID(CString cBadgeID) //判断指定的学生学号是否存在
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Base_Imfo WHERE BadgeID='" + cBadgeID + "'";
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

CString CBase_Imfo::GetBadgeID(CString cStu_Id)  //根据指定的学生编号返回学生学号
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT BadgeID FROM Base_Imfo WHERE Stu_Id=" + cStu_Id;
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return "";
	else
		return (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BadgeID");

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

void CBase_Imfo::sql_insert()
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	
	_bstr_t vSQL;
	vSQL = "INSERT INTO Base_Imfo (BadgeID, Stu_Name, Sex, Birth, Major) VALUES('"
		+BadgeID+"','"+Stu_Name+"','"+Sex+"','"+Birth+"','"+Major+"')";
	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
void CBase_Imfo::sql_update(CString cStu_Id)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置UPDATE语句
	_bstr_t vSQL;
	vSQL = "UPDATE Base_Imfo SET BadgeID='"+BadgeID+"',Stu_Name='"
		+Stu_Name+"',Sex='"+Sex+"',Birth='"+Birth+"',Major='"
		+Major+"' WHERE Stu_Id=" + cStu_Id;
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
void CBase_Imfo::sql_delete(CString CStu_Id)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Base_Imfo WHERE Stu_Id=" + CStu_Id;
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
//根据学生编号读取所有字段值
void CBase_Imfo::GetData(CString cStu_Id)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Base_Imfo WHERE Emp_id=" + cStu_Id;
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF == 1)
		CBase_Imfo;
	else
	{
		Stu_Id = atoi(cStu_Id);
		BadgeID = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BadgeID");
		Stu_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Stu_Name");
		Sex = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sex");
		Birth = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Birth");
		Major = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Dep_id");
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}