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



Web.sqlWebݿӿڳ
Фˮ֡
ժҪϸؽWeb.sqlݿӿڳ˼롢ص㡢ʵַӦáΪWebԱṩһͨWebSybaseݿӦó򿪷
ؼʡWebݿӿڣWWW Intranet Perl
WEB DATABASE INTERFACE
PROGRAM GENERATOR BASED ON WEB.SQL
Xiao ZongshuiChai QiaolinShan Yufeng
Netware Center, Sandong University of Industry, Sandong.Jinan 250061
AbstractThis paper introduced Web database interface program generatorbased on Web.sql and its main idea , function, features and application,it provides developers with a new kind of developing method and tool ofWeb database interface program.
KeywordsWeb database interfaceWWWIntranetPerl
1ǰ
ͨWeb.sqlӿڿԽWebSybaseݿ͸ؼһΪ̬WebҳݿϢ1ṩһּ㷽ͨWeb.sqlWebݿӦĿҪ߱Perl;飬ҪWeb.sqlй֪ʶһ㿪ԱһѶȡڻWeb.sqlWebݿӦóУ̴ƣԱòдظĳ롣⣬FORMʽݵ¼ύʱڴFORMݵķWeb.sqlͨӦFORMͬһHTMLļУFORMиؼĲҪWeb.sqlãҪڲͬļ֮໥գ̴϶಻㡣ĽܵĻWeb.sqlWebݿӿڷżӦĳһֽķ
2˼ݿӿ
ͨWeb.sqlӿڼWebݿӦó2,3ݽзоǽЩõӦóΣ罫ϵͳעᡢSQLύȡSQLĽFORMύ¼Ͳ˵ܵȶΪֽӿڷţ뵽HTMLĵʵλãӦĳԺЩŵHTMLĵдתΪӦܵPerl򣬴ӶʵWebSybaseݿķʡͼ1Ӧʾ⡣

ͼ1ϵͳṹ
2.1ӿڷŶ
1 <%DATABASEdb%>
ָʹõݿ⣬dbΪݿ
2 <%SQLsqlsta%>
ݿSQL䣬sqlstaҪ͵䡣
3 <%RESULT%>......<%/RESULT%>
<%RESULT%><%RESULT%>һѭ͵select䣬дصĲѯ
4 $coln
òѯnselectеֶ˳Ӧn0ʼ
磺select namesexage from tabman
$col0ݣ>name
$col1ݣ>sex
$col2ݣ>age
5 <%ACTIONformactionname %>......<%/ACTION%>
FORMύ󣬷˵ݴ̣Ӧĳ뵥һ¼ļformactionnameӦFORMactionurlͬ
6 <%GOTOurl%>
ضurlָWebҳ
7 <%REFRESHnurl%>
ʱurlָWebҳnΪʱλ롣urlָǵǰҳҳʱˢ¡
8 <%LOGIN%>......<%/LOGIN%>
ִûעṦܡֻûעɹִиôͨ<%LOGIN%><%ACTION%>С
9 <%RIGHTrightname %>....<%/RIGHT%>
ûǷ߱ĳȨޣ߱rightnameȨ޵ûִеĳ顣
10 <%LOGIN CHECK%>....<%/LOGIN CHECK%>
ûǷעᣬֹûֱURLִг
11 <%MENUmenuitem %>....<%/MENU%>
̬CGI򣬸͵ĳִʱͨURLĲṩ˵ѡݲͬmenuitemִжӦMENU顣
2.2ͨĳṹ
<%DATABASEdb%>
<LOGIN CHECK%>
<RIGHTrightname%>
HTML
<%MENUmenuitem%>
HTML
<%SQLsqlsta%>
<%RESULT%>
HTMLʽ
<%/RESULT%>
<%/MENU%>
<%/RIGHT%>
<%/LOGIN CHECK%>
<%ACTIONformactionname%>
<%SQLsqlsta%>
<%GOTOurl%>
<%/ACTION%>
3򿪷̺ͳʵ
3.1ӿڷų򿪷
1 Frontpageб༭HTMLĵFrontpageǽΪõĿӻHTML༭еEDIT:Database Column Valueӿڷţֱͨı༭룻
2 HTMLеʵλòӿڷţõļԡ.htxΪչ
3 ӿڷŵ.htxĵתΪPerl
4 ɵPerl
3.2
1 ű
@symbol="ӿڷ", ... ...
ڽӿڷ漰ɱλ$para档
2 ӿڷŶӦĴ
@code=qq!.....
.....!,
qq!.....
.....!,
......
@symbol@codeԪһһӦ
3 ɨ.htxļĽӿڷöӦĴ滻еĿɱ뵽ӦλãHTML룬perlprint乹죬ʽ£
print qq!HTML!;
4 .htxļе<%ACTION: formactionname%>ڵĴ룬һperlļļΪformactionnameݡ
3.3ݿӿڳ
1 (compiler.pl)ͨøó򽫽ӿ(*.htx)תΪperl(*.pl)
2 Ի(wdtool.htm)ûṩһĽʽ档ûӿļͽҪɵperlļtest.htxtest.plȻύ˵compiler.plӿtest.htxתΪӦperltest.plûԲһɵperlִ
3 (gentestview.pl):ļڲɵperlִ
4 Դ鿴(viewsrc.hts)ļڲ鿴ɵperlԴ롣
5 ߵ(wd.pl):ͨøóɶԽӿת͵ԡֱַӿļеԣʽΪ:.../wd.pl?htx=test.htx
3.4л
5ļƵWebĵĿ¼УͨҪĳĵͬһĿ¼¡WebIISNetscape Enterprise Web Server
4ص
4.1ȫ
ԵϢinternet/intranetһҪԣִԴİȫ⡣WWWinternet/intranetҪķ֮һ,WebվİȫرݿİȫΪҵǳӵо⡣ˣWebݿӿ﷨ͨԷʵWebݿӦóİȫԡ<%LOGIN CHECK%><%login%><RIGHT:rightname%>ȣ<LOGIN CHECK%> Ĺͨ˶Կͻ˻IPַûûעϢԷŵʹã֤ûĺϷԼʵȨ޵ȣֻͨϷ֤һȨ޵ûɷWebҳһ̶ϽWebݿӦϵͳеİȫ,ЧĶϵͳб
4.2¼ı̷
FORMû԰ԼϢύWebҲɽܴWebϢ޸ģʹͻ˺ͷ֮ʵ˽ʽķʣõ˹㷺Ӧã΢˾FrontpageΪԱṩһӻĿܷĴͶFORMǶFORMύݵĴҪɷ˵CGIɣFORMActionָCGIĳֱԱдĶĳļڽӿУͨ<%ACTION%>ӿڷţʹԱͬһHTMLĵмȿԶFORMͬʱҲ<%ACTION%>öĽӿڷűдFORMݴ򡣰FORMݵύΪһ¼¼<%ACTION%>гִС
4.3ʵ
ʹWeb.sqlûΪ͸ûֻFrontpageWebбHTMLĵHTMLĵʵλòӿڷţԶɽӿPerlתԲϤperlԺWeb.sqlû򲻱רѧϰЩ֪ʶֻ迪յĽӿڳ򣬾ͿWebݿӦóĿ񡣶ϤperlԺWeb.sqlĿԱ˳򿪷̡
߼飺Фˮ˶ʿʦҪо̻ݿ⼼Intranet
֡ڡҪо򣺼缰缼
塡˶ʿʦҪоýӦá
ߵλɽҵѧġɽ.ϣ250061
ο
1ݡNguyen T, V. Srinivasan. Accessing relational database from the World Wide Web. Proceeding of the 1996 ACM SIGMODCanada1996,6:529-539
2ݡκ,. WWWݿ.о뷢չ1997;(8)
3ݡ. Webݿ⼼չ. йû, 1997;(10)
ո:1999-01-11
