globalvarfunc.cpp

具有添加,删除,修改,更新的功能,用ado读ini文件访问数据库

#include "stdafx.h"
#include <io.h>
#include "GlobalVarFunc.h"

#include "ado.h"


//数据库相关变量
char gServerName[128];
char gDataBaseName[128];
char gUserName[128];
char gPassWD[128];


CADODatabase *gpDataBase;
bool         gDBConnected;
COleDateTime gDBConnTime;		// 数据连接成功时间
CADORecordset *pRs;
//程序路径
char gAppPath[MAX_PATH];
char gINIFullFileName[MAX_PATH];

////////////////////////////////////////////////////////////////////////////////

void InitGlobalVar()
{

	gpDataBase    = NULL;
	gDBConnected  = false;


	SetAllPathAndINIFileName();
	ReadINIFile();

}

void FreeGlobalVar()
{
	if(gpDataBase!= NULL)
	{
		gpDataBase->Close();
		delete gpDataBase;
		gpDataBase = NULL;
	}
}


/////////////////////////////////////////////////////////////////
//=============   INI 文件配置部分函数 ========================//
void SetAllPathAndINIFileName()
{	CString tmpStr,tmpINIFileName,tmpVocPath;
	int nPos;

	::GetModuleFileName(NULL, tmpStr.GetBuffer(MAX_PATH), MAX_PATH);
	tmpStr.ReleaseBuffer();
	nPos = tmpStr.ReverseFind('\\');
	strncpy(gAppPath,tmpStr,nPos+1);
	gAppPath[nPos+1] = 0;
	tmpINIFileName = tmpStr.Left(nPos+1) + INI_FILE_NAME;
	strcpy(gINIFullFileName,tmpINIFileName);
}

void ReadINIFile()
{
	ReadDataBaseConf();
}

void ReadDataBaseConf()
{
	//Server Name
	GetPrivateProfileString("DATABASE","ServerName","48D4A84ACB1F486",gServerName,128,gINIFullFileName);
	//DataBase Name
	GetPrivateProfileString("DATABASE","DataBaseName","学生成绩管理系统",gDataBaseName,200,gINIFullFileName);
	//User Name
	GetPrivateProfileString("DATABASE","UserName","",gUserName,128,gINIFullFileName);
	//Password
	GetPrivateProfileString("DATABASE","PassWD","",gPassWD,128,gINIFullFileName);

}

void WriteDataBaseConf()
{
	//Server Name
	WritePrivateProfileString("DATABASE","ServerName",gServerName,gINIFullFileName);
	//DataBase Name
	WritePrivateProfileString("DATABASE","DataBaseName",gDataBaseName,gINIFullFileName);
	//User Name
	WritePrivateProfileString("DATABASE","UserName",gUserName,gINIFullFileName);
	//Password
	WritePrivateProfileString("DATABASE","PassWD",gPassWD,gINIFullFileName);
}

bool TestDataBase()
{	
	char strConnection[256];
	strcpy(strConnection,"DRIVER=SQL Server;SERVER=");
	strcat(strConnection,gServerName);
	strcat(strConnection,";UID=");
	strcat(strConnection,gUserName);
	strcat(strConnection,";PWD=");
	strcat(strConnection,gPassWD);
	strcat(strConnection,";DATABASE=");
	strcat(strConnection,gDataBaseName);
	strcat(strConnection,";");
	CADODatabase m_database;
	SetCursor(LoadCursor(NULL,IDC_WAIT));
	m_database.PutConnectionTimeout(5);
	if(m_database.Open(strConnection)==true)
	{	m_database.Close();
		SetCursor(LoadCursor(NULL,IDC_ARROW));
		return true;
	}
	else
	{	SetCursor(LoadCursor(NULL,IDC_ARROW));
		return false;
	}
}

BOOL DirExists(LPCTSTR lpszDir)
{	DWORD attr;

	attr = GetFileAttributes(lpszDir);
	return attr != (DWORD)-1 && attr & FILE_ATTRIBUTE_DIRECTORY;
}

BOOL ExistFile(char *fname)
{
	if( (_access( fname ,0)) != -1 )
		return TRUE;
	else
		return FALSE;
}