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



Webۺϲѯϵͳʵ
־źʢ
ժҪȽڴWebӦóASPصϵͳҪȻASPʵIntranetϻWebݿۺϲѯϵͳ˼뼰ʵ֡
ؼʡ̬ҳ(ASP)IIS̬HTMLActiveXݶ(ADO)
DESIGN AND IMPLEMENTATION OF INTEGRATED
QUERY SYSTEM BASED ON WEB
Wang ZhipengZhang HaishengShen Yimin
Chengdu Institute of Computer Application, Academia Sinica, Sichuan.Chengdu 610041
AbstractAt the first, this paper introduces the characteristics and system requirements of ASP. Then explains the design idea and implementation of an integrated query system of database based on Web by using ASP in the intranet environment.
KeywordsASP, IIS, DHTML, ADO
1ǰ
InternetӦõĲչ,ҵڲIntranetǿҵڲϢļ빲ͨIntranetʱȡҵڲۺϢڸƺŻҵǿҵЧ潫ṩ֧֡ΪˣƺͿһ/ʽWebݿۺϲѯϵͳϵͳһͨõľ֧ۺϲѯϵͳڻWebODBCTCP/IPȼʵ칹ݿ칹ƽ̨ۺϲѯϵͳASPΪбҪȶASPһҪĽܡ
2ASP
ASPActive Server Pages΢Ƴķ˽űдʹHTMLűActiveXж̬ Web ӦóASPص㣺
. άټ򵥡 ASPļͨͨõı༭ ± רŵļɿVisual InterDevп;
. ͨáASPʹVBScriptJavascriptPerlȶֽűԽб;
. öΪ˷̣ASPṩֹǿöûдԼƵActiveXؼ;
. ȫԡASPʹNTİȫƣͨNTȨƿԹ涨ʹ÷Χ;
. ޹ءASPǷ˵Ľűִлֻ轫űִн͸ͻִнһֻ泬ıʶԲͻ˵
WebݿۺϲѯϵͳлһҪ󣬵ЩҪȽ㡣лҪ˺Ϳͻ档WebҪϵͳWindows NT 4.0뾭Service Pack 3װNT Option PackWebIIS 4.0 ͻ˲ϵͳWindows 95/98Windows NT WorkstationʹDHTMLIE4.01磺NavigatorʹIE 4.01ݿϵͳҪֻ֧ODBCɣݿϵͳɰװWebϣҲɰװϣΪݿ
3ϵͳƷ
ϵͳĿIntranet֮ϣ/ϵṹΪܹͨASPʽʵֽʽ̬Webۺϲѯϵͳ˼·ǣͻֻҿɷWeb˾ɿͻѡĲѯܣҷؽͻ˷ͻ˾̬ܶĻȡݿеϢ
ҪɶݿĲѯͱӦضܵSQL䣬ЩSQLҪƺãݿӦıУһҪǵķϢûļʹáϵͳṹͼ1ʾ

ͼ1ϵͳṹ
ͼеļͷʾϵͳݵУݿWebݣASPűִеضѯܵSQLϢΪSQLѯҵۺϢ
ϵͳڲṹΪͼ2ʾ㣺̶ϢͶ̬ѯ㡣̶ϢԳıļʽ洢ϵͳľ̬Ϣһ㲻ı䡣̬ѯضݲѯĹģɣһģһ׺Ϊaspļģ֮ͨ佻áģпܰýűдḶ́ͬʵضܡ

ͼ2ϵͳڲṹͼ
4ϵͳʵ
ϵͳʵҪΪ֣SQLɺWebѯҪʵSQLɵĹģ飬һֲҪҲWebʽʵ֣ÿͻ/ķʽɡϵͳͼ3ʾ

ͼ3SQLɵĽ
Ϊûʹ÷㣬ϵͳͨȡݿϵͳϢԿӻʽʾݿеıֶεԣûӦѡͿԿٴѯ䣬ṩѯȷ֤ͲѯԤ
ȻϵͳҪWebѯʵ֣һҪݿ⽨ӡSQLִкͽʾִнͼ4ʾ

ͼ4WebѯĽ
Ϊ˵ʵֲ裬WebݿǶֱΪwebsrvdbsrvݿSybase,ݿΪpubspubsбtsql洢ƺõSQLϢҪִеĲѯıͨsqlid롣
һADOͨODBCݿdbsrvӡ
ͨADOݿ⽨ӣҪConnection󣬲ӵĲDSNUIDPWDȣȻConnectionOpenӡӲɲDSNODBC־OLE DBʹõDSN
<%
ʼַConnstr
var Connstr="DSN=Pubs";
䴴Connection
var DBConn=Server.CreateObject("ADODB.Connection");
DBConn.Open(Connstr,"sa","pwd");
%>
ڶtsqlȡӦѯӦSQLADOпʹִSQL洢̣ ConnectionCommandRecordset
<%
//ѯűsqlid
var id=Request.QueryString("sqlid");
var sqlqry="select tsql.stext from pubs.tsql
where tsql.sid=";
//Command
var cmd=Server.CreateObject("ADODB.Command");
cmd.ActiveConnection=DBConn;
cmd.CommandText=sqlqry+id;
//cmdExecuteִвѯ
var rsTmp=cmd.Execute();
%>
ִSQLԳıʽزѯ
<%
//ȡΪsqlidĲѯ
var sqltext=rsTmp.fields.getValue("stext");
//ʼRecordset
var rsResults=Server.CreateObject("ADODB.Recordset");
rsResults.CursorType=adOpenDynamic;
rsResults.LockType=adLockOptimistic;
//ִбΪsqlidĲѯ
rsResults.Open(sqltext,DBConn);
//Գıʽʾѯ
var rdCount=rsResults.getCount(); 
//¼
var fdCount=rsResults.fields.getCount();
//ֶ
%>
<table border=1>
<thead>
<tr>
<% for i = 0 to fdCount -1 %>
<th>
<% =rsResults.fields.getName(i) %>
</th>
<% next %>
</tr>
<tbody>
<%
for i = 0 to rdCount - 1
Response.Write("<tr>");
for j = 0 to fdCount - 1
Response.Write("<td>");
Response.Write(rsResults.fields.getValue(j));
Response.Write("</td>");
next
rsResults.moveNext();
next
%>
</tbody>
</table>
5
ϵͳƺʵֻWebӦеһ֣ҪĽӵĲ֣磺ѯûʶ֤ȫԻơݿWebԼûĸԻõȡASPϵṩ񡢰ȫȹܣASP˿WebӦó漰ÿ档ASPҲһЩԣҪǶƽ̨ǿֻWindowsNT95WebУASPӦҪעġ
߼飺־˶ʿоҪо򣺷ֲݿ⡢Internet
źʢоԱʿʦҪо̡ϵͳɷ뼼CIMS
񡡸оԱҪоϵͳɡCIMS
ߵλйѧԺɶӦоĴ.ɶ610041
ο
1ݡMSDNMicrosoft Developer Networkhttp://msdn.microsoft.com/vinterdev
2ݡADOĵhttp://www.mocrosoft.com/data/ado/
3ݡASPĵhttp://www.microsoft.com/workshop/server/asp/
ո:1999-06-25
