Java library to write sql statements?

Does exists a java library that can create sql statements? I'm not in search of something fancy, just something at "string manipulation" level: I just use jdbc (with Preparestatements and Resultsets) but I don't really like to pass huge strings containing SQL code...

What I need is a "simple" Select class (or something similar); in my mind all I really want is to be able to do

SQLStatement stat = Select("*").from("table").where("condition and condition").orderby("something");
ResultSet rs = Connection.getResultSet(stat.toString());
/* equals to "select * from table where condition and condition order by something" */

Maybe I'm blind, but I cannot find something like that...

Obviously, I want some methods/class able to write inserts and updates and the other stuff...

I excluded ORMs for two reasons:

1. the db schema it's "old" and I cannot change it, and I'm not sure how can I adapt the ORM to follow our db
2. AFAIK the ORMs needs to change the model (m开发者_JAVA技巧aybe adding a base class, maybe you need to implements an interface) and the model in my project is big, old and grumpy
3. Onestly, I don't really like ORMs: Objects and Set theory just aren't made to be mapped (IMHO)

ORM (Object Relational Mapping) library is the clue.

Hibernate is the most mature one.

And the Hibernate-s Criteria API is object - oriented way to create such queries as You wished. Criteria API doc.

Hibernate is most likely what you're looking for. It contains many advanced features, but SQL statements are more straightforward.

Take a look at their site: http://www.hibernate.org/

I'd also recommend skimming through this guide:

https://www.owasp.org/index.php/Preventing_SQL_Injection_in_Java

Try SQLBuilder project. Honestly, I have not used this. Looking at their docs, i think it might suit your requirement.

You can also try to find similar APIs in Sourceforge,Google code etc..

I am not sure if you use Java for a native application or for the web. If you use Java for web you could consider using the Play framework.

Easy and has Hibernate included with a really simple implementation (easier when implementing Hibernate yourself).