Java轻量级数据库访问层：SeQuaLite
jopen
12年前
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.
SeQuaLite 的结构框图：
