demo: http://www.sandy1219.com/air/localDatabase.rarpackage { import flash.data.<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Connection; import flash.data.<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Mode; import flash.data.<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Result; import flash.data.<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Statement; import flash.errors.<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Error; import flash.events.<a href="/tag/sql/" target="_blank" class="keywords">sql</a>ErrorEvent; import flash.events.<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Event; import flash.filesystem.File; import mx.collections.ArrayCollection; import mx.controls.Alert; public class <a href="/tag/sql/" target="_blank" class="keywords">sql</a>Manager { private static var _instance:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Manager; public static function getIntance():<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Manager { if(_instance == null) { _instance = new <a href="/tag/sql/" target="_blank" class="keywords">sql</a>Manager(); } return _instance; } public static var dataList:ArrayCollection = new ArrayCollection();; private var conn:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Connection; public function connect():void { conn = new <a href="/tag/sql/" target="_blank" class="keywords">sql</a>Connection(); conn.addEventListener(<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Event.OPEN,openHandle); conn.addEventListener(<a href="/tag/sql/" target="_blank" class="keywords">sql</a>ErrorEvent.ERROR,errorHandle); var db:File = File.applicationDirectory.resolvePath('flex.db');trace(db.url) conn.open(db,<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Mode.UPDATE,'false'); } private function openHandle(e:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Event):void { trace("the database was opened successfully"); } private function errorHandle(event:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>ErrorEvent):void { trace("Details:",event.error.message); } public function insertData():void { try { var stmt:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Statement = new <a href="/tag/sql/" target="_blank" class="keywords">sql</a>Statement(); stmt.addEventListener(<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Event.RESULT,insertResult); stmt.addEventListener(<a href="/tag/sql/" target="_blank" class="keywords">sql</a>ErrorEvent.ERROR,errorResult); stmt.<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Connection = conn; stmt.text = "INSERT INTO flex ('name') VALUES ('"+ String(Math.random()*10000).slice(0,8) +"')"; stmt.execute(); } catch(error:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Error) { trace(error.toString()) Alert.show(error.details); } } private function insertResult(e:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Event):void { trace(e.toString()) var stmt:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Statement = <a href="/tag/sql/" target="_blank" class="keywords">sql</a>Statement(e.currentTarget); var result:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Result = stmt.getResult(); var primaryKey:Number = result.lastInsertRowID; trace('insert data at: ' + primaryKey) reflash(); } private function errorResult(e:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>ErrorEvent):void { trace(e.toString()) } public function reflash():void { try { var stmt:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Statement = new <a href="/tag/sql/" target="_blank" class="keywords">sql</a>Statement(); stmt.addEventListener(<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Event.RESULT,reflashResult); stmt.addEventListener(<a href="/tag/sql/" target="_blank" class="keywords">sql</a>ErrorEvent.ERROR,reflasError); stmt.<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Connection = conn; stmt.text = "SELECT * from flex"; stmt.execute(); } catch(error:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Error) { trace(error.toString()) } } private function reflashResult(e:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Event):void { var res:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Result = <a href="/tag/sql/" target="_blank" class="keywords">sql</a>Statement(e.currentTarget).getResult(); dataList.removeAll(); var ls:Array = res.data ; for(var i:int=0;i<ls.length;i++) { trace(ls[i]) dataList.addItem(ls[i]); } } private function reflasError(e:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>ErrorEvent):void { trace(e.toString()) } public function delItem(id:*):void { try { var stmt:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Statement = new <a href="/tag/sql/" target="_blank" class="keywords">sql</a>Statement(); stmt.addEventListener(<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Event.RESULT,delResult); stmt.addEventListener(<a href="/tag/sql/" target="_blank" class="keywords">sql</a>ErrorEvent.ERROR,delError); stmt.<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Connection = conn; stmt.text = "delete from flex where id = " + id; stmt.execute(); } catch(error:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Error) { trace(error.toString()) } } private function delResult(e:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Event):void { trace(e.toString()) var stmt:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Statement = <a href="/tag/sql/" target="_blank" class="keywords">sql</a>Statement(e.currentTarget); var result:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>Result = stmt.getResult(); var primaryKey:Number = result.lastInsertRowID; trace('insert data at: ' + primaryKey) reflash(); } private function delError(e:<a href="/tag/sql/" target="_blank" class="keywords">sql</a>ErrorEvent):void { trace(e.toString()) } } }