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 a client web page. To read this development article, click:

Querying and Persisting Adobe AEM data into MySQL