FastLaneReader is the best design pattern.
Put you r query in DAO from where it directly fetches data from database.
This DAO is called from session bean.This is the basic logic in this pattern.
Brief Description abt that is
Sometimes applications access data in a tabular fashion, such as when browsing
a catalog or a list of names or when exporting data in batches for use
elsewhere. This kind of data access is usually read-only. In such situations,
using entity beans to represent persistent data incurs overhead and provides
little benefit. Entity beans are best for coarse-grained access to individual
business entities, and are not effective for read-only access to large
quantities of tabular data.
The Fast Lane Reader design pattern provides a more efficient way to access
tabular, read-only data. A fast lane reader component directly accesses
persistent data using JDBCTM components, instead of using entity beans. The
result is improved performance and less coding, because the component
represents data in a form that is closer to how the data are used
and u can try this link