--- "Craig R. McClanahan" <[EMAIL PROTECTED]> wrote: > > > On Tue, 15 Jul 2003, Kris Schneider wrote: > > > Date: Tue, 15 Jul 2003 12:42:36 -0400 > > From: Kris Schneider <[EMAIL PROTECTED]> > > Reply-To: Struts Users Mailing List <[EMAIL PROTECTED]> > > To: Struts Users Mailing List <[EMAIL PROTECTED]> > > Subject: Re: Iterating the resultset contents in the view (jsp) > > > > Sure, understood. In fact I do this myself. But the reality is it's > still an > > identifier that's defined in the data layer, in this case embedded in > SQL. > > Isn't that going to be true even if you bury SQL inside a DAO? Someone > somewhere is going to have to deal with the column names that are > defined > in your database. > > > My point was that I'd be more concerned with identifiers defined in > the > > data layer getting referenced in the view layer then I would with > using > > Result and ResultSupport outside of a web app. > > A lot of people externalize SQL command strings into properties files so > that they can tweak them for differences between databases. This would > also give you a level of separation, in that you can reference the > actual > column names ONLY in the properties file strigns, and have your code > using > the result set deal only with the aliases set with "as".
I've found this approach to be quite useful. It gets tough when you need to dynamically create a query based on a user's search form values. In that situation I define each SQL search chunk under it's own key and use MessageFormat to insert values appropriately. David > > Craig > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
