΢͵Ӧ
MICROCOMPUTER APPLICATIONS
2000Vol.16No.1P.41-43



Intranet/InternetҽԺ
Ϣϵͳʵ
ơ
ժҪһۺҽԺΪʵIntranet/InternetʵһҽԺϢϵͳĹؼʵʩӦע⡣
ؼʣҽԺ硡ϢϵͳIntranet/Internet
AbstractThis paper describes the key processes and problems in realization of the new generation Hospital Information System (HIS)using Intranet/Internet technology.Alargepolyclinic hospital is used aas an example for illustration.
Keywordshospital network IS Intranet/Internet client/server browse/server accout
һ
żҽԺӦõ룬ҽԺԼϵͳµʶһ棬ҪϵͳɿԸߡߡӦ졢ȫԺãܹճҵҪһ棬ҽԺ侺漤ңҽԺҪԼͬʱҽͻʿҲҪϵͬ罻ļˮƽ
IntranetǲInternetĵλڲTCP/IPЭ飬Webɵ硣ǿӦù㷺ѧϰʹãά·㡣Ⱦ߱ͳλڲİȫԣ־߱InternetĿԺԡڶԵλڲӦṩЧͬʱϢ
Intranet/InternetҽԺļ罨УʹϵͳˮƽȽڶ̣ûһ£ûѵ٣رʺڴλһǧҵĴҽԺڽ϶̵ʱʵһƵҽԺϵͳǾൺѧҽѧԺҽԺΪ˵
ϵͳ巽
ҪʵһϵͳǱزٵģĻൺѧҽѧԺҽԺ¥AB¥¥¥ۺ¥¥¥ɡ¥ڣǲ˫߰貿ṹ׼ߣ¥¥֮о62.5/125ģӣȫ㼯СȫԺ1000Ϣ㣬12豸䣬¥Aṹ׼ƵĲϵͳ㣬ڶ˽ṹ
ĿǰǴӾϺʵԷ濼ǣɲ100Mʽ̫10M棬ǧ̫ATM
ͨ64K DDNרӵInternetԼվⷢϢṩInternetʷ
ӾϺϿǣѡ΢BackOfficeƷΪԼĺ̨ƽ̨ϵͳWindows NT 4.0ݿSQL Server6.5ʼExchange5.5WEBIIS3.0Proxy2.0еЭTCP/IP
ӦĿҪдͳĿͻ/(Client/Server)ʽȽ/(Browse/Server)ʽڱĿУǽַ߽ǵ
ϵͳʵʩ
ʾͼͼ1ʾ3COM Switch 3300ɽֱͨӵ¥豸3COM Switch 1100ϣ湤վռ10Mͨ·Internetؽܼؼʵʩ֡

ͼ1
1.IPַ뼰·ã
ʵ(ISP)IPַõIPַ10.82.128.3310.82.128.62Ϊ255.255.255.224ǵ·ͬIPַΪ10.82.185.2ֶ·IPַΪ10.82.185.1Ϊ255.255.255.252
·ѡCISCO2501·ụ̀
(1)̫E0ã
Interface ethernet 0
IP address 10.82.128.34255.255.255.224
E0IPַ
No shutdownE0
(2)ͬS0ã
Interface serial 0
Ip address 10.82.185.2255.255.255.252
S0IPַ
No shutdownS0
(3)·Эã
Router igrp 1IGRP·Э
Network10.0.0.010.0.0.0
··
(4)·ɱã
Ip classlessת·ɱ
İ
Ip router0.0.0.00.0.0.010.82.185.1
̬·ɱ
ⷢİ
ת10.82.185.1
2.ϵͳʵʩ
NTƷֱΪAccountServerSQLServerProxyServerǶдп3ȲUltra Wide SCSI 9GӲóRAID5ʽһ𻵣滻ӰʹáAccountServerIIS 3.0FrontPage98չExchange5.5ͬʱWebʼ512ڴ棬4PentiumXeonSQLServerSQL Server6.5ݿ512ڴ棬4Pentium  XeonProxyServerΪķǽIIS3.0Proxy2.0
3.ǽ
λڲϵļ˷ProxyServer⣬ԼڲIPַISPIPַ޹ءʹ150.150.1.1150.150.10.254Ϊ255.255.0.0ΪԼڲIPַΧ
ProxyServer䱸һIPַΪڲַ(150.150.1.3)һIPַΪISP(10.82.128.33)λڲInternetڲûҪInternetҪProxyServer,ProxyServer1GĻInternetķʣûInternetϵվҳ棬Ȳ鿴ProxyServerǷУֱӴӻȡأûͨDDNרߵInternetȥȡͬʱŵУInternetķٶȡProxyServerͬʱΪķǽԸҪ˳һЩɵİֻProxyServer¶Internetϡ
4.Windows NTã
Windows NTServerʺŵģǽIntraDomainProxyDomainֻдProxyServerProxyDomainProxyDomain(PDC)ͼIntraDomainAccountServer(PDC)֮佨ιϵͼ2ʾ

ͼ2
IntraDomainǱ(ʻ)ProxyDomain(Դ)ʺŶIntraDomainУIntraDomainûԷIntraDomainProxyDomainԴProxyDomainûֻܷʱԴͽһİȫԣʹߴProxyServerҲܶϵԴƻ
5.ʻԴĹ
ϵûҪݲְͬӦȨޡNTʺźԴĹԭҪûȫУȫҪԴıУ鸳ӦȨޡǾInternetշʼΪ˵
ϵûܶǷInternetIntraDomainнȫ飺InternetBrowseInternetMail飬ûInternetBrowseУշʼûInternetMailУڴProxyServerϽInternetBrowseInternetMail飬ȫInternetBrowse뱾InternetBrowseУȫInternetMail뱾InternetMailСWeb Proxy÷ʿƣWWWInternetBrowseȫƣFTPInternetBrowseȡWinSock Proxy÷ʿƣInternetMailƵķȨֻҪȫInternetBrowseĳԱܽInternetֻҪȫInternetMailĳԱշʼ
6.ҳά
ҪFrontPage98ҽԺҳҽԺɫҼ顢רҼ顢ÿӦרҡҽƷ¼ĿȵȡǵҳǶ̬ģݴǷڷSqlServerϵSQL6.5ݿУҳͨASPݿȡݡ
ڸؿҵļǿӦĸݿĿͻάԼйصҳݣﲿÿܽҵרŰ¼뵽SQLݿУͱ֤ҳʵʱ¡
ڲWebAccoutServer,AccountServerInternet˵ǲɼģʵְǵҳ?ҪĹˣڴWeb ProxyѡãWeb棬ΪAccountServerInternetϾͿԷǵҳˡ
7.InternetʿƺͼǷѵʵ
SQLServerнһһݿMSPнһMSP-LOG-TABLEǶWWWWinSockȴ־¼SQLʾ
CREATE TABLE MSP-LOG-TABLE(
ClientIPvarchar(32),ûIPַ
ClientUserNamevarchar(32),û
ClientAgentvarchar(128),
ClientAuthenticatevarchar(5),
logTimedatetime,ڼʱ
servicevarchar(12),
servernamevarchar(32),
referredservervarchar(32),
DestHostvarchar(32),Ŀ
DestHostIPvarchar(32),
DestHostPortint,
processingtimeint,
bytessentint,ֽ
bytesrecvdint,յֽ
protocolvarchar(8),
transportvarchar(8),
operationvarchar(8),
orivarchar(255),
mimetypevarchar(32)
objectsourcevarchar(10),
resultcodeint,
CacheInfoint
)
úProxyServerODBCϵͳDSNWeb ProxyWinsock Proxyʹ־ͨODBC¼ݱСDelphi3һѯͳɶûʱмල԰ڡûվ㡢շֽȽͳƣɶûмǷѡ
8.ӦĿʵʩ
ҽԺڲĿǲôͳĿͻ/(Client/Server)ʽȽ/(Browse/Server)ϵķУҪ漸ϵͳ
.żϵͳҺšշѡҩϵͳﲡ˹ϵͳ
.סԺϵͳҽڲ¼ҽԶʣҩҽҩֻ顢鱨桢ӰϾɼԶݡ
.ӰϵͳӰϼ鱨¼
.顢ҹϵͳ豸ֱͬͬĽ¼
.ҩƷϵͳҩƷ⡢⡢桢ۡ𡢲ѯȡ
.ʹϵͳ̶ʲֵ׺ƷƷƷȵĳ⡢桢ҵӵʹȡ
.ý嵼ҽϵͳָϡҽԺĲ֡ҵص㡢רҽڵسҩѡѡƷѵļ۸ȵȡ
.쵼ѯϵͳѯϵͳݣλռáչȵȡ
.໥ϵͳϿֻᣬEmailҽԺɫȼʱķȥ
һЩ¼ҪӦӦãտۡȡҩתҽ¼룬豸ϵĳӦãǲClient/ServerķʽDelphi3ǰ̨ӦóͨSQL linkͺ̨SQLݿӡ
һЩ¼١ʹԱ̶Ӧãýѯϵͳ쵼߲ѯϵͳϢϵͳȣBrowse/Serverķʽǰ̨ͳһͻˣDelphi3Ӧ÷һЩActiveX Form治Եùڵףѵ
ġܽ
1.ǵͨǽInternetģϵͳȫҪģӦϵguestʺŽֹԱûӦġҪúʺŹСȡЧڡʺŵԵȡڷҪֹIPתֻдϵIPַⲿɼġ
2.ϵͳԱԴȨ޹һҪúãҪγɰȫ©Ȩ޵ĹһҪNTԭ򣬽ûʺŷŵȫУȫŵУԱ鸳ԴʹõȨޣü¼
3.ϵͳؾ⣺ؾȷɢϡϵͳӦԼӿ졣
4.ϵͳǿҽԺģĲͬӻٷãҲԺ׵ǧ̫ATM
5.ѷProxyServer ŵУǿϵͳȫԡ
6.Cclient/Server  Browse/ServerַӦַǵŵ㣬ǵȱ㣬ܹڽ϶̵ʱڽƵҽԺϢϵͳ
ߵλ(ൺѧҽѧԺҽԺ 266003)
οף
1Microsoft Corporation Supporting Microsoft Windows NT Server 4.0 Enterprise Technologies
2Cisco Systems Inc Cisco 2500 Series Router Installation and Caonfiguration Guide
3Misrosoft Corporation ProxyServer 2.0 ѵ̳
4D.Solomon SQL Server 6.5 ָ
5ά Delphi 3.0 ŵͨ
ո:1999-10-19
