
COMPUTER ENGINEERING
1999 25 10 Vol.25 No.10 1999



ͨݿģʵ
뺺ƽӻԾ
ժҪڷSQLݲṹĻϣһͨݿģʵ֡ģǴʲֱʽʵݿͨòѯ롢ɾ޸ģйܴܺ󡢲򵥵ŵ㡣
ؼʣݿ⣻SQLԣݲ
The Designing and Implementation o fa General Database Manipulation Module
Feng Hanping He Yongyue Wu Zuoqiong
(Systems Engineering Institute of Xi'an Jiaotong University,Xi'an 710049)
AbstractBased on the analysis of the structure of common SQL data manipulation sentences,this paper inrtoduces the designing and implementation of a general database manipulation module.This module offers the users a visualized way of filling up forms which executes the general database functions of query,insertion,deletion and update.It is highly functional and easy to use
Key wordsDataase;SQL language;Data manipulation
һϸӵĹϢϵͳУѯ͸ݿⶼǳõĲͨǰԤ趨ķʽṩĳЩݿ¼롢ѯͳơȡ׶ǣ1)Ӧûı仯ȱԣ2)ݿṹӦǿ3)ûõĲҲҪרűд룬˷бҪһͨõݿģ飬һּ˵ķʽûṩȫݿӦûĸҪ󡣱ĽܵͨݿģDelphiʵ,˼Ժ׵ֲWindowsĿϡ
1˼·
SQLǹϵݿı׼ԣݶ塢ݲݿƵĹܡ幦ǿ󣬶ҿΪDelphiȺֱִܶУʾûݿҪǸܺõѡ񡣵ǲûֱʹSQLԣΪ1)ҪӢıɲԲ治Ѻã2)޷֤ݰȫܵQBE[1]ģķʽȫͼν£ɳûҪͳSQL䣬ӶרҵԱSQLһֱּ۵ķʽṩͨûڽ͹неȨ޼飬ȷݵİȫ
1.1 SQLݲķ
SQLԵݶݿһ㲻ҪҲնûʹãûֻͨõѯ롢ɾ͸µ4ݿSQL4ֳõľͣ
Selectֶбfrom[,[where]
Insert into[(ֶб)]values(ֵб)
Delete from[where]
Updatesetʽб[where]
һ﷨ЩԹΪĿ꡴ݱضļ¼ĳЩֶΡĳ֡(ѯ롢ɾ޸)ˣݱֶбʽ;͹SQL4Ҫءֵб͡ʽбҲԸֶεĲֵ޸ֵԹᵽֶбҪȥӶȷSQLĹ̾תΪȷ4ҪصĹ̡
ʹøӵSQLǿĹ֮һʽһ߼ʽԹΪ
:=or|and[or|and]
:=ֶΡʽ
:=>|<|=|>=|<=|<>
ڡУ䲻һֶΣ任ԹΪֶεʽұߵġʽֶΡΪֱ۵ر֮ġ롱͡򡱵Ĺϵʹһ1ʾı뷽ʽ֮ǡ򡱵߼ϵʱڲͬ룻ǡ롱Ĺϵ漰ͬġֶΡʱͬһеĲͬ룻漰ͬһֶΡ໥֮ǡ롱Ĺϵڱͬһ룬öŸʽʱִͬһڵġ롱ϵִмġ򡱹ϵԱ⸴ӵڱ롴ֻӦڡֶΡд͡ʽɣοͼ2
1뷽ʽ
ݱֶ 1ֶ 2ֶ 3
ֶб



ͼ2 
ھʵʱȷͺݱĹǶеģģֱǰ4ֲͺϵͳɲı԰ťбʽṩûѡȷֶбʽĹͬʱУûʵҪݿҪ1ʾıУģݱֶбеݣȷĿֶΣݱеݣȷʽȷ4ҪغϵͳֻҪSQLľ䷨ɾͿԺϳȷSQLָˡ
1.2 
ûѡ˶ݱԶЩݱ֮乲еֶΣĬϵTable1.C1=Table2.C1[and]ʽTable1Table2ҪӵݱC1ǹֶΡûҲԼûڽжʱʵָ£ģЩϽһͼʱûͿڵϲһ롢ɾ޸ˣҪ֧ͼĺ̨ݿϲʵ֡
1.3 ĵĴ
ڴ󲿷ͺ̨ݿϵͳʹӢֶΪģʹ¼ֶεϢ
TFieldInf=class
Name:string;//ֶ
Description:string;//ֶε
AllowUpdate:boolean;//ʶǷ޸
end;
ģרŵĳַбֶεתɶӦӢġûֱĻ½иֲҲֱʹֻһת򡣶ڳõģṩ˿ݲ˵Էû롣ڲ£Ա(ֶ)ϸ֡
1.4 ݵİȫ
ģ˱־ǷµȨ޲ڽ͹нȨ޼飬ݵĿƿԾȷֶΣȷݵİȫ
2ϵͳʵ
ģʵ˲ѯ롢ɾ޸ĵ 4 ͨõݿģ֮ĵùϵͼ1

ͼ1 ϵͳùϵ
2.1 ģ
ģҪ˻ӿڣ书ǽû룬ݸӦĹģ飬ͬʱϵͳϢظûģҪûѡҪݱȻȡֶڴԱ1ʾʽʾû롣
2.2 ģ
ģûϢʽͼ2ʾΪѯǷѵסϢɵʽΪӦս>ʵսor ˮӦս<ˮʵս(ڶӲѯɵʽиֶǰڵıݱ롱㡣)
2.3 ѯģ
ѯģ˿ɽиӵѯ⣬ʵһЩͳƹܡ磬ûܵӦսֻڵڶСӦս롰sumֶܺ͡εĲѯ״̬ɡģֵ֧ͳƺ2ʾѯĽڴڵĵײʾȨûֱڲѯ޸ݡ
2 ͳƺ
ͳƺ
CountĿ
Sumܺ
Avgƽֵ
Maxֵ
MinСֵ
2.4 ģ
ϵͳеĲ롢ɾ޸ĵģ飬Ҫɶָݱв롢ɾ޸ĵȹܣѯģơЩģУҪɡֶбֵбʽбȹؼǵɷʽʽԡʽбΪûҪ޸ġӦսֵڴֶд޸ĵĿֵ3ʾûͬʱ޸ĶֶΡЩģ԰ûɺܶ಻õĲ硰õ100ȵסĵѴ9Թõ硱Ȳ 
3 ޸ĲĿֵ
Ŀֵʾɵġʽб
+1Ӧս=Ӧս+1
=1Ӧս=1
ʵսӦս=ʵս
($+1)*2Ӧս=(Ӧս+1)*2
3Delphiһʵ
DelphiУTTableTQueryǳõݿ⴦ؼǶTBDEDataSetࡣģҲTBDEDataSetĶΪýӿڡʵҪ3ŵ㣺1)ʹDelphiݿ⴦ؼǿļֶκLookUpֶιܣ2)ֶԼǷ޸ĵı־ֱӴTBDEDataSetеõ3)ĲQueryʵ֣⴦ʵ־ͲʹSQLʾҪˣTBDEDataSetFilter(ɷʽSQL)ԼɾȷЧʱSQLһЩ 
4
Ľܵͨݿģ飬ʵڸֱϽиӵĲѯ롢ɾ͸£ṩ˰ȫƺһģûֻɸֲǳաΪĳҵ˾շϢϵͳһģ飬Ѿûʹãڻ̫InterBaseݿϵͳãû
߼飺뺺ƽ1979У˶ʿ򣺵г
ߵλͨѧϵͳо710049
ο
1 ѧ,º.ݿԭ빤Ӧ.Ϸʣйѧѧ,1996
2 ʦ,ɺ.ݿϵͳ.ߵȽ,1994
3 Ѧ.Ϣϵͳ.廪ѧ,1993
ոڣ1999-03-15
