Resultset to HTML Table

[IDForums]

I have a resultset like this:

year type total
2009 A 123
2009 B 223
2010 A 123

How should I display above resultset in the form of a HTML table attached.

Thanks.

[Eranga]

Do you want to do this using Java?

[IDForums]

Yes Eranga

[Eranga]

Could be done in many ways. But you should explain what you exactly want to do this, how, where you going to display it and so on...

You can create a string with concatenating all the required html tags to in to string. But you have to display the text in HTML support control, like a label and so on.

[r035198x]

I have a resultset like this:

year type total
2009 A 123
2009 B 223
2010 A 123

How should I display above resultset in the form of a HTML table attached.

Thanks.

Where do you have that resultset?
What format is it in?

The normal way of creating tables is to create the header first (c:foreach creating <th> tags) then creating the rows in the table body (c:foreach creating <tr> tags).

[Gunas]

It needs some processing on the result set data before it get displayed.
Please make it clear, from where you are trying to generate it, like
1. As a servlet outptut
2. In a JSP page
Then it will easy for us to give solution.
Note: If you found the soulution,please share here for others.

[IDForums]

I am generating it on a JSP page. As I loop though the arraylist that I build from DB Resultset, the problem is HTML table has to be constructed row by row. In the sense, each block below needs to be filled before I jump to the next col.
< tr>
< td>
2009
</td>
2010
< td>
</td>
</tr>

But my ArrayList is a list of Objects containing member variables as Year, Type, Total. When I loop though this list, I get all data pertaining to 2009 first and then only 2010.

Let me know if this post needs to be detailed more. Looking for some help

[r035198x]

Did you read the post which had

"The normal way of creating tables is to create the header first (c:foreach creating <th> tags) then creating the rows in the table body (c:foreach creating <tr> tags)."
?
If you did, what did you do about it?