// 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_)