本人用AS3.0开发的as3项目,没有用后台php等,就引用了asSQL2.8.SWC库文件直接操作mysql,程序能够插入、修改记录,但不知道如何显示查询记录,折腾了好久都没弄出来,只能执行到var token:MySqlToken =st.executeQuery(sql);这里,后面的函数估计用错了。哪位高手帮忙修改一下,将感激不尽!代码如下:package
{
/**
* @author: pengzhe
* @date: 2017-8-21 下午5:59:53
* @version: airee334 V1.0.0
* @description: <<请在此处简要描述 airee334 的主要功能>>
*/
import com.maclema.mysql.Connection;
import com.maclema.mysql.MySqlToken;
import com.maclema.mysql.ResultSet;
import com.maclema.mysql.Statement;
import com.maclema.mysql.events.MySqlErrorEvent;
import com.maclema.mysql.events.MySqlEvent;
import flash.display.Sprite;
public class airee334 extends Sprite
{
//属性 ----
//初始化----
public function airee334()
{
var host:String = "localhost";
var port:int = 3306;
var user:String = "root";
var pwd:String = "123456";
var database:String = "assq";
var con:Connection = new Connection(host,port,user,pwd,database);
con.connect();
var st:Statement = con.createStatement();
var sql:String="SELECT id,name FROM user";
var token:MySqlToken =st.executeQuery(sql);
token.addEventListener(MySqlEvent.RESULT,function (e:MySqlEvent):void{
var rs:ResultSet = e.resultSet;
var userName:String = rs.getString("id");
var roleId:String = rs.getString("name");
while ( rs.next() )
{
var _userNameArr:Array =new Array();
var _roleIdArr:Array = new Array();
_userNameArr.push(userName);
_roleIdArr.push(roleId);
}
trace(_userNameArr);
trace(_roleIdArr);
con.disconnect();
});
token.addEventListener(MySqlErrorEvent.SQL_ERROR,function(e:MySqlErrorEvent){
trace("访问出错了...");
con.disconnect();
});
}
//接口-----
//事件-----
}
}
{
/**
* @author: pengzhe
* @date: 2017-8-21 下午5:59:53
* @version: airee334 V1.0.0
* @description: <<请在此处简要描述 airee334 的主要功能>>
*/
import com.maclema.mysql.Connection;
import com.maclema.mysql.MySqlToken;
import com.maclema.mysql.ResultSet;
import com.maclema.mysql.Statement;
import com.maclema.mysql.events.MySqlErrorEvent;
import com.maclema.mysql.events.MySqlEvent;
import flash.display.Sprite;
public class airee334 extends Sprite
{
//属性 ----
//初始化----
public function airee334()
{
var host:String = "localhost";
var port:int = 3306;
var user:String = "root";
var pwd:String = "123456";
var database:String = "assq";
var con:Connection = new Connection(host,port,user,pwd,database);
con.connect();
var st:Statement = con.createStatement();
var sql:String="SELECT id,name FROM user";
var token:MySqlToken =st.executeQuery(sql);
token.addEventListener(MySqlEvent.RESULT,function (e:MySqlEvent):void{
var rs:ResultSet = e.resultSet;
var userName:String = rs.getString("id");
var roleId:String = rs.getString("name");
while ( rs.next() )
{
var _userNameArr:Array =new Array();
var _roleIdArr:Array = new Array();
_userNameArr.push(userName);
_roleIdArr.push(roleId);
}
trace(_userNameArr);
trace(_roleIdArr);
con.disconnect();
});
token.addEventListener(MySqlErrorEvent.SQL_ERROR,function(e:MySqlErrorEvent){
trace("访问出错了...");
con.disconnect();
});
}
//接口-----
//事件-----
}
}
var rs:ResultSet = e.resultSet;
var _userNameArr:Array =new Array();
var _roleIdArr:Array = new Array();
while ( rs.next() )
{
var userName:String = rs.getString("name");
var roleId:String = rs.getString("id");
_userNameArr.push(userName);
_roleIdArr.push(roleId);
}
trace(_userNameArr);
trace(_roleIdArr);
con.disconnect();
});