I am building a struts app that has the requirement of showing data in a table that contains some sortable columns.
The data is retrieve from database. By clicking on a column, the page will show data sorted by that column.
What are the best practices for handling sorting of data.
I think you should use a tag lib that was mentioned on this site a few weeks ago called display tag and it's available at http://www.displaytag.org.
Works well with struts and easily handles data sorting and pagination of result sets.