jOOQ

http://www.jooq.org/

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();

jOOQ

jOOQ

相关文章