学步园

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