
COMPUTER ENGINEERING
1999 25 10 Vol.25 No.10 1999



ʹDAOAccessݱBinaryֶ
ٱ
ժҪAccessݿݿ⼯ԵļṹݱеBinaryֶרΪŶݶġڴ꾡̽VC5.0ʹDAOAccessݱBinaryֶε;صCOleVariantӦ÷ʵһCMdbAccessExample࣬ʵݡ
ؼʣAccessݿ⣻BinaryֶΣDAOࣻCOleVariant
To Control the Binary Field of Access Database with DAO
Rong Bign Xu Weimin
(Dept.of Computer,Shanghai University,Shanghai 200072)
AbstractAccess Database(modb)processes the optimalizing file construction aimed at integration of Database.The Binary field of Access Data-Table is used for storing binary data.The artjcle elaborately gives an account of the method of accessing the mdb database using DAO class in VC5.0 and the relevant application of"Cole Variant"class.At last,the article also lay out an"CmdbAccessExample"aimed at a given example
Key wordsAccess database;Binary field;DAO class;COleVariant
Accessݱ˴ͳݿTextSingleLongData/Timeֶ⣬һBinaryֶΣڴŶݣͼѹݵ[1]
VC5.0ṩDAOAccessݱֱӷʣDAOں̶ܴODBCĳODBCĴ󲿷ֹܲԼĺܶ๦ܡDAOOLEʽʵֵģûҪֱЩ򽻵MFCDAOΪûеϸڣûṩOLE󽻻õݺͺԱ[2]DAOڱƴAccess.mdbݿ⡣
VCзAccessݱʱַͨȡݣ
(1) ʹVCӦóAppWizardһݿӦó򣬵̶ȺСһڶݿ޷ֱӷBinaryֶεݡ
(2) ӦóдԼݱ , ͨʵֶֶεķʡʵӦһVCDAOBinaryֶεķ˼·£
AccessݿBinaryֶδ洢ʱɷΪ3
 ȽҪ洢ݿһCBtyeArrayУ
 COleVariantĹ캯COleVariant(const CByteArray& arrSrc) һCOleVariantࣻ
 ʹCDaoRecordsetĳԱSetFieldsValue()ݴӦֶΡ
AccessݿBinaryֶλʱɰ²
 ʹCDaoRecordsetĳԱGetFieldsValue()ȡһCOleVariantС
 ݴCOleVariantн
1ص˵
1.1 DAOӦ
DAOΪû̴ͲݿṩһܣĹܷɢڼӦDAO棺CDaoDatabaseCdaoRecordset
CDaoDatabaseݿᣬͨԶݽвCDaoRecordsetһԴѡݼݼ3ͣ
ݼ--ݱ顢ӡɾһݱеļ¼
̬ݼ--һԿ޸ļ¼Ĳѯ̬ݼһһǱݱеݼڼ顢ӡɾ¼԰ݱеֶΡ̬ݼӦձݼͬʱҲCdaoRecordsetĬϵݼ͡
ݼ--һڲݻɱľ̬ݼݼһݣԱ¡
ĲӦ˶̬ݼ
1.2 VariantCOleVariantԼǣ浽ݽṹ
VariantʵһϴCԽṹ͵ϣUnionƷڲͬܵ͡Variantڲͬ£԰ݻָݵָ롣MFCĿԱʶVariant͵Ҫԣ˴һCOleVariant࣬ϼطװVariantṹOOPУΪԶͿͻ֮䴫ṩͳһȫĻ[3]ܴVariantOLEӦó򣬵κοԱʹõĵطÿӦóǷʹOLEݿȡԵҪ
VCжVariant͵Ķ[4]֣
typedef struct tagVARIANT{
VARTYPE vt;
unsigned short wReserved1;
unsigned short wReserved2;
unsigned short wReserved3;
union{
unsigned charbVal;//vtʶVT_UI1.
shortiVal;//vtʶVT_I2.
long lVal;//vtʶVT_I4.
floatfltVal; /vtʶVT_R4.
double dblVal;  //vtʶVT_R8.
VARIANT_BOOL bool;//vtʶVT_BOOL.
RETURN VALUE return_value;//vtʶVT_ERROR.
CYcyVal;//vtʶVT_CY.
DATE date;//vtʶVT_DATE.
BSTRbstrVal;//vtʶVT_BSTR.
IUnknownFAR*punkVal;//vtʶVT_UNKNOWN.
IdispatchFAR*pdispVal;//vtʶVT_DISPATCH.
SAFEARRAYFAR* parray;//vtʶVT_ARRAY|*.
unsigned charFAR* pbVal; //vtʶVT_BYREF|VT_UI1.
shortFAR*piVal;  //vtʶ VT_BYREF|VT_I2.
longFAR*plVal;//vtʶVT_BYREF|VT_I4.
floatFAR*pfltVal;//vtʶVT_BYREF|VT_R4.
doubleFAR*pdblVal;//vtʶVT_BYREF|VT_R8.
VARIANT_BOOL FAR* pbool;//vtʶVT_BYREF|VT_BOOL.
RETURN VALUE FAR* preturn value;//vtʶVT_BYREF|VT_ERROR.
CY FAR* pcyVal;//vtʶVT_BYREF|VT_CY.
DATE FAR* pdate;//vtʶVT_BYREF|VT_DATE.
BSTR FAR* pbstrVal;//vtʶVT_BYREF|VT_BSTR.
IUnknown FAR* FAR* ppunkVal;//vtʶVT_BYREF|VT_UNKNOWN.
IDispatch FAR* FAR* ppdispVal;//vtʶVT_BYREF|VT_DISPATCH.
SAFEARRAY FAR* FAR* parray;//vtʶVT_ARRAY|*.
VARIANT FAR* pvarVal;//vtʶVT_BYREF|VT_VARIANT.
void FAR* byref;//һ.
}
}VARIANT;
ģVariantһCṹһʹvtһЩֽԼһunion͡ʹvtŶunionֵĽ͡磺vtΪVT_I2ԴiValжVariantֵVariant԰ʵʵݻָݵָ룬vtVT_ARRAYλparray(SAFEARRAY FAR* parray)еָзʡ
һCByteArrayCOleVariantvtֵӦVT_UI1VT_ARRAYλʵݴparryָSAFEARRAYСSAFEARRAYṹ£
typedef struct FARSTRUCT tagSAFEARRAY{
unsigned short cDims;//еά.
unsigned short fFeatures;//ָSAFEARRAYԵı־
#if defined(WIN32)//Win32ƽ̨
unsigned long cbElements;// ÿԪռֽ.
unsigned long cLocks;// 鱻Ĵ
#else//16λƽ̨
unsigned short cbElements;
unsigned short cLocks;
unsigned long handle;// ΪԶã
#endif
void HUGEP* pvData;// ָʵݵָ
SAFEARRAYBOUND rgsabound[1]; // ÿһάı߽.
}SAFEARRAY;
pvDataָָյݣ飩ôʱڴеӳͼ1ʾ

ͼ1 ڴеӳ
1.3 COleVariantе(ƫλ)ݿС
1.2SAFEARRAYṹеrgsabound洢ݴС
typedef struct tagSAFEARRAYBOUND{
unsigned long cElements;//Ԫص
long lLbound; //ݵ½
}SAFEARRAYBOUND;
ILboundָݿ㣬pvDataֵָϴֵλácElementsȷݿĴС(С)
1.4 CByteArrayĳʼ
CByteArrayûṩӦĹ캯ڳʼֻʹøĳԱɡͨSetSize()ԱĴСȻSetAt()Աֵ
2С
AccessݿӦù㷺Ĺϵݿ⣬ͨVCDAOݲBinaryֶεÿԸЧʵݹܡĶAccessݿBinaryֶδȡ˸ṩһʵϣשЧݿиӦá
߼飺ٱ1973Уоз򣺸ܼϵṹ
ߵλϺѧϵϺ200072
ο
1 .Access 97ʹֲ.廪ѧ磬1998
2 Gregory K..Visual C++ ʹֲ.еҵ,1997
3 Koruglinski J D.ӡ.Visual C++ Ļ.廪ѧ,1994
4 Microsoft.Visual C++ 5.0 Online Help,MS Develop Studio,1997
ոڣ1999-01-04
