jOOQ

jOOQ generates Java code from your database and lets you build typesafe SQL queries through its fluent API.
jOOQ has a simple templating engine that can be used with plain SQL.
jOOQ's and MyBatis' have simple POJO mapping capabilities.
http://www.jooq.org/