Saturday, 17 August 2013

Querying and Persisting Adobe AEM data into MySQL

You can create an Adobe CQ web application that performs database operations on a relational database. In this development article, the CQ web application queries and updates a MySQL database. That is, a user can create a new customer record that is stored in the Customer table. Likewise, a user can view all Customer records, as shown in the following illustration.

Customer records queried from MySQL displayed in a CQ web page

The Java JDBC API is used within an OSGi bundle that queries customer data based on three options:

1 - All customers (both active and past customers are displayed as shown in the previous illustration).
2 - Active customers (only active customers are displayed).
3 - Past customers (only past customers are displayed).

This development article walks you through creating an AEM application that queries data from MySQL and displays the data in client web page. To read this development article, click:

Querying and Persisting Adobe AEM data into MySQL


Join the Adobe Experience Cloud Community 

Join the Adobe Experience Cloud Community by clicking this banner




I (Scott Macdonald) am a Senior Digital Marketing Community Manager at Adobe Systems with 20 years in the high tech industry. I am also a programmer with knowledge in Java, JavaScript, C#,C++, HTML, XML and ActionScript. If  you would like to see more CQ or other Adobe Digital Marketing end to end articles like this, then leave a comment and let me know what content you would like to see.


Twitter: Follow the Digital Marketing Customer Care team on Twitter @AdobeExpCare.

YouTube: Subscribe to the AEM Community Channel. 


at