database.cpp

由我为校教务处自主开发的竞赛计分软件。 该软件由“比赛信息管理”、“裁判信息管理”、“选手信息管理”、“比赛计分排序”等几个模块组成。基于MFC技术

#include "StdAfx.h"
#include "database.h"

database::database(void)
{
	
}

database::~database(void)
{
}
_RecordsetPtr database::getrs()
{
	return rs;
}

 void database::datasearcher(CString tsql){

	try{
	rs.CreateInstance(__uuidof(Recordset));
	rs->Open((_variant_t)tsql, conn->GetConnectionString(),adOpenDynamic, adLockOptimistic,adCmdText);
}
catch(_com_error e)///捕捉异常
{
	conn->Close();
	rs=NULL;
	CString errormessage;
	errormessage.Format("读取数据库失败!\r\n错误信息:%s",e.ErrorMessage());
	AfxMessageBox(errormessage);///显示错误信息
	exit(1);
} 
}

 void database::datasearcher(){
	try{
	rs.CreateInstance(__uuidof(Recordset));
	CString sql="select * from saishi";
	rs->Open((_variant_t)sql, conn->GetConnectionString(),adOpenDynamic, adLockOptimistic,adCmdText);
}
catch(_com_error e)///捕捉异常
{
	conn->Close();
	rs=NULL;
CString errormessage;
errormessage.Format("读取数据库失败!\r\n错误信息:%s",e.ErrorMessage());
AfxMessageBox(errormessage);///显示错误信息
exit(1);
} 
}
 void database::databaseconn(){

	try
{

conn.CreateInstance(__uuidof( Connection));//创建Connection对象
CString data="database\\database.mdb";
CString tdatapath=CbyWSDlg::datapath+data;
conn->Open(_bstr_t(tdatapath),"","",NULL);///连接数据库

}
catch(_com_error e)///捕捉异常
{
	conn=NULL;
	CString errormessage;
	errormessage.Format("连接数据库失败!\r\n请检查数据库路径\n");
	AfxMessageBox(errormessage);///显示错误信息
	exit(1);
} 

}
 void database::databaseclose(){
	 try{
	 conn->Close();
	rs->Close();
	conn=NULL;
	rs=NULL;
	 }
	 catch(_com_error e)///捕捉异常
{
	
} 
}

long database::getrscount(CString tsql){
	
	try{
	rscount.CreateInstance(__uuidof(Recordset));
	rscount->Open((_variant_t)tsql, conn->GetConnectionString(),adOpenDynamic, adLockOptimistic,adCmdText);
	long trscount=0;
	while(!rscount->adoeof){
		trscount++;
		rscount->MoveNext();
	}
	rscount->Close();
	return trscount;
	}
catch(_com_error e)///捕捉异常
{
	conn->Close();
	rscount=NULL;
	CString errormessage;
	errormessage.Format("读取数据总数失败!\r\n错误信息:%s",e.ErrorMessage());
	AfxMessageBox(errormessage);///显示错误信息
	
} 
 }

void database::datadelete(CString tslq){

}