jOOQ是个更不错的SQL解决方案。
你可以在Java中以一种类型安全的方式来书写SQL语句：
// Typesafely execute the SQL statement directly with jOOQ
Result<Record3<String, String, String>> result =
create.select(BOOK.TITLE, AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME)
.from(BOOK)
.join(AUTHOR)
.on(BOOK.AUTHOR_ID.equal(AUTHOR.ID))
.where(BOOK.PUBLISHED_IN.equal(1948))
.fetch();
原文：http://www.cnblogs.com/fangyuan303687320/p/5278767.html