struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Graham <>
Subject Re: generic SQL implementation
Date Mon, 07 Jul 2003 15:35:32 GMT
There is a Mapper project in the commons sandbox that might help you.  It
allows you to store SQL in a properties file to remove it from your code. 
Also, it acts as a layer between your app and your persistence technology
so you can swap in an O/R mapping tool, EJBs, etc if you decide against
using JDBC in the future.  It also, makes using JDBC a breeze and removes
much error prone and repetitive code from your app.


--- Vinay <> wrote:
> Has anybody implemented a generic implementation for querying databases
> during runtime. I am  using  DAO's for data access layer. But I want to
> furthur move the database logic to down one more layer of abstraction.I
> am dealing with different kinds of database (eg. let's say a MySQL, MS
> Access and another not SQL at all ,index sequential files). I want the
> DAO to access the database during runtime. So I want my DAO to be
> independent of the SQL statements.The Database Interfrace would talk to
> either MySQL,or Oracle or any other database.So that  there is no  need
> to have  DAO for each database syntax, rather , this should be handled
> by a API thru an interface.
> Here's and examples
> Let's say for select statement , we supply table name, column names,
> where cluase , and's etc
> The following method should handle the query
> List getSelect(String tablename, List columnnames, List Orderby,.....)
> etc {
> return queryresult
> }  
> Any ideas appreciated
> Thank you 
> Vinay

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message