myado.h

该代码是对数据库操作的数据库是sql server

// MyAdo.h: interface for the CMyAdo class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_MYADO_H__BEECC9E6_D5A0_4A25_895D_8B0EBE353E39__INCLUDED_)
#define AFX_MYADO_H__BEECC9E6_D5A0_4A25_895D_8B0EBE353E39__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

class AFX_EXT_CLASS CMyAdo  
{
private:
	BOOL m_IsOpened;
	CString gStrConnect ;
	BOOL m_IsNetWork;
	CString m_strSql;//接收外部传入的SQL语句
	_ConnectionPtr m_Cn ;//数据库联接对象
	_RecordsetPtr m_Set;//记录集对象
	_RecordsetPtr m_SetTemp;//记录集对象
	_CommandPtr m_cmd;//_CommandPtr对象
public:
	BOOL IsOpenDB();
	BOOL IsNetWorkServer();
	BOOL GetWorkerDataFromDataBase(char *pBuf);
	BOOL OpenTable(CString strTable,BOOL IsSql = TRUE);
	BOOL WriteWorkDataToDataBase(char *m_pFileBuffer, long DataLong);
	BOOL RollBackTran();
	BOOL CommitTran();
	BOOL BeginTran();
	_RecordsetPtr GetDataTempSet();
	CString GetNewID(CString strSql);
	_CommandPtr GetCommand();
	_ConnectionPtr GetConnection();
	_RecordsetPtr GetDataSet();
	BOOL ExecuteMySql(CString strSql,BOOL IsUpdateSet = FALSE);
	BOOL CloseDB();
	BOOL OpenDB(CString strDefaultTable);
	CMyAdo(CString DataBaseName,CString ServerName = "",BOOL IsNewWork = true);
	virtual ~CMyAdo();

};

#endif // !defined(AFX_MYADO_H__BEECC9E6_D5A0_4A25_895D_8B0EBE353E39__INCLUDED_)