ExtJs+JSP构造动态树

在实际生产中树的构造是需要根据后台数据库中存放的内容动态加载的,例如一个系统中,不同的角色有不同的权限,他们所能进行的操作也是不同的,如果需要构造一个树形结构展现某个角色所能进行的操作,这就用到了树形结构。
ExtJs提供了动态加载树形结构的机制,这里就用到了TreeStore动态加载,常用的动态加载数据格式有JSON和XML。
这里我们看一下如何使用JSON格式数据动态加载属性结构。

首先看一下建立的TreeStore。

var tree_store = Ext.create('Ext.data.TreeStore', {
	    id:'tree_store',
	    proxy: {
   		 type: 'ajax',
   		 url: 'MyJsp.jsp',
   	 }
	});

这里我们通过ajax的方式向一个JSP请求数据。下面看TreePanel的定义。

var treePanel = Ext.create('Ext.tree.Panel', {
	    id: 'tree_panel',
	    title: '动态加载',
	    region: 'west',
	    width: 200,
	    rootVisible: false,
	    store: tree_store,
	    listeners : {
			itemclick : tree_itemclick
		}, 
		tools: [{
	        type: 'refresh',
	        tooltip: '刷新',
	        handler: function() {//Ext.data.Store load
	            tree_store.load({
	                scope: this,
	                callback: function(records, operation, success) {
	                    treePanel.getRootNode().eachChild(function(child) { child.expand(); });
	                }
	            });
	        }
	    }
	    ],
});
这里需要注意一点,这段代码是卸载onReady()函数中的,而且在加载treePanel之前调用tree_store的load方法。或者将tree_store写在treePanel里面,否则可能造成树形结构无法正常加载显示。

后台最主要的作用是将节点信息组成恰当的JSON字符串,如果需要加载的节点不多的话可以使用拼接字符串的方式,如果节点较多可以使用javaBean封装节点信息,然后通过循环的方式拼接。

下面我们先看一下节点类的定义。

public class Node {
	private String text;//节点显示字符串
	private String id;//节点ID
	private boolean leaf;//是否是叶子节点
	
	public String getText() {
		return text;
	}
	public void setText(String text) {
		this.text = text;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public boolean isLeaf() {
		return leaf;
	}
	public void setLeaf(boolean leaf) {
		this.leaf = leaf;
	}
}

真实开发中可以从数据库中取出这些节点的一个集合信息,这里我们使用一个普通方法模拟一个节点信息的集合。

public ArrayList<Node> getRes(){
		ArrayList<Node> result = new ArrayList<Node>();
		
		Node node1 = new Node();
		node1.setId("第一个节点的id");
		node1.setLeaf(true);
		node1.setText("第一个节点");
		
		Node node2 = new Node();
		node2.setId("第二个节点的ID");
		node2.setLeaf(true);
		node2.setText("第二个节点");
		result.add(node1);
		result.add(node2);
			
		return result;
	}

下面我们看一下如何根据这个集合来拼接JSON字符

public String getJson(){
		String result = "[{text:'1级文件夹',id:'host',children:[";
		ArrayList<Node> arrlist = getRes();
		Iterator<Node> iterator = arrlist.iterator();
		while(iterator.hasNext()){
			Node node = iterator.next();
			if(iterator.hasNext())
				result +="{id:'"+node.getId()+"',text:'"+node.getText()+"',leaf:"+node.isLeaf()+"},";
			else
				result +="{id:'"+node.getId()+"',text:'"+node.getText()+"',leaf:"+node.isLeaf()+"}";
		}
		result+="]},{text:'2级文件夹',id:'operate',children:[{id:'addhost',text:'第三个节点',leaf:true},"
				+ "{id:'addclient',text:'第四个节点',leaf:true}]}]";
		return result;
	}
在result字符串定义和最后返回之前是使用最普通的字符串拼接的方法,这里一起进行测试。

然后我们看一下url中请求的JSP页面。

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<jsp:useBean id="service" class="service.Service"></jsp:useBean>
<%
	request.setCharacterEncoding("utf-8");
	response.setCharacterEncoding("utf-8");
	String json = service.getJson();
	System.out.println(json);
	response.getWriter().write(json);
%>
这样就可以在请求页面的过程中根据后台中的内容动态加载属性结构。

下面看一下效果图:




使用这种方式动态加载时将所有的几点信息一次全部加载,也就是当你点击展开一级文件夹或二级文件夹的时候他不会在想后台发送请求,这里通过firebug就能看出,如果树的层次比较深,在后台构造JSON字符串发送就会比较麻烦,这时可以使用异步加载,也就是当页面第一次加载的时候只会加载1级文件夹和2级文件夹,当点击展开1级文件夹或2级文件夹的时候这时会继续向后退发送请求,请求加载1级文件夹的子节点。关于异步加载将在下篇博客介绍。

  • 0
    点赞
  • 4
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
不服老外不行,还是人家实在,贴出来的源码绝对能运行,找了两个晚上找到的。佩服佩服,那些翻译的,每一个能完整的运行,哎。下面是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);

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值