Java輕量級數據庫訪問層：SeQuaLite

jopen 11年前發布 | 23K 次閱讀 Java 持久層框架

SeQuaLite是一個輕量級，java數據存取框架（整個jar包不到80k）。支持CRUD操作。支持對象懶加載，通過創建代理對象或空對象來代替，等有需要時再加載。支持級聯保存與級聯刪除操作。SeQuaLite使用 prepared statement來執行查詢，因此它更快，更安全。使用SeQuaLite能夠避免SQL注入安全威脅。SeQuaLite能夠創建和執行復雜的查詢 /DML，并支持分頁。

特性：

Supports C(INSERT)R(SELECT)U(UPDATE)D(DELETE) operations.
Supports Lazy-Loading of Objects in an Object Tree. Object can be created as a PROXY or as a NULL object and loaded later when required.
Supports save cascade and delete cascade operations.
SeQuaLite uses prepared statements for queries. So it's faster and secure. Avoid SQL injections by using SeQuaLite.
On the fly query generations.
Complex queries / DMLs can be created and used.
Supports Paginations. It's easy to created paginated reports.
Use sql operators or equaivalent operators in java. This reduces development time significantly. Please see the sample code section for examples.
Uses JDK Logging. All executed SQLs are logged if logLevel is set.
And many more.