You might want to look into something like DisplayTag or JQGrid. (*Chris*)
On Thu, Apr 12, 2012 at 7:24 AM, CRANFORD, CHRIS <chris.cranf...@setech.com>wrote: > I have several queries that I perform against my SQL database to get a > list of records and then iterate over them in a paginated way in JSPs. > Presently, I have a JSP for each query's output because there are > various different columns being shown depending upon the report; however > I am wondering if there is a better streamlined approach to this rather > than relying heavily on the JSP to control the columns displayed? > > Taking this one step forward, I've added Excel exports; however it's > reliant on the report export service to iterate the result set (just > like the JSP does) and add the column headings, values for each row and > perform any formatting needed. The service then hands the struts action > a ByteArrayOutputStream object that gets streamed back to the browser > through the action. > > In both cases, the JSP/service are driving what columns are shown, > controls formatting, etc. This means should a new column be added, > formatting changed, or a column removed from the JSP, one has to > remember to update the adjacent export service as well and from a design > perspective that seems redundant. I'd rather have a single place that > controls what columns are shown/hidden, manages formatting, etc. > > How has others tackled similar designs in the past? > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@struts.apache.org > For additional commands, e-mail: user-h...@struts.apache.org > >
