Java面向對象查詢框架，jOOQ 2.5.0 發布

jOOQ代表Java面向對象查詢Java Object Oriented Querying。它包含了以下功能特性：

• 代碼生成: jOOQ generates a simple Java representation of your database schema. Every table, view, stored procedure, enum, UDT is a class.
• Active records: jOOQ implements an easy-to-use active record pattern. It is NOT an OR-mapper, but provides a 1:1 mapping between tables/views and classes. Between columns and members.
• Typesafe SQL: jOOQ allows for writing compile-time typesafe querying using its built-in fluent API.
• SQL standard: jOOQ supports all standard SQL language features including the more complex UNION's, nested SELECTs, joins, aliasing
• Vendor-specific feature support: jOOQ encourages the use of vendor-specific extensions such as stored procedures, UDT's and ARRAY's, recursive queries, and many more.

示例代碼：

// Create a new record and insert it into the database
TBookRecord book = create.newRecord(T_BOOK);
book.setTitle("My first book");
book.store();

// Update it with new values
book.setPublishedIn(2010);
book.store();

// Delete it
book.delete();

jOOQ 2.5.0 首次增加對 Firebird 數據庫的支持，支持樂觀鎖，以及新增對 Oracle 很多特性的支持，改進的 API 和新的手冊。