<?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>
<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>