
COMPUTER ENGINEERING
1999 25 12 vol.25 No.12 1999



ҵϢϵͳСϻӡܵʵ
սƽ
ҵϢϵͳǽҹ״ʡмһ׻ͼʻԱϢϵͳĿǰе50ݻͼʻԱճϵͳClient/ServerģʽSybase/PowerbuilderǹͬϵͳмΪȽһ
ϵͳлͲԱʮָӣװWindows NT ServerHPķ΢ġ֤մҡġġָͨġ4ܷȾDDNרû80ûʹõĲϵͳWindows 3.1/3.2Windows 95/98ȻṩϸȨùܣΪ˽һ֤ϵͳȫԺݿɿԡԼȨԣֹʧ󣬶žԱ˽ףһЩϵͳеϵͳ־Ʋʵһǿ"ϻ"ܣùԶ¼ÿһûʲôʱʲôط̨ͨϵͳʲôʱЩȵϢùܵ˼ͬϢϵͳһĽá 
1 "ϻ"
"ϻ"Ҫ¼Ϣ࣬һͲϵͳصģһҵصġͲϵͳصϢIPַʱ䡢ûȣҵصϢӦűϵͳĸӹ
ϵͳͼʻԱ󲿷֡ԳƺΪߣʻ֤ΪҪݣ漰뻧졢װͣʻϡתȸڡʻԱݰ׼֤ѧϰ֤ʽʻ֤⳵׼֤ʱʻ֤ȣ֤Ĺ֤Ϊߣ漰֤롢顢ۡעתȸڡ
Ҫ¼ϢȽ϶࣬"ϻ"ԭǾܼ࣬Լٿռʱռãһ"ϻ"á
ԭϵͳֻһ"ϻ""ϻ" ڼʻԱͻһ壬ȱͲϵͳϢֱҵϢ"ϻ"ṹ£
Record_type ( ֤)tinyint1-77ͬʻ֤8-12ֱ׼֤ѧϰ֤ʽʻ֤⳵׼֤ʱʻ֤
Record_number(֤)char (6)5λƺ6λ֤롣
Operate_type ()tinyint1-16ֱӹ17-31 ֱʻԱӹ
Operate_add_info(Ϣ)varchar (40)¼ĳЩĸϢתתصȡ 
Operate_person(Ա)tinyint 
Operate_time(ʱ)datetime 
Login_name(û)tinyint 
Login _computer()tinyint
֤ࡢࡢԱûϸϢֱӦֵͬ䣬ϵͳԱάÿԱԼû뱾ϵͳĿɲԱԼܲʱ޸ġ
2 "ϻ"ʵ
Ҫʵ"ϻ"ܣؼǻȡ¼ҪϢ"ϻ"ҪͲϵͳϢWindows 3.1/3.2Windows 95/98ϵͳעУPowerbuilderейزϵͳעĺȡЩϢ磺
RegistryGet("HKEY_LOCAL_MACHINE\System\CurrentControlSet & control\ComputerName" "ComputerName", RegString!, Login_Computer)
ԻWindows 95/98ͻļעWindows 3.1/3.2ϵͳעWindows 95/98вͬʵֹͨGetEnvironment (env)жϲϵͳ࣬ѡȡͬעֵȷػȡҪϢ
"ϻ"ҵصϢɸӹģԶȡⲿϢƵʺܸߣ˶ϵͳЧӰܴΪ˽ʡϢʱ䣬ʹSybaseеĴ洢̡
Sybase ServerӴ洢̣
create procedure insertblackbox (@Record_type tinyint, @Record_number char(6), @Operate_type tinyint, @Operate_add_info varchar(40), @Operate_person tinyint,@Operate_time datetime,@Login_computer tinyint )as
insert into blackbox
values
(@Record_type, @Record_number, @Operate_type, @Operate_add_info, @Operate_person,getdate(),@Login_computer )
getdate()صǰĲʱ䡣
ȻPowerbuilderнһȫûڸö洢insertblackboxͿڳиӹģʹˡô洢̱"ϻ"ϢЧʣֽ˳ԣνһáʵӦУ"ϻ"ܻϢѯתȡ
3 
ҵϢϵͳ"ϻ"ܣ֤ϵͳȫԺݿɿԡԼȨԣҴӼϼ˲ʧ󣬶ž˲Ա˽յõЧ
ߵλͨѧϢоģ710049
ο
1 ӢТ. Sybaseݿϵͳ֪ʶ. йˮ ˮ磬1998
2 ֣˽. ʵ. ڶ棬廪ѧ磬19973 ξ. PowerBuilder 5.0ԭӦÿָ. ӹҵ 磬1997
