JSP :: Show Group Header Above Each Displayed Table?

Displaying the records in a table. I am looking for a group header to be placed above each printed table for its related category and subcategory, as well as, the no. of the records for each table to be shown at the top of the table.

The table contains columns for category, subcategory, name. ex:

Category Subcategory Name

CON Retail AAA

CON Wholesale BBB

SPEC Retail CCC

What I am looking for is the below layout:

Category/Subcategory (No. of records) –similar to a group header

Name – Country ..etc ----Table header

table records

Here is my code below:

<%
//Retrieve the values from the DB
while (rs.next()) {
category_name1=rs.getString("category_name");
subcategory_name1=rs.getString("subcategory_name");

[code]....

The problem in the above code is that it is showing the group headers category & sub category multiple times and the count is incorrect.