xml xmlList 与xmlListCollection的相互转换

最新推荐文章于 2025-08-14 09:04:35 发布

转载最新推荐文章于 2025-08-14 09:04:35 发布 · 2.3k 阅读

文章标签：

2 篇文章

订阅专栏

本文详细介绍了使用MXML创建数据库管理系统的步骤，包括导入必要的组件、定义数据表、设置数据提供程序以及展示数据的实现过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<?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");
xmlListxmlListCollection.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>

运行结果：