SingletDao
Keep it elegant.
Home
Downloads
JavaDoc
Wiki
Help
Open Discussion
Support
SingletDAO is a simple java data access frame work to access data in database. A Single Data Access Object to access data in database and eliminates writing custom DAOs. Easy to plug-in. Easy to manage SQL queries. Supports JSON.
Features
- A Single Data Access Object to access data in database and eliminates writing custom DAOs
- Add data layer instantly to your web app. Helps to plug in data access layer easily and quickly
- Native SQL
- Supports insert,insertUpdate,update,read,delete(C.R.U.D). DDL method - executeDDL
- read methods return either JSON or 2D String Array which fits well with Web2.0 (JQuery/Datatable etc.,) web applications
- Manage sql queries in xml configuration. XML configuration files can be placed in url or local path
- Low memory footprint
- Can be easily used with Spring JDBC frame work(Sample App)
SingletDAO1.0.5 (latest release)
Added Features
- Added validation for input fields with query fields. I fields in query doesn't exist in input fields.
- Added functionality to ignore additional input fields that doesn't exist in query.
Downloads
SingletDAO1.0.4 (previous release)
Added Features
- Minor Fix (carriage return in query)
Downloads
SingletDAO1.0.3
Added Features
- Added alias support for select
Downloads
SingletDAO1.0.2
Added Features
- New method executeDDL(conn, sqlid) to execute DDL queries.
- New insert method to return generated keys.
Downloads
- singletdao1.0.2.zip(10.6 MB) with samples
- singletdao1.0.2.jar(34 KB)
- SingletDAO102StrutsSpringSample.war(7.8 MB) (with embedded database)
(copy SingletDAO102StrutsSpringSample.war in/webapps/ . Run tomcat. Access application with http://localhost:8080/SingletDAO102StrutsSpringSample/)
SingletDAO1.0.1 (previous release)
Added Features
- Added support to have sql config file accessed through url or the file system.
- New read method which accepts start and end limit will help in pagination - supports only MySQL.
- Support for accepting sql query directly in place of sqlid. so you can rule you own query configuration if needed.
- insert,insertUpdate,update,delete method returns int
- insertBatch method returns int array.
Download
SingletDAO1.0 (previous release)
Features
- A Single Data Access Object to access data in database and eliminates writing custom DAOs
- Instant Data Layer. Helps to plug in data access layer easily and quickly
- Standard SQL.
- Supports insert,insertUpdate,insertBatch,read,update,delete (C.R.U.D)
- read methods return either JSON or 2D String Array which fits well with Web2.0 (JQuery/Datatable etc.,) web applications
Download
Sample Apps
- Spring-Struts (SingletDAO with Spring)
- sample-webapp.zip (SingletDAO with JQuery/DWR/Datatable)
- Struts-Spring-HyperSQL (SingletDAO with HyperSQl embedded database)