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



Intranetݿϵͳ()
̷桡޼
()
3WebݿӦʵ
ǰԸַķȽϣ潫һҵIntranetWebݿӦõʵϵͳһҵIntranetϢϵͳڳеѼϢϢṩûѯĹܣInternetϢķ
3.1ϵͳƽ̨ѡ
ƽ̨ѡWindows NT 4.0İϵͳݿϵͳѡMicrosoft˾SQL Server 6.5΢Windows NT 4.0SQL Server 6.5ĽʵBrowser/ServerϵṹWWWݿ⻥ƽֻ̨Ҫ1̨΢ͿΪϵͳķṩƵDNSʼWWWFTPGopherݿ
3.2InternetϢIIS
ҵIntranetϢϵͳĺΪIISWindows NT 4.0ԴһóWWWFTPGopher֧CGIISAPIIISҪ
.InternetWWWFTPGopher
.InternetInternetַĹߣ
.Internetݿ(IDC)
.Կװȫ׽Ӳ(SSL)ԿĹߡ
IISWindows NTİȫԺԣʹеûʺšûڰװWindows NT ServerʱװҲڰװNT֮ٵװҪWWWá
(1)Internet˫Ҫõķʾҳ
(2)ҳ(Service)Ŀ¼(Directories)¼(Logging)͸߼(Advanced)4ԡпӳʱ¼ȡϵͳĬϵ¼IUSRcomputernameȫIUSRcomputernameʺţʹWindows NTļϵͳ(NTFS)ɾļĿ¼ҳгΪWWWĿ¼ȱʡĿ¼ΪwwwrootȻԸıȱʡĿ¼Ŀ¼Ŀ¼ͬʱ1ҳҲ趨WWWĬĵԼǷĿ¼¼ҳпðWWW¼1ļSQL/ODBCݿУԱԱаȫͳƵ顣߼ҳпöWWWķȨޣĳЩIPַķʡ
(3)ֹͣУ
һֵעǣWebҳCGIIDCActiveXȶ̬ҳ漼ЩҳĿ¼зȨޱΪɡִС򽫻ڳִʱԾܾΪһ׼򣬶ڰCGIInternet ISAPIӦóĿ¼ִֻȨޡ
3.3WWWݿĻ
ǽIISṩInternetݿ(IDC)ʵWWWݿӡΪһּ򵥿ݵWebݿӦÿߣܴῪߵıѶȣͬʱIDCǻISAPIƵģݿЧʸߣԷɵĸСIDCʵһISAPIӦóHttpodbc.dllʹļƷݿҷؽHTMLҳĹ졣ļֱΪ
Internet Database Connectorļ(*.idc)
аӵODBCԴıҪϢҪִеSQL䣬HTMLչļļ·
HTMLչļ(*.htx)
ʾѯHTMLĵģļͬHTMLԱдģпɰ֡ͼƵƵȡģļIDCݿϢ(ѯ)뵽ģļУγһHTMLĵ
(1)IDCԭ
IDCʵWWWݿ⻥Ĺͼ7WebʹHTTPύWebWebHTMLʽĵݸIDCģ飬ȻIDCתӦSQL䣬ͨODBCȥݿ⡣尴6ִУ
IISURL
IISװIDCģ飬ṩURLбϢ
Httpodbc.dllģȡIDCļ
IDCODBCԴӣִIDCļеSQL䣻
IDCݿȡõݺϲHTXģļУ
WebϲɵHTMLĵظͻ
(2)ʵIISݿ4
ΪIISװODBC˫á塱еODBCͼ꣬롰ODBCԴԻǰװĳЩODBC򣬴ʱбʾӦԴ
ϵͳDSNť֡ϵͳԴԻ


ͼ7 IDCʵWWWݿ⻥Ĺ
    ӡť֡ԴԻѡODBC򡱲ȷרĶSQLServer
Դ(߼)硰LocalServerȷ֮𲽹رռɡ
ע⣬IDCʹõϵͳԴһҪ֤ȷDSN
ڱдñ(Form)û벢IDCļHTMLĵ
ڱ(Form)ıдУԳṩı(text)(password)ѡ(checkbox)ѡť(radio)Լѡб(<select>)ûľҳ档
۱дIDCļIDCļаڷݿϢǵĸʽΪֵɷΪ¼ࣺ
Ҫ
.DatasourceODBCϵͳԴ(DSN)
.Templateģļƺ·
.SQLStatementҪִеSQL䡣
ѡ
.UsernameʹSQL ServerɵİȫԣָһݿЧû
.PasswordûӦĿʡԴʾ޿
.DefaultParametersûδıĬֵ
.RequireParametersҪûдı
.MaxFieldSizeÿֶε󻺳ռ䣬ĬֵΪ8192B
.MaxRecordsѯɷص¼
.Expiresָٻˢ1ΣÿζҪݿ⡣ָɽϵͳĸɡ
ODBC߼ѡ
ЩѡIDCʹõODBCǵĸʽΪ
ODBCOptions:Option Name=Value,Option Name=Value
磬ҪʹSQLֹͣʮ룬ֹͣODBCõĸ٣IDCļָ
ODBCOptions:SQLQUERYTIMEOUT=10,
SQLOPTTRACE=1,
SQLOPTTRACEFILE=C:Sql.log
1ѯӡquery.idc:
Datasource:LocalServer
Usermame:guest
Password:ok
Template:query.htx
SQLStatement:
+select name,age,sex,id,birthday,phone,salary
+from pubs.dbo.personnel
+where name like`%%%namep%%%'and salary>%salaryp%
+order by id;
Ҫرעٷֺ(%)÷%SQLеͨSQLѯʹͨضַıеԪء%ǰʹá%%Ϊ˷ֹIDCͼʹ%ΪǷ
IDCļУԽSQLѯΪ2飺ѯͶಽѯ
.ѯ
ݿϵͳͬʱSQL䣬Ӧѯʽ磺
SQLStatement:
+insert into perf(testtime,tag)values(getdate(),`%tag%')
+select aulname,ytdsales from pubs.dbo.title where ytdsales>5000
+select count(*)as nrecs from pubs.dbo.title where ytdsales>5000
.ಽѯ
ݿϵͳѯͬʱ1SQL䣬ЩѯΪಽѯʽ磺
SQLStatement:
+insert into perf(testtime,tag)values(getdate(),`%tag%')
SQLStatement:
+select aulname,ytdsales from pubs.dbo.title where ytdsales>5000
SQLStatement:
+select count(*)as nrecs from pubs.dbo.titleview where ytdsales>5000
ѯ1δвѯಽѯÿֻ1ˣݿϵͳɽѯѯʽΪʽɻøõܡSQL Serverݿϵͳ
ܱдHTXģļSQLӦתΪHTMLļ
HTXģļǺ<%%><!--%%-->ĸӱǩHTMLĵIDCʶЩǩ̬ӵĵСHTXļ6ؼ(begindetail,enddetail,if,else,endif,and)4ֲ(LTEOGTCONTAINS)2ñ(CurrentRecordMaxRecords)⻹ʹøHTTPIDCļĲݿ뿴вѯʾHTXļquery.htx:
<html>
<head><title>ѯʾ</title></head>
<body background=.gif>
<center><h2>ԱϢѯ</h2>
<table border=6 width=600>
<%begindetail%>
<%if CurrentRecord EQ 0 %>
<tr><th></th><th></th><th></th><th>Ա</th>
<th></th><th>绰</th><th>нˮ</th></tr>
<%endif%>
<tr><td><b><%id%></b></td><td><b><%name%></b></td>
<td><b><%age%></b></td><td><b><%sex%></b></td>
<td><b><%birthday%></b></td><td><b><%phone%></b></td>
<td><b><%salary%></b></td></tr>
<%enddetail%>
<p></table></center>
<%if CurrentRecord EQ 0 %>
<h1>Ǹûѯ!</h1>
<%else%>
<hr size=3>
<%endif%>
</body>
</html>
4
ŻIntranetϢĽһƹ㣬ؽҵɴͳClient/ServerģʽȽBrowser/Serverģʽתڴ˻ϽԼϢϵͳҵĿԺ͹Чʡ 
ߵλ:ϷпԺо(230031)

ο
1Millecan J.Unlocking Microsoft Internet Information Server.廪ѧ硢˹عʳ湫˾1998
2Microsoft Corp.Microsoft Internet Information Server Installation and planning Guide.1995
3ԴȪ.Microsoftͻ/ʵֲ.廪ѧ磬1997
4̩ʩѫ.InternetơWWWʹָ.Ϸʣйѧѧ磬1996
5Stout R.The World Wide Web Complete Reference.磬1996
6Dwight J.Special Edition Using CGI.еҵ硢˹عʳ湫˾1998
7Hipson P D.Ŵ.Windows NT 4 Server.ӹҵ磬1997(ȫ)
(ոڣ1998-07-26)
