This recipe shows how to read data from a database and send it to the client in a convenient format.<\/p>\n
The SFSDBManager.executeQuery<\/strong> method on the server-side provides an effective way to execute a SQL query and obtain an SFSArray-based data strcuture which can be sent to the client on the fly. In this simple example we are going to obtain a list of records from a people database and send them over to the client in a few lines of code.<\/p>\n The source files (the download link is provided at the end of this recipe) come with a MySQL dump that can be used to generate the database table used by the Extension. These are the steps to setup and test the example application.<\/p>\n You can now startup the provided client and test the Extension.<\/p>\n In the source code you will find a GetPeopleHandler<\/strong> class which responds to the “getPeople” request coming from the client. Let’s take a look at what it does:<\/p>\n The returned SFSArray contains all the records represented as SFSObject(s), which makes it very easy to extract the field values. This is how it is done on the client side (ActionScript 3) when the EXTENSION_RESPONSE<\/strong> event is handled:<\/p>\n All we need to do is loop through each element in the received SFSArray. Each item is an SFSObject that represents one row of the resultset which allows us to access its fields by name. In our case the field names are: name<\/em>, location<\/em>, occupation<\/em>.<\/p>\n
\nFor more details on this we recommend to consult the SFSDBManager javadoc<\/a>.<\/p>\n\n
\n
\u00bb The request handler<\/strong><\/h3>\n
\r\npublic class GetPeopleHandler extends BaseClientRequestHandler\r\n{\r\n @Override\r\n public void handleClientRequest(User sender, ISFSObject params)\r\n {\r\n IDBManager dbManager = getParentExtension().getParentZone().getDBManager();\r\n String sql = "SELECT * FROM people";\r\n \r\n try\r\n {\r\n \/\/ Obtain a resultset\r\n ISFSArray res = dbManager.executeQuery(sql, new Object[] {});\r\n \r\n \/\/ Populate the response parameters\r\n ISFSObject response = new SFSObject();\r\n response.putSFSArray("people", res);\r\n \r\n \/\/ Send back to requester\r\n send("getPeople", response, sender);\r\n }\r\n catch (SQLException e)\r\n {\r\n trace(ExtensionLogLevel.WARN, "SQL Failed: " + e.toString());\r\n }\r\n }\r\n}\r\n<\/pre>\n\r\nprivate function onExtensionResponse(evt:SFSEvent):void\r\n{\r\n var params:ISFSObject = evt.params.params as ISFSObject\r\n var peopleArray:ISFSArray = params.getSFSArray("people")\r\n \r\n var dump:String = "PEOPLE LIST RECEIVED:\\n\\n"\r\n \r\n for (var i:int = 0; i < peopleArray.size(); i++)\r\n {\r\n var item:ISFSObject = peopleArray.getSFSObject(i)\r\n dump += " > " + item.getUtfString("name") + ", " + item.getUtfString("location") + ", " + item.getUtfString("occupation") + "\\n"\r\n }\r\n \r\n dTrace(dump)\r\n dTrace("Total records: " + peopleArray.size())\r\n}\r\n<\/pre>\n