΢ͻӦ
WEIXINGJI YU YINGYONG
19993 18 3 vol.18 No.3



WebϢϵͳ
¸־ơΰ ʡɯ
ժҪʵʿϺ̨ϢϵͳW ebϵʵΪһݿϵͳĿϵͳṹԼص ڻWebIntranetӦк⡣
ؼʣC/SģʽIntranetWebODBCӿڡNCAJavaԡActiv eX
1
Ϻ̨Ϣϵͳһ׷ӳ̨ȫ̡ݸ๤ ԱʵְƵϵͳWindowsΪƽ̨Develop2000Ϊǰ̨ ߣOracle7.3Ϊϵͳݿ⣬Sun Sparc1000EСͻ96Ͷ ӳáInternetIntranetռԼWebѸٷչ֮Ϻ ̨ҵҪĲߣԭеϵͳԵáġΪҪԭϵͳĻ ϣֹתƵWebC/Sṹģʽϵͳ(¼Ϊϵͳ)
WebC/SϵͳʵǴͳĶC/SģʽĽһչͨΪģʽ ڶģʽУͻ˼GUIӦóģ飬ʱΪһ塣 ģʽC/SϵͳԭͻһӦóģGUIֿ֮ǨƵȥ ṹģʽƵϵͳ3ֹܷȷġ㡱ɡṹ ͼ1ʾ

ͼ1 WebC/SģʽĻṹ
2ϵͳṹ
2.1ϵͳ
1.ͻˡ486΢/Pentium΢Windowsƽ̨/Windows95ϵͳOracleͻ ͨ(SQL*Net,Easy Configuration)Develop2000ͻNetscape
2.WebCompaq1200ר÷Windows NT3.51ϵͳWebSite3 2λODBCOracleͻͨϵͳӦãҳ桢CGI ԼJava Applet
3.ݿSUN Sparc 1000E;Solaris2.0ϵͳOracle7.3ݿ⣻PL/SQL洢 ̡
4.ݿⱸݷߵPCWindows95ϵͳPersonal Oracleݿ⣻SQL *Plusݿⱸݳ
5.RASߵPC3COM 3C7208(8)Modem;Windows NT 3.51ϵͳRA S
2.2ܼ
1.ѯղͬûṩӦŽĿĲѯԵ̨쵼ṩʵʱ ѯŴ߱ƬĹܣʱ˽ĽչһIntern etûǵ̨ĳЩԱҲֻѯǰϢеĲѯ ʱ䡢εϣ֧ģѯ
ʵֲ裺
ٿͻ˵Java ScriptûĲѯкϷԼ(߼ļ) ȷΪCGIĲб룬ִPOSTWeb Ӧľ棬ʾûWebϵWebSiteӦCGI̡CGIȡ ļеĲ룬ͨмODBCOracleݿӣٽSQL ѯ ݿOracleݿִвѯCGI̡Webϵ CGI̶̬ɰѯHTMLҳ棬ͻˡûѯ 

ͼ2  Webϵͳ
2.Ƭ߿κεص㣬InternetԶ̷2ַʽIntranetݵ дűƬʱλĵOracleݿ⣬༰ʱؽиĸ塢Ƭ 
ʵֲͬϣֻ践زɹϢCGI̸ݿִ ɲͬHTMLҳ档
3.ͳơŽĿĸϢͳƣԱֱͼͼʽʾ 
ʵֲͬϣ3вͬ
١ԡOracleݿִйͳƵĴ洢̣ͳƽCGI̡ WebϵCGI̽ݿķؽΪ̬ɰJava Applet  õHTMLҳ沢ͬһͻˡûнӦ¼ Java Script򣬿Java AppletĹûҪͼ
4.ȫ֤ΪʹϵͳҪİȫԣΪÿԱṩ1 ûݹҪ費ͬȨޣԱ쵼ߵ(Ȩ޿ )
ʵֲ裺
ûϵͳ¼ҳУдԼûΪCGIĲб룬 ִPOSTWebWeb֤CGỊû ʹõĹ뼯дWebϵûȨޱбȽϣȫ ʹӦĹܣܾ¼
5.ܴInternetûдȤƬĶıÿһʱ 䣬ݿ⣬һƬE-MailʽƬݷI nternetû
ʵֲ裺
InternetûںжıҳдԼE-MailַԼԼȤ Ƭʡʣ͸WebWebûE-Mailַ 붩ݿ⡣ÿһʱWebϵJSSܴ ݿ⣬һƬûE-MailķʽƬݷI nternetû(ڿ׶)
6.ĸòʼӹԱȷ񣬳ʵĵ ֽ칫ƪĲ
2.3йؼʵ
1.ĿǰWebӦʵݿӵķʽ൱࣬磺JavaCGIMicrosoftISAPI NetscapeNSAPIȡϵͳվʹCGIΪCGIҪʱżأ ͷţҲݿ(ԵٶȽʱռԴ϶)Ȼ Ƚ϶ ԣCGIӦüΪ㷺Ҳʮֳ죬ͨԡϵͳпCGI ʹVisual C++дʹWebSiteṩCCGI࣬MFCйݿʵ 
2.Java ScriptһӦض¼һڿصͻ˵Acti veXJava AppletԵʮϵͳͼJava AppletVisual J+ +дJava Script£ûнûԺַʽ ActiveXJava AppletڱJava ScriptVB ScriptƵķԱ ǹ(Public)ġ
3.ϵͳиûûӦȨļʽдWeb ϣά͹
4.ͳWebҪͻHTTPWebӦȻַʽ ӳInternetûȴӦʱ䡣ǾʹPUSHJSSһʱ ѯݿ⣬ԷE-Mailķʽؿͻˡַʽʹɱ״ ̬תΪ״̬˿ͻĿĵطWebƵʣIntranet ЩʵʱԲߵϢȫ縺ؽҹ賿Уһƽ ĸأϵͳܡ 
3ϵͳ
1ģϵͳı׼ֱӵķǿɱܵļ۸ȣӦԾ ܵ͵ĳɱʵ־ܸߵϵͳܡ
3.1ϵͳɱ
ڱϵͳ˻WebC/SϵӶ󽵵ϵͳڰװáά͹ϵ ɱһ棬¼Чĸ߿ЧʣֽһѹϵͳĿ ɱ
ǰֳһ¸Network Computingͻ˽ʹõõNCNPC ϵͳĳɱһ١ˣڽϵͳʵУܿʹô˽ṹ 
3.2ķ
ӰϵͳأԴӲͼģʽȷǡڸӲ 滮ڼѾȷѡõOracleͨȷװú Ҳдͻơˣֻͨƽ޶ȵϵͳܡ
ģʽ˴ͻ/Сͻģʽ˼ģʽ/ļģʽC/Sģʽ(ͳ ģʽͻWebģʽ)ģʽʵǼݻ 
ȫɷеȫɿͻ˳еɿͻˡֵ ϵͳе
ˣݿWebͻмĺʮҪ 乤ҪݱĴ͸ĸ()
жϵͳܵҪ䷴ӦٶȣϵͳӦٶȵĹؼͨ ӵWANϹ˶ᡱWorld Wide Waitı ȻʹǸߴLANݿϢƵʱҲϵͳƿ ܵϵͳ̱
ĸ޵ģʹǸ߶˷ƵʱҲ ӦˣֻͨЭ޶ȵطӸļ
Ϊ˱ڷݿΪ1ʾļģ顣 
1ݿģ
ģ
(ݺϷԼ)ݿȡģģ
(ͼλʾ)
ģ
ݿݼģ
ݿݼģ
ֵһǣϵͳǸݷ2ԭ򡪡ٵռ ƽأпƵġ
1.ٵռ
(1)ģӦڿͻִм㡣ΪòȷͨWeb  ṩݺϷԼ飬ٽϢWebؿͻˣ  ЦġʹWebϽݺϷԼҲȫûбҪġΪǶHTMLҳ еJava ScriptԻVB ScriptȫݺϷԼĹ ڼһЩӵ߼ϵͳJava ScriptڿͻģĹ 
ȻԱWebصͻҲռһִȻǽ һС֣Զôϳ۳Ҫöࡣ
(2)ͼʾ֪ݿݼģݿĲϽдá  ΪӦüڷУͨݼΪ򵥵ĿͻͷصĽ ǴSQLõݣӶʡ翪ڴݵļ㣬˿ ൱ɹˡʹݿṩĴ洢ݿݵļ 㹤һ˵Webݿ֮ͨԸ·ӣλ ͬһ̨ϣˣģϽдɡ
(3)ݿݼģ飬Ϊ޹أ˿κβϽд
(4)Java AppletʹJDBCΪݿӿڣģ顢ݿȡģһ WebݿϽдΪ͹ϵݿݿⶼܽϺõ ֧Oracleṩ˴洢̡ԼROLLBACKCOMMITSAVEPOINT ֧䡣ˣΪݿЩΪʡ
(5)ģڿͻ˻WebϽдȻĽͼΣ ͻ˽дʵϵͳģʱǵӦͼͼԴļϴ صͻ˱Ȼռ൱ĴǶHTMLҳеJava AppletҲڿƣ ûĽ˱ϵͳõķΪͼActiveXؼ Java AppletǶHTMLҳ棬ͳƽӦĲһ𴫻ؿͻˣҳ еJava ScriptӦû󣬽ActiveXؼJava AppletӦĿƣڱ ͼ
2.ƽ
ĿǰIntranetӦõĻ͹ģϸضԣڳΪϵͳƿ ˾ٵռӦΪĵһԭ򣬶ֻ һԭ£ſɿθõƽء
IntranetķչƶԣڲõĽWebܽԽԽĿͻ˷ ٽݿ޹ص㹤ҲִУؽWebĲظ ֮£ͻCPUٶȻRAMӦ˵GUI ๤ˣηֵWebĹӦΪƽ⸺ص֮ء
һֿеķǣݿݼģģActiveXJava Apple tʵ֣ WebҪʱصͻִУӶWebĸأ ͬʱݿݼģģݿ洢̻򴥷ʵ֣ ݿִУӶһWebĸء
4
ϵͳ˵ǰһЩµWebӶʹϺ̨ĵĹԱIntra netϷݿⲢӦķ 
ߵλϺͬôѧ(200092)
ο
1Raggett,Dave.Hypertext Markup Language Specification Vers ion 3.0.http://www.hp1.hp.co.uk/people/dsr/htm13/CoverPage.html
2Bobrowski S.Oracle8 Architecture.http://www.oraworld.com/EX0001C.htm
3Levin R.Java For The Enterprise.http://techweb.cmp.com/iw/660/60iujav.htm 199712
4WA's Ultimate JavaScript Tutorial.http://www.abstract.simplenet.com/javasc ript1.htm
5Strom D.Creating Private IntranetsChallenges and Prospects for IS.http://ww w.strom.com/pubwork/intranetp.html,199511
6⣬Ӧ.ORACLE 7Ӧÿʹֲ.㼼о ༭̫˾༭.
7ǫعȪ.Webָ.еҵ磬1996
(ոڣ1998-09-02)
