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



ASPݿϢĶ̬ҳ
ձ
ժҪҪASPͨ1򵥵ʵ ʹASPݿϢĶ̬ҳ档
ؼʣASP̬ҳ桡ݿ
1ASP
ASPһֿżԽHTMLűõActiveX ServerһԽ  Чġ̬ġWebӦó򻷾ASPڷ˵Ľű¹ ܣ̬ĸWebӦáASPĽűȫڷ ˡ
ASP֧ActiveX ServerʹáActiveX Serverͨģ(COM)ΪASP ˿ɱ̵Ľ棬еADO(ActiveX Data Object)ṩݿĻơADO 7
(1)Command󣺶Դв
(2)Connection󣺽1Դӡ
(3)Errorṩݷʴϸڡ
(4)Field󣺱ʾһ͵ֶΡ
(5)Parameter󣺱ʾcommandĲ
(6)Property󣺱ʾṩԴADOĶ̬ԡ
(7)Recordset󣺱ʾݿϢʾȫ
ʹADOԽ͹ݿӣݿȡݡִи¡ɾ ݡ
ͼ1ʾMicrosoftĸݴȡͬ

SQL Server.Oracle.Foxpro
ͼ2  MSݴȡĹϵ
1.ASPļʱWebASPȡ.ASPļݣִ.ASPļ еĽűȻͱ׼HTMLҳ棬ͼ2ʾ

ͼ2  ASPģ
ASPļ1Ƕ˿ڷִеĽűHTMLĵASPݵWebִЩ űڿͻASPļǱ׼HTMLı
1ASPļǰݵչΪ.ASPıļ
(1)Text(ı)
(2)HTML tags(HTML)
(3)ASPű
.ASPļǳ򵥣1űHTMLļֻ¹űչ .htm.htmlΪ.ASPȻűűڷֽ<%%>֮䣬ű ǽűJava ScriptVBscript䡣<%%>֮κνűԺ 䡢ʽ̺Ҳ֮HTMLı
2ASPݿ
Ƚ1ODBCԴ(DSN)ļDSNָODBCݿ⣬ݿáûȨ ޡݿλá
巽ǣڷĿ壬˫ODBCͼ꣬ѡFILE DSNADDϵͳ ԴDSNļд1DSNļCLHSָ1SQL Serverݿmisd bl
1ܵҳframe.htmУû1ѡҪѯ(ӦҳΪcl hs.htm)1ʾݿĲѯ
űʵֵĹǣ1(clhs.htm)ѡ̬ѯ(䳬Ϊ1ASP kclist.asp)ڷkclist.aspеĽűݿmisdbıcljgm lȡòϵơƻۼǰ̬ϢʾҳС
Frame.htmΪ
<html>
<head>
<meta http-equiv=Content-Type"content=text/html;charset=gb2312>
<title>ܿ</title>
<meta name=GENERATORcontent=Microsoft FrontPage 3.0>
<bgsound src=ҵġ°˿.rmiloop=-1>
<meta name=Microsoft Themecontent=arcs lll,default>
</head>
<frameset framespacing=0border=falseframeborder=0rows=*> 
<frameset cols=26%,*>
<frame name=contentstarget=mainsrc=clhs.htmscrolling=auto >
<frame name=mainsrc=intro.htmscrolling=auto>
</frameset>
</noframes>
<body>
<p>This page uses frames,but your browser doesn't support them.</p>
</body>
</noframes>
</frameset>
</html>
clhs.htmΪ
<html>
<head>
<meta http-equiv=Content-Typecontent=text/html;charset=gb2312>[ ZK)
<title>Ϻϵͳ</title>
<base target=main>
<meta name=Microsoft Themecontent=arcs 111>
</head>
<body>
<h5 align=left>Ϻϵͳ</h5>
<o1>
<li><font size=2><a href=intro.htm></a></font></li> 
<li><font size=2><a href=kclist.asp>϶̬</a></font></li >
<li><font size=2><a href=clrk.asp>̨</a></font></li> 
<li><font size=2><a href=clck.asp>ϳ̨</a></font></li> 
<li><font size=2><a href=gjrk.asp>ѯ</a></font></li> 
</o1>
</body>
</html>
kclist.aspΪ(űΪVBSript,ű<%%>֮)
<html>
<head>
<meta http-equiv=Content-Typecontent=text/html;charset=gb2312>[ ZK)
<title>϶̬</title>
<meta name=GENERATORcontent=Microsoft FrontPage 3.0>
<meta name=Microsoft Themecontent=arcs 111,default>
</head>
<body>
<%
set rstMain=CreateObject(ADODB.Recordset);ASPķ
CreateObje ct1Recordsetʵ
rstMain.CursorType=3
rstMain.OpenSELECTclbh,mc1,mc2,dw,jhj,kcs1FROM
misdb1.dbo.cljgml",DATABASE=misdb1;UID=sa;PWD=;DSN=clhs
%>
<h6 align=center><big><big><big><a name=head></a>϶̬
             &n bsp; 
</big></big></big></h6>
<table border=1width=88%height=21>
<tr>
<td height=17valign=middlealign=center><font COLOR=#00000 0size=2>Ŀ</font></td>
<td height=17valign=middlealign=center><font COLOR=#00000 0size=2></font></td>
<td height=17valign=middlealign=center><font COLOR=#00000 0size=2></font></td>
<td height=17valign=middlealign=center><font size=2> </font></td>
<td height=17valign=middlealign=center><font COLOR=#00000 0size=2></font></td>
</tr>
<%do while not rstMain.eof%>
<tr>
<td height=15valign=middlealign=center><font COLOR=#00000 0size=2><%=rstMain.fields(0)%></font></td>
<td height=15valign=middlealign=center><font COLOR=#00000 0size=2><%=rstMain.fields(1)%></font></td>
<td height=15valign=middlealign=center><font COLOR=#00000 0size=2><%=rstMain.fields(2)%></font></td>
<td height=15valign=middlealign=center><font COLOR=#00000 0size=2><%=rstMain.fields(4)%></font></td>
<td height=15valign=middlealign=center><font COLOR=#00000 0size=2><%=rstMain.fields(5)%></font></td>
</tr>
<%rstMain.movenext%>
<%loop %>
</table>
<hr align=center>
<p align=right><a href=#head></a></p>
</body>
</html>
ϳ绷ȷС 
ߵλɽѧԺϢϵ(250014)
(ոڣ1998-09-13)
