JSP and Database tables

Suppose I have the following requirements (basically, editing DB data from JSP):
1. To display the content of a database table in a JSP page
2. A table may contain lots of record, so pagination should be possible
3. Allow the user to modify the content of the table (update, delete)

What would you recommend to do this ?

I'm considering using the DisplayTag to show the content.
In the library's help, they show two solutions to retrieve data:
1. Using JSTL's sql tags
2. Using dynabeans

Thank you

I would vote against JSTL SQL tags.
They (in my opinion) go against the principals of MVC and never should have been written.

The spec itself recommends that they only be used in trivial apps.

I don't know much about dynaBeans so I can't comment there.

Originally posted by Ben Souther:
I would vote against JSTL SQL tags.

Second the motion.

Thank you very much for sharing.

I think Databeans are Much Gud then the JSTL As per my Real time Experience