Ӧо
APPLICATION RESEARCH OF COMPUTERS
2000Vol.17No.5P.74-77



WebάѯϢϵͳʵ

ժ  Ҫ  Եǰάҵڵ⣬üInternet/IntranetWebάѯϢϵͳΪάҵЧ
ؼ  Internet/Intranet  Web  άѯϢϵͳ  B/Sģʽ
1  ǰάҵڵ
ٴѸٷչµĳ͡µĹԽԽ࣬ȫ15100Ʒ֣3,000ֳÿÿ7·ݼƳһ³͡Ŀǰҹ600֮࣬ͬʱϵͳ渴ӡȼ䡢صװáٿơŷſơơѹơʾϡùʧЧԶECTASDٷϵͳASRװABSǣTRCTEMSѲơȫSRS״ײװáյϵͳԶΡſءؼ๦г¼ʹԶϢӵͼϵͳͨѶϵͳȡĿǰв˵ʲôȫͨϳ۵ģӴһҪ˵Щļϸڡ
ڴάҵ״ҹάҵ22ҴСάҵҵԱԼ200ˣרҵѵͽϸĻĹ̼Ա3%άԱĻʽϵͣҼṹּңۺųϵϲС޳ɴϣֲ޳ۺϹϡάԱرרҼάԱȱǶάҵʧȥģԱʺͼչĲӦʹά޷ߡ
۴߸ȷ˽⡢ʹ³¹ܣǼٹϵҪ;Ծߵ鷢֣Լ80%ϲʹ磺ԶO/DأģʽѲƵ¹ܡ򳵺ҪͷʼѧϰһЩĻԭά޼ɣһûⷽĽһҲеʻǧ޷Ԥϡ
ڹڷŸĸ￪ŵķٷչҹϵش仯һǽڴȽǹҴҲҪȽ£еҪǵάҵת۵㣬ҪĥΪݵĹת䵽ѧʵʵĿɿΪݵĹҪӶڽΪת䵽Բⲿϡ
Էϵԭ򣬳ά޵ļضȱͺصӰ˳άС޵¼ʱ
޼ȱִĸԴߣΪ޳رĹߣѧϰʹȽҲΪҹάԱҪ⡣
֮ӻĽ̵ķٷչܻʱķչάޡʹõǰδеĳά޶󣬾Ӫģʽά޹˾޴ı仯䱾άͺȰϢͺҲϢͺ
أӿ͹ϾҪһµάѯģʽҪʱΪάԱṩֳǧļϢ˷άԱʵͣɵЧʵͣɱߵı׶ˡͬʱΪṩЧѯ
ԼΪģ硢ݿ⡢רϵͳý塢߷ҵȽļʽлϣγɵۺѯϵͳӭս
2  WebάѯϢϵͳ
ͳҵNovellWindowsUnixϵͳΪľڲнǿϵͳԶ̹ԶϢͬϢȷԵȱݡInternetѳΪȫɹͨ磬ṩEmailFTPWWWNewsGopher߷ǿܡWWWȫͼλĳıӷʽṩѰԴķ㡢ͿݵĽ
ص㣺IntranetڴͳҵϣInternetTCP/IPЭΪWebΪӦãͳһͱϢƽ̨Web缼IntranetҪʽ١ά򵥡ûʹ÷㡣
Webƽ̨IntranetϢͽʽϵԣڲĻⲿġͬҵϵͳ֮ϢΪͼïĶýϢͨͳһṩѯϢ˫ġչϢԴõȡWebƽ̨CGI(ͨؽӿ)JDBC(JavaݿӼ)ISAPI(InternetӦóӿ)ԼݿϵͳеĹߵȶֿߣHTMLҳҵݿ֮ӣSQLʵֲѯݿ⡣
ֻڲϢⲿϢǴͳϢϵͳ(MIS)ľڣһƣIntranetѸٵõռӦõҪԭ֮һIntranetҵϢϵͳһȫµļģʽWeb Browser/Web Server(B/S)ģʽB/SģʽֲͨṹWebݿͼ1

ͼ1
B/Sģʽʵһն/ϵͳĽṹģʽͬʱ־пͻ/ģʽķֲԣصǼйҲ˵ĳݿԼһЩڷˣû˳(Ĳϵͳ)֮صĹάûҪѯϺʹӡĵݶͬһݿ⣬Ӷ֤ݵļʱԡӹĽǶȶԣάԼݿıݺճάȶڷ˽С
3  Ӳϵͳ

ͼ2
4  ϵͳ
4.1  绰ϵͳ
1)ʹóʶ
(1)Զʹ
(2)ABSʻע
(3)еʻע
(4)طʹע
(5)аȫSRSϵʻע
(6)װзϵͳʻע
(7)װиߵϵͳʹע
(8)Ѳϵͳʹóʶ
2)άʶ
(1)άʶ&middot;
(2)ϵͳάʶ
(3)תϵάʶ
(4)ʻϵάʶ
3)ִѯ
(1)Ӧʩ
(2)Ҫѯ
4.2  άѯϵͳ(B/Sģʽ)
1)Ϻά޳ѯ
2)ܡλѯ
3)ϵͳ·ѯ
4)ͼѯ
5)άѯ
4.3  ѵϵͳ(B/Sģʽ)
1)糵ԭγ̣
(1)緢
(2)Զ
(3)ABSSRS
(4)װáյ
2)糵άγ̣
(1)緢
(2)Զ
(3)ABSSRS
(4)װáյ
(5)Ǳʹõ
3)ֳϵרάγ̣
(1)ﳵϵ
(2)ͨóϵ
(3)سϵ
(4)ŷ޳ϵ
4.4  ά˲Źϵͳ(B/Sģʽ)
˲ŹϢ
4.5  гѯϵͳ(B/Sģʽ)
1)Դѯ
2)ļ۸ѯ
3)ѯ
4)Ľṹѯ
5)ɴѯ
4.6  ά繤(B/Sģʽ)
1)ά鷢
2)ά
3)ר
4)άݿ⽨
5)ר֧ϵͳĿ
5  ϵͳƽ̨ѡ
IntranetϽWebϢѯϵͳ¼ؼ⣺
WWWƽ̨ѡ
ݿѡ
WWWݿĻ
WWWӦõĿԡ
WWWƽ̨ĿǰõWWWƽ̨ܶ࣬磺Microsoft˾Internet Information Server (IIS)ϵСNetscape˾Enterprise ServerFast Track ServerϵСNCSAȡӼѡMicrosoft˾IIS3.0ΪάѯϢϵͳWWWƽ̨
(1)InternetվWWW
Microsoft˾IISϵWWWMicrosoft˾InternetϢҪȻֵʱȽǷչٶȺܿ졣Ŀǰںܶеõ˹㷺Ӧá˾ƷȣMicrosoft˾IISϵWWWµŵ㣺
İװá򵥣գ
Microsoft Windows NTϵͳƽ̨ϣкǿܣ
Ժãֱ֧׼HTTP 1.0ԼЭ飬֧CGIWinCGI淶ԿWWWӦã
Microsoft˾ƷVisual Studio97SQL ServerInternet ExplorerIndex ServerExchange ServerTransaction ServerȲƷԺãЩƷԺIISʵ޷켯ɣڿӡЧӦϵͳ
Microsoft˾רſһInternetӦóӿ(ISAPI)ṩ뿪ֶΣ
Microsoft˾OLE/COM淶ԲActiveXؼĹܣ
ṩInternet Database Connection(IDC)Active Server Pages(ASP)ȸЧߣڿWWWķӦϵͳ
(2)ݿ
ݿϵͳѡMicrosoft SQL Server6.5Microsoft SQL Server 6.5һġݿϵͳרΪֲʽͻ/㻷ơݸƹܡǿĹߺͿʽϵͳϵṹΪϢṩһ׿Խƽ̨Internet/IntranetܼɡSQL ServerWeb AssistantԶHTMLʽϢԤŵױWebҳΪ¡SQL MailʹSQL ServerͨMicrosoft ExchangeͺͽյʼSQL ServerExchangeļС
(3)WWWݿĻ
άѯϢϵͳInternetվ㽨ݿΪĵInternetվ㡣ΪʵάѯϢϵͳInternetվ㽨蹤̣ǸֻWebĹϢϵͳʵWWWݿĻʵߵĻҪּ;
ʵĿߣʵֻ
ݿṩרϵͳʵֻ
Ƚ϶ԣǰһַӦԸ㣬һַѯҪǰһַǲMicrosoft˾IISΪWWWˣ˲õڶַʵWWWݿĻÿһַʵֻ϶ʹõһЩWWW似ʹWWWִһĳЩʹݿӿݿʵֻ
Ϊ˴ﵽͨԣ󲿷̶ֳODBCΪݿӿڡODBCMicrosoft˾Ƴרʵݿ⻥һͨýӿڣýӿͨͼ3ķʵжԲͬݿķʡ

ͼ 3
Microsoft ODBCʵODBCĹҪODBCԴĹʹODBCĳʹضԴȥݿ⡣ݿODBCճ󣬲ʵͨųݿͨţݿеݿⱾִг󣬲ظ
ODBCŵͨԺãû򲢲Ϊʹõݿⲻͬ޸ģ߿ЧʺͳĿԣϵͳҲܼ㡣WebάѯϢϵͳODBCΪݿĹߡ
SQLǷݿʱʹõһֽṹѯԣIBM˾ĿǰʹϵݿѯԡSQLԲӢ﷨ṹգеݿ⳧̶֧SQLԡеĳΪϵͳܣSQLԽ˲̶ͬȵ䣬γһּ򵥵ıԡʹODBCݿʱΪϵͳļԣֻʹñ׼SQLԡ
(4)WWWӦõĿ
WWWӦָûʹͨͿеӦộҪûװضĳǴͳClient/ServerģʽһشĸĽַʽԴٿԱάͬʱûʹʱҲ١
ڿWebϢϵͳάѯϢϵͳǲMicrosoft˾Active Server Pages(ASP)ΪߡASPMicrosoft˾IIS3.0ƳһWWWӦÿߣ츴ӵWWWӦáASPʹOLE/ISAPIӿڣӿMicrosoft˾ڿInternetӦʱı׼ӿڡ
ASPṩһֳֶ֮⣬ṩһڽԼЩ벿ɷǳǿĹܣݿӡļʵȹܡͬʱûµĲضҪ
ASPö¼֣
ServerһЩصҪWWWĹɲʵCGIȹ
RequestռûеϢԼûһЩϢ
Response󣺿WWWûӦ̣
Application󣺴ĳһضӦҪûϢ
Session󣺴ĳһλỰУûһЩϢ
ASPò¼֣
Ad Rotatorʵһ򵥵ĶЧ
Browser CapabilitiesûļԾΪ
Database Accessݿ⣻
Content LinkingWWWӵһֹߣ
File Accessʷļ
ĶͲṩһܷĿڻWebϢϵͳҪݿʿؼɸÿؼʹODBCάѯϢϵͳڲĺ̨ݿݿĲ
6  
ùеInternetЭWebWWWķʽʵάѯϢּĿǰµļֶ֮һмࡢЧʹ÷ص㣬õĿԡάԵŵ㡣ˣۺѯϵͳΪάҵЧṩ
(ְͨҵѧԺ   350007)
(йڵӼ޹˾   350001)
ο
1. ΢ҵӦչ. ά, 1998, 6
2Ӣ. ҵġרһ, ά, 1998, 6
3Microsoft Corporations, IISASP˵ĵ
4ODBCʹôȫ. : 廪ѧ
5SQL Server 6.5ָ. : 廪ѧ
ոڣ1999-12-3
