grade.cpp

C++应用编程20例,各种小程序原代码都有

// Grade.cpp: implementation of the CGrade class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Classsystem.h"
#include "Grade.h"
#include "ADOConn.h"
//#include "_recordset.h"
#include "Users.h"


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

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

CGrade::CGrade()
{
	grade=0;
	course="";
	xuehao="";

}

int CGrade::getgrade()
{
	return grade;
}
void CGrade::setgrade(int cgrade)
{
	grade=cgrade;
}
CString CGrade::getcourse()
{
	return course;
}
void CGrade::setcourse(CString ccourse)
{
	course=ccourse;
}
CString CGrade::getxuehao()
{
	return xuehao;
}
void CGrade::setxuehao(CString cxuehao)
{
	xuehao=cxuehao;
}
void CGrade::g_insert()
{
	ADOConn m_adoconn;
	m_adoconn.OnInitADOConn();
	CString strgrade;
	strgrade.Format("%d",grade);
	_bstr_t vsql;
	vsql="insert into xs_kc(学号,课程号,成绩)values('"+xuehao+"','";
	vsql= vsql + course + "','" ;
	vsql= vsql + strgrade + "')";
	m_adoconn.ExecuteSQL(vsql);
	m_adoconn.ExitConnect();
}
void CGrade::g_update(CString cxuehao,CString ccourse)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString strgrade;
	strgrade.Format("%d",grade);
	//设置UPDATE语句
	_bstr_t vSQL;
	vSQL = "UPDATE xs_kc SET 成绩='";
	vSQL=vSQL+ strgrade ;
	vSQL= vSQL + "' WHERE 学号= '"+ cxuehao ;
	vSQL= vSQL + "' and 课程号='"+ ccourse +"'" ;
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CGrade::g_delete(CString cxuehao,CString ccourse)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM xs_kc WHERE 学号=" + cxuehao+" and 课程号='" + ccourse + "'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

//根据员工编号读取所有字段值
void CGrade::getdata(CString cxuehao,CString ccourse)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM xs_kc WHERE 学号=" + cxuehao + " and 课程号='" + ccourse +"'";
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF == 1)
		CGrade();
	else
	{
		xuehao = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("学号");
		course = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("课程号");
		grade = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("成绩"));
	//	date = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("date");
	//	home = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("home");
	//	Dep_id = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Dep_id"));
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
CGrade::~CGrade()
{

}