qiusongze的专栏

经过几天的研究实现定时读取数据库报警信息，报警，请大家参考。

本人经过今天研究开发的基于sqlserver2000的，定时刷新读取数据库，如果有新的报警，提示音。

大家有需要的下载啊，json用的所有的包

安卓点菜系统实现，客户端加服务端，供大家参考

简单extjs+json+servlet实现，页面展示，仅供大家参考

毫不容易找到的key文件和大家共享，不过这个第三方控件确实好用，希望大家可以共同研究

不服老外不行，还是人家实在，贴出来的源码绝对能运行，找了两个晚上找到的。佩服佩服，那些翻译的，每一个能完整的运行，哎。下面是sql CREATE TABLE [dbo].[Employee]( [EmployeeID] [int] IDENTITY(1,1) NOT NULL, [FirstName] [varchar](50), [LastName] [varchar](50), [SupervisorID] [int] NULL, CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED ( [EmployeeID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO GO ALTER TABLE [dbo].[Employee] WITH CHECK ADD CONSTRAINT [FK_Employee_Employee] FOREIGN KEY([SupervisorID]) REFERENCES [dbo].[Employee] ([EmployeeID]); TRUNCATE TABLE Employee; SET IDENTITY_INSERT Employee ON INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(21, 'Arrigoni','Ellen',null); INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(22,'Beilby','Paige Denise',null); INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(32,'Bell','Ken James',null); INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(45,'Campbell','Scott Richard',null); INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(91,'Chen','Hueyfang',null); INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(93,'Figaro','Christopher Michael',null); INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(113,'Fitzgerald','Joseph OConnor',null); INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(201,'Heriveaux','Marlange',null); INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(301,'MacKenzie','Davin S',null); INSERT INTO Employee(EmployeeID, FirstName, LastName, SupervisorID) VALUES(311,'Brien','Kelsey Leigh',null); SET IDENTITY_INSERT Employee OFF; INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Sarfatti','Aaron Joseph',null); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wu','Ichan John',null); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Xia','Diwei',null); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Zhao','Jingjing',null); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Abbas','Anees Fatima',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Adams','Philip Lance',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Allen','Adrienne N',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Allen','Philip Michael',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Altilio','Michael',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Amspacher','Gregory Robert',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Anderson','David Michael',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Anger','Amelie Huimei',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Ashby','John J.',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Au','Chanel Roxanna',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Au','Wai Kong',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Ausiello','Kristin Ann',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Avery','Hans',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Badley','Roger Kenneth',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Bagla','Vikash',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Baillargeon','Michelle C',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Basha','Paul Frederick',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Bazile','Max Husani',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Beauchesne','Francois Montpetit',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Berube','Pierre-Luc',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Boehme','Joshua',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Boundy','Kris Dawnlyn',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Brisson','Edith',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Brown','Robert Wayne',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Burningham','Bryan Paul',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Burris','Donald Hugh',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Byrd','Matthew Russel',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Campbell','Brian Alexander',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Carlson','Karen Denise',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chan','Charline Dizon',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chan','Chia Khow',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chan','Hau-Chung',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chan','Ho Lun',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chan','Ka Shing',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chan','Ka Yip',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chang','SeungHwan',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chao','Paojung',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chaudhry','Nikita',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chen','Chongyang',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chen','Hong',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chen','Irawati',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chen','Sheng-Hsien',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chen','Shun',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chen','Wan-Yu',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Cheng','Huiyu',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Cheong','Bevan Y S',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Cheung','Carin',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Cheung','Geoffrey C',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chim','Grace Wai Sze',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chin','Chang-Han',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chow','Jeany',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chow','Khong Tic',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Christensen','Issac Merrill',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Christy','Ilene E',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Christy','Karen',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chu','Wendy',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chua','Samuel Teik Kiong',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Chung','Ho Yin',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Clark','Michael E',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Coe','Adam James',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Comeau-Tougas','Etienne',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Conroy','Kelly Riehl',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Corona','Jonas',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Coulombe','Diane',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Covalle','Matthew Allen',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Curran','Ron Alan',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dai','Rui',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dealmeida','Arthur Craig',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dhulipala','Deepti',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Didier','Matthew Lee',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dion','Valerie',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dodd','Heidi Lynn',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dooley','Brent Alan',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dorr','Nate H',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Doyle','Michael Andrew IV,',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Dwyer','Brandon John',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Ellis','Amanda Senules',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Ellis','Claudia',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Enriquez','Keith H',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Etheridge','Andrew Christian',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Etlinger','Benjamin Herman',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fan','Taylor',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fang','Wilson',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fast','Trevor James',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fausey','Jeffrey John',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Filshtein','Teresa Jenica',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('France','Andrew Edson',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fraser','Andrew James',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fredrickson','Tricia Ann',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fries','John William',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Fung','Chui Ying',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Gabriel','Joseph',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Gao','Jie',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Gao','Yang',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Garneau','Michael',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Gesink','Gary James',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Gingerich','Adam Michael',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Gould','Susan Yvonne',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Gupta','Puja',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hale','Christopher Allen',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Han','Zhongxian',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hardy','Amber Kay',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Harshman','Michael John',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hassan','Raza',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hayes','Richard Laurent',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hess','Laura Vignati',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hickok','Lauren Elizabeth',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hixon','Sarah C',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hoge','Bryan Kenneth',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Honett','Stephanie Grace',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Howard','Jason David',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hsu','Chi-Pu',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hsu','Chiukao',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hu','Yungui',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Huang','Ying',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hubbard','Mindy',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hung','Kenneth Lik Hang',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Hung','Kian Teong',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Iwamoto','Todd Akira',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Jiang','Dazhi',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Jin','Jenny',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Jin','Yueqi (Alec)',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Jobe','Elizabeth Anne',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Jong','Peter Cy',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Junt','Don',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kabala','Joel C',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kao','Nicole',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kassam','Salim Shiraz',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Khor','Kahhoa',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kim','Hwa-Young',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kim','Jihyun',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kim','Joseph M.',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kimball','Jacob A',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kong','Weifeng',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Koumoulis','Mirjam',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kouri','Justin Vahe',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kriausakul','Navarat',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kroening','Jason Gerald',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kwan','Pui-Yin',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kwok','Chau Mo',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Kwok','Johnathan Pak Wai',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lai','Kim Fung',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lalumiere','Michel',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lam','Ho Ying Ellen',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lam','Melissa I',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lamm','Elizabeth Ann',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lang','Jessica May',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lannan','Dustin William',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lantagne','Kathie',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lapeyre','Francois',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Larson','Michael John',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lau','Phooi Wan',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Laurence Bourassa','Yannick',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lavoie','Lisa',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Law','Chi Hong',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lawton','Linda Barker',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lazarus','Saul',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lee','Kin Hoe',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lee','Mandy Hoi Man',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lee','Michelle Keum',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lee','Su Meng',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lee','Taik-Ki',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Leida','Johann K',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Levinsky','Marc R',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Chen',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Chun Yu Matthew',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Dongsheng',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Fengchun',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Hongyi',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Hua',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Xinyan',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Xinyu X',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Yanli',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Zheng',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Li','Zhigang John',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lian','Xiu',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lim','Yih Chen',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lin','Chia Ju',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lin','Tsung Yu',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lin','Yijing',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lipperman','Brody D',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Liu','Dong',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Liu','Jianxun',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Liu','Pak-Hay Patrick',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Liu','Xiaofang',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lo','Keith Joe Ye',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lokken','Patrick William',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Long','Jeffrey Ryan',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Long','Jun',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lu','Chien-Hung',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Lu','Ziyao',201); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Luo','Mian',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('MacMurdy','Michael',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Majeed','Rizwan',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Maloney','Matthew Ryan',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Maltais','Maxime',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Man','Angie Rho-Nung',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Marks','Nathaniel Andrew',311); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('McBane','Roderick James',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Minute','Eric John',91); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Morehead','Lynn M',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Morris','Michael',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Motsiopoulos','Christos',113); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Murray','Timothy Kevin',311); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Nadeau Roy','Melanie',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Nee','Stephanie Wan-Jung Wang',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Ng','Pui Wai',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Nguyen','Hoan Thi Ngoc',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Nolan','Thomas',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Noonan','Valerie Ann',311); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Notaristefano','Amanda Jean',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Ofori','Ernest Ntim',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Olberding','Kevin William',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Orr','William Breckenridge',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Owens','John Philip',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Paquet','Marie-Andree',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Patel','Amee Y',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Patota','Timothy Jason',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Pearce','Marissa Simone',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Pesarek','Brad Michael',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Ponorovskaya','Olga',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Popatia','Yasmin Akberali',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Qi','Jinning',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Qi','Youquan',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Qian','Aiping',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Quock','Cathy Wemie',113); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Rachakonda','Bindavi',311); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Rakowski','Brian J',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Rao','Smita Ramdas',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Rasmussen','Jonathan William',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Rawlins','Marisa',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Renfrew','Jessica Erin',91); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Romano','Christine Lynne',311); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Sakhrani','Paul Vashi',113); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Santay','Kavita',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Sapochak','Jonathan Andrew',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Schenck','Robert Tarlton',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Schopfer','Mark Louis',311); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Schweickert','Estellene Mischelle',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Sequeira','Nancy Salgado',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Shafer','Garrett C',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Shewarega','Meron',91); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Simonelli','Brad Lee',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Slowinska','Jowita',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Smith','Glenn Stanley',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Southwell','Andrew Lee',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Spencer','John A',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Stecklein','Daniel',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Steinbrunner','David James',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Steinshouer','Jared B',311); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Sudwerts','Ephraim',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Sui','Difei',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Svara','Frank Richard',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Symonds','Mark Andrew',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Tackmann','Andrew Richard',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Tam','Nga Yau',311); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Tess','Andrew Steven',113); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Tharnish','Sarah Marie',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Theisen','Tyler Jay',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Thomas','Kemba',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Thomas','Stephen Paul',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Thoo','Kwan-Ji Jeannie',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Treetipbut','Pataraporn',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Tremblay','Jean-Francois',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Trexler','Weston Dean',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Trinrud','Christopher Walter',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Trivedi','Aditya Dushyant',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Tsai','Ching-Fang',311); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Tsang','ChiFai',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Turner','Andrew Frederick',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Vahid','Reza',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Verghis','Raina Rachel',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Vincent','Adrian',113); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Vulpio','Laura M',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wang','Jingyan',91); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wang','Ning',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wang','Tianjiao',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wang','Xiaolu',21); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wei Chong','Lai',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Weise','Mary Katherine',311); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wen','Jiajia',113); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wen','Victoria',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Widmer','Alisa Johnson',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('WONG','Man Hong',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wong','Maria Wing Kei',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wong','Ngai Keung',311); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wu','Chingfeng',301); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Wu','Li',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Xiao','Chunfang',113); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Xiao','Meng',311); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Yang','Su',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Yeung','Hon Keung',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Yiu','Terence Tin Hang',32); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Yuen','Kim Hung Jackie',113); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Zhang','Chu',22); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Zhang','Ning',311); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Zhang','Peng',93); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Zheng','Chunmei',45); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Zhuang','Yuelin',113); INSERT INTO Employee(FirstName, LastName, SupervisorID) VALUES('Zou','Hui',113);

JSON(JavaScript Object Notation) 是一种轻量级的数据交换格式，易于阅读和编写，同时也易于机器解析和生成。它基于ECMA262语言规范（1999-12第三版）中JavaScript编程语言的一个子集。 JSON采用与编程语言无关的文本格式，但是也使用了类C语言（包括C， C++， C#， Java， JavaScript， Perl， Python等）的习惯，这些特性使JSON成为理想的数据交换格式。

前几天介绍过在2.X中可以使用extbuilder这个Eclipse插件来可视化开发ExtJs,今天又发现了一个在线版,唯一不同的是,在线版本只能导出json格式数据.最难得的是这一个项目也是采用ExtJs开发,并且全部代码开源. 设计器的主要功能: Full support of drag and drop for all Ext xtyped elements Eventhandler can be added containing JavaScript Advanced options to connect Json design to caller Embbeded documentation Backend support to load and save json designs External wizard support