<?xml version="1.0" encoding="utf-8"?>
<s:View xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:s="library://ns.adobe.com/flex/spark" title="HomeView"
creationComplete="creationComplete(event)">
<fx:Script>
<![CDATA[
import mx.collections.ArrayCollection;
import mx.events.FlexEvent;
import mx.formatters.DateFormatter;
protected function creationComplete(event:FlexEvent):void
{
var conn:SQLConnection = new SQLConnection();
var dbFile:File = File.applicationDirectory.resolvePath('assets/test.db');
var dbAppFile:File = File.applicationStorageDirectory.resolvePath('assets/test.db');
if(!dbAppFile.exists)
dbFile.copyTo(dbAppFile);
conn.openAsync(dbAppFile, SQLMode.READ, new Responder(function success(event:SQLEvent):void{
/* var update:SQLStatement = new SQLStatement();
update.sqlConnection = conn;
update.text = "UPDATE mytable SET dob = :dob WHERE name = :name"
update.parameters[':dob'] = new Date()
update.parameters[':name'] = 'Test';
update.execute(-1, new Responder(function success(event:SQLResult):void{
trace(event.rowsAffected);
},
function error(event:SQLError):void{
trace(event.toString());
})); */
var select:SQLStatement = new SQLStatement();
select.sqlConnection = conn;
select.text = "SELECT name, dob FROM mytable";
select.execute(-1, new Responder(function success(event:SQLResult):void{
trace("OK");
list.dataProvider = new ArrayCollection(event.data);
},
function error(event:SQLErrorEvent):void{
trace(event.error.toString());
}));
},
function error(event:SQLError):void{
trace(event.toString());
}));
}
private var _dateformatter:DateFormatter = new DateFormatter();
private function formatDate(item:Object,column:GridColumn):String
{
_dateformatter.formatString = "DD/MM/YYYY";
return _dateformatter.format(item[column.dataField]);
}
]]>
</fx:Script>
<fx:Declarations>
<!-- Place non-visual elements (e.g., services, value objects) here -->
</fx:Declarations>
<s:DataGrid id="list" left="0" right="0" top="0" bottom="0" >
<s:columns>
<s:ArrayCollection>
<s:GridColumn dataField="name" />
<s:GridColumn dataField="dob" labelFunction="formatDate" />
</s:ArrayCollection>
</s:columns>
</s:DataGrid>
</s:View>