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



IIS̬Ϣһַ
ǿ ϼ 
ժҪ MSNTServer,ͨInternet database ConnectorʵWebͬݿ,ӶʵͨWeb̬ݿݵĿ.
ؼ Internet Ϣ ȫ HTMLInternetݿ
A Way to Publish Dynamic Information with IIS
Li Qiang Zhao Xia XU Xiaoming
(Autonation Department of Shanghai Jiaotong University Shanghai 200030)
[Abstract] This article is aimed at introducing a way to establish dynamic link between Web server and databasse server through Internet database connector on MS NT SServer,and realize the goal of dynamic publishing for datqa stored in databases through Web.
[Key Words] IIS Web;HTML;IDC
InternetĳٷչȫϢҵĸȻWebӦõʵ֣ҪһҪͨWebû룬ʵʱִû룬Ȼ󣬷ִкĽҲǸûṩһƽ̨ʹûԼȤݡʱWebͻϿĲǾ̬ҳ棬ǸûύɵĶ̬ҳ档
ڴ˱£MS NT Server4.0Ͽ̬Web񣬴ﵽͨ磬Webʵֶݿݲѯ롢޸ġɾȹܡ
1 IIS
IIS(Internet Information Server)ǼWindows NTһWeb ServerҪ
(1)InternetWWWFTPGopher
(2)InternetInternetĹߣ
(3)InternetݿݿⷢSQL
(4)Կװȫ׽ֲ(SLL)ԿĹߡ
ISSԺܺõؼɵеĻСIISWindows NTİȫԺԡʹ÷ϵЧûʺţҪʺžб¼ȨޡIISWindows NTϵͳУûװWindows NT ServerʱѡװIISʱûаװҲûϵûIISװɹװIISûʹInternetIISú͹£
(1)InternetѡûҪϷWebķInternet(WWW)鿴ԡ
(2)ҳĸǩӦԣServiceҳDirectoriesҳLoggingҳAdvancedҳDirectoriesҳпҪWebݡIISNT ServerϵͳĿ¼µ/InetPub/WWWrootΪWWWȱʡĿ¼ûԸҪĿ¼ЩĿ¼߼ϴĿ¼ڣĿ¼ûԽҪĿ¼ʽ
Уǽ淢ݵĿ¼ΪĿ¼Ŀ¼
úInternetȻODBCãǼǺҪӵԴݿPowerBuilder5.0µıݿpersonnelһԱϢemployeeֶζΪ(Name)ձ(Sex)(Age)(Department)ȡODBCǰǼΪϵͳԴpersonnel(ע⣺IDCֻϵͳԴһ)˶Web Server˵ҪáNT ServerеIISṩһַInternetݿ(IDC)ͨODBCӿݿ⣬ִInternetݿļ(.idc)ûύĲɵı׼SQL䣬ȻͨHTMLչļ(.htx)ؽ
2  IDCԭ
IDC(Internet Database Connector)Microsoft Infor-mation Server for NTMicrosoft Personal Web Server for Win95ںݿӿڡûñ׼SQLWebӵκοݿвIDCʹļInterentݿļ(.idc)HTMLչļ(.htx)ηݿιHTMLĵInterentݿļʵODBCԴִSQLϢInternetݿļHTMLչļƺλáHTMLչļʵHTMLĵģ壬HTMLĵIDCݿϢ֮󷵻Web
ǿĻWindows NT Server4.0Web ServerIIS2.0ͼǿͻʷõ̡
(1)ͻWebͨHTTPЭWeb(IIS)ύдõĴӷϵõFORM
(2)IISHttpodbc.dllӦ(.idc)ļûдĲHttpodbc.dll
(3)Httpodbc.dllӦ(.idc)ļ(.idc)ļûдĲɱ׼SQL䣻
(4)Httpodbc.dll(.idc)ļָԴͱ׼SQL佻ODBCӿӦݿⲢִиñ׼SQL䣻
(5)ODBCӿڽصHttpodbc.dll
(6)Httpodbc.dllӦHTMLչļ(.htx)IIS
(7)Httpodbc.dllѲHTMLչļ(.htx)IIS
(8)IISHTMLļͨHTTPЭ齻ͻWeb
3  
3.1 
Ǵ洢WebͨĿ¼ʽıͻWebȴWebȡô˱
<html><head>
<title>ѯԱ</title>
</head>
<body>
<h2 align="center">ѯ</h2>
<form method="post"action="query.idc">
<div align="center"><center><p>Sex:<input name="sex"value size="20"></p>
</center></idv><hr>
<div align="center"><center><p><input type="submit"value="submit"align="center"></p>
</center></div>
</form></body></html>
3.2 Internetݿļ(.idc)
ͻдõıˣָ(.idc)ļΪquery.idcIISHttpodbc.dllͨɿͻдϢInternetݿļ(query.idc)ĺϳɡInternetݿļ(.idc)мfield:valueʽDatasourceӦԴUsernameӦûTemplateӦӦģļSQL StatementΪûдıϳɵı׼SQL䡣
Datasource:personnel
Username:dba
Password:sql
Template:query.htx
SQL Statement:
+SELECT Name,Age from employee where Sex='%'sex%'
3.3 HTMLչļ(,htx)r
<HTML><HEAD><TITLE>ѯ</TITLE></HEAD><center>
<%ifidc.sex eq"male"%>
<h2>Աѯ</h2>
<%else%>
<center><caption>ѯ<%idc.sex%>Աѯ</caption>
<%endif%>
<TR><TABLE><tr><td></td><td><p>
<table border>
<TR><TH><B>Name</B></TH><TH><B>Age</B></TH></TR>
<%begindetail%>
<TR><TD><%Name%></TD><TD><%Age></TD></TR>
<%enddetail%>
<P></TABLE></center><P></font></td></tr></table>
</BODY></HTML>
ǲѯֵʵֻ֣Ҫ裬дӦ(.idc)(.htx)ļͿʵֶݵĲ롢ɾ޸ĵȹܡ
4 
֮CGIJava̬ñĽܵIISƽ̨Internet Database Connectorӿʵ־з㡢ֱۺʵֵص㡣ǣǼMS IISMS Personel Web Server֮ϣӦ÷ΧCGIJavaխ
߼:ǿ,,23,о,Ҫоݿ,ϢݿIntranetп.
ߵλ:ϺͨѧԶϵ Ϻ200030
ο
1 KRIS JAMSA롣Webƽ̳.ӹҵ磬1997250-272
2 .̬̽.΢磬1998(9)37-39
ո:1998-06-30
