Ӧ
Computer Applications
1999 198 Vol.19No.8 1999



ASPݿѯҳʾʵ
ƽ
ժҪļҪASPĻԼƼҳʾʱľ巽Ӷһ˵ASPڹInternet/IntranetӦʱмЧȼơ
ؼʡASPWebӦãҳʾ
IMPLEMENTATION OF DATABASE RETRIEVE
PAGES DISPLAY TECHNOLOGY ON ASP
Zhu Shiping
China University of Mining & Technology, Jiangsu.Xuzhou 221008
AbstractThis paper briefly describes the basic concepts of ASP technology. It also describes specific method, in the course of access result pages design. It explains technical advantage of ASP on application of Internet/Intranet.
KeywordsASP, Application of web, Retrieve technology, Pages display
1
ASPActive Server pagesMicrosoft˾199611ƳWebӦó򿪷ṩһԼɽűԣVbscriptJscriptȣHTMLҳڷ˵ĽűASPHTMLODBCݿʺӱһӶʹWebӦϵͳƸӼֱۡܵ󿪷ԱĹעASPݿѯҳʾľʵֽ
2ݿѯ
֪ASPݿͨõADODBʵһܵġͨϡ塱ODBCDSNͨDSNָODBCݿ⡣
ȻҪʹáServer.CreateObjectӶ󣬲áOpen򿪴ݿ⣬ʽΪ
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.open"ݿ"
ݿƼΪODBC趨ġԴơServer. CreateObjectҪ˵ASPΪʹڿWebӦ÷иһĹܣṩڽ
Request ڴʹȡϢ
Response Ϣ͸ʹߡ
Server ṩȡWebķԡ
Session һûĶҳ֮䱣ʹĳЩͬϢ
ApplicationһASPӦòͬʹ߹Ϣ
ServerһҪCreateObject
еADODBʵASPṩؼеһͨΪݿʿؼһؼ൱һṩʹ÷Դ
Ҫ÷ؼͱServerCreateObjectؼʵ
Set Conn=Server.CreateObject("ADODB.Connection")
ADODBؼ⣬ĸؼǣ
ļʿؼͨFileSystemObjectTextStreamṩдļĹܡ
ֲؼùͼƬϢʾҳϡ
ϢؼṩûĹϢWeb
ӿؼܷʹһıļӡһҳһҳӹܡ
һݿ⽨ӣͿ趨SQLʹáExecute"ʼִݿļ洢RecordSetsRSʽ£
Set RS=Conn.Execute(SQL)
SQLеļHTMLFormУûȷRS󣬾ܹʹRecordsetsԲѯпơҪ
RS.Fields.count: Recordsetsֶ
RS(i).Name:iֶơi0RS.Fields.count-1
RS(i):iֶεݡi0RS.Fields.count-1
RS("ֶ"):ȡֶָεݡ
RS.EOF:ǣTrueFalseָݿļһ¼
RS.MoveNext:ָƵһ¼
RS.MovePrev:ָƵǰһ¼
RS.MoveFirst:ָƵһ¼
RS.MoveLast:ָƵһ¼
RS.GetRows:ѯŵС
RS.Close:رռ
Conn.Close:رӵݿ⡣
ϾASPѯеһЩ
3ҳʾʵ
еݺܶʱϣͨʽԲѯзģҲWindowsӦóͨʹõķʽôASPʵһأ֪ASPRecordsetҪݽ棬´ܹһǰֻRecordset
Set Conn=Server.CreateObject("ADODB.Connection")
Set RS=Server.CreateObject("ADODB. Recordset")
Conn.Open"ZHUDB""SA"""
RS.Open "Select * from authors"Conn,
adOpenKeyset,adLockReadOnly
RecordsetĴ򿪣ʹֲͬĹģʽ
̬ģʽ鿴ûӡ޸ĺɾRecordset͵ƶǩṩ֧ǩܡ
̹ģʽһ̬֮꣬Ϊ鿴ûӲȡûRecordsetɾļ¼
̬ģʽṩ̬ؿһ׼¼ĲԲѯݻ߲֮áûӡ޸ĺɾǲɼġ
ǰģʽһֻ̬֮꣬ǰ¼ֻҪʹһRecordsetʱеЧʡ
粻ָģʽASP/ADOԤΪǰģʽǰRecordset֧MoveNextʵӦйģʽ͵趨ֵ1ʾ
1

ֵ
AdOpenForwardOnly0ǰģʽ
AdOpenKeyset1̹ģʽ
AdOpenDynamic2̬ģʽ
AdOpenStatic3̬ģʽ
AdLockReadOnly1ֻ
AdLockPressimistic2۵
AdLockOptimistic3ֹ۵
AdLockBatchOptimistic4ֹ۵

ĹģʽԼRecordset뷽PageSize,AbsolutePage,NextRcordsetȣͬʱӦĽű룬ܹʵԤڵЧһʵ룺
** Zhu.aspļ
<HTML>
<Body>
<%
Const a dOpenKeySet=1
Const a dLockReadOnly=1
Set Conn=Server.CreateObject("ADODB.Connection")
Set RS=Server.CreateObject("ADODB.RecordSet")
Conn.Open "SQLWEB1","SA",""
RS.OPEN "Select*From CBOOK Where Title =ߵѧ",
Conn a dOpenKeySet, a dLockReadOnly
RS.PageSize=4

SCRO=REQUEST("SCRO")
IF SCRO <> "" THEN
PAGENO=MID(SCRO,5)
IF PAGENO <1 THEN
PAGENO=1
END IF
ELSE
PAGENO=1
END IF
RS.ABSOLUTEPAGE=PAGENO
%> 
<P>
<Form Method=POST ACTION="ZHU.asp">
<% Do While Not(RS is Nothing) %>
ʾ
<TABLE Colspan=8 Cellpadding=5 Border=1>
<TR>
<TH> </TH><TH></TH><TH></TH><TH></TH>
</TR>
<%
RowCount=RS.PageSize
Do While Not RS.EOF and RowCount>0
%>
<TR>
<TD BGCOLOR="8fffde" VALIGN=TOP><FONT 
COLOR="#0000"><%=RS("title") %></TD>
<TD BGCOLOR="8fffde" VALIGN=TOP><FONT 
COLOR="#0000"><%=RS("author") %></TD>
<TD BGCOLOR="8fffde" VALIGN=TOP><FONT 
COLOR="#0000"><%=RS("pubdate") %></TD>
<TD BGCOLOR="8fffde" VALIGN=TOP><FONT 
COLOR="#0000"><%=RS("publisher")%></TD>
</TR>
<%
RowCount=RowCount-1
RS.MoveNext
Loop
%>
</TABLE>
<p>
<%
SET RS=RS.NextRecordSet
Loop
Conn.Close
Set RS=Nothing
Set Conn=Nothing
%>
<p><p>
<% IF PAGENO>1 THEN %>

<INPUT TYPE="SUBMIT" NAME="SCRO" VALUE="<%="Page" & PAGENO-1 %>">
<% END IF %>
<% IF ROWCOUNT=0 THEN %>
<INPUT TYPE="SUBMIT" NAME="SCRO" VALUE="<%="Page" & PAGENO+1 %>">
<% END IF %>
</Form>

</BODY>
</HTML>
óڲѯͼĿжСߵѧͼ顣ȷÿҳʾ¼ʾݰߣ꣬硣нͼ1ʾ


ͼ1н
4
ŻĲϷչݿӦùInternet/IntranetϿ϶ǷչıȻơASPⷽȷʵǴʤ¼ȻֻASPݿѯҳʾ⣬ASPActiveXãʹǴWebӦϵͳ
߼飺ƽоԱҪо򣺼ݿӦá
ߵλƽйҵѧ.ݣ221008
ο
1ݡձ.ϢϵͳʵݿϵͳWebļ.ϵͳӦã1998;9:33-35
2ݡŽ.ǳ̸ASPWebݿӦü.ϵͳӦ,1998;9:36-39
ո:1999-04-23(޸ĸ)
