flex 连接mysql

转载自(http://hi.baidu.com/jsbrml/item/b578c75d4beb0f424fff2070)

<?xml version="1.0" encoding="utf-8"?>   <mx:WindowedApplication    
        xmlns:mx="http://www.adobe.com/2006/mxml"    
        xmlns:assql="com.maclema.mysql.mxml.*"    
        layout="absolute">           <mx:script>   
        <![CDATA[                           import mx.controls.Alert;   
                        import com.maclema.mysql.events.MySqlErrorEvent;   
                import com.maclema.util.ResultsUtil;   
                private function handleConnected(e:Event):void {   
                        service.send("SELECT * FROM employees2 LIMIT 10");   
                }   
                private function handleError(e:MySqlErrorEvent):void {   
                        Alert.show(e.text);                   }   
        ]]>           </mx:script>   
        <assql:MySqlService id="service"   
                hostname="localhost"                    username="root"   
                password=""                   database="assql-test"   
                autoConnect="true"   
                connect="handleConnected(event)"    
                sqlError="handleError(event)" />   
        <mx:DataGrid id="grid" left="10" right="10" top="10" bottom="10"   
                dataProvider="{service.lastResult}"   
                columns="{ResultsUtil.getDataGridColumns(service.lastResultSet)}" />   
</mx:WindowedApplication>

注意要下载引用asSQL-Beta2.8.swc哦!  

posted @ 2012-11-19 09:43  junjunang  阅读(292)  评论(0编辑  收藏  举报