<?xml version="1.0" encoding="utf-8"?>
<s:WindowedApplication xmlns:fx="http://ns.adobe.com/mxml/2009" 
					   xmlns:s="library://ns.adobe.com/flex/spark" 
					   xmlns:mx="library://ns.adobe.com/flex/mx" 
					   creationComplete="init()">
	
	<fx:Script>
		<![CDATA[
			import flash.data.SQLConnection;
			import flash.data.SQLStatement;
			import flash.events.SQLErrorEvent;
			import flash.events.SQLEvent;
			import flash.filesystem.File;
			
			import mx.collections.ArrayCollection;
			import mx.controls.Alert;
			
			import vo.Animal;
			
			private var sqlConnection:SQLConnection;
			private var sqlStatement:SQLStatement;
			
			private var Animals:ArrayCollection = new ArrayCollection();
			
			private function init():void
			{
				sqlConnection = new SQLConnection();
				sqlConnection.addEventListener(SQLEvent.OPEN, openHandler);
				sqlConnection.addEventListener(SQLErrorEvent.ERROR, errorHandler);
				
				sqlStatement = new SQLStatement();
				sqlStatement.sqlConnection = sqlConnection;
				sqlStatement.text = "SELECT * FROM animals";
				sqlStatement.itemClass = Animal;
				
				var dbFile:File = File.applicationDirectory.resolvePath("data/dbdemos.db3");
				sqlConnection.open(dbFile);
			}
			
			private function openHandler(event:SQLEvent):void
			{
				sqlStatement.addEventListener(SQLEvent.RESULT, resultHandler);
				sqlStatement.execute();
			}
			
			private function errorHandler(event:SQLErrorEvent):void
			{
				Alert.show(event.error.details);
			}
			
			private function resultHandler(event:SQLEvent):void
			{
				var result:SQLResult = sqlStatement.getResult();
				if(result != null)
				{
					for(var i:int = 0; i < result.data.length; i++)
					{
						Animals.addItem(result.data[i]);
					}
				}
			}
			
		]]>
	</fx:Script>
	
	<fx:Declarations>
		<!-- Place non-visual elements (e.g., services, value objects) here -->
	</fx:Declarations>
	
	<s:Panel title="Air App Accessing Local Database Demo">
			
		<mx:DataGrid dataProvider="{Animals}">
			<mx:columns>
				<mx:DataGridColumn headerText="Name" dataField="NAME"/>
				<mx:DataGridColumn headerText="Size" dataField="SIZE"/>
				<mx:DataGridColumn headerText="Weight" dataField="WEIGHT"/>
				<mx:DataGridColumn headerText="Area" dataField="AREA"/>
				<mx:DataGridColumn headerText="BMP" dataField="BMP"/>
			</mx:columns>
		</mx:DataGrid>
		
	</s:Panel>
	
</s:WindowedApplication>

package vo
{
	[Bindable]
	public class Animal
	{
		public var NAME:String;
		public var SIZE:int;
		public var WEIGHT:int;
		public var AREA:String;
		public var BMP:String
		
		public function Animal()
		{
		}
	}
}