Java轻量级数据库访问层:SeQuaLite
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 的结构框图:
本文由用户 jopen 自行上传分享,仅供网友学习交流。所有权归原作者,若您的权利被侵害,请联系管理员。
转载本站原创文章,请注明出处,并保留原始链接、图片水印。
本站是一个以用户分享为主的开源技术平台,欢迎各类分享!