본 게시물은 테스트용으로 오류가 있는 게시물입니다.
수정중에 있음.
샘플코드 :
Flex Code :
xmlns:mx="http://www.adobe.com/2006/mxml"
creationComplete="onCreationComplete()"
layout="horizontal">
import mx.collections.ArrayCollection;
import com.maclema.mysql.ResultSet;
import com.maclema.mysql.MySqlToken;
import com.maclema.mysql.Statement;
import com.maclema.mysql.Connection;
import com.maclema.mysql.events.MySqlErrorEvent;
import mx.rpc.AsyncResponder;
import mx.controls.Alert;
private var con:Connection;
private var st:Statement;
private var token:MySqlToken;
[Bindable]
private var dataAC:ArrayCollection;
private function onCreationComplete():void
{
con = new Connection("localhost", 3306, "guest", "pass1", "db_guest");
con.addEventListener(Event.CONNECT, handleConnected);
con.connect("euckr");
}
private function handleConnected(e:Event):void
{
if (con != null)
{
st = con.createStatement();
Alert.show("connect ok");
}
else
{
Alert.show("connect fail");
}
}
private function insertResult(data:Object, token:Object):void
{
Alert.show(token.description + " 삽입성공!");
selectProcess();
insertBox.visible = false;
}
private function selectResult(data:Object, token:Object):void
{
Alert.show("select ok!");
var rs:ResultSet = ResultSet(data);
dataAC = rs.getRows();
}
private function fault(info:Object, token:Object):void
{
Alert.show("Error: " + info);
}
private function selectProcess():void
{
var token:MySqlToken = st.executeQuery("SELECT name,used FROM members");
token.type = "select";
token.addResponder(new AsyncResponder(selectResult, fault, token));
}
private function insertProcess():void
{
st.sql = "INSERT INTO members (name, used) VALUES (?, ?)";
st.setString(1, inputDescription.text);
st.setString(2, '1');
var token:MySqlToken = st.executeQuery();
token.description = inputDescription.text;
token.addResponder(new AsyncResponder(insertResult, fault, token));
}
]]>
mySQL table info :
table : members
----------------
name | used
----------------
tony | 1
----------------
shown | 1
----------------
