Explanation of the encryption process:

• Create a seed string of your choice, mySeed.
• Prepare a bytearray variable to hold the encryption key
• Create the myKey ByteArray
• Use hexToInt function and the seed, mySeed, to create the key
• Use the writeByte method - Writes bytes to the byte stream
• Create a File that will represent the SQLite database
• Pass the key [a ByteArray], myKey, to the open method of the SQLConnection, dbConn

import flash.data.*;
import flash.filesystem.File;

private var dbConn:SQLConnection = new SQLConnection();
private var dbStatement:SQLStatement = new SQLStatement();

private function init(): void {
    // create a seed string of your choice
    var mySeed:String = "AdobeAIRIsAGreatProduct";

    // prepare a bytearray variable to hold the encryption key
     var myKey:ByteArray = new ByteArray();

    // create the myKey ByteArray
    var i:int = 0;
    for (var j:int=0; j<16; j++) {
        // use hexToInt function and the seed to create the key
        i = (hexToInt(mySeed.charCodeAt(j))*15) +
        hexToInt(mySeed.charCodeAt(j+1));

        // use the writeByte method - Writes byte to the byte stream
        myKey.writeByte(i&0x00FF);
    }
    // create a File that will represent the SQLite db
    var dbFile:File =
    File.desktopDirectory.resolvePath("Encryptedemployees.db");
    dbStatement.sqlConnection = dbConn;

    //pass the key, myKey, to the open method of the SQLConnection, dbConn
    dbConn.open(dbFile, SQLMode.CREATE, false, 2048, myKey);
}

private function hexToInt(hex:Number):int {
    return parseInt("0x" + hex);
}

This example is available here. The source code is available by right-clicking and selecting 'View Source' in this AIR application. You will need to install the Adobe AIR runtime if you do not already have it installed.

The SQLite database contains Lord of the Rings information.

A TitleWindow that displays the Lord of the Rings characters' images as read from the SQLite database.

Opening the database shows that the data is encrypted.

        Tip Jar: