
COMPUTER ENGINEERING
1999 25 8 Vol.25 No.8 1999



ƱϢϵͳʵ
»
ժҪClient/Server£ͨϵͳӲԼݿһƷýʽױҵSMDSͨŵϵͳӲƷ˹WinSockͨŵĳ̣ԼClient/ServerݿӦÿļ㾭顣
ؼʣͻʽױҵ׽֣ʽݿ⻥ݿϵͳ
The Design and Realization for Information System of Airlines Tickets Service
Wang Shiming,du xinhua
(Research Institute of Optical Fibre Technology shanghai Jiaotong University,Shanghai 200030)
AbstractA design methodology of the hardware,software in telecommunication system and database under Client/Server environment is discussed in this paper.A system hardware design methodology of data communication via SMDS is presented.The technological process of communication programming using WinSock and the experience of database application development under Client/Server environment are also discussed.
Key wordsClient/Server;SMDS;WinSock;ODBC;Database management system
1 Ӳϵͳʵ
ڹУƱƱϢĵľ򼸹ʮϰٹֱµķвͨģߵûηһķ DDN(Digital Data Network), øٵר߽ Client  Server ַǿеģȱ㣺רߵĴǹ̶ģƱϢϵͳԣͻԵģԴʼͣ 1 ˣø÷Ҫܸܺߵдۡһַǲ X.25 ⷽõľܣ㲻˶ܵҪ X.25 ô洢תĽʽӳٴ ( һΪ ms); Ҵ X.25 繤 64Kb/s ϣ㲻ϵͳͻݶʵҪ 
ʵϵͳʵʹ˽ʽױҵ SMDS(switched multimegabit data service) ͼ 1 ûͨ SMDS ûӿ SNI(Subscriber Network Interface) ÷ֲʽ˫ SQDB Э SMDS  SMDS һٵ LAN һ LAN һ LAN ûֻ n  SMDS ·Ķ·Щ·ѡøӰ취ʹ DQDB ĳ (MAN) ӵ绰˾ú̵ܶĸרߣֱӵӣ߽·ȡ 

ͼ1 ʹSMDSʾͼ
SMDS ΪͻƵģı׼ٶ 45Mb/s ȻʱѡһЩٶȡ SMDS ·ʽͻӵÿߵ·һԹ̶ӡһ鵽·ʱȼֵǷȷ鳤ֵǣ÷ͳȥҸüȥ鳤ֵ򣬸÷鱻ʵϣû 20Kb/s ƽʷݣͻʿҪߵöࡣ· 0.5s ôû԰ 45Mb/s ʷ 1KB ͻݣԼ 0.18ms ʹ 100KB/s ·ϣͬҲҪ 10ms  1 г˲ͬûϢӳ (  SMDS ƽݴΪ 26kb/s, · 0.5s) ɴ˿ɼһ˴ԴȽͨųɱмõľԡͬʱҪʱṩ˿Ӧӳʱ̡ 
1 ͬϢӳ
ӳ/ms(100ֽڵ֡)ӳ/ms(1600ֽڵ֡)
SMDS0.0180.28
֡м̽1.22.0
X.2512.020.0
19.2 kb/s41.67666.7
56 kb/s14.28228.57
1.544 Mb/s0.528.29

SMDS ûֵһ᣺ٶ㲥ͣûָһϵ SMDS ַұһĺԴбκηúķ齫бϵгԱڵһ鵽 SMDS ʱ·ȷԴַǷһ£һ£鱻 SMDS ṩַΣûЧؽ˽磬û SMDS ϵȷİȫԡ󣬸÷չά 
2 ϵͳ
ϵͳصڣƲĳƼڿУ Client  Server ໥õ࣬Ҫ Client  Server ֮Դ Client/Server ģʽҵ̣ʱڰոӵṹӦԣӿ쿪ٶȺͽͿۡ̽ϵͳľ巽ʵֲԡ 
2.1 ϵͳͿߵѡ  
ûԸϵͳϤ̶ȺûѺԣѡùͨõĻ TCP/IP  Microsoft WindowsNT 4.0  Client  WindowsNT WorkStation  Server  WindowsNT Server ߷棬ǵ߹ܵǿԼǷмõĿ棬 Visual C++ 5.0 Ϊ Visual C++ 5.0 ֧ Windows Sockets ̣ṩ ODBC Щ֧ Access  Foxpro  Oracle ݿϵͳ΢ (MFC) ṩ˷ḻõĻ࣬ȵؼ˱̹ "  " ĽƷʹͼûӿ (GUI) Ʒ滨̫ʱ; 
2.2 ͨ 
Sockets ͨŵĻԪṩ˲ͬ˫ͨŵĶ˿ڣ Sockets ̽ӿӦòЭʵֻͨôԭʴײ㸴ӵĽṹЭ飬ʹԱܹ򵥵ؽͨš Internet ȫΧڵĹ㷺ʹã Sockets 𽥳Ϊ̵ͨýӿڡ Windows ׽ (WinSock)  WinSock API ˲׽ֺ΢ Windows ֽṹʹԱ Windows ϢƺͲ׽ֹ淶 WinSock ֧׽ֱ֣ʽ׽ (SOCK_STREAM ֧ TCP Э ) ݱ׽ (SOCK_DGRAM ֧ UDP Э )  Client/Server ģ͡׽Уݱ׽ֹ֧㲥Ϣķ֤ͣݵĿɿԣҲ֤ݵ˳ڹвʽ׽֣ʽ׽һ "  " Ĵ䷽ڷ Socket ɹ󲢴ڵȴ״̬ʱ (  Listening ״̬ ) ͻ Socket ɹ Socket ӡӳɹ˫ͿԽݵķͺͽչȫ˫״̬պͷͬʱСʽ׽ֿԱ֤ĿɿԲ֤ݵ˳ 
Ϊ Windows Socket  MFC ṩࣺ CAsynSocket  CSocket  CAsynSocket װ Windows Sockets API,  Sockets йص Windows ϢתΪص CAsynSocket ǻ࣬ʹøԣԱԱҪҲϸߡ CSocket  CAsynSocket ࣬ͨ MFC е CArchive Ķṩ˸߲εĳװ Sockets ʵеСڡͨĿʱ CSocket ࣬ 7  ( ͼ 2 ʾ )  

ע1ListenSocketOnAccept(int nErrorCode)صԿͻҪ󣻣2OnReceive(int nErrorCode)صһϢ
1ΪϢ2ΪͻϢ
ͼ2 Socketͨͼ
(1) ڷˣ CListenSocket  (  CListenSocket  CSocket ࣬ OnAccept(int nErrorCode) ʹ䴦Կͻ ) ڿͻˣ CClientSocket  (  CClientSocket  CSocket ࣬ OnReceive(int nErrorCode) ʹڴԷϢ )  
(2) ֱ Create  
(3) ڷˣ CListenSocket  Listen ڿͻˣ CClientSocket  Connect  
(4) һ CListenSocket  OnAccept ãִ CSrvSocket SrvSocket  CListenSocket.Accept (SrvSocket)(  CSrvSocket  CSocket ࣬ OnReceive(int nErrorCode) ʹڴԿͻϢ )  
(5) ڷͿͻ˷ֱ CSocketFile ʹֱ CSrvSocket  CClientSocket  CArchive 󣬽ջݡ 
(6)  CArchive  Client/Server ͨš 
(7) Ҫʱɾ CArchive  CSocketFile  Sockets  
ʵʵУ塣ΪʡƪԴ򲿷ԡ 
2.3 ݿ 
ݿϵͳĹؼڣ̶ܴܺȷϵͳܡϵͳĿУⲿ 
ȣݿʵַ棬ݿļ⣬Ҫ칹ݿĻͼɣͱ߿ʽݿĵ·һõĿ棬ѡ ODBC  VC Book Online Ķ壺 ODBC provides an API that different database vendors implement via ODBC drivers specific to a particular database management system (DBMS). Your program uses this API to call the ODBC Driver Manager, which passes the calls to the appropriate driver. The driver, in turn, interacts with the DBMS using Structured Query Language (SQL) ˵Ϊ Windows ű׼ϵ (WOSA) һɲ֣ ODBC ͨṩݿĶԵġһ֧ ODBC õģ飬 MFC ݿʱͨ (ODBC.DLL) ֵ֧ĺݿ⡣ͬʱڹ̿ʱŻ˵ ODBC  Client/Server ϵṹͼ 3 ʾ ODBC λ Server ˣ˹Ĺṩ˿ŵ ODBC API( Ӧó̽ӿ ) ڶƺŻӦó⣬ΪӦó򿪷 3 õ MFC ݿࣺ CDatabase װԴӵĲ CRecordset װ˴Դѡõļ¼ü¼ǰԤĲѯõļϣ CRecordView ṩ˱ͼ CRecordset ӡУʵҪ CRecordset ɸѡԸּ¼ " ɸѡ "  "  " ҲǺҪһ , ʹӦø㡢 

ͼ3 Ż˵ODBC Client/Serverϵṹ
ΣΪ Client/Server ݿϵͳķӦٶȣѡ˷ֲʽ߼ãʹϵͳ Client  Server жԳƵĸء Client  Server ֮ÿһϢӦһݿﴦӶ縺ءͬʱڽʾ߼㻮Ϊ Client  Server ĸأϵͳķӦٶȡ⻹ַ߷Ӧٶȣרõ SQL  SQL  FAT ļʽٲϵͳٻ壬ʹòҪȡ 
ϵͳйУڲԤпʹͨŻݿʧܣͻᵼ¿ͻ˺ͷĲһ£ʹݿԺһ⵽ƻΪˣڹвַƣ֤ʵƣÿһݿд֤Ƿ񱻳ɹִУֹÿһһż¼ĸ¶ıֶΣͨȽǰֵֶ͵ǰֵͿжڼݿǷ񱻸¡ֹݿϵͳķӦٶȡ 
3 Ч 
ϵͳ׳ԺӦʱؼ⡣ԽͿͻͨŵӳ 0.1 £δϵͳݿǸĿɲ֣ڽ 1 ܵĲԹУݿķӦʱ 0.5 £δ⵽κδ˺ƱϢϵͳԽ׳ԺӦʱҪûϵͳܱʾ⡣ڽɺгɱ棬ӲϵͳƣͬƵϢϵͳȣϵͳߵܼ۸ȡ⣬ϵͳľƣ俪൱͵ġ 
ݿ Client/Server ģ͵ĽϣϢϵͳչıȻơӲϵͳʵͨ磬ϲ WinSock  Client  Server ֮ͨţɻýϸߵܼͨ۸ȡ ODBC һʮּݿӦýӿڣʵԽʡʱ䣬򻯿̣ؽݿϵͳĸط䣬ĵݿӦÿݿϵͳķӦٶȣ䷴Ӧʱ䡣 
ߵλϺͨѧ˼оϺ 200030
ο 
1 Norton P. MFC  Windows95/NT4.0 Ӧָ . 廪ѧ  ,Prentice Hall  1998,4 
2 Tanenbaum A S.Computer Networks(Third Edition). 廪 ѧ硢 Prentice Hall  1997,2 
3 ߴƣ . ̳ . Ϻѧ 磬 1994,11 
4 Ullman J D  Widom J.A First Course in Database Systems.  廪ѧ磬 1998,4 
5 Online Help about Visual C++ 5.0.Microsoft Corporation  1997 
