Ӧо
APPLICATION RESERCH OF COMPUTERS
2000  Vol.17No.1P.68-70




Ѱϵͳʵ
̺ꡡ־
ժ Ҫ Ѱϵͳص㣬Ѱϵͳƺ͹ģϸͬʱѰĻ̣Ա֤ѰϵͳĸЧԡѰϵͳɿԡȶȡӲʵַȫо
ؼ Ѱ  C/Sģʽ
1 
ͨѶҪͨѶʽ֮һŵڸ㣬ƶԺãڶϢշBPֻȶǶϢͨѶϵͳĵʵ
ѰϵͳͨǴ͵ϵͳȰվӲӦѰѰڳӲĻϿľжֹܵϵͳѰĻпͻϢķ͡ԱͻϹͻϢͳơϢʱϢȣĸӹܣѰϵͳɶ໥ģɡѰĿУԣҪʱ̹Ϣ͵ĸЧԡɿԼȶԵȡڼܹѰϵͳӲʱҪֿߵĿѧԺͺԣѡʱҪֿϵͳĿɿԣĽṹϣʵĽṹ֤Ϣ͵ĸԵȡͳѰϵͳΪԭһǻNovellDOSϵͳ£ѶѰϵͳWindows NTϵͳʵͼν棬ϵͳȶݱݡײԵȷиŵ㡣Ľ⼸ϸ
2 ϵͳṹ빦
ѰϵͳûѰϵͳĸЧԡɿӲáʵֵҪĿ꣬ڿҪμһ㡣ǿѶѰľ飬ǴϵͳṹԼĹܷϸ
2.1 ϵͳṹ
ѰϵͳͨѶڿͻϢķͺͲѯϣǲÿͻϢԱϢĽṹԭڹϢķѰϢƵռͨѶ϶࣬ǣϢķҹȽΪеʱСͬģԲԱϵĹԼûϵȵĹҲҪУֻϷ仯µסͳʱŶϵͳϽά˲õϵͳṹͼ1

ͼ1Ѱϵͳṹʾͼ
Ա80100̨486586(100)̹վɡ̹վUC-DOSϵͳȿԽͳɱҲЧֹڻԱϵͳĲ˽ϵͳ̹վNTз˫ȱݣֹڲ֪£ʧʹѰϵͳ̱ӰѰ񡣸߼ԱʹõĻ(̨)Ϊ586(266)Щͨһ·ռѰϢõ硣ѰϢķͨɵģõѰͨԷݿĶȡַϢǷдݣдݣͽϢ͸רŵı豸ѰϢбͳȥ
2.2 ϵͳ
ѰϵͳͻϢķͻѰ̨ĹܣϵͳܹϵԷΪ󲿷֣1)ͻϢķͣⲿҪǰ̨Աʵ֡2)Ѱ̨ϹûϵĹԱϵĹϢȺùԼ۹гȸԹܣͬʱΪ˽˫ͨѶйѰϵͳӿ˫ѰϵͳӿڣԹ˫Ѱʹá3)̨еĴܡ󲿷ศɹͬѰϵͳЩܶͨݿıϵһݿУϸݿνЩģϵġܸģĹܡѶѰҪ漸ģ(ģ)
ٻԱģ
ѰѰϵͳĹܣûʵּʱϢѯϵͳȺظȡֵעǣΪ˱֤ѰЧʣͻԵĹ̨ԵȹܷڹԱģʵ֡
Ѱ
ѰǳҪѰϢбͳȥݷϢ¼ѽ׷ӵͳϿȥѰҪϢϢ͡
۶ʱ
ʱʱأں̨УҪ˹ԤеĲȱƵĳɵġʱ㴦ͣûݿʹ߽Ѵ֡
ܹϢ
ϢһϢɹԱвġ
Ϣصǣ
ϢһһԵķ͸һȺûû
ϢĳȱȽϳ
ϢͱȽϹ̶ϢȽƣһĶԡ
ˣڽйϢʱöĹϢݿ⣬ݿݽи£ضʱ䣬ɶʱȡݿ⣬ӶԶʵϢķ͡
ݹԱģ
ԱģѰҪɲ֡ҪпͻԱϹȺԼѰϵͳĹܡԱģͬܲͬķʽݲͬԱļʾͬĹܽ棬ԱֻʵʾеĹܣûĳȨ޵ĲԱӦĲԱļԱ߼Ա(Ա)Ա(ΪϹԱֵ̨)͸߼ԱǷֱʵйеĲֹܡ
ûϵĽɾġѯϲѯͳƹܡ
ԱϵĽɾġѰϢ顢Աÿջѯ
ԵĽɾ޸ġ
Ⱥ
߽ѡǷѡͣûѯͳơ
3 Ѱϵͳʵַ
3.1 ݿѡ
ԭ˵ݿѡжַԲOracleSQL ServerԼݿ⣬SybaseȡǵѰϢϴص㣬ԼͶɱݿάײԡݿĿչԡԵȷ棬ϵͳSQL Server7.0SQL ServerݿİȫԵȷͻص㣬Oracleһǿݿϵͳ֮ûѡOracleԭڳɱͶĿǣҪ100ǰ˹վ£SQL ServerOracleãOracleǿܵʹҪʽϸߵݿԱOracle˵SQL ServerĹԼЩSQL ServerWindows NTڰȫԵȷ漯ɵñȽϽܡڿУע⵽SQL ServerԷOracleݿв㣬ⲻӰϵͳܵʵ֡
ǰᵽģݿŸģ顣ѰҪб
ûϱ(Userinfo)ûϱڴŵǼûйϣͻ롢ͻ롢ַ͡ʼʱ䡢ֹʱ䡢Ƶ㡢Ա26
Ϣ(Transmit)ڴŴѰϢ
Ϣѯ(Infoqury)Ϣѯ洢һʱڷѰϢ
ʱϢ(Timing)ʱϢڼ¼ûʱ䷢ѰϢ
Աϱ(Operator)ûϱڼ¼ԱйϢ
ͳϢ(Statinfo)ͳϢаһʱ(ͳϢĲͬΪաܡ¡)ͳϢ
ϱ(Groupinfo)ûϱйϢ
Ϣ(Grouptran)֤󽫷Ϣд뱾
Ϣ(Publicinfo)ĹϢ
ڻԱˣԱӵûĵ绰ûĺ룬ϵͳûϱĻʾйϢЩϢԱ֤ûЧԣ״̬֤ɹ󣬽ѰϢд뷢Ϣ⵽ϢеϢϢ͵ϱȥͬʱϢдϢѯݿˣдϢѯļ¼м㣬дͳϢԹԱģʹá
ڿ̨ˣĹѰƣԱϱϢдϢⲢϢȥϢķԼ򵥣ֱӶȡϢеݣЩϢŶӺ䡣Ϲ뷢ûйϵûԱϵĹǶûϱждԹԱʹãҪͳʱԱȡͳϢеļ¼ԲԱѰϢвʱֻϢѯȡϹǸԶĹ̡
3.2 ϵͳ
NT̹վͨHub̨Windows 95/Windows 98Windows NT Server 4.0
3.3 
ݲͬģòͬĿߡʱģͻԱѰģVC++l.5ϣʹVCĳٶȿص㣻Աģ͹ϢģPowerBuilder 6.0ϡ
3.4 Ϣ͵ͼ
ѰѰϵͳĻĺĹܡ
棬صѰ̣ͼ2ѰͼͼԽбʵ֡
4 ؼ
ϵͳĿѰص㣬ڿǰ뾭ϸ¡ȫĵУݿṹݿиԼĽṹгֵ⣬̱ײݿ΢СĶΪ벻鷳ļܹ棬粼ߡ豸ѡӰϵͳЧʣʵϵͳͬʱҪֿϵͳչڵѰϵͳʵϵͳ˫ѰܣҿǵᾭõķչǻΧԽԽ㵥Ѱͨţϣʱضܵ뱾һͨŷ񼴹ѰνѰϵͳָڲͬѰͨĳַʽ໥ϢݺͽʹЩϵͳеѰûܹÿѰΪѰҪݿм˹ѰҪֶΣǡƵȡΪʵͨѡκٺغȹṩ˿ܡϵͳȫ漯NTSQL ServerİȫԣͨԱȨ÷ӦܡΪ˱֤ʵʱԣں̨УݿĴʹйصݿʵʱ¡
5 
ĶԶϢѰϵͳʵֽϸָʵֹҪעԼõĹؼܹʵֵȷα֤ѰϵͳĸЧԡɿԡʵʱԡԡϵͳбͼνNT ServerµϵͳԭеĻDOSNovellѰϵͳԶݡȫԡЧԡײԵȷиŵ㡣
Ŀɹǻƻ
̺꣨պѧѧ빤ϵ  100083
־գպѧѧ빤ϵ  100083
ο
1Frank Derfler, ϴӨ. 缼ʵָ. ӹҵ, 1999.1
2. PowerBuilder6.0Ӧ뿪. 廪ѧ, 1998.12
3Soukup, Ӣ. SQL Server 6.5Ļ. 廪ѧ, 1999.2
4Kruglinski, ӡ. Visual C++Ļ. 廪ѧ, 1997.9
5Microsoft. ݿϵͳMicrosoft SQL Server 6.0. ѧ, 1997.1
ոڣ1999628
