as3现在可以直接读sql数据库了，大家一起研究啊

http://maclema.com/assql/
as3现在可以直接读数据库,再返回xml格式文件给flash读取，
xml文件

<mx:Script>
<![CDATA[
private function callService(sql:String):void
{
sqlService.send(sql);
}
]]>
</mx:Script>
<sql:MysqlService id="sqlService"
host="database.mydomain.com"
port="3306"
user="username"
scrambler="{new PlainTextScrambler('password')}"
database="databaseName"
response="onResponse(event)"
error="onError(event)" />
<mx:ComboBox id="cbx1" dataProvider="{sqlService.lastResult}" labelField="userName" />

复制代码

Actionscript文件

private function getUserList():void
{
   var host:String = "database.mydomain.com";
   var port:int = 3306;
   var user:String = "mydatabaseuser";
   var scrambler:PlainTextScrambler = new PlainTextScrambler("password");
   var database:String = "databaseName";
   var con:Connection = new Connection(host, post, user, scrambler, database);
   con.addEventListener(Event.CONNECT, onConnect);
   con.addEventListener(SQLErrorEvent.SQL_ERROR, onError);
   con.connect();
}
private function onConnect(e:Event):void
{
   var con:Connection = Connection(e.target);
   var st:Statement = con.createStatement();
   st.addEventListener(RestulsEvent.RESULTS, onResults); //FOR SELECT
   st.addEventListener(ResponseEvent.RESPONSE, onResponse); //FOR INSERT, UPDATE, etc.
   st.addEventListener(SQLErrorEvent.SQL_ERROR, onError);
   st.executeQuery("SELECT * FROM users;");
}
private function onResults(e:ResultsEvent):void
{
   var st:Statement = Statement(e.target);
   var con:Connection = st.getConnection();
   var rs:ResultSet = e.resultSet;
   while ( rs.next() )
   {
      var userName = rs.getString("userName");
      var email = rs.getString(2);
   }
   con.disconnect();
}
private function onResponse(e:ResponseEvent):void
{
   var st:Statement = Statement(e.target);
   var con:Connection = st.getConnection();

   var affectedRows:int = e.affectedRows;
   var insertID:int = e.insertID;
   con.disconnect();
}
private function onError(e:SQLErrorEvent):void
{
   var st:Statement = Statement(e.target);
   var con:Connection = st.getConnection();

   var message:String = e.msg;
   var errorNo:int = e.id;
   var text:String = e.text; // Equals SQLError #{id}: {msg}
   con.disconnect();
}