root/as3/SQLControls/src/org/libspark/snippets/controls/SQLList.as

/**
 * The SQL List Class for AIR Application
 *
 * @author      Copyright (c) 2008 daoki2
 * @version     1.0.0
 * @link        http://snippets.libspark.org/
 * @link        http://homepage.mac.com/daoki2/
 *
 * Copyright (c) 2008 daoki2
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in
 * all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
 * THE SOFTWARE.
 */

package org.libspark.snippets.controls {
    import flash.data.SQLConnection;
    import mx.controls.Alert;
    import mx.controls.List;
    import org.libspark.utils.SqlUtil;

    public class SQLList extends List {
        public var sqlConnection:SQLConnection = null;
        public var delimiter:String = "";

       /**
        * Constructor
        */
        public function SQLList() {
          super();
        }

       /**
        * Execute SQL and apply to DataGrid
        * @param        sql     The SQL statement to execute
        */
        public function executeQuery(sql:String):void {
            if (sqlConnection == null) {
                Alert.show("sqlConnection is null", "ERROR!");
                return;
            }
            if(!sqlConnection.connected) {
                Alert.show("SQLConnection is not connected", "ERROR!");
                return;
            }
            var result:Array = SqlUtil.getData(sqlConnection, sql);
            var query:Array = new Array();
            if (result != null) {
                if (result[1].data != null) {
                    var dataLength:Number = result[1].data.length;
                    for (var i:uint = 0; i < dataLength; i++) {
                        var txt:String = "";
                        for each (var val:* in result[0]) {
                            txt += result[1].data[i][val] + delimiter;
                        }
                        query.push(txt.substring(0, txt.length - delimiter.length));
                    }
                }
            }
            this.dataProvider = query;
        }
    }
}