sql query in J2EE 2003-09-30 - By Stan Ou
Back I have a JSP that provides 10 or 12 search options such as a text field for company name, a dropdown for business industries, etc. After submit, different sql query strings will be composed by a business object according to user selections.
a simplified example: select companyName, etc from etc where companyName = etc or select companyName, etc from etc where industry = etc
All queries return the same db columns (i.e., companyName, address, etc ). what is the best way to implement this and what patterns can I use ? thanks
stan
__ ____ ____ ____ ____ ____ ______ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com
=========================================================================== To unsubscribe, send email to listserv@(protected) and include in the body of the message "signoff J2EE-INTEREST". For general help, send email to listserv@(protected) and include in the body of the message "help".
|
|