SYSTEM AND METHOD FOR QUERYING A DATA SOURCE

摘要

The invention provides a system for querying a data source. The system comprises a query registry for storing at least one SQL query; a query processor for receiving a query command from a caller in an application, retrieving an SQL query associated with the query command from the query registry, and returning results of the query to the query command; and a data source adapter for accessing the data source to apply the SQL query associat ed with the query command and for returning the results of the query to the query processor. T he query command maps the results of the query to a data access object of some type and retur ns it to the caller. The system includes a module for gathering user input for each SQL query and generating the source code of the query command and the data access object needed to execute the query.