database.h

vc6.0是一个很好的开放环境

// DataBase.h: interface for the CDataBase class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_DATABASE_H__0964F832_4E25_45B5_84E6_022362B3D1A8__INCLUDED_)
#define AFX_DATABASE_H__0964F832_4E25_45B5_84E6_022362B3D1A8__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
#include "AfxDB.h"
class CDB  
{
public:
	BOOL GetVarIntValue(char *cFieldName, int *iResult);
	BOOL DBState();
	bool GetFieldValue(int iField, CString &strResult);
	BOOL GetFieldValue(char *cFieldName, double *dResult);
	BOOL Rollback();
	BOOL CommitTrans();
	BOOL BeginTrans();
	BOOL GetFieldValue(int iField,int *iResult);
	void CloseRecordSet();
	BOOL GetFieldValue(char *,CString &strResult);
	void MoveNext();
	BOOL IsEOF();
	BOOL GetFieldValue(char *,int *iResult);
	BOOL OpenTable(CString &strSql);
	void CloseDatabase();
	BOOL ExecuteSQL(CString& sql);
	BOOL ConnectDB(char *cIp,char *cDbName,char *cUserName,char *cPassWord);
	CDB();
	virtual ~CDB();
	CDatabase  m_db;
    CRecordset m_rs;
};

#endif // !defined(AFX_DATABASE_H__0964F832_4E25_45B5_84E6_022362B3D1A8__INCLUDED_)