
COMPUTER ENGINEERING 
1999 25 5 Vol.25 No.5 1999



Intranet ͼWebϵͳĿ
Ӣ
ժҪ ҪWebⲿӦóֽӿڷʽCGIISAPԼISAPIĹ̡ڴ˻Ͻ߿ıλIntranetϵͼWebϢϵͳ
ؼ ͨؽӿ IntranetӦóӿ IntranetϢ
The Development of Web Retrieval Information System Based on Intranet
Jia Meiying
Beijing Graphics Research Institute Beijing 100029
[Abstract] This paper gives a comparison of CGI and ISAPI which are interfaces between explorerWeb server and executive programsthen analyzes the theory of ISAPIat lastintroduces a Web retrieval information system on the Intranet programmed by author
[Key words] CGIISAPIIIS
λIntranetϵͼWebϢϵͳҪĿʵֱλݲͼ鱨Ϣķ㡢ٲѯ͸ЧáϵͳClient/ServerṹWindows NT 4.0ΪõInternet Information Server(IIS)ΪWebݿϵͳOracle 7.3ODBCӦѡ2.5汾ͻ˲Windows95FrontPageΪ
1 ֽӿڹ淶ѡ
ͻͨWebķ֣һҪ󷵻һMIME͵ĵWebֱӴؽһҪִӦóű롣WebǽݽӦóűӦóűִнԱ׼ķʽظ򡣷յ󣬽MIMEʵʽظͻ
IISе֮һǿӦóűʹκ32λԱдʽӦó򡣵дӦóűʱʹIISISAPIͨؽӿCGI(Common Gateway Interface)ֽ֧һ֡ISAPICGIǿͻWebⲿӦó֮佻һ淶ͨдHTML򵥻WebϵHTMLҳеӣWebͻCGIűISAPIӦóCGIűISAPIӦóɻȡͻWebṩϢȱ̵飬Ȼ󷵻HTMLҳӦóĽϢݵݿ⡣ߵISAPIWebϴΪDLLӦóӦóڷʱѱװڴ棻CGIűǵ͵Ķִгÿ󶼵һ̣ϵͳ
CGIISAPIص㣬Web ServerʱѡISAPIΪWebҳͬݿĽӿڷʽͬʱӦMS FrontPageҳWeb Server
2 ͨISAPIݿԭ
IISṩһΪݿ(IDC)ISAPIӦ(httpodbc.dll)ʹODBC APISQL ServerInternet䷢ͺͼϢHttpodbc.dllʹļ(.idcļ.htxļ)ƶݿķʺWebҳĹ졣ЩļInternetݿ(.idc)ļHTMLչ(.htx)ļ.idcļODBCԴйϢִSQLϢͬʱhtmlչļλú(.htx).htxļݿⷵؽĹ췵htmlļļHTMLչļʵHTMLĵģ壬HTMLĵIDCȡݿϢ֮󷵻Web乤ԭͼ1ʾ

ͼ1 ISAPIԭ
ISAPIҪ£
.IISURL
.IISװhttpodbc.dll
.httpodbc.dllȡIDCļ
.IDCӵODBCԴִSQL䣻
.IDCݿȡݣϲHTMLչļ
.IDCϲĵͻIISصͻ
3 ͼWebϢϵͳʵ
ϽܵWebݿӿԭ߿˱λIntranetϵͼWebϢϵͳüϵͳҪ3ܣ(1)ѯݲͼ飻(2)ѯ߱ͨϢ(3)ؼϵͳϢϵͳOracleݿĻϣҪԸݿĹݲͼͨжֶεļѯݲͼҪʡߡغŲѯûʱﱾͼݰڵϢ߿ԸԼĽ֤ѯԼͨϢûԴǵԼҪ°ϵͳϢҳϵͳעȡ"ѯ"˵ʵֹ̡
IDCֻͨϵͳԴݿ⣬ODBCһϵͳԴΪzlj_webݿӴΪzljÿݿӴӦΨһݿûͨûȨ޷ݿ⣻ڶһѯĽҳ"ѯ.htm" "ѯ.idc""ѯ.htx".idcļӦ.htxļȱһɡѯ.htmûѡѯʽͽûѯ.idcʼѯ
3.1 ѯ.htm 
ѯ.htmͼ2ʾ

ͼ2 ѯ.htm
.ѯҪṩ˿ѡĲѯʽ
.ʼڡûҪѯϵﱾϿڷΧ
.ƥûҪѯƥʡ
.ǰƥ䡢ƥ临ѡûѡѯƥģʽǰƥָûĲѯƥݵǰ漸֣ƥָûĲѯƥݵ漸֡ѡѡУָ˫ƥ䣬ûĲѯƥݵλõļ֡ṩ⼸ƥģʽҪΪ߲ѯٶȡ
.ѯťûƥʣѡƥģʽѯ.idcвѯWebڽյѯͨͱ׼/ʽISAPI򴫵Ϣ
.ðťƥ׼µƥʡ
3.2 ѯ .idc
Datasource: zlj_web
SQLStatement: select book_id,substr(chinese_name,1,30) as chinese_name1 ,
+substr(name,1,55) as name1
+ from zljdba.z2_catalogue
+ where %name_para% like
+ upper('%left_para%'||'%name0%'||'%right_para%')
+ and arrival_date>=to_date('%begin_year%'||'%begin_month%'||'%begin_day%',
+'yyyymmdd')
+ and arrival_date<to_date('%end_year%'||'%end_month%'||'%end_day%',
+'yyyymmdd')
+ order by chinese_name ASC,name ASC
Template:ѯ.htx
Username: zlj
Password: zlj
ODBCOptions: SQL_MAX_ROWS=500
3.3 ѯ.htx
ʾѯĳѯģƼͼ3

ͼ3 ѯ.htx
ҪHTML£
<%begindetail%>
  <option> value="<%book_id%>"><%chinese_name1%>%name1%></option>
  <option> value="<%book_id%>">---------------</option>
<%enddetail%>
4 ϵͳİȫ֤
OracleݿϢķNTFSṩļȫԺͷʿƻƱ֤ϵͳݵİȫԡݿ⽨רŵûԼݿͼͼֻûɷϢûֻܲѯͼеϢܽ޸ģžƻݵĿԡͨԶ̲û֤䲦ȨޡȨûֻܶضļĿ¼зʣҲΪزЧ˲ŵĵ绰ͼ޶ȵرԴ
ϵͳĿǰIntranetϷ˶ߺͼݹԱĹЧʣͬʱҲͼ鱨ʣʵͼ鱨ϿٲѯЧú͹Ŀġ
߼飺Ӣ Ů24꣬Ҫоݿ
ߵλͼо 100029
ο
1 .ORACLEݿϵͳ.廪ѧ,1995-11
2 Jason Garms.ѩ,Ӧ,ĵ.Windows NT Server 4ȫ.еҵ,1997-07
3 ֣˽.ʵ.廪ѧ,1991-02
ոڣ1998-06-30
