Extjs数据展现原理

本文深入探讨ExtJS前端框架的数据展现原理,介绍如何通过Store、Model和Grid等组件实现数据加载、绑定及动态更新,帮助开发者理解其背后的机制。
摘要由CSDN通过智能技术生成

    

       无论前端框架多么复杂, 最基本的技术是不变的:    

                   HTML,  Javascript , CSS ;  
               Json ,   Javascript 函数与面向对象, 原型继承机制。


        要弄懂前端框架, 上述前端基础至少要非常熟悉。

        Extjs 对数据如何与组件交互和组件展现数据的层次性划分是比较清晰的, 值得学习和借鉴。


        数据展现基本机制 
 
        

  关于其中的实现原理, 应该与服务端相应技术类似, 只是使用 Javascript 实现而已:

  1.  Model :   类似于 Java 端的 DataObject, 或 JavaBean;

  2.  Reader:   其核心技术应该是 JSON 解析。 使用一个 JSON 工具包, 解析传入的字符串,并转化为 Model 实例集,

  3.  Writer:     将 Model 实例数据及请求进行修改、拼接、编码并发送, 也是使用 JSON 工具包;

                       同 Reader 相似, 过程相逆;  

  4.  Proxy:      接收服务端的数据并委托 Reader 进行解析, 或者接收客户端的数据,委托 Writer 进行处理;

                       从图中可以看出, 它是枢纽角色;

  5.  Store:       数据的最大管理者,  它封装 Proxy, Model , Data 及解析而得的 Model 实例集, 单独与组件进行交互;

  Store 的实现 在 Java  端应该是不难模拟的, 可以练练手。 


  组件展示:

  1.   组件展示主要是将 Store 里的数据与 HTML 片段, 生成最终的HTML文本,并交给浏览器进行显示;

  2.   HTML 生成:  使用模板 或 DOM 元素生成器;

  3.   模板生成HTML: 可以使用正则表达式来匹配和填充;

  4.   DOM元素生成器: 为原生的HTML标签提供一层封装, 变成 Extjs 组件。


 示例代码: (User 相关文件是默认MAVEN工程所配置的DEMO,不用理会)
 
目录:

应用启动:  app.js   
Ext.Loader.setConfig({enabled:true, disableCache:true});

Ext.application({
    name:'Extjstudy',
    appFolder:"app",
    autoCreateViewport: true,
    
    requires:[
		'Extjstudy.global.ExtjstudyTemplates'          
    ],

    stores:['VmSnapshot'],

    launch:function()
    {
    	
    }
});
 总视图文件: Viewport.js
Ext.define('Extjstudy.view.Viewport', {
    extend:'Ext.container.Viewport',
    layout:'border',
    
    requires:[
        'Extjstudy.view.Entrance'          
    ],
    
    items: [
        {
            xtype: 'container',
            region: 'north',
            html:'<div>Extjs Study and Explore </div>',
            style: {
                padding: '10px',
                font: '1.2em'
            }
        },
        {
            xtype:'entrance',
            region: 'center' 
        }
    ]

});
视图文件: Entrance.js
Ext.define('Extjstudy.view.Entrance', {
    extend: 'Ext.panel.Panel',
    alias: 'widget.entrance',
    
    title: 'Customized View Demo',
    
    layout: 'fit',
    
    items: [
		{
		    xtype: 'dataview',
		    store: 'VmSnapshot',
		    tpl: et.deviceSnapshotTpl,
		    itemSelector: 'div.vmdeviceSnapshots',	
		    width: '800'
		}  
    ]
    
});
模板文件: ExtjstudyTemplates.js
Ext.define('Extjstudy.global.ExtjstudyTemplates', {
	
	deviceSnapshotTpl: new Ext.XTemplate(
       '<tpl for=".">',	         
       '<div class="vmdeviceSnapshots" style="margin:15px 10px 30px 15px">', 
           '<p>磁盘: {device_no} ( {device_type}, {device_size}G ) </p>',
           '<p>快照详情:</p>',
           '<table border="1" width="95%" cellpadding="3" class="moonmmTable">',
              '<tr><th>快照ID</th><th>创建时间</th><th>进度</th><th>Image_no</th><th>所属用户</th></tr>',
                 '<tpl for="snapshotExts">', 
                     '<tr align="center"><td> {snapshot_id}</td><td>{create_time}</td><td>{progress}</td><td>{image_no}</td><td>{owner}</td> </tr>',
	             '</tpl>',
	        '</table>',
       '</div></tpl><br/><br/>'
	),

});

var et = Ext.create('Extjstudy.global.ExtjstudyTemplates');
Model: VmSnapshot.js
Ext.define('Extjstudy.model.VmSnapshot', {
    extend: 'Ext.data.Model',
    
    fields:[
        {   name: 'vm_name', type: 'string' } ,
        {   name: 'vm_status', type: 'string' } ,
        {   name: 'device_no', type: 'string' } , 
        {   name: 'device_type', type: 'string' } , 
        {   name: 'device_size', type: 'string' } , 
        {   name: 'snapshotExts', type: 'auto' } ,    
        {   name: 'snapshots', type: 'auto' }
    ]
});
Store:   VmSnapshot.js
Ext.define('Extjstudy.store.VmSnapshot', {
	extend: 'Ext.data.Store',

	model: 'Extjstudy.model.VmSnapshot',
	
	data:[
         {"vm_name":"change-test01","vm_status":"Shutting","device_no":"3-10057140","mode":"system","device_size":60,"device_type":"system","safety_quota":1,
                      "snapshotExts":[{"snapshot_id":"3-10057140-607877","snapshot_name":"","progress":"100%","create_time":"2013-05-22 18:02:57","image_no":"redhat54.64.20120823.qa_rpc.vhd","owner":"229"},
                                      {"snapshot_id":"3-10057140-607881","snapshot_name":"","progress":"100%","create_time":"2013-05-22 19:05:31","image_no":"redhat54.64.20120823.qa_rpc.vhd","owner":"229"},
                                      {"snapshot_id":"3-10057140-607884","snapshot_name":"","progress":"100%","create_time":"2013-05-22 19:53:02","image_no":"redhat54.64.20120823.qa_rpc.vhd","owner":"229"}],
                       "snapshots":[{"snapshot":"3-10057140-607877"},{"snapshot":"3-10057140-607881"},{"snapshot":"3-10057140-607884"}]},
         {"vm_name":"change-test01","vm_status":"Shutting","device_no":"3-10057141","mode":"data","device_size":40,"device_type":"data","safety_quota":1,
                       "snapshotExts":[{"snapshot_id":"3-10057141-607879","snapshot_name":"","progress":"100%","create_time":"2013-05-22 18:06:01","image_no":"","owner":"229"}],
                       "snapshots":[{"snapshot":"3-10057141-607879"}]}
          
    ]
})

结果:



  具体细节继续学习中。。。。。。
  

不服老外不行,还是人家实在,贴出来的源码绝对能运行,找了两个晚上找到的。佩服佩服,那些翻译的,每一个能完整的运行,哎。下面是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);
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值