Pagination with Sorting

[Rasika Chitnis]

I have seen many threads here and also on TheSeverSide.com that discuss strategies for paging the result set for large search operations. But it did not mention how to handle sorting with paging. Any body has any good ideas about implementing paging with sorting?
thanks

[Lavern Matthew]

Take a look at http://valuelist.sourceforge.net.

[Bear Bibeault]

Lavern, it isn't really necessary to add this to every topic. Please avoid such spamming in the future.

[Dana Hanna]

Actually, his link proves quite useful to this question.

[Bear Bibeault]

No doubt, but it is not necessary to post it on every previous paging question asked. Once will do just fine, and it can be posted as an answer to future questions of the same kind. Goodness knows it gets asked enough.
[ June 05, 2004: Message edited by: Bear Bibeault ]

[steve souza]

As part of the FormattedDataSet codeline I have an array Sorter if that is what you wish to sort. I use it to perform the clickable sorting that you see on the live demo homepage at http://www.fdsapi.com.

In general it works like similarly to an order by clause on a select statement, but for arrays instead (i.e. order by col1 desc, col2 asc). You can also provide your own Compare logic. The javadocs are also available at the link.

  
   // order by lastname desc, firstname asc
   Object[][] array={{"jeff", "beck"}, {"william", "reid"}, {"jim", "reid"},{"ray", "davies"},{"dave", "davies"},};
   ArrayComparator ac=new ArrayComparator();
   ac.addSortCol(1,"desc"); // sort by column 0 in ascending order first
   ac.addSortCol(0,"asc"); // then by column 1 in descending order
   ac.sort(array);  // note the ArrayComparator can be used to sort as many arrays as needed after it has been created.