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.

Ease Development.     Increase Productivity.     Reduce Cost.     

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.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


News

SingletDAO1.0.5 released.Download


Have Questions?

Please write to singletdao@gmail.com

Your feedback is important to improve the framework.


Review

Please write your review here
or write to singletdao@gmail.com


Find Bugs ?

Please post here