从Adobe flex/AIR访问mysql

import flash.data.SQLConnection;
import flash.data.SQLStatement;
import flash.events.SQLEvent;

// 创建SQL连接
var connection:SQLConnection = new SQLConnection();
connection.open("myDatabase.db", SQLMode.CREATE);

// 创建SQL语句
var statement:SQLStatement = new SQLStatement();
statement.sqlConnection = connection;
statement.text = "SELECT * FROM myTable";

// 执行SQL查询
statement.execute();
statement.addEventListener(SQLEvent.RESULT, onResult);

function onResult(event:SQLEvent):void {
    var result:SQLResult = statement.getResult();
    for (var i:int = 0; i< result.data.length; i++) {
        var row:Object = result.data[i];
        trace(row.column1, row.column2);
    }
}