【转自CBM】AIR SQL 学习笔记(20080229)

txf2004

浏览: 6853580 次
性别:
来自: 上海

最近访客更多访客>>

east_java

u012363178

wangyy

GDGZWQZ

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

AIR SQL Flash SQLite

AIR 本地数据为SQLite，

applicationDirectory 路径为 %APPDATA%\appName\
applicationStorageDirectory路径为 %APPDATA%\appName\Local Store\

%APPDATA% 为系统环境变量，默认为%SystemDrive%\Documents and Settings\%USERNAME%\Application Data
appName为AIR应用程序名称

组织出了一个基础的SQL类库。方便今后常用数据库操作。

package
{
import com.cbmland.data.SQL;
import flash.display.Sprite;
import flash.events.ErrorEvent;   
import flash.events.Event;
import flash.filesystem.File;
import flash.text.TextField;
public class SQL_test extends Sprite 
{
		var sql:SQL= new SQL()
		var _textField:TextField=new TextField()
public function SQL_test()
{
			sql.addEventListener(SQL.RESULT,sql_RESULT)
			sql.addEventListener(SQL.ERROR,sql_ERROR)
			sql.open(File.applicationStorageDirectory.resolvePath("DBSample.db"))		

//尝试创建数据库以及一个表
			var sqlText=
"CREATE TABLE IF NOT EXISTS employees (" + 
"    empId INTEGER PRIMARY KEY AUTOINCREMENT, " + 
"    firstName TEXT, " + 
"    lastName TEXT, " + 
"    salary NUMERIC CHECK (salary > 0)" + 
")";

			query(sqlText)

//插入一个记录
			sqlText="INSERT INTO employees (firstName, lastName, salary) " + 
"VALUES ('Bob', 'Smith', 8000)";
			query(sqlText)

//查询
			sqlText='SELECT * FROM employees '
			query(sqlText) 

			_textField.multiline=true
			_textField.width= stage.stageWidth
			_textField.height= stage.stageHeight
this.addChild(_textField)

}

private function query(text:String){
			sql.text=text
			sql.execute()
}
private function view_RESULT(result):void
{

if(result.data!=null){
					    var numRows:int = result.data.length;
for (var i:int = 0; i < numRows; i++)
{
					        var output:String = "";
for (var columnName:String in result.data[i])
{
					            output += columnName + ": " + result.data[i][columnName] + "; ";
}
					        trace("row[" + i.toString() + "]\t", output);
					        _textField.appendText("row[" + i.toString() + "] "+output+'\n')
}
// if(!result.complete){sql.next()}
}else if(result.rowsAffected>0){
				    		trace(result.lastInsertRowID)
}
} 

private function sql_RESULT(event:Event){
			var result=(event.target.getResult())
			view_RESULT(result)

}
private function sql_ERROR(event:ErrorEvent){
			trace("Error message:", event['error'].message);
			trace("Details:", event['error'].details);
}	
}
}