Take a look at the following code...
This is a simple bit of code that you pass in a result set and a title to use for the table. It uses the database metadata to discover the column names and uses them for header lables.
public String dumpAnyResultSetToTable(java.sql.ResultSet rs, String title) throws java.sql.SQLException {
StringBuffer sb = new StringBuffer();
sb.append("<TABLE border=1>");
java.sql.ResultSetMetaData rsmd = rs.getMetaData();
final int cols = rsmd.getColumnCount();
sb.append("<tr><td colspan=");
sb.append(cols + ">");
sb.append(title);
sb.append("</td></tr>");
// Load labels and column names...
// Element 0 will not be used to simplify code.
String[] labels = new String[cols + 1];
String[] names = new String[cols + 1];
for (int i = 1; i <= cols; i++) {
labels[i] = rsmd.getColumnLabel(i);
names[i] = rsmd.getColumnName(i);
}
// Build table header
sb.append("<tr>");
for (int i = 1; i <= cols; i++) {
sb.append("<th>");
sb.append(labels[i]);
sb.append("</th>");
}
sb.append("</tr>");
// Build the table data
while (rs.next()) {
sb.append("<tr>");
for (int i = 1; i <= cols; i++) {
sb.append("<td>");
sb.append(rs.getString(names[i]));
sb.append("</td>");
}
sb.append("</tr>");
}
sb.append("</table>");
return sb.toString();
}
Hope it helps and gives you some ideas of your own.
Happy coding,
