΢͵Ӧ
MICROCOMPUTER APPLICATIONS
2000Vol.16No.1P.44-47



WEBվе̳ʵ
Ƽ
ժҪ΢IISṩIDCWebݿϵͳӣϸWebվʵȫӵײܹĵ̳ĳʵ֣ʹûʵʱػཻϢ
ؼʣInternetInternetݿ̳SQL
AbstractThis paper describes the connection of a Web ser ver with a database system using the IDC technology of Microsoft Internet Inform ation Server (IIS). It presents in detail the programming method of complete bot tom-up implementation of electronic forums on Web sites. Users can exchange info rmation in real time on the browser in such a system.
KeywordsInternetInternet database connectionelectronic forum SQL statement
һ
WWWInternetµĻʹInternetû˱ըԵҵ׷׽ҵڲӵԼWEBվ㡣ӹϵͳBBSһֱInternetΪҪһû£Ķ˵ƷṩϢѰĽ˵ʦѡWWWܣ˻WEBվĵӹϵͳ(WWW-BBSΪ̳)ԱȻTelnetInternet BBS̳зٶȿ졢Сḻʹ÷ŵ㣬ĿǰWEBվ㶼ṩ̳
WebУMicrosoft˾InternetϢIISǵWindows NTϵͳƽ̨ʹõWebIISṩInternetݿIDCIDCṩһʹݿݵInternetϷûнķֻҪ߾HTMLSQLṹѯԵ֪ʶҪκC++DLLƵıԸIDCӦóļǽԵģṩٵĿѭͷIDCּ򵥸ЧԣñԶ̵ʱڽӦó򣬶һЩи֤ӦóӦóIDCǽϺʵı̹ߡ
IDCAccessݿϵͳʵȫӵײܹWWW-BBSУ԰IntranetϿһЩۻԼҵȹܷ
ܼ
̳Ĵܣ
û¼ܣûʱעᡢעû¼ֹδȨû¼
ϢܣϢֳɼ⣬ЩУϢγ̣߳ʹһϢбУÿһϢ¶صķϢ
ϢܣûϢбз»(»ֲṹĵһ)ĳѴڵϢϢϢڱϢ֮£С
ܣûһһֳַ10Ϣһ飬ûԷ
еķΪWindows NT 4.0,IIS3.0,Access97,վΪWindows 95/98,IE4.0á
ݿ
Access97ݿnet.mdb,иֶ£
Ϣmessages:Messageid(Ϣʶ)Messagesubject(Ϣ)Messagetext(Ϣ)Userid(Ϣߵûʶ)Messagets(Ϣʱ)Conferenceid(Ϣʶ)Parentmessageid(ϢΪһϢķϢŸϢʶ)Numspace(ϢǶ)Displayordering(Ϣбе)
conferences:Conferenceid(ʶ)Conferencename()
ûusers:Userid(ûʶ)Username(û)Useremail(ûEmailַ)Userpassword(û)
հױspacesNumspaces(ſոַпոϢеNumspaceӦ)Spacestring(ſոַ)
spacesҪڸϢǶȺƲõĿոַ
ġϵͳԴ
.Windows NTеODBC
.ѡSystem DSNǩ
.AddťCreate New Data SourceԻ
.бѡMicrosoft Access DriverFinishť
.Data Source Nameıdbmessagebase
.Selectҵnet.mdb
.OKá
net.mdbݿóԴdbmessagebaseֻҪ.IDCļнdatasourceΪdbmessagebaseɶݿʵʩSQL
塢̼ʵ
ͼ1Ϊ̳ͼͼÿһһҳÿߴҪһIDCļǰһҳݴռһҳʾϢߴӡ

ͼ1 ͼ
1.¼ҳʾӭû뱾̳ûûͿûעᡣҳ.HTMļеıɽûûͿinputuseridinputuserpwУȷťmainscreen.idcļIDCļinputuseridinputuserpwֵѯusersǷӦû¼ͬʱconferencesмеʶԹҳʾҪΪ
template:mainscreen.htx
odbcoptions:SQL-ACCESS-MODE=1
requiredparameter:inputuserid,inputuserpw
datasource:dbmessagebase
SQLStatement:SELECT userid,username,useremail,userpassword from users
+where username='%inputuserid%'and userpassword='%inputuserpw%'
SQLStatement:SELECT conferenceid,conferencename from conferences
2.ִmainscreen.idcļĽmainscreen.htxļγɡҳҳa.гû¼ȫ¼ʾϢص¼ҳĳӡb.ComboboxϿ͡鿴ťûѡĶc.ҡťûʹóܡbcû¼ɹʾҳ.HTXļеҪУ
<form action=viemconfmessages.idcmethod=post>
<%begintail%><h3>ӭ<%username%></h3><%enddetail%>
<%if currentrecord eq 0%>
<h3>Բĵ¼<a href="messagebase.htm"></a></h3>
</form>
<%else%>
<select name="conferencename"size="1">
<%begindetail%><option><%conferencename%><%enddetail%>
<input type="submit"ualue="鿴">
</form>
<form action="search.idc"method="post">
<h4>Ϣ</h4>
<%begin detail%><input type="hidden"name="userid"value=<%userid%>>
<%enddetail%>
<input type=submit value="">
</form>
3.ڡҳУûѡĳ󵥻鿴ťִviewconfmessages.idcļļڿвѯָеϢܣҪУ
Datasource:dbmessagebase
Template:viewconfmessages.htx
SQLStatement:SELECT DISTINCTROW`+'& spacing.spacestring+& messages.
+messagesubject AS exprl,users.username,messages.messagets,+messages.messageid
+FROM conferences inner join(users INNER join lspacing inner join messages
+on spaceing.numspaces=messages.+numspaces)on users.usersid=messages.userid)
+on conferences.coferenceid=messages.+conferenceidwhere(conferences.conferencename)
+='%conferencename%'+order by messages.displayordering
ѯõȫϢͨviewconfmessages.htxʾγɡϢбҳ
4.Ϣбҳĸa.ˢ¡ťûбb.±⡱ťû롰Ϣҳc.ÿϢС򿪡ťû롰鿴Ϣҳd.һʾ£ҳδ֡һҳťʾûиϢ!ҳ.HTXļеҪУ
<formaction="viewconfmessages.idc"methed="post">
<input type="submit"value="ˢб"></form>
<form action="newtopic,idc"methed=post>
<input type="submit"value="±"></form>
<table width="95%">
<tr><td colspan="4"align="center"bgcolor="#d0ffff">
<h3><%idc.conferencename%></h3></td></tr>
<tr><th></th><>th</th><th></th></tr>
<%begindetail%>
<tr><td>
<form action="viewmessage.idc"methed="post">
<input type="submit"name="open"value=""></form>
</td>
<td><pre><%exprl%></pre></td>
<td><%username%></td><td><%messagets%></td></tr>
<%if currentrecord eq 9%>
<form action="viewconfmessages.idc"methed="post">
<input type="submit"value="һҳ"></form>
<%endif%>
<%enddetail%>
5.ϢҳûϢı⡢ϢĵȣȻ󵥻ҳеġ͡ťpostnew.idcļļûϢ⡢ϢͬûʶѡıʶϢڵȲ뵽ϢСע¼ĸϢʶֶӦΪ1ϢǶֶӦΪ0ֶӦΪֵֵֶ+1ͬʱʾϢбҳSQL£
INSERT INTO messages(messagesubject,userid,messagets,conferenceid,parentmessageid,
+numspaces,messagetext,displayordering)select`%messagesubject%','%userid%',now(),
+'%conferenceid%',0,1,'%messagetext%',1+max(displayordering)from messages
+where confrenceid=%conferenceid%
6.ûڡϢбҳеĳϢġ򿪡ť롰鿴Ϣҳҳǰ󡱰ťʹûǰ鿴ϢػصϢбҳťûʾϢϢصбťûءϢбҳ
鿴ϢҳIDCļеSQLʵָmessageidusersֶΡϢߵEmailַĹܡ
鿴ǰһϢIDCļеSQLУ(message.displayordering>(select displayordering from messages where messageid=%messageid%))һȷһϢܷضУODBCoptions:sql-max-rows=1һֻһı鿴һϢIDCļеSQL˾ơ
ڼĳϢʾʱע⣬Emailһӣû߷Emailùһδʵ֡
<%if authoremail eq""%>
<%authorname%>
<%else%>
<a href=mailto:<%authoremail%>>
<%authorname%>
</a>
<%endif%>
7.ڡ鿴ϢҳУûť롰ϢҳҳûϢ͡ťϢΪڲ鿴ϢϢصϢбҳڷϢIDCļҪSQLϢdisplayorderingʹ֮ϢбʾڸûϢϢdisplayordering1Ӧ.HTXļҪõıtextarea.<textarea>ʶӦýſʼʶκοʼʶʶֶ֮Ϊıȱʡֵ
8.ûڡ¼ҳе³Աעᡱť롰³Աעᡱҳҳʾʹñ̳ļɣҪδעûûEmailַȱҪϢעᡣ֤ûǷΨһûǷ֮ͬusersС
9.ûڡеҡť롰ҡҳҳһбûѡһ()һûַڲַпͳҡťѯһͳ˵ûʹͳҪ£
<select multiple name="seldconferences">
<%begindetail%>
<option value="<%conferenceid%>"><%conferencename%>
<%enddetail%>
</select>
10.ҽҳ롰Ϣбҳƣҳһťûô˽롰ҡҳǲҵϢбһʾ£ҳδ֡һҳťʾҲˡ˺ͷҳõĴ£
+where messages.messageid>%maxmsg%
+and messages.messagesubject like `%searchtext%'
+and conferences.conferenceid in(%seldconferences%)

IDCʵֽݿInternetIntranetϷķصŵ㣬Webվ˸Accessݿϵͳ֯ģҲκһ־ODBCݿϵͳʵ֣MS-SQLSYSBASEȡ
ߵλƼ(й֯ѧϵ  214063)
οף
1ϣͼ鴴ҡMicrosoft SQL Server6.5οֲᡡѧ
2Susann Novalisɶ롡Frontpage97ŵͨӹҵ
3Mark Minasiߡ롡Windows NT Server 4ŵͨӹҵ
ոڣ1999-10-20
