AIR for androd 笔记

 1 1.stage.addEventListener(Event.ACTIVE,onActive);
 2 
 3   stage.addEventListener(Event.DEACTIVE,onDeactive);
 4 
 5 
 6 
 7 2.KeyboardEvent
 8    switch(e.keycode){
 9         case Keyboard.BACK:  break;
10         case Keyboard.HOME: break;
11         case Keyboard.SEARCH: break;
12     }
13 }

SQLite是运行本地环境的一个数据库系统，保存数据在硬盘上的文件中。每一个数据库保存一个文件

首先创建一个数据库，然后打开数据库（这两部可以一起），创建表，

创建db:

 1 import flash.filesystem.File;
 2 import flash.events.SQLErrorEvent;
 3 import flash.events.SQLEvent;
 4 import flash.data.SQLConnection;
 5 
 6 var file:File=File.applicationStorageDirectory.resolvePath("test.db");
 7 var conn:SQLConnection=new SQLConnection();
 8 conn.addEventListener(SQLEvent.OPEN,onOpen);
 9 conn.addEventListener(SQLErrorEvent.ERROR,onError);
10 try{
11     conn.open(file);
12     txt.appendText("-----open ");
13 }catch(e){
14     txt.appendText("-----error oh!!!");
15 }
16 function onOpen(e:SQLEvent){
17     txt.appendText("-----open success");
18 }
19 function onError(e:SQLErrorEvent){
20     txt.appendText("-----open error");
21 }

 创建表：

var sql:String ="CREATE TABLE IF NOT EXISTS employees (" +  
    "    empId INTEGER PRIMARY KEY AUTOINCREMENT, " +  
    "    firstName TEXT, " +  
    "    lastName TEXT, " +  
    "    salary NUMERIC CHECK (salary > 0)" +  
    ")"; 
var statm:SQLStatement=new SQLStatement();
statm.addEventListener(SQLEvent.RESULT,onResult);
statm.sqlConnection=conn;
statm.text=sql;
statm.execute();
function onResult(e:SQLEvent){
    trace("----创建表成功");
}

查询数据：

selectStmt.sqlConnection = conn; 
     
selectStmt.text = "SELECT itemId, itemName, price FROM products"; 
     
selectStmt.addEventListener(SQLEvent.RESULT, resultHandler); 
selectStmt.addEventListener(SQLErrorEvent.ERROR, errorHandler); 
     
selectStmt.execute(); 
     
function resultHandler(event:SQLEvent):void 
{ 
    var result:SQLResult = selectStmt.getResult(); 
     
    var numResults:int = result.data.length; 
    for (var i:int = 0; i < numResults; i++) 
    { 
        var row:Object = result.data[i]; 
        var output:String = "itemId: " + row.itemId; 
        output += "; itemName: " + row.itemName; 
        output += "; price: " + row.price; 
        trace(output); 
    } 
} 
     
function errorHandler(event:SQLErrorEvent):void 
{ 
    // Information about the error is available in the 
    // event.error property, which is an instance of  
    // the SQLError class. 
}

插入数据：

var insertStmt:SQLStatement = new SQLStatement(); 
insertStmt.sqlConnection = conn; 
     
// define the SQL text 
var sql:String =  
    "INSERT INTO employees (firstName, lastName, salary) " +  
    "VALUES ('Bob', 'Smith', 8000)"; 
insertStmt.text = sql; 
     
// register listeners for the result and failure (status) events 
insertStmt.addEventListener(SQLEvent.RESULT, insertResult); 
insertStmt.addEventListener(SQLErrorEvent.ERROR, insertError); 
     
// execute the statement 
insertStmt.execute(); 
     
function insertResult(event:SQLEvent):void 
{ 
    trace("INSERT statement succeeded"); 
} 
     
function insertError(event:SQLErrorEvent):void 
{ 
    trace("Error message:", event.error.message); 
    trace("Details:", event.error.details); 
} 

 使用加密的数据库