How to USe SQLite with Flex Hello Readers! This blog is about how to use SQLite in Flex. Before proceeding a brief introduction to SQLite. SQLite is a relational database management system contained in a small C programming library,it is an embedded SQL database engine and a compact library. It implements a self-contained, serverless, zero-configuration, transactional SQL database engine and the transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.There is no set up required and does not need to be configured before it is used.
And here goes the code!! In this the "name" and "password" will insert into the table named "login" when a user click the button.
1. import flash.data.SQLConnection; 2.
import flash.data.SQLMode;
3.
import flash.data.SQLResult;
4.
import flash.data.SQLStatement;
5.
import flash.errors.SQLError;
6.
import flash.events.EventDispatcher;
7.
import flash.events.SQLErrorEvent;
8.
import flash.events.SQLEvent;
9.
import flash.filesystem.File;
10.
import flash.net.Responder;
11. 12.
public class SQLHandler extends EventDispatcher
13.
{
14. 15.
private var conn:SQLConnection;
16. 17.
public function SQLHandler()
18.
{
19.
createSQlConnection();
20. 21. Read Full Blogs : How to Use SQLite with Flex
You can check more informative blogs and tutorials at java development blogs section and can also browse the java developer forum for posting and viewing latest questions on iphone development