Ӧ
COMPUTER APPLICATIONS
1999 19 9 Vol.19 No.9 1999



ASPϢϵͳķʵ
ϼҦ
ժҪ/ṹϢϵͳǵǰӦõһȵ㡣ĽһµWebASPĹԭص㣬ͼϢϵͳΪASPϢϵͳķ
ؼʡASP, Intranet, Web
1
ϢϵͳĺľҪݿеݽмӹӶȡõĹϢϢϵͳ뵽Internet/IntranetĿ֮ٵľͨҳʺ̨ݿϢĿǰWebҳͬݿжַʵ֣CGI(Common Gateway Interface)ISAPI/NSAPIJDBCݿϵͳṩĹܽӿڵȡASP(Active Server Pages)΢ΪIIS 3.0ԼMS Personal Web ServerWebĶ̬վƼж̬Чڽص㡣ΪInternetչеһ̱
ĽASPԭһӦʵʹ÷
2ASPԭ
ӱϽASPһڷִеĽűASPܼ򵥵ΪһĽűԣǽűԣVBscriptJScriptɵHTMLҳڷ˵Ľűһ*.ASPԴļ԰ֳɷ֣
. ıʾϢҳȣԳⵥԪС
. HTMLǣʵҳ񣬿ɵʹãҲǶ뵽ASPűԪ֮䣬á< ͡>Ϊ
. VBScriptűڿƸActivexؼɵʹãҲǶ뵽ASPűԪ֮䣬<Script></Script>Ϊ
. ASPűӦó̵ĿƼܵʵ֡ɵʹãҲ԰<html></html>ڣá<% ͡%>Ϊ
ҳʱWebӦHTTP󣬵ASP棬ͱļκActivex ScriptingݵĽű(VBScriptJscript)ʱASP ӦĽűд͵õʵϣASPеVBscript𲻴󣬵ASPͶģͣCOM̷ͨActivexʹΪϢϵͳЧߡASPʼVBScriptӦõActivexԪأ֧Ӧó򡢻ỰӦͷASPǴASPṹ֮DLL֧ݿʡļʡADתӵȣκԴ磬ݿADOASPзǳõһ֣ʹɶݿķʡ
ASPűڷеģûֻܿASPűɵı׼HTML룬ԱʣûԶASPűĴ룬ϵͳİȫԡASPһŵ㻹ѧ䡣
3ASPݿļ
ASPADOݿ⡣ADOActivex Data Objects Activexݶ΢µݿAPIOLE DB֮ϡADOһŻķݿרö󼯣ΪASPṩվݿʷADOʹõRecordSetsΪݵҪӿڣʹVBScriptJScriptƶݿķʼѯʾ
űָкзݿ󣬾ͨODBC̨ݿݿִзÿ
ʹADOݿҪASPļ䣬ǣ
ݿ
set objconnection = server.createobject
("adodb.connection")
objconnectionΪݿӶ
򿪴ʵݿ
objconnection.open "Դ" "ûID" ""
ִзݿĶ
set objrecordset= objconnection.execute("SQL")
objrecordsetΪ
ʾѯ
ʾѯб
<select size=8> 
<%do while not objrecordset.eof %> 
<option><% =objrecordset ("ֶ")%> </option>
<% objrecordset.movenext loop %>
</select>
4ʵӦ
һͼϢϵͳΪβASPп
4.1ϵͳ
õϵͳƽ̨ΪWindows NTWebΪ֧ASPIIS 3.0̨ݿΪSQL Server 6.5ͻ˲Win95Win98ƽ̨ΪIE 4.0 ɡ߲Visual InterDevFrontPage 98ȻΪҳۣͼ߻һЩý幤ҲǱزٵġ
4.2ϵͳ
ͼϢϵͳҪΪ˱ͼݶͼճûͼϢѯҪܹʵֲͼ顢ǼǡͳͼϢȡϵͳܰͼϢĲѯͳơάӡȣڲͬûϵͳ䲻ͬʹȨޡûڿͻͨ¼뵽ϵͳУͼϢиֲѯͼԱɽһЩϵͳάͼϢӡ޸ġɾȡ
ͼĻϢҪšۡ硢ߡ󡢳¡ͼƬݼȣΪ˱ϵͳάϵͳͼݿаͼϢͼݱ
4.3ʵ
ϵͳеѯΪʵַ
. ѯ¼ʵ֣
ѯ¼ҳͼʾ

ҳҪFrontPage 98ҳҪһñжMS forms 2.0 ActiveXؼͨƵVBScriptASPűƸؼʾݺЧԡѡ˳ֶκбʾںͲڣӦֵбʾ֡һѯЧɵĲѯûķʽʾıУʵύSQLĲѯһصı(tsql)С⻹ťûԲѯд
ûʼѯťɵĲѯύcx.aspļɶͼϢĲѯʾ
. òʾѯ
InterDev ½һASPҳ棬Ϊcx.aspļڴļеBODYĴ룺
<%@ Language=VBScript %>
<% dim objconnection
dim objrecordsetstrsql
set objconnection=server.createobject
("adodb.connection")
objconnection.open "TSXX","sa"
strsql="select no,title,author,
publications from books,pub, "
strsql=strsql+"where books.pubid=pub.pubid and"
+request.form("tsql")"
set objrecordset=objconnection.Execute(strsql) %>
<%if objrecordset.bof and objrecordset.eof then
<h2><center> Ǹûз飬롣
</center></h2>
<%else 
<table border="0" cellpadding="0" cellspacing="0">
<tr><th></th>
<th></th>
<th></th></tr>
<% do while not objrecordset.EOF %>
<tr><td>
<a href="detail.asp?title=<%=(objrecordset("title"))%>"%=objrecordset ("title")%> </a> </td>
<td ><p align="left"><%=objrecordset("authors")%></td>
<td ><p align="left"><%=objrecordset("publication")%> </td>
</tr>
<% objrecordset.movenext loop %> </table>
<%end if%>
cx.aspִкѯԱʽʾ˷ͼơߡ硣ʱûĳһһ˽ϸϣԵӦ⽫һASPҳ漴detail.aspִdetail.aspûԿķ桢ݼϸϡ
5
Intranet/ṹϢϵͳ봫ͳϢϵͳȣӿšЧȫͱʽḻµܳ͡ԭ豸ͶٺͿڶ̣ȫܹҵϢҪ⣬/ṹϢϵͳû߱ѺԺһԣʹûڽܡ
߼飺ϼ˶ʿʦҪоϢӦáֲʽϢ
Ҧ˶ʿڡҪо򣺼缰Ӧáͼѧ
ߵλеѧԺӱ.ʯׯ050003)
ο
1ݡ()S.ϣ, D.÷,.Active Server Pagesָ. ,. 磬1998
2ݡ()Scott Jarol Marisa Pena. Web뿪ָ.Ƕ,. еҵ磬1998ƣϢȫһֱϡ
ỰSOCKS ProxyͨỰSOCKS Proxyʹͻ˺ʹ˽ͨӡֻд֤ͨĿͻܺУ԰ķͨӣͨʵcacheܡ
أУ԰ڲ״̬غĿǰͨĸԴĿIPַ档
ƷϵͳƷϵͳҪû־Ʒѱ׼áûö̬ѯûͳƹɡ
ո:1999-06-15(޸ĸ)
