dbaccess.h

用C++基于SQL SERVER使用存储过程

// DBAccess.h: interface for the DBAccess class.
//
//////////////////////////////////////////////////////////////////////
#import "c:\program files\common files\system\ado\msado15.dll" \
no_namespace rename ("EOF", "EndOfFile")
#if !defined(AFX_DBACCESS_H__A139B81F_F593_433E_A912_7683F749A59F__INCLUDED_)
#define AFX_DBACCESS_H__A139B81F_F593_433E_A912_7683F749A59F__INCLUDED_
#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
#include "afx.h"

class DBAccess  
{
public:
	_ConnectionPtr	m_pCon;
	_RecordsetPtr	m_pRst;
	_CommandPtr		m_pCmd;
    CString			m_strSQL;
	bool			m_fConnected;
	CString			m_strSource;
	CString			m_strErrMsg;
	//_bstr_t m_strSource;
	//_bstr_t m_strUser;
	//_bstr_t m_strPwd;
	CString			m_strStepName;
	CString			m_strObjName;
	
public:
	int startbr();
	int readnext();
	int endbr();
	int insertrec();
	int updaterec();
	int deleterec();
	int execute();
	//CString datestrproc(CString);
	//bool writelog(char *);
	//_ConnectionPtr connectdb();
	CString PrintError();
	
private:
	virtual int bindvalue();
	virtual int setvalue();

public:
	DBAccess();
	virtual ~DBAccess();

};

#endif // !defined(AFX_DBACCESS_H__A139B81F_F593_433E_A912_7683F749A59F__INCLUDED_)