Home
Name Modified Size InfoDownloads / Week
README DAObasic v1.txt 2011-03-19 1.3 kB
nbDAObasicARSv1.0.rar 2011-03-19 3.1 MB
README for nbCrudJQwithDTARS.txt 2011-03-19 101 Bytes
nbCrudJQwithDTARS.rar 2011-03-19 4.2 MB
CrudJQwithDTARS3.JPG 2011-03-05 36.5 kB
CrudJQwithDTARS2.JPG 2011-03-05 18.8 kB
CrudJQwithDTARS1.JPG 2011-03-05 35.6 kB
README.txt 2011-03-05 1.2 kB
nbCrudJQwithDTARS.war 2011-03-05 2.4 MB
Totals: 9 Items   9.8 MB 1
This DAO is a new version of the original one that 
you can find at:
http://tekne-techne.blogspot.com/2011/01/simple-dao-tutorial-1.html 

I have used this original DAO's MySQL implementation files
in the Simple CRUD with JQuery and many other examples at my blog.

The problem in the original DAO was it reorganised the DB as soon as
a record was deleted.  This was caused by a wrong design
decision that each record should have a sequential id with no
ids missing in between them.

I removed this requirement in this new version of DAO with:

public Person readNextRec() throws PersonDAOSysException {
...
stmt = conn.prepareStatement("select id, firstName, lastName, "
         + " hobby from personTab where id > ? ORDER BY ID ASC LIMIT 1");
...
This is true for only HSQL and MySQL DBs.  The vector 'DB' is left as
it was.

To read an in depth analysis of this package please refer to
http://tekne-techne.blogspot.com/2011/01/simple-dao-tutorial-1.html

To correct speed problems at the delete function of Simple CRUD with JQuery
you may use PersonDAOMySQLDBImpl.java of nbDAObasicARSv1.0.

I will provide a new version as such for Simple CRUD with JQuery
in the near future.  Also a new master - detail on the same JSP
will follow.

Once again this for only training purposes, it is not meant for
any other.
Source: README DAObasic v1.txt, updated 2011-03-19