Flex-Air-SQLite操作类及其简要用法

自己用的一个SQLite操作类，包括AIRSQLite，SqlParameter这两个类。用的都是静态的方法，使用的时候不用创建实例，直接引用就可以的。例如：AIRSQLite. setLocalSQLServer(“d:/test.db”)就在d盘根目录下新建了名为test的数据库。提供了建表查询删除等等的方法，自己可以扩展的SqlParameter= AIRSQLite.aspackage import flash.data.SQLConnection;import flash.data.SQLMode;import flash.data.SQLResult;import flash.data.SQLStatement;import flash.errors.SQLError;import flash.filesystem.File;public class AIRSQLite/ 数据库连接字串public static var localSQLServer:SQLConnection = new SQLConnection();public function AIRSQLite()/ 连接数据库public static function setLocalSQLServer(dbURL:String):Booleantryvar dbFile:File = File.applicationDirectory.resolvePath(dbURL);if(localSQLServer.connected)return true;localSQLServer.open(dbFile, SQLMode.UPDATE);catch(error:Error)return false;return true;/ 执行SQL语句，返回影响的记录数 public static function executeSql(conn:SQLConnection, sqlString:String, cmdParams:SqlParameter):int var result:SQLResult = querySQL(conn, sqlString, cmdParams); return result.rowsAffected; / 执行查询语句，返回结果数组public static function query(conn:SQLConnection, sqlString:String, cmdParams:SqlParameter):Arrayvar result:SQLResult = querySQL(conn, sqlString, cmdParams);return result.data;/ 执行查询语句，返回结果public static function querySQL(conn:SQLConnection, sqlString:String, cmdParams:SqlParameter):SQLResultvar sqlstatement:SQLStatement = new SQLStatement();sqlstatement.sqlConnection = conn;sqlstatement.text = sqlString;tryif(cmdParams.length 0)cmdParams.transParameters(sqlstatement);sqlstatement.execute();/cmdParams.clear();catch(error:SQLError)trace(error.details);throw SQLError;return sqlstatement.getResult(); / 检测一个记录是否存在 public static function exists(conn:SQLConnection, sqlString:String, cmdParams:SqlParameter):Boolean var result:Array = query(conn, sqlString, cmdParams); return result.length 0; / 获取表某个字段的最大值 public static function getMaxID(conn:SQLConnection, FieldName:String, TableName:String):uint var sql:String = SELECT MAX( + FieldName + ) FROM + TableName; var result:Array = query(conn, sql, new SqlParameter(); if (result0FieldName != null) return result0FieldName; else return 0; /总记录数 public static function getRecordNum(conn:SQLConnection, TableName:String, FieldName:String, cmdParams:SqlParameter, wheresql:String = ):uint var sql:String = SELECT COUNT( + FieldName + ) FROM + TableName; sql += +wheresql; var result:Array = query(conn, sql, cmdParams); return uint(result0COUNT(+FieldName+).toString(); /pageSize 每页数据量 /pageIndex 页数 public static function pageList(conn:SQLConnection, sqlString:String, cmdParams:SqlParameter, pageSize:uint, pageIndex:uint):Array sqlString += LIMIT +(pageSize*(pageIndex-1).toString()+, +pageSize.toString(); return query(conn, sqlString, cmdParams); =SqlParameter.aspackage import flash.data.SQLStatement;public dynamic class SqlParameter extends Objectpublic function SqlParameter()/给SQLStatement参数赋值public function transParameters(SQLStatementParameters:SQLStatement):voidfor (var i:String in this)SQLStatementParameters.parametersi = thisi;/清除全部属性public function clear():voidfor (var i:String in this)delete thisi;/获取属性数量public function get length():uintvar len:uint = 0;for (var i:String in this)len +;return len;=用法：整个类非常的简单，使用起来也简单，例如删除记录代码：/首先连接数据库,alert.sqlite是示例所用到的数据库名if(!AIRSQLite.setLocalSQLServer(“alert.sqlite”)trace(“连接数据库失败”);/deletepublic static function deleteDB(PKId:uint):Boolean/SQL字符串var sql:String = “Delete FROM EventTable Where PKId=PKId”;var parameters:SqlParameter = new SqlParameter();/参数parametersPKId = PKId;/执行return AIRSQLite.executeSql(AIRSQLite.localSQLServer, sql, parameters)0;/查询语句public static function viewDB(PKId:int = 0):Arrayvar sql:String = “Select * FROM EventTable “;var parameters:SqlParameter = new SqlParameter();if(PKId != 0)sql += “Where PKId=PKId”;parametersPKId = PKId;var result:Array = AIRSQLite.query(AIRSQLite.loc