我省略了和前例类似部分技术文章都会用到数据库所以我拥有大量数据库

创建表视图代码

创建举例Flex应用最后步就是添加表格下拉菜单并在数据网格中显示选中表格数据该例完整代码如清单4所示

清单4:flexmysql.mxml

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="vertical"
initialize="onInitialize">
<mx:Script>
<![CDATA[
import mx.collections.ArrayCollection;
private const SERVICE_BASE:String = "http://localhost/sql/req.php";
private var loadingDatabases:Boolean = true;
private var loadingTables:Boolean = false;
public function _disibledevent=>myservice.url = SERVICE_BASE;
myservice.send( null );
} public function _disibledevent=>selectedDatabase.dataProvider = myservice.lastResult..database.*;
onSelectDatabase;
}
( loadingTables )
{
loadingTables = false;
var tables:Array = Array;
for each ( var tablRecord:XML in myservice.lastResult..record )
{
for each( var tablCol:XML in tablRecord.* )
tables.push( tablCol..*.toString );
}
selectedTable.dataProvider = tables;
onSelectTable;
}
{
var records:Array = Array;
for each ( var record:XML in myservice.lastResult..record )
{
var outRecord:Array = Array;
for each( var column:XML in record.* )
outRecord[ column.name ] = column..*.toString;
records.push( outRecord );
}
var data:ArrayCollection = ArrayCollection( records );
dg1.dataProvider = data;
}
} public function _disibledevent=>loadingTables = true;
varurl:String= SERVICE_BASE;
url "?mode=getTables&db="+selectedDatabase.selectedLabel;
myservice.url = url;
myservice.send(null);
} public function _disibledevent=>url:String= SERVICE_BASE;
url "?mode=getData&db="+selectedDatabase.selectedLabel;
url "&table="+selectedTable.selectedLabel;
myservice.url = url;
myservice.send(null);
}
]]>
</mx:Script>
<mx:HTTPService id="myservice" result="onResult(event)" resultFormat="e4x">
</mx:HTTPService>
<mx:VBox horizontalAlign="left">
<mx:HBox>
<mx:Label text="Database:" />
<mx:ComboBox id="selectedDatabase" width="381" height="21"
change="onSelectDatabase">
</mx:ComboBox>
</mx:HBox>
<mx:HBox>
<mx:Label text="Table:" />
<mx:ComboBox id="selectedTable" width="381" height="21"
change="onSelectTable">
</mx:ComboBox>
</mx:HBox>
<mx:DataGrid id="dg1" width="452">
</mx:DataGrid>
</mx:VBox>
</mx:Application>







其中有处重要修改即添加了onSelectDatabase代码以获取表格列表然后将其输入到onResult中还添加了onSelectTable该可检索表格中数据并在onResult处理器中设置数据网格