Maybe I'm posting (I've posted) this in the wrong forum. Apologies.
In a JSP with a Search field, would it be possible to retrieve results for case insensitive combinations of 'abc' from a JSP-level modification?
For example, if I enter "doyle" in the Search box to invoke a "select * from BOOKS where AUTHOR='doyle'" through a servlet, is it possible to retrieve results for Doyle, doyle, DOYLE etc, through some modification at the JSP level?
Tip #1 - get the JDBC code out of the JSP. It's poor practice to mix the database and presentation layers in addition to being harder to maintain.
Tip #2 - Use a prepared statement so SQL injection can't happen. (Google it for why this is a bad thing)
The JSP has only the Search field - no SQL. A button-click invokes a servlet which retrieves the results from DB. My search retrieves only case-sensitive results for 'doyle'. I am trying to see if at all there is any possibility of pushing the database to give me case-insensitive results by making only changes to the JSP such as generate all possible cases for an input String and then retrieve all records for doyle, Doyle, etc.
But, I guess that will corrupt the JSP into doing more than what JSP is supposed to do.
Thank you for your time.
author & internet detective