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.