Jooq is a Java class library capable of efficiently merging complex SQL, type safety, source code generation, activity records, stored procedures, and advanced http://www.aliyun.com/zixun/aggregation/18278.html data types.
Jooq 2.0.4 This release introduces a number of improvements to source code generation. Improved integration of Oracle table and Varray types.
Demo Code:
Create.select (first_name, last_name, Create.count ())
. from (AUTHOR)
. Join (book). On (Author.ID.equal (book.author_id))
. where (Language.equal ("DE"))
. and (Published.greaterthan parsedate (' 2008-01-01 '))
. GroupBy (first_name, last_name)
. Having (Create.count (). GreaterThan (5))
. (Last_name.asc () Nullsfirst ())
. Limit (2)
. Offset (1)
. Forupdate ()
. of (first_name, last_name)
Software Information: http://www.jooq.org/
Download address: http://sourceforge.net/projects/jooq/files/920.html ">release/