org.libspark.utils.SqlUtil

Class SqlUtil

Package org.libspark.utils

Class public class SqlUtil
(Flex Only)

Package	org.libspark.utils
Class	public class SqlUtil

Public Methods

SqlUtil()
Constructor SqlUtil
buildInsert(table:String, rows:ArrayCollection) :String
static Build Insert SQL Statement SqlUtil
buildSelectAll(db:SQLConnection, table:String) :String
static Build Select All SQL Statement SqlUtil
buildTableDefs(db:SQLConnection, table:String) :Array
static Build Create Table SQL Statement SqlUtil
createIndex(db:SQLConnection, table:String, indexDefs:ArrayCollection) :Boolean
static Create index of the specified table SqlUtil
createTable(db:SQLConnection, table:String, tableDefs:ArrayCollection) :Boolean
static Create table to the specified database SqlUtil
deleteRow(db:SQLConnection, table:String, keyColumn:String, keyValue:int) :Boolean
static Delete row from the specified table SqlUtil
dropIndex(db:SQLConnection, index:String) :Boolean
static Drop the specified index from the DataBase SqlUtil
dropTable(db:SQLConnection, table:String) :Boolean
static Drop the specified table from the DataBase SqlUtil
executeSQLStatement(db:SQLConnection, sql:String) :Object
static private method SqlUtil
existsIndex(db:SQLConnection, table:String, index:String) :Boolean
static Check if the index exists in the specified table SqlUtil
existsTable(db:SQLConnection, table:String) :Boolean
static Check if the table exists in the database SqlUtil
getColumnDef(db:SQLConnection, table:String) :ArrayCollection
static Get the columns definition of the specified table SqlUtil
getData(db:SQLConnection, sql:String) :Array
static Get the Data & Column Defs of the table SqlUtil
getIndexList(db:SQLConnection, table:String) :ArrayCollection
static Get the index list of the specified table SqlUtil
getRowCount(db:SQLConnection, table:String) :uint
static Get the row count of the table SqlUtil
getTableList(db:SQLConnection) :Array
static Get the table list of the specified DataBase SqlUtil
insertRow(db:SQLConnection, table:String, rows:ArrayCollection) :Boolean
static Insert row to the specified table SqlUtil
trancateTable(db:SQLConnection, table:String, keyColumn:String) :Boolean
static Remove the whole data of the specified table SqlUtil
updateRow(db:SQLConnection, table:String, keyColumn:String, keyValue:int, updateColumn:String, updateValue:String, updateType:String) :Boolean
static Update row of the specified table SqlUtil

Constructor detail

SqlUtil() constructorpublic function SqlUtil()
Constructor

Method detail

buildInsert() methodpublic static function buildInsert(table:String, rows:ArrayCollection):String
Build Insert SQL Statement

Parameters

table:String
— Table to insert data

rows:ArrayCollection
— Data to insert

Returns

String
— Insert SQL Statement
buildSelectAll() methodpublic static function buildSelectAll(db:SQLConnection, table:String):String
Build Select All SQL Statement

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

table:String
— Table to build the SQL statement

Returns

String
— Select All SQL Statement
buildTableDefs() methodpublic static function buildTableDefs(db:SQLConnection, table:String):Array
Build Create Table SQL Statement

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

table:String
— Table to build the SQL statement

Returns

Array
— Create Table SQL Statement
createIndex() methodpublic static function createIndex(db:SQLConnection, table:String, indexDefs:ArrayCollection):Boolean
Create index of the specified table

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

table:String
— The table to create index

indexDefs:ArrayCollection
— ArrayCollection of the index definition and it contains the following params. - name : Index name - columns: The list of the column

Returns

Boolean
— true/false If it succeed to create the index
createTable() methodpublic static function createTable(db:SQLConnection, table:String, tableDefs:ArrayCollection):Boolean
Create table to the specified database

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

table:String
— The table name

tableDefs:ArrayCollection
— ArrayCollection of the table definition and it contains the following params. - name : Column name - type : The data type of the column - primaryKey : If the column is primary key - autoIncrement: If it will increment the value automatically - allowNull : If the column allows null value

Returns

Boolean
— true/false If it succeed to create the table
deleteRow() methodpublic static function deleteRow(db:SQLConnection, table:String, keyColumn:String, keyValue:int):Boolean
Delete row from the specified table

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

table:String
— The table to delete the row

keyColumn:String
— The column name that specify the row

keyValue:int
— The column value that specify the row

Returns

Boolean
— true/false If it succeed to delete the row
dropIndex() methodpublic static function dropIndex(db:SQLConnection, index:String):Boolean
Drop the specified index from the DataBase

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

index:String
— The Index to drop from DataBase

Returns

Boolean
— true/false If it succed to drop the index
dropTable() methodpublic static function dropTable(db:SQLConnection, table:String):Boolean
Drop the specified table from the DataBase

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

table:String
— The Table to drop from DataBase

Returns

Boolean
— true/false If it succed to drop the table
executeSQLStatement() methodpublic static function executeSQLStatement(db:SQLConnection, sql:String):Object
private method

Parameters

db:SQLConnection

sql:String

Returns

Object
existsIndex() methodpublic static function existsIndex(db:SQLConnection, table:String, index:String):Boolean
Check if the index exists in the specified table

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

table:String
— The table if contains the index

index:String
— The index name to check

Returns

Boolean
— true/false If the index exists in the table
existsTable() methodpublic static function existsTable(db:SQLConnection, table:String):Boolean
Check if the table exists in the database

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

table:String
— The table name to check

Returns

Boolean
— true/false If the table exists in the table
getColumnDef() methodpublic static function getColumnDef(db:SQLConnection, table:String):ArrayCollection
Get the columns definition of the specified table

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

table:String
— The table name which you want the column defs

Returns

ArrayCollection
— The ArrayCollection of the columns definition and it contains the following params - name : Column name - type : The Data type of the column - primaryKey : If this column is primary key - autoIncrement: If this column increment automatically - allowNull : If this column allow null value
getData() methodpublic static function getData(db:SQLConnection, sql:String):Array
Get the Data & Column Defs of the table

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

sql:String
— The SQL string

Returns

Array
— result The Array which contains column defs and data The following are the description - result[0]: The Array of the columns name - result[1]: The SQLResult of the sql which executed
getIndexList() methodpublic static function getIndexList(db:SQLConnection, table:String):ArrayCollection
Get the index list of the specified table

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

table:String
— The table to get the list of index

Returns

ArrayCollection
— The ArrayCollection of the index and it contains the following params - name : Index name - columns: The column list
getRowCount() methodpublic static function getRowCount(db:SQLConnection, table:String):uint
Get the row count of the table

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

table:String
— The table name which you want to get the row count

Returns

uint
— The row count of the table
getTableList() methodpublic static function getTableList(db:SQLConnection):Array
Get the table list of the specified DataBase

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

Returns

Array
— The Array of the table name
insertRow() methodpublic static function insertRow(db:SQLConnection, table:String, rows:ArrayCollection):Boolean
Insert row to the specified table

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

table:String
— The table to insert the data

rows:ArrayCollection
— The ArrayCollection of the data to insert and it contains the following params - column: Column name - value : Column value - type : Data type of the column

Returns

Boolean
— true/false If it succeed to insert the row data
trancateTable() methodpublic static function trancateTable(db:SQLConnection, table:String, keyColumn:String):Boolean
Remove the whole data of the specified table

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

table:String
— The table to remove the whole data

keyColumn:String

Returns

Boolean
— true/false If it succed to trancate the table
updateRow() methodpublic static function updateRow(db:SQLConnection, table:String, keyColumn:String, keyValue:int, updateColumn:String, updateValue:String, updateType:String):Boolean
Update row of the specified table

Parameters

db:SQLConnection
— The SQLConnection of the specified DataBase

table:String
— The table to update the data

keyColumn:String
— The column name to specify the row

keyValue:int
— The column value to specify the row

updateColumn:String
— The column name to update

updateValue:String
— The column value to update

updateType:String
— The data type of the column to update

Returns

Boolean
— true/false If it succeed to update the row data