At 02:16 PM 2000/12/19 -0500, you wrote:
>A simple solution would be to ditch the resultset and convert it to XML.
>Then you can use XML/XSL and DOM to sort it easy with an "order-by". This
>is a effective solution if you are already using XML and loading stuff into
>the parser DOM.
>
>-Michael
>
>-----Original Message-----
>From: Jyoti Bongarala [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, December 19, 2000 9:16 AM
>To: [EMAIL PROTECTED]
>Subject: [JSP-INTEREST] (Very very urgent)Sorting a resultset after
>closing the connection
>
>
>HI all,
>
>My problem is I am looking for an algorithm or a
>program that would do the following :
>
>1. Once I retrieve a resultset from the database, I
>store it in a CachedRowSet. And when I display it ,
>the user should be able to sort the data by any column
>(total columns retrieved are 13) and this sorting has
>to be done (outside the database)
>
>Please somebody help me with this or give me a
>lead....
>
>thanks,
>Jyoti
The Java Collections Framework has what you need. Read the ResultSet out
into a data structure and make comparators for each column so that the
collections framework can sort your data on each column, as required. When
you receive a request for sorting on a given column, simply use the
relevant comparator for sorting. The collections framework will also sort
in reverse order, no database interaction required.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
