Flex Air 周边整合之碎语
手边近期有一个项目（薪酬系统）要开工，开始用Flex Air打理框架
1、Flex Air 依然作为本地前台；
2、中介语言不再采用php(amfphp),java(lds)或c#(FluorineFx)来搞了,直接采用assql;
3. 数据库采用远程数据库Mysql
[Note]
1.由于涉及远程数据库，所以用C++编辑Mysql联机参数，再采用Alchemy编译成swc来封装
//MySqlService.cpp
#include <stdlib.h>#include <stdio.h>#include <string.h>#include "AS3.h"AS3_Val GetMysqlArg(void* self, AS3_Val args){char* val = NULL; //本机AS3_Val localconn = AS3_Object("host:StrType,port:StrType,username:StrType,password:StrType,database:StrType","127.0.0.1","3306","xxxxx", "xxxx","xxxxx");//网络 AS3_Val netconn = AS3_Object("host:StrType,port:StrType,username:StrType,password:StrType,database:StrType","xxx.xxx.xx.xx","3306","xxxxx", "xxxx","xxxx");AS3_ArrayValue( args, "StrType", &val );if(val == NULL){return localconn;}return netconn;}int main(){AS3_Val cMethod = AS3_Function( NULL, GetMysqlArg);AS3_Val result = AS3_Object("GetMysqlArg: AS3ValType",cMethod);AS3_Release(cMethod);AS3_LibInit( result );return 0;} var cppMySqlService:CLibInit=new cmodule.mysqlservice.CLibInit;var mysqlArgObj:Object=cppMySqlService.init();//与远程数据库联机var mysqlServie:Object=mysqlArgObj.GetMysqlArg("net");SQLGlobal.set_mysql_host(mysqlServie.host);SQLGlobal.set_mysql_port(int(mysqlServie.port))SQLGlobal.set_mysql_username(mysqlServie.username)SQLGlobal.set_mysql_password(mysqlServie.password)SQLGlobal.set_mysql_database(mysqlServie.database)protected function isNewerFunction(currentVersion:String, updateVersion:String):Boolean{if (currentVersion == updateVersion){trace("版本一样,直接进入平台")DoShowLogin()}else{trace("版本不一样")//提示用户是否更新Alert.show("软件有新的更新:版本(" + updater.updateVersion + ").下载安装更新吗?", "提示信息", 3, null, versionCloseHandler, null, 3)}return true;}private function versionCloseHandler(event:CloseEvent):void{if (event.detail == Alert.YES){trace("更新");doGoUpdate()}else{//客户不更新，直接登陆界面DoShowLogin()}}protected function doGoUpdate():void{doCreateDownloadingView()updater.addEventListener(DownloadErrorEvent.DOWNLOAD_ERROR, updater_downloadErrorHandler);updater.addEventListener(UpdateEvent.DOWNLOAD_COMPLETE, updater_downloadCompleteHandler);updater.downloadUpdate();}private function doCreateDownloadingView():void{//清空对象，创建下载更新包自定义界面MainAppContainer.removeAllChildren();var viewHGroup:HGroup=new HGroup();viewHGroup.setStyle("horizontalCenter", 0)viewHGroup.setStyle("verticalCenter", 0);viewHGroup.setStyle("verticalAlign", "top");MainAppContainer.addChild(viewHGroup)var bitmapImg:BitmapImage=new BitmapImage();bitmapImg.source='/assets/system_upgrade.png';viewHGroup.addElement(bitmapImg)var viewVGroup:VGroup=new VGroup();viewVGroup.percentWidth=100;viewVGroup.setStyle("horizontalAlign", "center")viewHGroup.addElement(viewVGroup)var infoLabel:Label=new Label();infoLabel.text="更新说明："viewVGroup.addElement(infoLabel)var richTxt:RichText=new RichText();richTxt.text=updater.updateDescription;viewVGroup.addElement(richTxt);var prgBar:ProgressBar=new ProgressBar();prgBar.label="下载中... %3%";prgBar.source=updater;viewVGroup.addElement(prgBar);}protected function updater_errorHandler(event:ErrorEvent):void{Alert.show(event.text);}protected function updater_initializedHandler(event:UpdateEvent):void{trace("初始化毕，执行检查")updater.checkNow();}protected function updater_updateStatusHandler(event:StatusUpdateEvent):void{if (event.available){event.preventDefault();}else{Alert.show("Your application is up to date!");}}private function updater_downloadCompleteHandler(event:UpdateEvent):void{trace("下载完成")updater.installUpdate();}private function updater_downloadErrorHandler(event:DownloadErrorEvent):void{Alert.show("下载更新安装包出错，请稍候再试！");}/******************************************************************************/public function DoShowLogin():void{trace("显示登陆界面")this.stage.nativeWindow.visible=falsevar logoWin:LoginWindow=new LoginWindow()logoWin.open(true)logoWin.nativeWindow.x=Capabilities.screenResolutionX / 2 - logoWin.width / 2;logoWin.nativeWindow.y=Capabilities.screenResolutionY / 2 - logoWin.height / 2;}