mysql - How to working with mx.rpc.Responder in AS3 -

-

i trying use library called assql serving operations mysql. in use, saw works method called asyncresponder mx.rpc package available flex applications ... question is, how can use method in conventional as3, or use function solve problem?

package  {      import com.maclema.mysql.statement;     import com.maclema.mysql.connection;     import com.maclema.mysql.resultset;     import mx.rpc.asyncresponder;     import com.maclema.mysql.mysqltoken;     import com.maclema.util.resultsutil;     import flash.display.movieclip;     import flash.events.event;       public class crud extends movieclip{          //the mysql connection         private var con:connection;          public function crud() {             oncreationcomplete();         }          private function oncreationcomplete():void {             con = new connection("localhost", 3306, "root", "", "banricoop-game");             con.addeventlistener(event.connect, handleconnected);             con.connect();         }          private function handleconnected(event:event):void {             getallusers();         }          private function getallusers():void {             var st:statement = con.createstatement();              var token:mysqltoken = st.executequery("select * users");             token.info = "getallusers";             token.addresponder(new asyncresponder(result, fault, token));         }          private function getemployee(userid:int):void {             var st:statement = con.createstatement();             st.sql = "select * users id = ?";             st.setnumber(1, userid);              var token:mysqltoken = st.executequery();             token.info = "getuser";             token.userid = userid;             token.addresponder(new asyncresponder(result, fault, token));         }          private function result(data:object, token:object):void {             var rs:resultset;              if ( token.info == "getallusers" ) {                 rs = resultset(data);                     trace("found " + rs.size() + " employees!");                    } else if ( token.info == "getuser" ) {                 rs = resultset(data);                 if ( rs.next() ) {                     trace("employee " + token.employeeid + " username '" + rs.getstring("username") + "'");                 }                 else {                     trace("no such employee id " + token.employeeid);                 }             }         }          private function fault(info:object, token:object):void {                 trace(token.info + " error: " + info);         }     } }

hugs!

you need download flex sdk , add these libraries project:

  • /frameworks/libs/framework.swc
  • /frameworks/libs/rpc.swc

so, able use in as3 environment.


Comments

Post a Comment

Popular posts from this blog

How to run C# code using mono without Xamarin in Android? -

-
i want create program uses mono runtime run c# code (binary not application). i copied libmono.so unity app , i'm write code using documentation: http://www.mono-project.com/docs/advanced/embedding/ and it's working have problems references can access classes mscorlib.dll , have problems system.reflection.assembly class throwing exception, when print console see: system.missingmethodexception: method not found: 'system.reflection.assembly.op_inequality' can fix it? can use mono runtime in c binary on android? ps. i'm using android tests. edit: found solution loading libraries, need set environment variable mono_path libraries path. but have still problems assembly class. the system.missingmethodexception error have seems .net profile mismatch error, 1 explained here . can use mono runtime in c binary on android? yes, using ndk guess. there alternatives can use instead of rolling own, such xmadevlab .
Read more

c# - SharpSsh Command Execution -

-
Image
i trying create ssh client using c#. using tamir.sharpssh library. having issues sending command , getting appropriate response server. the way have been testing sending on ls command, followed cd.. command, followed ls command again -- see whether or not cd.. command being executed properly. however, there no difference between first ls command , second ls command. not entirely sure doing wrong. perhaps using wrong ssh type. have provided code , output getting. have added output expect. using tamir.sharpssh; namespace sshnetexample { class program { static void main(string[] args) { sshexec ssh = null; try { console.write("-connecting..."); ssh = new sshexec(host, username, password); ssh.connect(); console.writeline("ok ({0}/{1})", ssh.cipher, ssh.mac); console.writeline("server version={0}, client versio...
Read more

python - Specify path of savefig with pylab or matplotlib -

-
i struggling on how find correct way specify save path (or repository) when calling function savefig in matplotlib or pylab. i tried several syntaxes, everytime python console returns : filenotfounderror: [errno 2] no such file or directory: '../mydocs/resource/frames/myimage.png' currently, have written following : pylab.savefig('../mydocs/resource/frames/myimage.png') does know how it? thanks in advance! the tilde operator , variable $home entered strings , therefore not function while saving. have provide either relative path (as did) or provide full path. eg. pylab.savefig("/home/username/desktop/myfig.png") .
Read more