adoconn.h

自己封装的数据库操作类

// ADOConn.h: interface for the CADOConn class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_ADOCONN1_H__E411A6A3_90BA_4C07_8BC5_5F48FFF4DB07__INCLUDED_)
#define AFX_ADOCONN1_H__E411A6A3_90BA_4C07_8BC5_5F48FFF4DB07__INCLUDED_

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

#include "String.h"
//#include <sql.h>
#include <sqlext.h>
#import "d:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","adoEOF") rename("BOF","adoBOF")
class CADOConn  
{
public:
	CADOConn();
	virtual ~CADOConn();
public:
	_ConnectionPtr m_pConnection;
	_RecordsetPtr  m_pRecordset;

public:
	
	BOOL OnInitDBConnect();//初始化——连接数据库
	
	BOOL GetRecordSet(_bstr_t bstrSQL);//执行查询
	
	BOOL ExecuteSQL(_bstr_t bstrSQL);//Insetr Update _variant_t
	void ExitConnect();//退出数据库
	
	BOOL GetRecordCount(_bstr_t bstrSQL, int &nCount);//获得表长，记录集
	//表名，待查字段名数组，待查字段个数，查询结果数组,查询条件“ where。。。”

public://以下是填加部分
	BOOL GetRecordDataChar(_bstr_t bstrSQL,CString sItemName,DWORD nNum,BSTR *pData);
	BOOL GetRecordDataDWORD(_bstr_t bstrSQL,CString sItemName,DWORD nNum,DWORD *pData);
	CString m_sServer;	//服务器名
	CString m_sDatabase;//数据库名
	CString m_sUser;	//用户名
	CString m_sPwd;		//密码
};

#endif // !defined(AFX_ADOCONN1_H__E411A6A3_90BA_4C07_8BC5_5F48FFF4DB07__INCLUDED_)