Ӧ
Computer Applications
1999 198 Vol.19No.8 1999



VBDAOݸʽݿ
Тѧࡡɡ
ժҪʹݿʽӿڹDAO(ݷʶ)ݸʽݿһ㷽
ؼʡݷʣݿ
1VBݿӿ
VBṩĲݿĽӿڹDC(ݿؼ)DAO(ݷʶ)RDC(Զݿؼ)RDO(Զݷʶ)ODBC(ݿ)ODBC API(ͨWindowsݿ⺯APIݿ)
DC򵥣ݰ(Bounding)ؼͨJETﵽñдκδ뼴ʵʾݿĿģڹܴܵƣ粻óпơϢļ޷ʵֵȣһ½ڳԱʹá
ʹRDCҲڲñƳ£ʹͻܲݿ⡣
DAODCҪӵö࣬õļϺͶĸÿԼԼҺܶԱֿɳΪ󣬳ʹVBѧ޴֣ñдķʽݿģԴʵʿĹУдЧʵĲݿӦó
2JETDAO
2.1JET
JETΪVBݿĽӿṩд޸ĺɾѯ֤ݵԣ֧SQL(ѯ)ݿ޸ѹ
JETͳ⣬ͣͼOLEͣӼǶ룩VB 5.0һеJetΪ3.5汾ǿ˶ODBC ԴĹܡ

JETһм㣬ɷʵݿDBaseODBCOracle SQL ServerԴݿ(οͼ1)


ͼ1
ISAM(˳ʷIndexed Sequential Access Method)Դݿ⡢ͣJETҪʹISAM
ODBCͲҪһ˷ݿͣFoxProҲOracle
2.2DAO
DAOûطݿеʵϢ˵VBͨһϵDAOJETĹܡDAOṹͼ2


ͼ2
DAODCJET棬Լ򵥵VBԴODBCԴƼʹRDOΪRDOʹJETJETԷMS AccessݿʱٶVBOOPʹûվһ(ṹ)ƸߡĲȥ⣬бʵǰ߸⣬ͻʵͳĶ󣬶ṇ̀ݶ壨Ϣǳȶ
DataBases֮ϻDBEngineWorkSpaces󣬼JET棬һ϶WorkSpacesWorkSpacesһݿ⼯϶DataBasesDatabasesDatabaseɡ
DatabaseڴݿʱģеConnectָ˴ݿͻʽַAccess,ݿ⣻Name԰ݿ·ļAccessΪݿ·ļFoxPro2.5,dBaseΪĿ¼·ÿһ.DBFļΪһ
CreateTableDefTableDefOpenRecordSetڽһRecordSet¼󣬿DynaSet̬SnapshotաTable͡
TableDefʵʵݣһݿжʹCreateFieldԽµFieldҲOpenRecordSetRecordSetVBڽRecordSetʱӦָ͡
3ʹDAOݿ
3.1ݿ
ݿһݿ⣬Ѵݿ󸳸ݿ
Dim DataBaseObjVar As Database
䶨DataBaseObjVar
Set DataBaseObjVar=CreateDataBase(DataBaseName)
ݿ󸳸ݿ
DataBaseObjVarΪڷҪݵĶDatabaseΪݿ󣬲DataBaseNameΪҪݿ·̷"C:\MyDataAcess\My.mbd"(ӦAccessݿ)C:\MyDataFoxPro"(ӦFoxProݿ)
⣬CreateDatabaseУж汾Ϣ𡢿Ƿܵȣ¿ʡԣϸܡ
3.2
󣬰ݿеı󸳸ӵУһݿж
Dim TableObjVar As TableDef
䶨
Set TableObjVar=DataBaseObjVar.CreateTableDef(TableName)
䴴
DatabaseObjVar.TableDefs.Append TableObjVar 
佫ӵ
TableObjVarΪʴĶTableNameΪıTableDefΪCreateTableDefΪķAppendΪӱеķʹıΪݿеһԱ
3.3ֶ
еֶζеֶΣѱеֶζ󸳸ֶζֶӵֶμУͨһжֶΡڴһֶ(Ϊ0)
Dim FieldObjVar() As Field
䶨ֶα
SetFieldObjVar(0)=TableObjVar.CreateField(FieldName,FieldType,FieldLength)
ֶָεƣͣ
DataBaseObjVar.TableObjVar.Fields.Append FieldObjVar(0)
ֶεֶμ
ظ䣬ɶֶΡFieldObjVarΪʴֶεĶʾһжֶΣֵ0ΪһֶΣֶεֵ0ʼFieldNNameΪֶFieldTypeΪֶε(ַ͡)FieldLengthΪֶεĳȡ
ʹAppendӴֶεֶμУʡԡ
3.4
ݿһһҲûʱΨһԣֶΣֶκֱӵֶμϺС
Dim IndexObjVar As Index
䶨
Set IndexObjVar=DataBaseObjVar.TableObjVar(0).
CreateIndex(IndexField Name)
ĳѾıн󣬲
IndexObjVar.Primary=True

IndexObjVar.Uinque=True
Ψһ
Dime IndexFieldObjVar As Field
䶨ֶζ
Set IndexFieldObjVar=IndexObjVar.CreateField(IndexFieldName)
佨ֶζ󣬲ֶζ
IndexObjVar.Fields.Append IndexFieldObjVar
ֶӵֶμ
DataBaeObjVar.TableObjVar(0).Inedxes.Append IndexObjVar
佨ӵ
ظ䣬ɴ
ʹInedxCreateFieldֶΣTableDefѴڵֶΡ
3.5¼
£ݿʱǼ¼Ĳ롢ɾ޸ģݿ⡢ֶμϺҪ¼󡣼¼Ĵ¼ʹSQLѯԴ򿪼¼
Dim RecordSetObjVar As RecordSet
䶨¼
SQLVar="SelectֶαFrom嵥Whereʽ
ѯ
Set RecordSetObjVar=DataBaseObjVar.OpenRecod et(SQLVar)
SQLοӦϡ
ΪֹݿṹϽˣԺʹRecordSetMoveFirstMoveLastMovePreviousMoveNextFindFirstFindLastFindPreviousFindNextȷݿˡ
4
ӴݿĹ̿ԿVBûɸҪݿ⣬ǳض͵ݸʽһϣʲͬݸʽݿķȫһġݿĲר̽֡ 
߼:Т¡ʦ
ߵλ:Тѧࡡɡ顡֣ݹҵѧ.֣ݣ450002)
ո:1999-04-30(޸ĸ)
