sqlaccess.h

用于当前sql等主流数据库连接的动态链接库

// SQLAccess.h: interface for the CSQLAccess class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_SQLACCESS_H__502A23DD_7175_411A_A615_929C24CDEBA8__INCLUDED_)
#define AFX_SQLACCESS_H__502A23DD_7175_411A_A615_929C24CDEBA8__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
//#include <comdef.h>
//#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","rsEOF")//导入ado动态连接库
class AFX_EXT_CLASS CSQLAccess  
{
public:
	HRESULT RollbackTransSQL();
	HRESULT CommitTransSQL();
	long BeginTransSQl();
	_RecordsetPtr QuerySQL(_bstr_t  str,VARIANT  *var=NULL,long op=adCmdText);
	/*_ReordsetPtr*/ BOOL UpDateSQL(_bstr_t str,VARIANT *var=NULL,long op=adCmdText);
	CSQLAccess();
	CSQLAccess(CString Database,CString uid,CString pwd,CString Provider="SQLOLEDB.1",CString HostName="127.0.0.1");
	virtual ~CSQLAccess();
private:
	_ConnectionPtr m_pCon;//添加指向Connection对象的指针，用来连接数据库时用
	_RecordsetPtr m_pRs;
	CString Con;
	CString Provider,Server,Database,uid,pwd,HostName;
	
};

#endif // !defined(AFX_SQLACCESS_H__502A23DD_7175_411A_A615_929C24CDEBA8__INCLUDED_)