Jooq is an efficient Java class library that incorporates complex SQL, type safety, source code generation, activity records, stored procedures, and Advanced http://www.aliyun.com/zixun/aggregation/18278.html "> data types."
The Jooq 2.0.0 version is a problem-solving version, and the issue of access to the user's needs has been resolved.
Sample 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/Release/jOOQ-2.0.0-binaries-only.zip/download
Http://sourceforge.net/projects/jooq/files/Release/jOOQ-2.0.0-full.zip/download