adoconn.h

GemoMedia 应用 演示了其使用方法

// ADOConn.h: interface for the ADOConn class.
//
//////////////////////////////////////////////////////////////////////
#import "c:\Program Files\Common Files\System\ado\msado15.dll"  rename("EOF","adoEOF") rename("BOF","adoBOF")

#if !defined(AFX_ADOCONN_H__AC448F02_AF26_45E4_9B2D_D7ECB8FFCFB9__INCLUDED_)
#define AFX_ADOCONN_H__AC448F02_AF26_45E4_9B2D_D7ECB8FFCFB9__INCLUDED_

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

class ADOConn  
{
// 定义变量
public:
	CString m_str_server;  //数据库服务
	CString m_str_user;   //服务器
	CString m_str_password; //密码
	CString m_str_Db; //数据库

	//添加一个指向Connection对象的指针:
	ADODB::_ConnectionPtr m_pConnection;
	//添加一个指向Recordset对象的指针:
	ADODB::_RecordsetPtr m_pRecordset;
// 定义方法
public:
	bool OnInitADOConnOra(CString str_User,CString str_pass,CString str_Server);
	void SetDbUserPass(CString strUser,CString strPassWord);
	ADOConn();
	virtual ~ADOConn();
	//设置用户名、密码
	// 初始化—连接数据库
	bool  OnInitADOConn(CString str_User,CString str_Pass,CString str_server,CString str_Db);
	// 执行查询
	ADODB::_RecordsetPtr& GetRecordSet(_bstr_t bstrSQL);
	// 执行SQL语句，Insert Update _variant_t
	BOOL ExecuteSQL(_bstr_t bstrSQL);
	void ExitConnect();
	void SetServer(CString str_server);

	bool OnInitADOAcess(CString strDB);
	
	//是否连接成功
	bool m_bConnect;

};

#endif // !defined(AFX_ADOCONN_H__AC448F02_AF26_45E4_9B2D_D7ECB8FFCFB9__INCLUDED_)