Ӧо
APPLICATION RESEARCH OF COMPUTERS
2000Vol.17No.2P.84-86



עܼӹݿϵͳо

ժ Ҫ ¿עܼӹݿϵͳۣϵͳܴ㹫ʽڵĲͬʽĹղ֤ʵõġ
ؼ עܼӹ ݿ 
1 ǰ
עУҪϵضԸֹղŻ磬ע¶ȡעѹѡϵȲŻͬʱڸֹղڲͬ豸ͲͬõŻݻͬҪһܻݿϵͳܹעܼӹ̵ĸŻݽй⣬ڸϡ׼漰ļ㹫ʽˣӦҪݿϵͳּ߱㹫ʽ
۵ڶעܻҵע޹˾ڴѧ̼ѧԺĺĿǵУȷעܼӹУҪ漰Ĺղʽֵ֣Χֵϵֵͼ㹫ʽ
2 O-O
(OO)Ŀǰ봫ͳ̷ȣ̷¼ŵ[1]
ٴʵп͹۴ڵ()ϵͳϵͳоȻ˼άʽʹϵͳֱӵӳ򣬱Ｐ໥ϵıò
OOAOODһµıʾڴͳз֮ĺ蹵
OOP׶βĳܹܵضӦOODģ͡
ϵͳױ仯أ,΢ķװڶڲ,νġЧӦ
߲󷽷עܼӹݿϵͳаķOOA(Object-Oriented Analysis)OOD(Object-Oriented Design)ıOOP(Object-Oriented Program)ĲOOT(Object-Oriented Test)ĸ׶Ρ
1)OOA
ͼ1ΪϵͳOOAģ(ͼ)

ͼ1עܼӹݿϵͳOOAģ(ͼ)
ͨϵͳϵͳΣ߸ࣺ
DBMSԱһࡣϵͳаݵĽɫǿϵͳûݿиִDBMSԱһΪDBMS,ͨϢ(ûݿ⡱͡û桱)ӦԼĹܡ
ûݿ⣺ûݿ⡣ʱݿ⡱͡סݿ⡱ϢִӦķ
ݿ⣺ҪΪʱݿ⡱͡Ϣݿ⡱ĸڡ
ʱݿ⣺ڡݿ⡱࣬ûݿļ¼ϵͳֱӴľݿ⣬ûݿ⡱ϢִӦķ
Ϣݿ⣺ڡݿ⡱࣬йûݿһЩϢ
û룺ҪϵͳṩҪĸϢ
û棺ʵϵͳĸֹܡڡû桱롰ʱݿ⡱͡Ϣݿ⡱֮ƵϢˣ壭ֽṹʱݿ⡱͡Ϣݿ⡱Ϊû桱ֶ
2)OODOOPOOT
OODOOAһµĸԭͱʾ֮䲻ں蹵ҪӷĵĵתˣOODҪOOAеһЩʵ⡣һOODʵOOAֵĶࡣ
OODУûСDBMSԱһࡣʵϣϵͳͨûWindowsһЩؼWindowsڲϢʵDBMSġ
OODҲûСûݿ⡱ࡣֻOOAΪ˷˼·һࡣ
OODУMFCṩCRecordsetOOAеġݿ⡱ӦͬʱֱCRecordsetCFundamentalOOAеġʱݿ⡱ӦCFieldInfoSet͡Ϣݿ⡱ӦCDialogCDbRecordDlgOOAСû桱ӦOOAеġû롱OODҪͨһЩԻʵֵġ
עܼӹݿϵͳOOPOOTھı̺ͶϵͳĵԹѾõʵ֣ﲻ
3 DBMSϵͳļԼ취
1)Եעܼӹݿϵͳ
һ˵Visual C++ṩMFC⴦ĳݿ⣬Ҳ˵ݿֶϢǲ׸ıġעܼӹݿϵͳҪǸֲͬݿ⣬ˣʵֶԸݿĴǿDBMSϵͳѵ֮һͼ2ӳ˽һ˼롣

ͼ2
ûҪݿΪAΪûݿ⡣ֶϢݿĲͬı䡣⽨һ㹻ֶεĹ̶ݿBΪʱݿ⡣ֶǾģıġ跨õAм¼Ǽ뵽BУAB֮Ӧñ֤ͬ͵ֶ֮ݴͣȻϵͳͿԴB̶ݿˡҲζʵ˶AݿĴɺ󣬰Bеļ¼ظAʵûAı䶯ȻBõֶλAĲͬı䡣Ϊ˽⣬һݿCΪϢݿ⣬йûݿAϢͿԸCϢBӦĴˡ
ͼ3Ǹ÷ͼڴͼУûݿ⴦ģĹǣ跨ȡҪûݿAйϢ(¼ֶθÿֶεֶֺε͵ȵ)ϢݿCбȡûݿAм¼Ǽ뵽ʱݿBȥͬʱûݿAеϢûʾ

ͼ3
2)ʽĴ
һԼԱʹDBMSϵͳܹʶΧֵϵֵ㹫ʽʽ
ִкСжΪΧֵ
ִԡβжΪ㹫ʽ
ִԡ[ʼ,ԡ]β,жΪϵֵ
Ϊʹϵͳ߱㹫ʽϵͳһֵʵֹʽ㡣ͼ4ʾֵܵϵͳϢ(ʽ)󣬱ֵ㣬Ȼ(ʽֵ)ΪϢظϵͳ

ͼ4
3)עܼӹ̵Ż
ΪΧֵϵֵĲģоԶɻӦŻݣҪϵͳܹڲͬµֵ
ԷΧֵΪ(ϵֵĴ)ߵĽͼ5ǷʾͼD淶ΧֵݣFҪʾĳΧֵŻݣEŴΧֵϵֵֵʱҪõйϢ
ΪܹʾΧֵӦŻݣ߰ÿŻݶһ¼(ü¼ֵֶӦı·dbPathtableNameڼ¼ıʶrecordIDӦĲFieldName)ԤķΧֵݿD档ֵϢݿEϢͿԶDеݽСΧСˡڷΧֵʾݿF(ʵFDһӼ)ʶҪĲڲͬµݡ
ʵϣʽ(˳)ȡӦݡ
·(޶ʺ)dbPathtableName¼ʶrecordIDֶFieldName
tableName¼ʶrecordIDֶFieldName
õһʽԓܵؔʶݿбĲӦݡһȱ㣺һвֵĴ洢λñ㲻ܸıˡעܼӹݿϵͳʶֵʱпִܳ
õڶʽԓܵؔʶовͬıеĲӦݣĴ洢λ(Դ洢ڲͬ·߲ͬķϣҿԾвͬ)ǣлͬıDBMSϵͳʶֵʱпִܳ󡣱ϵͳõǵڶʽ
4 
߿עܼӹݿϵͳɶԸֹղŻ룬ʵ˶ֵΧֵϵֵͼ㹫ʽȸֱ׼ݵܻۻ˾Ӧ֤Чġ
ڴѧ̼ѧԺ  518060
ڴѧ̼ѧԺ  518060
ο
1ά, ܽ. ϵͳ. 廪ѧ, ѧ,1998
2Marshall Brain, Lance Lovette. Developing Professional Applications for Windows95 and NT Using MFC
3ģֲ. еҵ, 1994
ոڣ1999628
