dbovictable.h

来自「本人买的<<VC++项目开发实例>>源代码配套光盘.」· C头文件 代码 · 共 70 行

// dbovicTABLE.H : Declaration of the CdbovicTABLE class

#ifndef __DBOVICTABLE_H_
#define __DBOVICTABLE_H_

class CdbovicTABLEAccessor
{
public:
	TCHAR m_c1[11];

BEGIN_COLUMN_MAP(CdbovicTABLEAccessor)
	COLUMN_ENTRY(1, m_c1)
END_COLUMN_MAP()

DEFINE_COMMAND(CdbovicTABLEAccessor, _T(" \
	SELECT \
		c1  \
		FROM dbo.vicTABLE"))

	// You may wish to call this function if you are inserting a record and wish to
	// initialize all the fields, if you are not going to explicitly set all of them.
	void ClearRecord()
	{
		memset(this, 0, sizeof(*this));
	}
};

class CdbovicTABLE : public CCommand<CAccessor<CdbovicTABLEAccessor> >
{
public:
	HRESULT Open()
	{
		HRESULT		hr;

		hr = OpenDataSource();
		if (FAILED(hr))
			return hr;

		return OpenRowset();
	}
	HRESULT OpenDataSource()
	{
		HRESULT		hr;
		CDataSource db;
		CDBPropSet	dbinit(DBPROPSET_DBINIT);

		dbinit.AddProperty(DBPROP_AUTH_INTEGRATED, OLESTR("SSPI"));
		dbinit.AddProperty(DBPROP_INIT_CATALOG, OLESTR("VicDB"));
		dbinit.AddProperty(DBPROP_INIT_LCID, (long)2052);
		dbinit.AddProperty(DBPROP_INIT_PROMPT, (short)4);
		hr = db.Open(_T("SQLOLEDB.1"), &dbinit);
		if (FAILED(hr))
			return hr;

		return m_session.Open(db);
	}
	HRESULT OpenRowset()
	{
		// Set properties for open
		CDBPropSet	propset(DBPROPSET_ROWSET);
		propset.AddProperty(DBPROP_IRowsetChange, true);
		propset.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE);

		return CCommand<CAccessor<CdbovicTABLEAccessor> >::Open(m_session, NULL, &propset);
	}
	CSession	m_session;
};

#endif // __DBOVICTABLE_H_