Retrieving data from a MySQL database and displaying it in html using java

Question

I have a MySQL database and I am trying to search it and display the results in a table with the same columns as the db in HTML on a web page. I am using JAVA for the servlet and I have the web page send the search string using JavaScript to the servlet. I know how to:

1. Connect to the database
2. Query db and retrieve appropriate data in a resultset

I am having trouble going from the resultset and sending it back to and displaying it on the web page in a table.

Solution

This is is a pretty good tutorial (if a little old now). It covers getting data from the database, using an MVC type architecture, java beans and JSP with Expression language.

http://pdf.coreservlets.com/

Have a look at chapter 17.