adodb.h

本家庭理财系统是一个简易的家庭理财工具

#ifndef ADO_DB_H
#define ADO_DB_H

#import "msado15.dll" no_namespace rename("EOF","adoEOF")

#include <vector>
typedef ::std::vector<CString> CStrs;
typedef ::std::vector<CStrs> CDStrs;

class CAdoDB
{
public:
	CAdoDB();
	virtual ~CAdoDB();
public:
	BOOL Open(LPCTSTR lpszConnect=_T(""),long lOptions=adConnectUnspecified);
	void Close();
	BOOL IsOpen();
	_ConnectionPtr GetConnection(){return m_pConn;};
	_RecordsetPtr GetRecordset(){return m_pRs;};
	CString GetConString(){return m_strConn;};
	_RecordsetPtr Execute(LPCTSTR strSQL,long lOptions=adCmdText);
	CString vartostr(_variant_t &var);
	void ExecuteQuery(LPCTSTR lpszSQL,CDStrs& Fields);
	void ExecuteQueryValue(LPCTSTR lpszSQL,CString& value);
protected:
	CString m_strConn;
	_ConnectionPtr m_pConn;
	_RecordsetPtr m_pRs;
};

#endif