What I want to do is to have a text field that when the user starts typing, a search of the database will be made and the user would be given "suggestions".
Considering that I currently use servlets to fill the data on most of my jsp pages, I thought maybe I could use a servlet that could call on a DAO.
String sql = "SELECT name FROM User WHERE name LIKE '"+str+"%';
Or should the texbox already know which values to select from?
Is this the way I should be approaching this? Because so far all of the tutorials I have found so far haven't worked for me. I don't know PHP or JSON if that's needed to do this.
Any help on this would be greatly appreciated, I have been looking everywhere!