΢ͻӦ
MICROCOMPUTER & ITS APPLICATIONS
2000 Vol.19 No.3 P.45-48



3ṹҵϢƽ̨ķо
ï
ժҪ˶3ṹϢƽ̨UnixϵͳµORACLE WEB SERVER 2.0WINDOWS NT4.0ϵIIS4.0(Internet Information Server 4.0)Ӧʵ,3ṹʵԺͿѧ,һЩѵĽ
ؼʣ3ṹ ҵϢƽ̨ ݿ
2080Ŀͻ/Client/Server,ΪC/SṹӦ,ǰݿ⼼Ӧ÷չġ1ӵӦúֱ۵û,㽻˺̨ȥ,ûӦٶ,Ӧÿ,,ݿӦ˽ϴƶá
ϢĽһչ,C/Sṹ¶һЩ,ͻҪװ,Ҫϸߵ,ͻ˵άƵ,ûҪרѵܲ,ϵͳгɱһֱ,ĳ̶ֳӦ÷Χ,ԭC/SMISиĽΪ,ǽĿǰе3ṹӦ,ȳԭԴ,ųԭϵͳı׶,ﵽѧԡʵԺ;ͳһĿġ
1 3ṹ
Internet/Intranetķչ,Ѳھ̬Ϣ,ʼWebݿ,γ˻ݿWebģ,ּģӦõInternet/Intranet,ճΪ3ͻ/Ӧýṹ˵,ûݿ,Ҳû3ṹӦá
3ṹʵϾҪWEBC/Sģʽ,ѴͳC/Sģʽеķֽ1Web1ݿ,ͼ1ʾ

ͼ1 3ṹͼ
3ṹֵ:1Ǳʾ,Ҫûͺ̨ĽղѯܡͻURLUniform Resource Locator,ͳһԴλָWeb,,WebHTTPЭļϴ͸û,ͻ˽ļϢ2ǾCGIODBCӿڵWeb,ڹܲ㡣Ҫ÷ɿͻӦùܡWebܿͻ,ҪִCGI,ݿ,,󽫴Web,Webͻˡ3ݿݲ㡣ݿܿͻؽи㡣ڴȫݲ,ܲ㷢仯Ӱ쵽ݲĸı,,3ṹӲ仯ʱӦC/Sģʽ2ṹǿö,иǿĿԡ
2 3ṹĿƽ̨ѡ
ӦϵͳԺ̨ݿķ3ṹĿеĺ,ͨ,ԼӦʵ,ȷ2ƽ̨,ϸܡ
2.1 Oracle Web Server2.0¼Web2Ӧ
ԭMIS,ݿƽ̨ѡOracle,ѡ3ṹƽ̨Web2,Web2Oracleݿ⳧1996ƳרWeb,WRBWeb Request Broker,Web,ֻ֧OracleݿWEBӦáWeb2һܡ̺߳Ͷ̵HTTP,ֱͨWRBṩ̬HTMLҳ,WRBеķչΪ1ĽִСͻֱӷֲOracleִждCGI
2.1.1 Oracle Web Server2.0Ĺ
Oracle Web Server2.0Ĺԭʾͼͼ2ʾ

ͼ2 Oracle Web Server2.0ԭͼ
1Web,ų̂ӦõURL
2WebWeb Listenerû󲢽з,ֻһ㾲̬ҳ棨ļǣ.htm,üתsimply Dispatcher,һͨļϵͳҳ淵ظûWebWRBͳһԴλȱʡĿ¼/owa,ִ͸WebתWRB Dispatcher
3תͽWRBִ棨WRBXs,WRB Executable EnginesĽ̳ͨšת1еġóҪWRBִ,ִȨ,ǼܽղȷͳһԴλЧ,ÿ1󱻴ݵںִ̨иĽ̡
4ÿWRBִʹWRBӦñ̽ӿںWebWRB CartridgeӿڡWebPL/SQLAgent CartridgeJAVALiveHTML̿չ
PL/SQLPL/SQL Agent:ִд洢ݿеPL/SQLJavaŻ˶ݿķ,Javaȫܡ
Java:ڷִJava̬Webҳ档ʹԴJavaִPL/SQL
LiveHTML:Oracleڹҵ׼ãSSI,Server Side IncludesܵʵʩչLiveHTMLԽûϵͳеκγûWebҳ֮С
5PL/SQLִд洢ݿеPL/SQL,ݿظû
ʵʿӦ,ҪĿ:
1ݿļDCDDatabase Con-nection Descriptor1ͳһԴλURLPL/SQLʱָӦݿӵļ,ļ1Web Serverάϵͳļ,ļṩݿӵûݿһЩݿҪϢļPL/SQLִиʱ,ܷһݿԼܷݿеһ֡ͳһԴλиļ,PL/SQLͰļṩݽá,õDCDļǡglxx,ôͳһԴλӦ:http//servernameַ/owa/glxx/package_name
2OracleݿִеPL/SQLPackage,ʹκı༭,ð,һֶݿв,һֽHTML׼ʽתɿɹҳ档
3Oracle SQLPLUSвɳϵͳӦù,ظûHTMLļ,ļ
2.1.2 Oracle Web Server2.0Ӧ÷
1Web2ϵı˼·Oracle,Oracleٶȿ,ԶOracleӦܼ;ͨOracleĿ˵,ѡWeb2Ϊ3ṹƽ̨һѡ
2ݿOracle7,ͨWeb2иЧʵķʱ,ϵͳɿԺȶԲڶû䲢ʱ,ײͷŵĽ,󽵵˷,ܵݿֹͣ,Web2һ㡣ѡOracle8ûзϡ
3Oracle Web ServerֻܹΪOracleݿṩWeb,ʵӦWeb Server칹ݿķ,һĲ㡣Ӧó޿ֲ,ݿƽ̨,Ӧóϡ
4Oracle Web ServerϵͳӲƽ̨Ҫϸ,ϵͳгɱϸߡ
5Ӧϵͳ̸,Чʵ̬͡ҳνӲơ
2.2 WEB SERVER IIS4.0Ӧ
IIS4.0ASPActive Server pagesӦWindows NTƽ̨,ûݶADOActiveX Data ObjectͨODBCOpen Database Connectivity׼ݿʶݿ,ͲϢģʽWEBӦõԽԽ㷺
΢NT 4.0IIS 4.0,为տͻ˵WEB,ÿһ,ӦIIS 4.0 Webӵݿ,ͨIIS 4.0չӦóASPԼɶԸԴзʵĻݶADOʵֵġ
Ӧõص:ADOԶ̬ӿ⣨DLLʽ,ͨؽӿڣCGIΪĶ⿪,1DLLڵ1յʱװ,Ȼפڴеȴ,幤:
1Web,ų̂ӦõURL,Web
2Webжû,һľ̬ҳ棨׺Ǣ.htm,ڷļϵͳҵҳΪսظûûǶڷִеĽűԵĳã׺ǣ.asp,ӦASP,̬ҳ淵ظû
3ASPʹADOɶԸԴĴȡADOΪWeb˵һչ,WebӦóĿԱд˵ĽűչWebӦóWebõǺSQLĳʱ,ɸöҳǶSQL,ݿⲢشϢ,֯ɱ׼HTMLı,ظûûõҳв<% %>,ҲSQL,Щѱмִнȡˡ˵ĽűһVB Scriptд,Щø߼ԱдĽűڷִ,ǲκοͻ˵Ĳϵͳ
4ڷ˻VB ScriptADOҳ档岽:ADOеADODB;ADODB;ڴ򿪵ϴݽ,ݽݽв;رӡ
ӦóݿķͨݿADOʵֵ,ҪWebݿ֮ĻỰ,ݿĵ,SQL﷨Ч;ΪSQL򿪹꣨Cursor;WebӦóеıճݿĴ洢;˵Ҫֶε,ЩֶԷݽṹеֵΪ;ڹ洢ռִSQL;ȡ1WebӦóҳ;رչꡣ
һСγ˵衣
Set conn=server.createobjectADODB.Connection壩
Conn.open info_source,orauser,orapasswd
Set RS=conn.exexcuteselect  from authors壩

Conn.Close
ɼӦϵͳͨADOݿķʶʵֵġһ,ADOֱӶݿ,ͨODBCԴķʵֶݿķʡͨODBCӿڵɡҪʲͬݿֻ贴ӦODBCˡһ,Ϊṩ˼򵥡׼͸ݿӵĹ̽ӿ,ݿ⳧̸ODBC׼ȥʵָԵײ,ݲͬݿϵͳòͬļŻʵ֡ODBCΪ칹ݿĻṩ˱֤ODBCĹ:
WEBWINDOWS NTϰװݿODBC,ODBC⹤ݿǷͨORACLE ODBC TESTڿвο1ODBCơ
1 Microsoft ODBC
Microsoft ODBC for Oracleװ
Դ(N)glxx
(D)Ϣ
û(U)useriis
(S)Ora8

ѡƽ̨ŵ֮һADOṩ൱ݶ,˵VBűҲṩ൱CGIӿں,ӦϵͳܵʵֱȽ,ԽӦóֲݿƽ̨С̱ȽϷ,ûнϺÿ,ٶ
3 ϵͳеļ
3.1 ⣨
ʲô߽3ṹĿ,Ǳһ,Ͻԭʼ⣨ṹ,ԵЩٶˡõķC/SµĿæǾѡPOWERBUILDER,ٶȿ,ر򵥡
IIS 4.0 WEB SERVERҪװOracleͨSQLNETNET8,пֲʾ,Ϊװѡ˴ַ¡̨Oracleݿʹõַķ:WIN NTע༭REGEDIT,ѡHKEY_LOCAL_MACHINE,ѡSOFTWARE,ѡOracle,ȻѡNLS_LANGԵĹ֧֣,ͷַͬ˵ַΪAMERICAN_AMERICAN.US7ASCII,ڴҲˡ
3.2 ѡFRONTPAGE98ҳ
õĿ߿ԴӿϵͳĿ,Ϳɱ,ӰӦϵͳڵҪءASPĿ,ĿǰûĹߡһЩFrontpage98,Ա༭HTMLҳ,ʵֺͺݿ֮ĸӽIISϵĿ,Frontpage98дҳ,ٽVB ScriptǶ,ʹҳ,ܷݿ⡣
3.3 WEBҳ֡Frameʹ
ʹ֡ʹ沼ָӺ,õӾЧڿҳʹõһ:
<frameset rows=20%, frameborder=0 framespacing=0 border=1 >
<framesrc=glxx01.aspt name=Buttons scrolling=AUTO>
<framesrc=coverpage.html name=Main scolling=AUTO>
</frameset>
Webҳֳ2֡,֡ҳռҳ20%,֡ҳռ80%ϰ벿ûԻ,°벿Ƿصҳ,ͳƽ粻ȡ֡ʽ,û˳ҳ,ٽҳ,ӰЧʡ
3.4 3ṹϵJava
JavaѷչΪInternet/Intranet칹绷ŵĳ,ҪJavaСӦóJava AppletƸͳͼ,Oracle WEB SERVERIISṩ,Щ,JavaԱͼ,J++̡
ͳֱ۵ķʽǸݻ,߿ֱͼͼڻʱ,Ҫǻ㷨ͨ,ʾݵĴС͸ݷֲܣÿһݶͬ,þʾ,ҵ1ʵֵ1Եֵ,Ҫݵʾ,Сݿͽӽ,޷ٽбȽϡ,ꡣY,ѡһ,ĸ߶ǹ̶,ȻֵYĿ̶,Ƴݵĸ߶ȡX,ÿݵĸX̶ȡõķ:ͳHTMLparamעṩ,ͳƵݸû;ݵĸģȡ̶ֵȵXY;߷ÿݵͬʱõֵ,ֱͼʾÿݵֵ
3.5 ϵͳİȫʩ
ϵͳİȫԿԴӶǿ,һʹWebṩİȫ,WebķʻȷIPַͺϷûûڷʱṩûͿ,һ濪ͨӦϵͳӰȫԹʵ֡ڱϵͳͨݿӺϷû,¼ϷûĵλϢ,ԱӦóݵĵλԻ,:
1û뵥λơû,ҽֵи,ȻύWeb֤ûĺϷ,URLʾû
2WebѯݿкϷû,֤3ȷ,ṩûʹý档
3ûתȥʹҳ湦ʱ,Web𽫼ܵûϢ1ҳ,ҳִʱ,ͬҪ֤ûĺϷ,,ûʹøҳܡ,ҪǵWebɢȱ,ֹǷûм롣
ïϣɽʡӪʤʯ͹Ϣģ257001
ոڣ1999-09-20
