Assql

Examples - assql - Project Hosting on Google Code

http://code.google.com/p/assql/wiki/Examples

My favorites

▼

| Sign in

assql
Actionscript 3 MySql Driver Project Home Search Downloads for Updated Feb 04, 2010 by maclema Labels: Featured Wiki Issues Source

Examples
#Examples of using asSQL (Beta 2.5 and later)

On This Page
MySqlService Example Token Responder Example 1Token Responder Example 2 Inserting Binary Data Example Selecting Binary Data Example Stored Procedure Example Streaming Results

MySqlService Example
This example is using MySqlService and DataGrid. The data grid's columns property and dataProvider property are bound to the MySqlService lastResult (ArrayCollection of Rows) and lastResultSet (The actual ResultSet).


TokenResponder Example 1
This is an example of using an AsyncResponder to handle a query.
import import import import import import import com.maclema.mysql.Statement; com.maclema.mysql.Connection; com.maclema.mysql.ResultSet; mx.controls.Alert; mx.rpc.AsyncResponder; com.maclema.mysql.MySqlToken; com.maclema.util.ResultsUtil;

//The MySql Connection private var con:Connection;

1 de 7

28/02/201011:21 a.m.

Examples - assql - Project Hosting on Google Code

http://code.google.com/p/assql/wiki/Examples

private function onCreationComplete():void { con = new Connection("localhost", 3306, "root", "", "assql-test"); con.addEventListener(Event.CONNECT, handleConnected); con.connect(); } private function handleConnected(e:Event):void { var st:Statement = con.createStatement(); vartoken:MySqlToken = st.executeQuery("SELECT * FROM employees"); token.addResponder(new AsyncResponder( function(data:Object, token:Object):void { var rs:ResultSet = ResultSet(data); Alert.show("Found " + rs.size() + " employees!"); }, function(info:Object, token:Object):void { Alert.show("Error: " + info); }, token )); }

Token Responder Example 2
This is a more in depth example. With eachstatement, an info property is set on the MySqlToken. This way all queries and responses can be handled with the same result and fault handlers. This example also uses a statement that uses parameters.
import import import import import import import com.maclema.mysql.Statement; com.maclema.mysql.Connection; com.maclema.mysql.ResultSet; mx.controls.Alert; mx.rpc.AsyncResponder;com.maclema.mysql.MySqlToken; com.maclema.util.ResultsUtil;

//The MySql Connection private var con:Connection; private function onCreationComplete():void { con = new Connection("localhost", 3306, "root", "", "assql-test"); con.addEventListener(Event.CONNECT, handleConnected); con.connect(); } private function handleConnected(e:Event):void { getAllEmployees(); } private function getAllEmployees():void { varst:Statement = con.createStatement(); var token:MySqlToken = st.executeQuery("SELECT * FROM employees"); token.info = "GetAllEmployees"; token.addResponder(new AsyncResponder(result, fault, token)); } private function getEmployee(employeeID:int):void { var st:Statement = con.createStatement(); st.sql = "SELECT * FROM employees WHERE employeeID = ?"; st.setNumber(1, employeeID); vartoken:MySqlToken = st.executeQuery(); token.info = "GetEmployee"; token.employeeID = employeeID; token.addResponder(new AsyncResponder(result, fault, token)); } private function result(data:Object, token:Object):void { var rs:ResultSet; if ( token.info == "GetAllEmployees" ) { rs = ResultSet(data); Alert.show("Found " + rs.size() + " employees!"); } else if ( token.info == "GetEmployee" ) { rs =ResultSet(data); if ( rs.next() ) { Alert.show("Employee " + token.employeeID + " username is '" + rs.getString("username") + "'"); } else { Alert.show("No such employee for id " + token.employeeID); } } } private function fault(info:Object, token:Object):void { Alert.show(token.info + " Error: " + info); }

2 de 7

28/02/2010 11:21 a.m.

Examples - assql - Project Hosting on Google Code...