Name | Modified | Size | Downloads / 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.