Ӧо
APPLICATION RESEARCH OF COMPUTERS
2000Vol.17No.5P.78-80



WebϵĶ̬ҳо
ƵܡѦСƽ
ժ  Ҫ  ĿǰInternetչƳWebݿϵҪԽԽձ飬ͳĿCGIѣЧʵͣ£΢ƳASPпԡײԡЧʸߺŵ㡣ASPADOݿв
ؼ  Web  CGI  ASP  ADO  ODBC   ݿ
1  
Internet/Intranet淢չʹҵϢѾʶIntranetƣʹݿWebӳΪݿ⿪ż֮һ
Ŀǰҳ󶼱ṩʽĲʽҳҪݿ⼼ͳĿCGIѣЧʵͣ£΢ƳASPASPطݿ⣬ңASPڷϽִеģԣѡضʹASPи㷺Ӧ÷Χ
2  ASP(Active Service Pages)ķģ
ΪIISһɲֵASPһWeb˵ĿԲж̬ġġܵWebӦóASPʹκScriptԣֻҪṩӦĽű(Engine)ASPṩVBScriptJava ScriptASPԽִеScriptֱǶHTMLļHTMLScriptͬһ̾ͿɣͨActiveXؼʵַǳӵWebӦá
ASPһ޹صӦÿлӦÿ߿԰HTMLActiveXȽһ𣬴Ӷһ̬ĹǿWebӦϵͳ
ASPActiveXеServer˼볣ڿͻʵֶ̬ҳļJava AppletActiveX ControlȲͬڿͻ˲Ҫ̡ASPеScript䶼ɷִеģִнĶ̬Webҳ潫͵ͻ˵Scriptִ(ͼ1ʾ)ASPڷ˽ִУ߿ԲؿǷ֧ASPͬʱڷִУҲصıسӶȡ߼

ͼ1̬ҳģ
ASPļ൱һִļ˱WebпִȨ޵Ŀ¼¡WebASPļʱASPͨASPõĶͷʹã߿ɷǳӵ񣬶ûñ˿ķרŵ
÷˵ScriptHTMLԺ׵ɶ̬ǹޣ粻ӷݿ⡢ʹ繦ܻʷļϵͳȡCOM(Component Object Model)ͨCOM׵ʹCOMֶWebɹCOMǷһ൱һṩԺͷʹ÷Դҷ֧ActiveXκεASPԴֱʹãɴ󲿷ַ˵Ĺ
3  ASPĻ
ASPṩҪݿ(ADODB)ļASPͨADODBݿв
ASPΪOLEԶ(OLE Automation Servers)ھƺΪһӦóһûСЩûڲűйչϵͳЩչĹܽбܡASPԹMicrosoft˾ĹϵĹԼ׼ϣҲֱʹASPԴĻActiveXݶ(ADO (Access Database Object))ļϵͳ͹ת
ActiveXݶ(ADO)ṩκODBCݿOLE DBԴĸӡADO翪߷ؽһݿһҳӣԱȡͲݡ֧ݿWebӦó򣬲ϵͳ硰ǰ˴
һURLûʹӵĹԶԼݱԵǰWebҳӡб洢ϣһҳԶ̬عţƻӡӡɾƶҳҪбļжҳеûڵҳ϶HTMLļб༭
ļϵͳļϵͳṩһִȡʽɶԴ洢ڷıļĴȡַͨʽдԼĴ뼴ļϵͳϴ򿪻رļΪűԲֱӴȡļַǳá
ͨʹһASPļԶԿͻʹõĹ̬ܽ֯ɲֺݵŻȷWebmasterΪÿһϵظҳ
תתҳϼԷرõĹ沿֡ͨһͬбʾȨԱÿζASPļһ󣬿ͨʹڵǰı׼ʾһ档ҪЩõASPڽ
ASPõķӦó򹹽Щʹ߿԰ѺܶෳĹȡԿͻϸڡӦó״̬͵ȡЩڽ
RequestResponseRequestṩ˶κHTTPתűϢĴȡа塢URLѯHTTPйϢResponseϢķаҳֹʱHTTPȫؼ
ApplicationSessionЩ״̬Application洢һضӦóϢSessionڴȡһضûϢASPһǳõԣWebmasterͷ۵⡣ApplicationûԶWebӦóԽãԱڶûʵϢ⣬ͨLOCK()UNLOCK()ȷûͬʱ޸һԡSessionֻҪûͬһУWebӦóеҳ֮ʱ洢SessionеıʼЧֻе񱻽ֹ߱ʱŻٻһӦSessionSession;֮һ洢ѵ¼ûȨޣͿԷؽWebӦóİȫ⡣
ServerServerűActive ServerʵµĹܽжASPչServerӵҪMapPathCreateObjectMapPathԽWeb Server·ԭʵ·CreateObjectҪһɲĶʵServer.CreateObject(ProgID)ProgIDָ˹ʶEXEҲDLL̬ӿ⡣ЩڲϵͳעCOMŻϵͳϿ(Registry)άЩϢ
ںܶ£ΪʵԵӦãҪõݿⷽĲADOʵֲҪֶΡ
4  Ӧʵ
(1)Ӧÿṹģ
WebӦϵͳģʽṹԭͻһӦóģGUIֿŵϣγṹϵͳķӦٶȿ졢пɱϵͳĿֲԺáṹ£
һΪʾ㣺ɿͻURLָûWeb롣Webû֤HTTPЭļϴ͸ûͻֻǽļϣʾWWWϡ
ڶCGI(Common Gateway Interface)WebΪӦ߼㡣Ҫ÷ɿͻӦùܣWebܿͻ룬ҪִCGIԱݿӣ봦󽫴WebWebͻˡCGI׶ˣΪCGIѣCGIÿHTTP󶼼һӦ̣ɴɳռϵͳԴЧʣڳִʱġ
Ϊݲ㣺WebӦģʽķչƶWebĽӦHTMLWebĴͳģʽѾǵҪˡWebһ㰲װһ̨ǿļϣܳ÷ļΪԶûṩද̬ȤݡЩ⣬ͬṩ˲ͬļWebӦõĿ΢Windows NT4.0ṩIIS(Internet Information ServerϢ)ĿṩӦǿInternetIntranetܡͨΧWindows NTŻIISкܸߵִЧʡܺõİȫԡڹԼѸٵŵ㡣
ADOʵһṩݷʵӻơͨһʹþڿͻ/ӦжԹϵݿݵķʣASPУͨVBScriptJavaScriptADOʵĲADOͨODBCԴãSQL ServerOracleAccessݿMicrosoft ExcelTextļеݡ
ADOʵǽOLE-DBһĻϣADOóODBC֮ԴṩߡODBCԴ˵ֲͬODBCֿṩͬĹܡЩʹADOһЩԡھӦûͬ
(2)ݿӺͷ
WebϵĿ飬ҪҪݿӹϵSQL Server ODBC˵
ADOҪĶConnectionRecordset
Connection
ݿһֱּӵĲȣҪһConnectionʵֻActive Database ComponentʵֵĶ֮һProgIDADODB䴴
Set conn=Server.CreateObject("ADODB.Connection")
ͨServerCreateObjectǳʼһconnڱָ´ӵָ롣ȻǵConnectionOpenһӣ
conn.OpenTeachersTeachersODBC¼ѾڵϵͳDSN
Ӻ󣬾ͿԶݿвѯˣ磺conn.executedelete * from Teachers where name=quot;
Recordset
£ҪͨADOһЩ¼Ϳ԰ѷصĽʾǵWebҳСҪĲѯǾRecordset淵صĽ
ǿConnectionExecuteRecordset
Set conn=Server.CreateObject(ADODB.Connection)
Conn.openTeachers
Sql="select*from Teachers where name=
Set rs=conn.Execute(Sql)
ҲֱӴһRecordset
Set rs=Server.CreateObject(ADODB.Recordset)
Sql=select*from Teachers where name=
Rs.open Sql
ݿĲҪɾġֻĲﱾ˸Լľṩһݿ
Set conn=Server.CreateObject(ADODB.Connection)
Conn.openTeachers
Sql1=Insert Into Teacher (name, age, address, telephone) Values (, 24, Shanghai,123456) 'Ӽ¼
Set rs1=conn.Execute(Sql1)
Sql2=delete*from Teachers where name='ɾ¼
Set rs2=conn.Execute(Sql2)
Sql3=Update Teacher Set telephone=6+telephone'޸ļ¼
Set rs3=conn.Execute(Sql3)
Sql4=select*from Teachers where name='Ҽ¼
Set rs4=conn.Execute(Sql1)
5  
ϽASPֵʱASPص㡢ADO÷ԼǵĶģ͡ԿASPΪһֶ̬WebӦõĿߣźܺõԺͺǿܣӶǿؽڽInternet̨ϴʡ
Ƶ(Ϻѧѧϵ  Ϻ 200331)
ѦСƽ(Ϻѧѧϵ  Ϻ 200331)
(Ϻѧѧϵ  Ϻ 200331)
ο
1ɽ, ¼. WebݿĽ. : еҵ, 1997
2۵. Active Server Pagesָ. : , 1998
ոڣ1999-11-29
