如何用 Adobe AIR 读写sqlite

当前位置：主页 > AIR > 文章内容

如何用 Adobe AIR 读写sqlite

来源：guodong.net/blog 作者：qinghu 2008-08-13 【大中小】 TAG:

程序代码

import fl.controls.dataGridClasses.DataGridColumn;
import fl.events.DataGridEvent;
import fl.data.DataProvider;
import flash.data.SQLConnection;
import flash.data.SQLStatement;
import flash.data.SQLResult;
import flash.events.SQLErrorEvent;
import flash.events.SQLEvent;
import flash.filesystem.File;
var conn:SQLConnection = new SQLConnection();
var sqlStatement:SQLStatement = new SQLStatement();
sqlStatement.sqlConnection = conn;
conn.addEventListener(SQLEvent.OPEN, openHandler);
conn.addEventListener(SQLErrorEvent.ERROR, errorHandler);
sqlStatement.addEventListener(SQLEvent.RESULT, sqlStatementResultHander);
sqlStatement.addEventListener(SQLErrorEvent.ERROR, sqlStatementErrorHander);
var dbFile:File = File.applicationDirectory.resolvePath("data.db");
conn.open(dbFile);
var sql:String ="Insert INTO news (news_title) VALUES ('我是庆虎^_^')";
sqlStatement.text = sql;
sqlStatement.execute();
sql ="select * from news";
sqlStatement.text = sql;
sqlStatement.execute();
conn.close();
function openHandler(event:SQLEvent):void {
    trace("the database was opened successfully");
}
function errorHandler(event:SQLErrorEvent):void {
    trace("Details:", event.error.message);
}
function sqlStatementResultHander(event:SQLEvent):void {
    var re:SQLResult=event.target.getResult();
    var aDP_array:Array = new Array();
    if (re.data!=null) {
        for (var i:int = 0; i < re.data.length; i++) {
            aDP_array.push({id:re.data[i]["id"], news_title:re.data[i]["news_title"]});
        }
        my_dg.dataProvider = new DataProvider(aDP_array);
    }
}
function sqlStatementErrorHander(event:SQLErrorEvent):void {
    trace(event.error.message);
}

上一篇：8个跑在Linux上面的AdobeAIR程序下一篇：创建AIR应用时常犯的10个错误

·AIR中使用LocalConnection注意事项	·分享一个air版本的Flash Tracer
·AIR版的Flash Console	·AIR程序间的相互调用
·Adobe AIR 1.5在线课程	·AIR版本的SQL注入漏洞检测工具
·在JavaScript AIR开发中使用Action	· 一个简洁的AIR聊天程序Falking (1
· 发布Air Reader RSS读写器，开放	·Adobe AIR获得了2个重要的奖项提名