I have a generic query to retrieve the result from the Database Once the result is returned back, I want to show the information in various formats eseentially group by different columns. Is there any way i can do that in a Result set ?
You really need to write your own. There are data management tools, but its kind of a vague area since almost all database-driven applications would fall under the category of data management tools.
You can easily store the contents of the result set in an array of HashMaps since essentially a single record is equivalent to a Map. Then, you just need to sort the data over the array of maps, and/or build simplified indexes over the array as needed.