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_PROJECTS (PROJECT_ID INTEGER PRIMARY KEY AUTOINCREMENT,PROJECT_NAME TEXT,PROJECT_INFO_SEG1 TEXT,PROJECT_INFO_SEG2 TEXT,PROJECT_INFO_SEG3 TEXT,PROJECT_INFO_SEG4 TEXT,PROJECT_INFO_SEG5 TEXT,PROJECT_INFO_SEG6 TEXT,PROJECT_INFO_SEG7 TEXT,PROJECT_INFO_SEG8 TEXT,PROJECT_INFO_SEG9 TEXT,PROJECT_INFO_SEG10 TEXT,PROJECT_INFO_SEG11 TEXT,PROJECT_INFO_SEG12 TEXT,PROJECT_INFO_SEG13 TEXT,PROJECT_INFO_SEG14 TEXT,PROJECT_INFO_SEG15 TEXT,TECH_DIRECTOR_NAME TEXT,TECH_PM_NAME,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>