Java的ORM框架jOOQ 1.5.8 发布

There is now full support for the non-SQL standard LIMIT clause, even in dialects where the LIMIT clause is not supported natively (especially Oracle, but also DB2, SQL Server, and Sybase, which have limitations). jOOQ simulates LIMITs by rendering nested selects filtering on ROWNUM (Oracle) or on ROW_NUMBER() (DB2, SQL Server, and Sybase).

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

项目主页：http://sourceforge.net/apps/trac/jooq