
COMPUTER ENGINEERING
1999 25 12 vol.25 No.12 1999



BDEGATE:һݿԭ͵о빹
ѩƽš塡Ÿ
ڷֲʽļ㻷УôͳĿͻ/ģʽڷԶݿʱ밲װݿʽӿڡøʹϵͳʹò㣬ϵͳֺ֧άƫߡϵͳϵͳԽԽӣÿһҪԶݿĿͻ϶ҪװݿʽӿڣܻᵼЩӿ֮Ĳһ£һҪݿӿڣôÿ̨ͻ϶°װϵͳòԽܡ⣬ԲͬݿʣûķȨݿϵͳģӦϵͳ޷ṩݿⰲȫͻݿķʡӦõڸӣݿʵĹܺҪԽߡԣǰӦõķѲܺܺõӦõҪ
Ϊˣһݿʽݿӿڷֲʽͻ/Ӧõ·һݿԭBDEGATE(Borland Database Engine Gateway)ͨݿأݿӿڵĸԼڷϣͿͻ˵ݿӿڵĸԣǿֲʽC/SӦóĿάԣӶݿⰲȫĿƣ֧ݿĽӿڡĿǰֲʽͻ/ʵֶݿʵĽӿڴ¿ԷΪ3֡
(1) רݿӿAPI
ݿ⳧̷׷ƳԵרõݿӿAPIרݿӿAPIǶʽԵʽڡصݿЧʸߣǿЧʼ͡Ҳͬݿ⳧̵API֮ڿɻԡרAPIӦóں̨ݿıʱпܲò¿֮רݿĽӿڷԵݿƷܼɣЧʡܻǰȫԷ涼ﵽˮƽҲֽܼɣֻܾڸԵݿƷ֮ϣԼԺͿֲԲ
(2) Microsoft˾Ŀݿ⻥ODBC(Open Database Connectivity)Microsoft
˾Ŀݿ⻥һݿмͨõݿӿڡݿ⻥ִSQL(Structured Query Language)Ӧóӿڣһ鿪ݿ⻥ӿں͹淶ɣκιϵݿⷢSQL䣬Ӷֶ֧ԶݿķʣC++VBȶֿ֧ݿ⻥ӿڡÿݿ⻥ӿڣֻҪдһܹӦݿⷢݿ󡣿ݿ⻥Ϊһͨõݿӿڣзʲͬ͵ݿͬʱҲΪͨԶݿʵЧʡʹÿݿ⻥пͻĻϰװһODBC򣬶һҪODBC˷ֲʽĿͻ/ӦõĸԺӰάԡ
(3) Borland˾ݿ
BDEBorland˾ݿҲһݿм뿪ݿ⻥ƣݿҲִSQLӦóӿڣһݿӿɣκιϵݿⷢSQL䣬Ӷֶ֧Զݿķʡ뿪ݿ⻥ͬǣݿ֧ݿֱӣЧõǱпͻĻϰװһݿ򣬶һҪBDE˷ֲʽĿͻ/ӦõĸԺӰάԡ
1 ݿط
ͨķʽڿֲʽĿͻ/Ӧʱ漰Զݿʱÿݿ⻥ݿ淽ʹVBC++Ӧóʱݿ⻥ѡķʹDelphiʱݿʵѡ񡣵ʹÿݿ⻥ʹݿ棬Ӧеϱ밲װһݿ⻥ӿ(ͨODBC)װһݿ(ͨBDE)⣬ҪӦݿӿڻݿ档һؼеӦûУַǿеġȻһֲӦûУǿӦûУַĿֵûɣϵͳĸԼӣϵͳĿάԴ󽵵͡
ڷֲӦûУڷݿʱҲڱݿʽӿڣԼϵͳؽڣӶϵͳĿάԺͽϵͳĸԡݿصĿľڴˣڿͻʵݿʵ÷ݿӿڵĸԼݿϣͬʱʵİȫƲԣǿϵͳİȫԡ
2 ݿԭBDEGATE˼
ƺʵֵݿصĻṹͼ1ʾΪ󲿷֣һǻڷݿطDBGSM(Database Gateway Service Manager)һǻڿͻݿȡ(DB interface) DBGSMһ̣ǰ˵Ŀͻͺ˵ݿ֮ͨŵ(Ҳص)ÿͻȱDBGSMӡʱDBGSMаȫ顣ֻͨȫĿͻDBGSMӣӶDBGSMݿط񣻷DBGSMܾͻڽӺDBGSM䵱ͻݿ֮ĴͻSQL͵DBGSMȻDBGSM͸ذѸSQLύݿӣݿִSQL󣬰ѽͨݿӷظDBGSMȻDBGSMѽظͻݿȡRemoteDataBaseFrontDataSet󣻴ӶΪԶݿṩ˷㡣

ͼ1ݿBDEGATEĻṹ
ݿصϵṹõ(Three-tier)ͻ/ģ͡ݿͻͨŲ׽(Stream Socket)ʵ֣˶̵߳ŵ㣬ʹݿͻ׽ܹͨؽСݿݿĽӿڲݿ (BDE)֮ͨ׼SQLԽͨŵġڿͻˣö²ʵṩûһʹõĽ档
3 ݿԭBDEGATEʵ
ݿص˼룬ѡDelphi 3.0ΪߣBDEGATEΪһWindows NTʵ֡DelphiѾΪܻӭݿӦÿĹߣDelphi 3.0ṩPascalԣ֧Ŀ֧ӦùĿBDEGATEĿͻУǾùTRemoteDatabase TFrontDataSetӶʹÿͻ˵Ӧÿǳ򵥣۴ӸǱ̣ʹôͳı̷һʵݿBDEGATEĹвĹؼ
3.1 ݿBDE
ݿBDEһBorland˾ĶݿϵͳDBMSݿӿڣһͨõSQLݿʿܣڲͬݿʹͳһĽӿڡʹݿBDEԱֻҪдһݿӿڣҪ±ܹκԴݿBDEֱ֧ӵݿʣЧԶȿݿ⻥ߡǰݿBDEֵ֧ݿӿУWindows NT ServerϵMicrosoft SQL ServerSybase SQL ServerSCO UNIXƽ̨ϵInformixOS/2 Warp Serverƽ̨ϵDB2ȡ⻹ṩԿݿ⻥Դ֧֡ʹݿ棬ʵֶһݿķʡ
ͻ˷͹SQLͨݿBDEִСûָSQLͬʱָӵBDEıԼ֤ûû
3.2 ׽
ЭTCP(Transfer Control Protocol)ṩһֿɿĶ˶Զ˵ͨͨͻ/Ӧóͨš׽е֮˫ͨ·һ˵㡣ӦTCP׽ֳΪ׽֣ӵġӦóض˿ڣȴԿͻ󡣵һ󵽴ʱͻ֮佨һרӣͨšӹУͻһض˿ںţһ׽ְ󶨵˿ڡͻͨ׽дϢԼ׽ֶԷϢķʽͨšƣҲһµıض˿ں(ҪµĶ˿ںΪܹԭĶ˿ϼ)Ҳһ׽ְ󶨵һض˿ڣͨд׽ͻͨţͻͷʹͬЭ飬Ҳ˵ͨ׽شϢʱʹͬԡͼ2ʾ׽ֵĹ̡

ͼ2 ׽ֵĹ
׽֣Ϊݿ²ͨŵҸӦҪ׽϶ͨЭ飬ЩϲûǲɼģڿͻˣDelphiݿȡTRemoteDatabaseTFrontDatasetû²ͨЭ顣
3.3 ߳
߳һе˳ָ̡̳߳ڵʹọ̈߳Щ߳ͬһʱ䲢Уִвͬڶ̳߳У߳Ҫݡ磬һ߳ļдݣһ߳Ҫļжݡ̹߳ʱҪ߳ͬԴﵽԤڵĽһмھԴͱʵ֤ͬƽÿ̶߳޵Դܹ㹻ķʱ֤Ľȣϵͳǹƽġ
ݿBDEGATEУΪÿͻṩһ̵߳ķʽʵ֡ݿУҪ4̣߳1).̣߳2).̣߳3).й̣߳4).״̡̬߳м̡߳й̺߳״̬߳Ƿʼմڵ3̣߳߳Ǹݿͻʧģͼ3ʾ˷̵߳Ĺ̡߳ʼڼһԿͻ˵ķ󣬷߳̾һ̣߳ݱҪĲȻɵķ߳SSLû֤Ȼ֤Сһӽ󣬿ͻֱӺصķ߳أķ߳޹ءй̶߳ں̨Уӵʹ״̬ĳѾʱδ(ʱ)ϿͷԴһֻ߳ΪһͻʧܵûӰ̶߳ͻӦ

ͼ3 ̵߳Ĺ
3.4 ȫ
Windows NTϵͳİȫƣSSPI (Secure Service Provider Interface)ûϢ֤ûûݿʱȰû֤ϢͨSSPIĿͻ˽ӿڽת(൱ڼ)Ȼ²׽ְתĽ͸̣߳߳ͨSSPIķ˽ӿڰ֤Ϣ͵ϵͳ֤û˰֤Ľͨ²׽ַظͻˡڴ͵Ǿ֤ܵϢû֤ϢйܵĿԡ֤BDEGATEϵͳ־дһȫ־¼ϵͳ֤ɹûӣ򣬲ûӡûݿʱȰûϢӳݿȡϢϣȻѾӳݿӳϢȥݿ⡣ְͨȫƣԼûԼİȫԣʵϴǿݿϵͳʵİȫԣɿԡ
ڱʵݿصĹУرעļ⡣ΪǲɿģͻͬɿBDEGATE˳ֵĳ(Exception Handling)ơڳ󣬰ѳԭ򾡿ܵظ߿ͻˣÿͻ˽ϵͳ״̬
ƺʵݿBDEGATEĹУµĹؼͻ/ģͣSQLBDE׽֣̣߳SSPIֵ֧İȫơ
4 С
ƺͿݿԭݿBDEݿʣʹÿԷʸݿϵͳ˶̼߳ʹϵͳĽ׳Եõ˱֤SSPI˶ݿʰȫơΪ˲ԿݿԭͣǱдһ򵥵Ŀͻ˲ԳԼԳİװǷ֣Ӳͬ͵ݿʱͻ˵Ӧó޸ģʹTCP/IPϳõЭҲ޷ûݿ֤ϢӶͻӦʱBDEGATEãԴĴﵽˮƽ
ݿصԭйܣʵ˿ͻ˵÷Ϳͻ˵ݿӿڵĸԣǿֲʽͻ/ӦóĿάԣݿʵİȫƣֹ֧ϵݿӡ
ߵλѧϵϺ200433
ο
1 ʩ֣¥. ݿϵͳ. ߵȽ 磬1994
2 ». Delphi 3 ָ. 磬1998
3 Minasi MAnderson CCreegan E. Windows NT Server 
4  ŵͨ. ӹҵ磬1997
