Flex直接与mysql数据库连接

 <?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx=" http://ns.adobe.com/mxml/2009"
      xmlns:s="library://ns.adobe.com/flex/spark"
      creationComplete="application1_creationCompleteHandler(event)"
      xmlns:mx="library://ns.adobe.com/flex/mx"
      minWidth="955"
      minHeight="600">
 <s:layout>
  <s:BasicLayout/>
 </s:layout>
 <fx:Script>
  <![CDATA[
   import com.maclema.mysql.Connection;
   import com.maclema.mysql.MySqlToken;
   import com.maclema.mysql.ResultSet;
   import com.maclema.mysql.Statement;
   
   import mx.controls.Alert;
   import mx.events.FlexEvent;
   import mx.rpc.AsyncResponder;
   
   private var con:Connection;
   
   protected function application1_creationCompleteHandler(event:FlexEvent):void
   {
    con=new Connection("localhost", 3306, "root", "root", "croot");
    con.connect();
   }
   
   protected function button1_clickHandler(event:MouseEvent):void
   {
    var st:Statement=con.createStatement();
    var token:MySqlToken=st.executeQuery("select * from  xstudent");
    token.addResponder(new AsyncResponder(function(data:Object, token:Object):void
    {
     var rs:ResultSet=ResultSet(data);
     while (rs.next())
     {
      Alert.show(rs.getString("login_name"));
     }
    }, function(info:Object, token:Object):void
    {
     Alert.show("Error: " + info);
    }, token));
   }
   
  ]]>
 </fx:Script>
 <fx:Declarations>
  <!-- 将非可视元素(例如服务、值对象)放在此处 -->
 </fx:Declarations>
 <mx:Button label="连接数据库" click="button1_clickHandler(event)"></mx:Button>
</s:Application>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值