dbset.h

很好的系统,vc++ + ASSSE 系统

// DBSet.h : interface of the CDBSet class
//
/////////////////////////////////////////////////////////////////////////////

#if !defined(AFX_DBSET_H__9FEB3E63_E772_4014_857B_6BB0004186BC__INCLUDED_)
#define AFX_DBSET_H__9FEB3E63_E772_4014_857B_6BB0004186BC__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

class CMy
{
public:
	CMy()
	{
		memset( (void*)this, 0, sizeof(*this) );
	};

	wchar_t m_column0[5];
	wchar_t m_column1[6];
	wchar_t m_column2[16];
	wchar_t m_column3[1];
	wchar_t m_column4[2];
	wchar_t m_column5[6];
	wchar_t m_column6[5];
	wchar_t m_column7[5];
	wchar_t m_column8[4];
	CURRENCY m_column9;
	wchar_t m_column10[5];
	CURRENCY m_column11;
	wchar_t m_column12[5];
	wchar_t m_column13[6];
	CURRENCY m_column14;
	wchar_t m_column15[5];
	wchar_t m_column16[3];
	wchar_t m_column17[41];
	wchar_t m_column18[5];
	wchar_t m_column19[5];
	wchar_t m_column20[3];
	CURRENCY m_column21;
	wchar_t m_column22[6];
	wchar_t m_column23[5];
	short m_column24;
	wchar_t m_column25[3];
	wchar_t m_column26[11];
	wchar_t m_column27[6];
	wchar_t m_column28[4];


BEGIN_COLUMN_MAP(CMy)
		COLUMN_ENTRY_TYPE(7, DBTYPE_WSTR, m_column0)
		COLUMN_ENTRY_TYPE(6, DBTYPE_WSTR, m_column1)
		COLUMN_ENTRY_TYPE(29, DBTYPE_WSTR, m_column2)
		COLUMN_ENTRY_TYPE(28, DBTYPE_WSTR, m_column3)
		COLUMN_ENTRY_TYPE(2, DBTYPE_WSTR, m_column4)
		COLUMN_ENTRY_TYPE(25, DBTYPE_WSTR, m_column5)
		COLUMN_ENTRY_TYPE(24, DBTYPE_WSTR, m_column6)
		COLUMN_ENTRY_TYPE(19, DBTYPE_WSTR, m_column7)
		COLUMN_ENTRY_TYPE(5, DBTYPE_WSTR, m_column8)
		COLUMN_ENTRY_TYPE(22, DBTYPE_CY, m_column9)
		COLUMN_ENTRY_TYPE(16, DBTYPE_WSTR, m_column10)
		COLUMN_ENTRY_TYPE(17, DBTYPE_CY, m_column11)
		COLUMN_ENTRY_TYPE(18, DBTYPE_WSTR, m_column12)
		COLUMN_ENTRY_TYPE(4, DBTYPE_WSTR, m_column13)
		COLUMN_ENTRY_TYPE(20, DBTYPE_CY, m_column14)
		COLUMN_ENTRY_TYPE(1, DBTYPE_WSTR, m_column15)
		COLUMN_ENTRY_TYPE(15, DBTYPE_WSTR, m_column16)
		COLUMN_ENTRY_TYPE(11, DBTYPE_WSTR, m_column17)
		COLUMN_ENTRY_TYPE(14, DBTYPE_WSTR, m_column18)
		COLUMN_ENTRY_TYPE(8, DBTYPE_WSTR, m_column19)
		COLUMN_ENTRY_TYPE(9, DBTYPE_WSTR, m_column20)
		COLUMN_ENTRY_TYPE(21, DBTYPE_CY, m_column21)
		COLUMN_ENTRY_TYPE(27, DBTYPE_WSTR, m_column22)
		COLUMN_ENTRY_TYPE(26, DBTYPE_WSTR, m_column23)
		COLUMN_ENTRY_TYPE(23, DBTYPE_I2, m_column24)
		COLUMN_ENTRY_TYPE(10, DBTYPE_WSTR, m_column25)
		COLUMN_ENTRY_TYPE(13, DBTYPE_WSTR, m_column26)
		COLUMN_ENTRY_TYPE(12, DBTYPE_WSTR, m_column27)
		COLUMN_ENTRY_TYPE(3, DBTYPE_WSTR, m_column28)
END_COLUMN_MAP()

};

class CDBSet : public CCommand<CAccessor<CMy> >
{
public:

	HRESULT Open()
	{
		CDataSource db;
		CSession	session;
		HRESULT		hr;

		CDBPropSet	dbinit(DBPROPSET_DBINIT);
		dbinit.AddProperty(DBPROP_AUTH_CACHE_AUTHINFO, true);
		dbinit.AddProperty(DBPROP_AUTH_ENCRYPT_PASSWORD, false);
		dbinit.AddProperty(DBPROP_AUTH_MASK_PASSWORD, false);
		dbinit.AddProperty(DBPROP_AUTH_PASSWORD, "");
		dbinit.AddProperty(DBPROP_AUTH_USERID, "Admin");
		dbinit.AddProperty(DBPROP_INIT_DATASOURCE, "Bus.mdb");
		dbinit.AddProperty(DBPROP_INIT_MODE, (long)16);
		dbinit.AddProperty(DBPROP_INIT_PROMPT, (short)4);
		dbinit.AddProperty(DBPROP_INIT_PROVIDERSTRING, "");
		dbinit.AddProperty(DBPROP_INIT_LCID, (long)1033);
		dbinit.AddProperty(DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO, false);

		hr = db.OpenWithServiceComponents("Microsoft.Jet.OLEDB.4.0", &dbinit);
		if (FAILED(hr))
			return hr;

		hr = session.Open(db);
		if (FAILED(hr))
			return hr;

		CDBPropSet	propset(DBPROPSET_ROWSET);
		propset.AddProperty(DBPROP_CANFETCHBACKWARDS, true);
		propset.AddProperty(DBPROP_IRowsetScroll, true);
		propset.AddProperty(DBPROP_IRowsetChange, true);
		propset.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE );

		hr = CCommand<CAccessor<CMy> >::Open(session, "SELECT * FROM 报案登记表", &propset);
		if (FAILED(hr))
			return hr;

		return MoveNext();
	}

};

//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_DBSET_H__9FEB3E63_E772_4014_857B_6BB0004186BC__INCLUDED_)