Added Features

• Minor Fix (carriage return in query)

Downloads

• singletdao1.0.4.jar(34 KB)
• singletdao1.0.4(2.3 MB) with samples

Added Features

• Added alias support for select

Downloads

• singletdao1.0.3.zip(10.6 MB) with samples
• singletdao1.0.3.jar(34 KB)

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/)

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

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

• singletdao1.0.zip

Sample Apps

• Spring-Struts (SingletDAO with Spring)
• sample-webapp.zip (SingletDAO with JQuery/DWR/Datatable)
• Struts-Spring-HyperSQL (SingletDAO with HyperSQl embedded database)