This week's book giveaway is in the Android forum.
We're giving away four copies of Head First Android and have Dawn & David Griffiths on-line!
See this thread for details.
The moose likes Struts and the fly likes sorting the result Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "sorting the result" Watch "sorting the result" New topic
Author

sorting the result

PradeepPillai Pradeep
Ranch Hand

Joined: Nov 15, 2005
Posts: 186
I have a result.jsp where I print a resultset in an html table. I want to sort each colum alphabetically. I am implementing this using struts. I want to sort it and print it in the same jsp. Any help appreciated.
Thanks in advance.
Timothy Sam
Ranch Hand

Joined: Sep 18, 2005
Posts: 751
Hi PradeepPillai Pradeep, is that your real name? Anyway, I always tend to sort my records during query like this...



it's much easier this way.


SCJP 1.5
http://devpinoy.org/blogs/lamia/ - http://everypesocounts.com/
Dom Lassy
Ranch Hand

Joined: May 05, 2006
Posts: 181
Or if it is in a collection already, use a comparator.

http://java.sun.com/j2se/1.4.2/docs/api/java/util/Comparator.html
Merrill Higginson
Ranch Hand

Joined: Feb 15, 2005
Posts: 4864
For this type of situation, I'd use a JavaScript sort. There are a number of free packages out there that will create a sortable table on your page that can be sorted in ascending or descending order on any column by clickking on the column heading.

I've been using Sortable Table and have been happy with the results.


Merrill
Consultant, Sima Solutions
PradeepPillai Pradeep
Ranch Hand

Joined: Nov 15, 2005
Posts: 186
What I have now is that I have an html table and a link at the top of each column. When I click the link at the top of each column, it would print the sorted list in another jsp. What I wanted was the sorted result in the same jsp. How can I do this using struts?
I am posting my code here.


----------------
<%
ResultSet rs = (ResultSet)request.getAttribute("results");
%>
<TABLE border="1">
<TBODY>
<tr>
<th> <A href="/sort1.do">Col1</A> </th><th> <A href="/sort2.do">Col2</A> </th> <th> <A href="/sort3.do">Col3</A> </th> <th> <A href="/sort4.do">Col4</A> </th> <th><A href="/sort5.do">Col5</A> </th>
</tr>
<%while(rs.next() ){%>
<TR>
<TD><%=rs.getString(1)%></TD>
<TD><%=rs.getString(2)%></TD>
<TD><%=rs.getString(3)%></TD>
<TD><%=rs.getString(4)%></TD>
<TD><%=rs.getString(5)%></TD>
</TR>
<%}%>
</TBODY>
</TABLE>
-----------------------

I don�t have much experience with struts. Please help me if this is not the way to do it.
[ June 02, 2006: Message edited by: PradeepPillai Pradeep ]
 
jQuery in Action, 3rd edition
 
subject: sorting the result
 
It's not a secret anymore!