Hello!
In my application I have a lot of SQL queries to the database. I want
to implement them in a way, which in future should allow an easy
migration to another database (I'm using bean-managed-persistence).
One of the problems of database migration are slight differences in
the syntax of SQL queries at different DBMS.
Now I have a special class for each query, so instead of writing
Statement statement = conn.createStatement();
statement.executeUpdate("DELETE FROM tbl_project WHERE ID=" + 1);
I write
Statement statement = conn.createStatement();
ProjectDeletionQuery query = new ProjectDeletionQuery(1);
statement.executeUpdate(query.toString());
where ProjectDeletionQuery is defined as
public class ProjectDeletionQuery
{
public ProjectDeletionQuery(int pk)
{
this.primaryKey = pk;
}
public String toString()
{
return "DELETE FROM tbl_project WHERE ID=" + this.primaryKey;
}
private int primaryKey;
}
I would like to know whether there are more elegant ways to separate
SQL query syntax from the code (perhaps a special Java library or a
tool).
Thanks in advance
Dimitri Pissarenko
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
