΢͵Ӧ
MICROCOMPUTER APPLICATIONS
2000Vol.16No.1P.36-37



ݿҵ()˾ֿ
Ϣϵͳʵ
öڽ𺣡Ծ쳡κ
ժҪ½ݿҵ()˾ֿϢϵͳ(YKJDMIS)˼룬ԼC/SB/S沢õģʽô͹ϵݿOracle7.3ǰ˿Visual Foxpro5.0ľʵַУ˽沢C/SB/Sģʽŵ㣬˷ֲʽݿϢĽ취Լصļ߹ܵʵ֣л漰̬㷨Ͷ̬ɷ
ؼʣC/SB/S󡡷ֲʽݿMIS
AbstractThis paper introduces the overall design of YanZ hou Mining (Group) Corporations Management Information System (MIS) of Mechani cal & Electrical Equipment on the Two Levels of Bureau and Mine. It also describ es the concrete implementation method of using large RDB Oracle 7.3 and the fron t end developing tool of Visual FoxPro 5.0 to develop such a system based on Cli ent/Server (C/S)and Browser/Server (B/S). It particularly explains the advantage s of cross usage of C/S and B/S and the solution to the problem of sharing infor mation in the distributed database, and the implementation of related Computer A ided Decision Support functions. The method of dynamic creation of arithmetic an d dynamic reports is also given in it.
KeywordsClient/ServerBrowser/Serverobject oriented Distributed Database Management Information SystemCAD
һϵͳ
ݿҵ()˾ҹúҵͷݿҵ()˾ֿϢϵͳ(YKJDMIS)ݿҵ()˾ϢϵͳҪϵͳݿҵ()˾ʮҵӵл豸̨豸ɼŹ˾紦ͳһлƣרŹ豸Ź˾Ļ豸ɢڸ豸վҵЩҵڵֲϱȽϷɢԹżʱ豸Ϣѡ豸ϢϵͳĻĿΪṩʱ׼ȷ豸ϢԱĹԱŽпѧЧΪ߽пѧṩݡ
Ź˾ְ֯
1.֯
Ź˾֯ͼ1

ͼ1 Ź˾֯ͼ
2.ָҵְ
紦
(1)칫
ĵġġ鵵֪ͨ
(2)豸
豸۹豸̱ޡƻ豸¹ʣϹŹЭ걨ռ豸Ϣתļ豸̨ʣ豸ݡػе¼죬
(3)ת
Ĵת豸(ˮáѹͨʳ)̬豸ͣ޹˿Ƥ̬״̬٣豸󻬹豸
(4)
õ
(5)ۺϿ
豸ȫ¯ѹڳ
(6)ʩ豸վ
豸޹豸ã豸͡޺ͬ豸޹豸豸״̬٣޷ѹ
(7)豸
豸ܡָꡢת״̬
3.ҵ
ƣ
豸Ϣ豸Ƭ̨ʹ豸̱ޡƻƣ豸޹豸ϡ¹ʴ˿Ƥü桢ʹü̬״豸󻬹
4.֮ҵϵͼ
֮ҵϵͼ2

ͼ2֮ҵϵͼ
ϵͳԭ
(1)ִͨżʵȫŹ˾豸ļ߹淶ҵʵϢڴֹͶĻϣʹŹߵһµˮƽ
(2)ȽINTRANETΪƽ̨INTRANETMISЧؽΪŵճﴦṩȫµ֧֡
(3)C/SB/S沢ģʽ֯ϵͳĿڿڡڲC/SģʽҵԱʹáC/SģʽǿȫԺãͨѶͣٶȿ졣ڼŹ˾ڲB/Sģʽ쵼ѯáB/Sģʽͻ˼򻯣άףûʹü򵥣Ϣ
(4)ͳƷȷݲѯͳƵ׼ȷԺͼʱԡ
(5)ٽ;߿ѧִ
(6)ͳһࡢֱۡʵͼû棬㡢ʹֱۡ
1.淶ҵ
(1)л豸͡ţŹ˾Ͻоֿ󼶵λʵͳһ룬Թ淶ҵñɾͳһƶλɸͳһ롣
(2)豸ӦϹұ׼豸豸Ĳѯͳơ豸Ӧӳ豸ࡢСࡢͬ豸˳š豸λҪϢ
(3)ʵҵҵķִֹҪ
2.ֲʽݴ洢
ǿ֡ʹõģ¼Ҫڸ󡢳ֻҪݲѯͳƣҲв޸ĹھֿԶͨʲߣԱϵͳݵĺֲΪɹĹؼ֮һǲõķǣݷֲ洢ڸϣֻ紦Ÿݵĸֿݶ໥ƣԱֻ֤紦Ÿݣݵ޸ļʱ͵Աݵһԡ
ŵ㣺ϵͳЧʽϸߣ롢ѯӦٶȿ죬ֻزѯͳϵͳʱݸơ
ȱ㣺ϴ󣬲ѯݿܲµġ
ϵͳάϵͳиȨûṩֿݵĲ棬ﴫݣѡµݿݵļϵͳԶOracleexp73ݵļ(ļչΪ.dmp)ûѡַϵͳԶļFTPصַȨûϵͳάϵͳѡݵļϵͳԶOracleimp73ݴ.dmpļеݿӦıС޸ݣҲݵһ.dmpļУȻصӦĿϣȨûɽݴ,dmpļԼݿӦС
3.ϵͳ
ϵͳþ֡ʹãݸְܣֹģ飬ֱпʹðװʱɸҵҪĸģ顣
ϵͳ漰ıǳ࣬ĳЩֵļ㷨Ƕ̬ıģһʱںһʱڲͬûԤж㷨磬û㷨ƣȻûмѡҪмгϵûмѡҪּļ¼¼Ҫе㣬ͻȡƽֵ󷽲򲻽κμ㡣ͳʱûֻҪѡҪмѡ㷨ƣϵͳԶû㷨м㡣
⣬ҲûѡʽҲûڹ淶ıʽѡ񣬱ȿû취óûѡ屨ļ*.frxṩûĿؼGridؼӡпͬGridпһԶ
4.ϵͳĿά
ϵͳ豸͡λصȾϵͳάУպȨû޸άǾͳһ룬ƵĸĲӰʷϢĲѯͳơ
5.ϵͳİȫ
ϵͳ¼ʱҪϵͳʹ߽ʶȻȨܶ俪ӦĹܡΪ˱ݵİȫԺͿɿԣݵĶд޸ȨҪָλȷ֡
ϵͳûϵͳάģʵ֣ɸϵͳĹԱȨȨȰģ黮֣ǷȨģ飻ΣģûΪܽб༭ȨûֻܲѯķȨû
ϵͳϵͳάУݿⱸָھֿ֮Ĵܵ͡ȡ
6.ϵͳȽ
ϵͳΪ쵼ѯṩһļ߹ܡĴת豸ʹԤûԤÿϵͳԶм⣬ԤϢͨźŵ˸ԼʾϢ澯ûṩ顣˿ĸ͹ԤҲû趨ԤϵͳԶݸ˿ʹü¼ԤʾõʷͬڱȽϵͳʱҲͼκʾȣ쵼ߡ
7.ϵͳĴ
ϵͳĴͼ3

ͼ3 ϵͳĴ
ġϵͳüṹ
ϵͳѡUNIXϵͳݿѡOracle7.3վϵͳWindows98ǰ˿ѡVisual Foxfro5.0ЭʹTCP/IPBrowse˿Front Page 98VB Scriptϵͳṹͼͼ4

ͼ4ϵͳṹͼ
塢ϵͳṹ
ϵͳṹͼ5



ͼ5 ϵͳṹ
ϵͳ£
1.豸ʲϵͳ
ϵͳ豸̨ʹ̱ƻ޹豸̨ʹַΪ豸Ϣ豸ǰ߶豸Ϣϵͳɰַʽĳ̨豸ĳ豸ĻϢвѯͳƣ簴豸ơͺŻװصвѯ߽豸ϵͳжԼĽ༭桢ܡɸԼȰƻϱԸİƻ԰ƻͳơ豸̱ƻɸԼ豸üƻϱԸ豸üƻʽ𳬹һ޶ʱҪ豸ѡ֤ﻹԹ̱ƻͳƲѯ豸޹ɸԼ豸޼ƻϱԸ豸޼ƻԴ޼ƻͳƺͲѯ
2.ת豸ϵͳ
ϵͳʽͻϵͳ˿ͣ޹ĴҪתϡ/´ʽͻͼʹÿͳƻܡ˿˿ݹ˿ʹö̬˿˿㡣ͣ޹Уɸȿͣ޼ƻͿͣ޼ƻϱԸͣ޼ƻͳͣ޼ƻĴҪת豸Ĺ豸豸ж̬豸ϵͳ¼¼豸Ʒݿݡ豸ѯָꡢ豸Ԥʹͳơ
3.豸ϵͳ
ϵͳ豸(ػݣ)͹¯ѹа豸̨ʹ豸ȫ¼¯̨ʵĹ¯¹ʡ켰ժǡѹ鱨桢ѹ״̬ͳƱ
4.豸̬״ϵͳ
ϵͳ豸ǰ״̬¼豸¹ʹ豸豸Ϲ豸豸豸ά޹
5.豸޹ϵͳ
ϵͳÿɹ豸Ĺ豸ѡ͡޺ͬ豸嵥޷Ŀ޵λ¼豸Ϣ¼豸̬¼
6.豸󻬹ϵͳ
ϵͳ豸淶󻬼¼豸ʵ󻬼⣻豸Ӽ¼豸󻬸¼豸Ӽ
7.ϵͳϵͳ
ϵͳϵͳͼĹش¹ʼ¼ϵĹ籨ͬԤûкͬݺͬŽĹ
8.ĵϵͳ
ϵͳĵ¼룬Ϲؼֵ¼룬Լֵݹؼֵ¼룬Ҫʱɸĵϻ򵥾ݵʱ䡢ƻؼֲѯĵݻĵϻ򵥾ݵĴλá
9.Сϵͳ
úС͵豸ĹƵ롢޸ġѯӡͳơݷάϵͳȹܡ
10.¹ϵͳ
ϵͳ»ϢµĶ̬ʹ͵µǰ״̬ͳơ
11.ͳƱϵͳ
ͳƱϵͳϱĸҪ丩ԼЩĻܡ
12.ۺϲѯϵͳ
ṩ쵼ͨɲѯһЩҪĻͳƵϢ
13.ϵͳάϵͳ
ûʹϵͳȨޡݿеĻ(豸롢豸͡𡢵λصƼ)άȨûݡоֿݡ

ϵͳѡĳ򿪷ߣͨõ࣬ܲѯ봰ڵȣɵЧʸߡ
ϵͳ˴ͼʾͳƽֱۡƯ쵼ߡ
ûṩĲ棬ûȥѡ񣬼ȷ㣬ֱ֤ݵԺһԡ
沢C/SB/Sģʽвּ߹ܣ㷨ɣǿϵͳά֧ϵͳĿάԣֲֿʽݿMISƲʧΪϵͳͻɫ
ߵλö(ͨѧ  710043)
Ծ(ϵͳι˾  710043)
ο
1ݲάԶҶĴC/SģʽB/Sģʽ沢õMISϵͳƽ̨΢Ӧá1999.3
2S.Ceri, G.Pelagutt Distributed Databases: Principles & System
3Singh & Leighʷɭ롡Oracleݿ⿪ָϡ廪ѧ硡1998.6
ոڣ1999-07-30
