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.

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

Adobe Digital Marketing Community

Join the Adobe Digital Marketing Community. Start by clicking this banner

About the Author

I (Scott Macdonald) am a Senior Digital Marketing Community Manager at Adobe Systems with over 16 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.

Linked In
TwitterFollow the Digital Marketing Customer Care team on Twitter @AdobeMktgCare.

No comments:

Post a Comment