Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package {
- import flash.data.SQLConnection;
- import flash.data.SQLResult;
- import flash.data.SQLStatement;
- import flash.filesystem.File;
- import qnx.ui.data.DataProvider;
- public class SQLFunctions {
- private var dbName:String = "fishySQL.db";
- private var dbFile:File = File.applicationStorageDirectory.resolvePath(dbName);
- private var dbConn:SQLConnection;
- private var dbSTMT:SQLStatement;
- private var sqlResult:SQLResult;
- private var databaseDP:DataProvider;
- private var firstRun:Boolean;
- private var totalRows:int;
- public function SQLFunctions() {
- if (!dbFile.exists) {
- createDB()
- }
- }
- public function createDB():void {
- createConnection();
- dbSTMT.text = "CREATE TABLE IF NOT EXISTS USERTABLE (USER_ID INTEGER PRIMARY KEY AUTOINCREMENT, " +
- "USERNAME TEXT, " +
- "USERPASSWORD TEXT, " +
- "USERDESCRIPTION TEXT" +
- ")";
- dbSTMT.execute();
- dbSTMT.text = "INSERT INTO USERTABLE (" +
- "USERNAME, " +
- "USERPASSWORD, " +
- "USERDESCRIPTION" +
- ") VALUES (?, ?, ?)";
- dbSTMT.parameters[0] = "John Doe";
- dbSTMT.parameters[1] = "p455w0rd";
- dbSTMT.parameters[2] = "PW IS BAD!";
- dbSTMT.execute();
- closeConnection();
- }
- public function createConnection():void {
- dbConn = new SQLConnection();
- dbConn.open(dbFile);
- dbSTMT = new SQLStatement();
- dbSTMT.sqlConnection = dbConn;
- }
- public function closeConnection():void {
- dbConn.close();
- }
- public function getTableData():DataProvider {
- createConnection();
- dbSTMT.text = "SELECT * FROM USERTABLE";
- dbSTMT.execute();
- sqlResult = dbSTMT.getResult();
- totalRows = sqlResult.data.length;
- databaseDP = new DataProvider();
- for each(var obj:Object in sqlResult.data){
- if(obj != null){
- databaseDP.addItem({label:obj["USERNAME"]});
- databaseDP.addItem({label:obj["USERPASSWORD"]});
- databaseDP.addItem({label:obj["USERDESCRIPTION"]});
- }
- }
- return databaseDP;
- }
- public function getCount():int {
- return totalRows;
- }
- public function writeData(inputUN:String, inputUP:String, inputUD:String):void {
- createConnection();
- dbSTMT.text = "INSERT INTO USERTABLE (" +
- "USERNAME, " +
- "USERPASSWORD, " +
- "USERDESCRIPTION" +
- ") VALUES (?, ?, ?)";
- dbSTMT.parameters[0] = inputUN;
- dbSTMT.parameters[1] = inputUP;
- dbSTMT.parameters[2] = inputUD;
- dbSTMT.execute();
- closeConnection();
- }
- public function removeRecord(delID:int):void {
- createConnection();
- dbSTMT.text = "DELETE FROM USERTABLE WHERE USER_ID = " + delID + "";
- dbSTMT.execute();
- closeConnection();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement