FLEX实践—XML、XMLList、 XMLListCollection、ArrayCollection关系转换

  <?xml version="1.0" encoding="utf-8"?> 
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" 
layout="absolute" 
creationComplete="init()"> 
<mx:Script> 
<!--[CDATA[ 
import mx.collections.XMLListCollection; 
import mx.collections.ArrayCollection; 
import mx.controls.Alert; 
public var myData:XML= 
<tables> 
<table> 
<name>TRP_USERS</name> 
<statement>CREATE TABLE IF NOT EXISTS TRP_USERS (USER_ID INTEGER PRIMARY KEY AUTOINCREMENT,USER_NAME TEXT,PASSWORD TEXT,CREATION_DATE DATE)</statement> 
</table> 
<table> 
<name>TRP_PROJECTS</name> 
<statement>CREATE TABLE IF NOT EXISTS TRP_EMPLOYEE_PROJECTS (EMPLOYEE_PROJECT_ID INTEGER PRIMARY KEY AUTOINCREMENT,USER_ID INTEGER,EMPLOYEE_NUMBER TEXT,LEVEL_CODE TEXT,PROJECT_NAME TEXT,PROJECT_MANAGER TEXT,START_DATE DATE,SCHEDULE_END_DATE DATE,TECH_DIRECTOR_NAME TEXT,TECH_LEADER_NAME TEXT,TWO_WEEK_OUT TEXT,MEMO TEXT,UPLOAD_FLAG TEXT,CREATION_DATE DATE)</statement> 
</table> 
</tables>; 
private var xmlList:XMLList=new XMLList(); 
private var xmlListCollection:XMLListCollection=new XMLListCollection(); 
private var provider:ArrayCollection; 
private function init():void 
{ 
xmlList=myData.elements("table"); 
xmlListCollection.source=xmlList; 
provider=new ArrayCollection(xmlListCollection.toArray()); 
grid.dataProvider=provider; 
} 
]]--> 
</mx:Script> 
<mx:DataGrid x="221" 
y="65" 
width="742" 
height="294" 
id="grid"> 
<mx:columns> 
<mx:DataGridColumn headerText="Name" 
dataField="name"/> 
<mx:DataGridColumn headerText="Sql" 
dataField="statement"/> 
</mx:columns> 
</mx:DataGrid> 
</mx:Application>