Adobe AIR has had support for embedded SQLite databases from the beginning. This is one of the best ways of storing structured information within our Android applications. SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The database files it creates are simply individual .db files, which can be transported across a network, copied, and deleted just like any other file type.
We will create a mobile application along with a local SQLite database, which can employ the SQL query language to allow the user access to add new records and run a simple query based upon these entries:
1. First, import the following classes necessary for this example:
import flash.data.SQLConnection; import flash.data.SQLStatement; import flash.data.SQLResult; import flash.display.Sprite; import flash.display.StageAlign; import flash.display.StageScaleMode; import flash.events.Event; import...