In my previous post, I provided an example of an Apollo application using the Flex Message Service. Since then, a number of people have asked for examples of Apollo applications accessing data using the Flex Data Management services. So here is a simple Contact Management application that demonstrates this integration.

Using the Data Services to work with data in Apollo offers several benefits. First, just like for traditional browser-based Flex apps, the Data Management Services automate the synchronization of data between the client and the middle-tier. In other words, you don’t have to flag/keep track of the changes made at the client-side, and then make corresponding RPC calls to send changes to the server: all that is managed automatically.

For this application, I actually used LiveCycle Data Services (the new name for Flex Data Services) 2.5 currently in beta 2, which offer additional benefits in the context of this application:

• Using the new SQL assembler, you don’t have to write server-side components if you don’t want/need to: you just provide a series of SQL statements indicating how data should be retrieved, and how changes should be persisted in the database. The SQL assembler makes it extremely fast and easy to create applications that don’t require sophisticated persistence logic.
• In 2.5, the DataService API provides methods (such as dataService.saveCache() / dataService.clearCache()) to save data locally and manipulate the local data store. You can also automatically synchronize the changes you made offline with the server. I ran into a bug in LCDS beta 2 that prevented me from implementing offline caching in this sample. The bug is fixed post beta 2 and I will share an updated version of the app when the bits become publicly available.

Installation instructions:

1. Install LiveCycle Data Services 2.5 beta here
2. Modify the flexdemosb database file to add the contact table: replace WEB-INF\db\flexdemodb\flexdemodb.script with this version.
3. Open WEB-INF\flex\data-management-config.xml and add the following destination.
   
   <destination id="sql-contact">
     <adapter ref="java-dao" />
     <properties>
       <use-transactions>true</use-transactions>
       <source>flex.data.assemblers.SQLAssembler</source>
       <scope>application</scope>
       <metadata>
         <identity property="CONTACT_ID"/>
       </metadata>
       <network>
         <session-timeout>20</session-timeout>
         <paging enabled="false" pageSize="10" />
         <throttle-inbound policy="ERROR" max-frequency="500"/>
         <throttle-outbound policy="REPLACE" max-frequency="500"/>
       </network>
       <server>
         <database>
             <driver-class>org.hsqldb.jdbcDriver</driver-class>          
             <url>jdbc:hsqldb:file:C:/lcds/jrun4/servers/default/samples/WEB-INF/db/flexdemodb/flexdemodb</url>
             <username>sa</username>
             <password></password>
           <login-timeout>15</login-timeout>
         </database>
         <actionscript-class>Contact</actionscript-class>
          <fill>
              <name>all</name>
              <sql>SELECT * FROM CONTACT</sql>
          </fill>
         <get-item>
           <sql>SELECT * FROM CONTACT WHERE CONTACT_ID = #CONTACT_ID#</sql>
         </get-item>
          <create-item>
           <sql>INSERT INTO CONTACT (FIRST_NAME,LAST_NAME,EMAIL,PHONE,ADDRESS,CITY,STATE,ZIP,COUNTRY,NOTES) VALUES (#FIRST_NAME#, #LAST_NAME#, #EMAIL#, #PHONE#, #ADDRESS#, #CITY#, #STATE#, #ZIP#, #COUNTRY#, #NOTES#)</sql>
           <id-query>CALL IDENTITY()</id-query>
         </create-item>
          <update-item>
           <sql>UPDATE CONTACT SET FIRST_NAME=#FIRST_NAME#,  LAST_NAME=#LAST_NAME#,  EMAIL=#EMAIL#, PHONE=#PHONE#, ADDRESS=#ADDRESS#, CITY=#CITY#, STATE=#STATE#, ZIP=#ZIP#, COUNTRY=#COUNTRY#, NOTES=#NOTES# WHERE CONTACT_ID=#_PREV.CONTACT_ID#</sql>
         </update-item>
          <delete-item>
           <sql>DELETE FROM CONTACT WHERE CONTACT_ID=#CONTACT_ID#</sql>
         </delete-item>
         <count>
           <name>all</name>
           <sql>SELECT count(*) FROM CONTACT</sql>
         </count>
       </server>
     </properties>
   </destination>    
   

作者：gdgzboy@牛C网
地址：http://www.niuc.net/post/261/
版权所有。转载时必须以链接形式注明作者和原始出处及本声明！