좋은거 발견;;
—————————————————————————
assql
http://code.google.com/p/assql/ (IE에서만 보임)
http://www.maclema.com/assql/
문서
[#M_croosdomain 보기|닫기|
To access your database server you will need a crossdomain.xml file on the root of the server the database is located on.
Example: This allows any website to access the database from a flex app.
<?xml version=”1.0″?>
<!DOCTYPE cross-domain-policy SYSTEM "http://www.macromedia.com/xml/dtds/cross-domain-policy.dtd">
<cross-domain-policy>
<allow-access-from domain=“*” to-ports=“3306″ />
</cross-domain-policy>
Example 2: This allows yourdomain.com to access mysql.yourdomain.com: (Place crossdomain.xml on root of mysql.yourdomain.com)
<?xml version=”1.0″?>
<!DOCTYPE cross-domain-policy SYSTEM "http://www.macromedia.com/xml/dtds/cross-domain-policy.dtd">
<cross-domain-policy>
<allow-access-from domain=“*yourdomain.com” to-ports=“80,3306″ />
</cross-domain-policy>
These should work, let me know if they dont.
_M#]
======================================================================================
asql
http://asql.mooska.pl/
————- database/SQL ——————-
drop table if exists person;
CREATE TABLE person
(
personID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(personID),
GivenName varchar(15),
FamilyName varchar(25),
Phone varchar(15)
);
INSERT INTO person (GivenName, FamilyName, Phone)
VALUES (‘Peter’, ‘Griffin’, ’07 3344 5566′);
INSERT INTO person (GivenName, FamilyName, Phone)
VALUES (‘Glenn’, ‘Quagmire’, ’07 3456 7890′);
select * from person;
—————- Flex code ———————
<?xml version=”1.0″ encoding=”utf-8″?>
<mx:Application xmlns:mx=”http://www.adobe.com/2006/mxml” layout=”absolute” applicationComplete=”ASQL()”>
<mx:Script>
<![CDATA[
import pl.mooska.asql.*;
import pl.mooska.asql.events.*;
import flash.display.Sprite;
private var connector:Asql = new Asql();//creating instance of asql
[Bindable]
public var recordset:Array;
public function ASQL():void
{
connector.addEventListener( SQLEvent.CONNECT, handleConnect );
connector.addEventListener( SQLError.SQL_ERROR, handleError );
connector.addEventListener( SQLEvent.SQL_OK, handleOK )//will be invoked after succefull update or insert
connector.addEventListener(SQLEvent.SQL_DATA, handleData);
connector.connect(“localhost”, “myuser”, “password”, “test2″ , 3306);//connecting to the server
//arguments are host, user, pass, database, and port (shouldnt change that one)
}
private function handleConnect ( evt:SQLEvent ) :void
{
trace(“ASQL is connected”);
connector.query(“select * from person”);//type a query, without semicolon at the end
}
private function handleError ( evt:SQLError ) :void
{
trace(“Error catched “+evt.text);
}
private function handleOK ( evt:SQLEvent ) :void
{
trace(“Command was succesfull “);
}
private function handleData ( evt:SQLEvent ) :void
{
trace(“Final data received”);
trace( evt.data );//you get result as an array of objects, every object is one row
//to get into value, just type evt.data[0].columnName etc
recordset = evt.data;
//connector.disconnect();
}
]]>
</mx:Script>
<mx:Canvas>
<mx:DataGrid dataProvider=”{recordset}” />
</mx:Canvas>
</mx:Application>
===========================================================================
AS3 라이브러리 정리
http://riapp.egloos.com/3630552
