labs / tiddlywiki / tiddlers / content / labs / lab05 / _Labs_05_Project
@Mark George Mark George on 1 Aug 2020 644 bytes WIP - Lab 5

Implement the remaining DAO methods in your JDBC DAO:

  • searchById

  • filterByCategory

You should use the database to perform the searching and filtering via SQL rather than using collections to perform the filtering. Remember that a production system could have tens of thousands of products --- pulling all of that data across a network just to do the filtering in a collection is horribly inefficient.

Note --- You may be tempted to adapt your tests to use the new JDBC DAO at this point. This is a great idea, but we have to do a do bit of extra work to make this function correctly. This will be covered in the next two labs.