jOOQ 3.2.2 發布，Java數據庫框架

jOOQ能夠根據您的數據庫生成Java代碼，并允許您通過它流暢的API構建類型安全的SQL查詢。它主要包含以下特性：
1、代碼生成:jOOQ能夠生成與數據庫結構相對應的Java對象，包括表格，視圖，存儲過程，用戶定義的類型等。
2、Active records:jOOQ實現一個易于使用的Active Record模式。它不是一個OR-mapper，但提供了表格/視圖與Java對象之間的一對一映射和字段與對象成員之間的映射。
3、Typesafe SQL:jOOQ允許使用內置的DSL來編寫編譯期類型安全的SQL查詢語句。
4、SQL標準:jOOQ支持所有標準SQL語法包括，復雜的UNION，嵌套SELECTs，Joins，別名。

Java數據庫框架比較

</div>

	jOOQ	Hibernate	MyBatis	SpringData	JDBC
SQL related
SQL centric		[1]		[2]
SQL dialect abstraction
SQL dialect emulation
Database related
Stored procedures		[3]	[3]	[3]	[3]
User-defined types				[4]	[4]
Java API related
Native SQL support
Typesafe query DSL		[5]
Metadata code generation
Active records
Query lifecycle SPI
Schema, table multitenancy
SQL transformation SPI
SQL templating	[6]
POJO mapping	[7]		[7]
Row mapping

備注說明：

1. Hibernate evolves around HQL and/or JPQL. While it does not hide SQL entirely, it does not really help writing SQL.
2. Spring Data is not focused on SQL, which means that you load lots of non-related dependencies and complexity from other types of data stores.
3. You can make stored procedures work with all frameworks. But it is a pain, compared to jOOQ.
4. You can make user-defined types work with JDBC. But it is a pain, compared to jOOQ.
5. Hibernate inherits JPA's Criteria API, which is a typesafe query DSL, although not for SQL.
6. jOOQ has a simple templating engine that can be used with plain SQL.
7. jOOQ's and MyBatis' have simple POJO mapping capabilities.

 本文由用戶 jopen 自行上傳分享，僅供網友學習交流。所有權歸原作者，若您的權利被侵害，請聯系管理員。

 轉載本站原創文章，請注明出處，并保留原始鏈接、圖片水印。

 本站是一個以用戶分享為主的開源技術平臺，歡迎各類分享！

  本文地址：http://www.baiduhome.net/news/view/19616b9

jOOQ