JSP Resultset not iterating multiple times

This site is best viewed in a modern browser with JavaScript enabled.

JSP Resultset not iterating multiple times

RunningDude87

Hi,

I'm trying to use JSP resultset.next() multiple times to print HTML tables. However, it doesn't seem to want to work. I can print one or the other fine, but not both. I'm trying something below:

Resultset rs = null;
String SQL = "select column1, column2 from table";
rs = stmtPROD.executeQuery(SQL);

out.println("<table>")
while(rs.next()) {
out.println("<tr><td> " + rs.getString("column1") + "</td></tr>");
out.println("</table><table>");

while(rs.next()) {
out.println("<tr><td> " + rs.getString("column2") + "</td></tr>");
out.println("</table>");

Any tips would be helpful. Thanks!

Khalid_Ali

what are you trying to do?
you should create both tables in one while loop. The way I see it your code should be like this

out.println("<table>")
while(rs.next()) {
out.println("<tr><td> " + rs.getString("column1") + "</td></tr>");
out.println("<tr><td> " + rs.getString("column2") + "</td></tr>");
}
out.println("</table>
[/code
If for some reasons you want each row in its own table element then it should be like this

[code]

while(rs.next()) {
out.println("<table>")
out.println("<tr><td> " + rs.getString("column1") + "</td></tr>");
out.println("</table>");
out.println("<table>")
out.println("<tr><td> " + rs.getString("column2") + "</td></tr>");
out.println("</table>");
}
[/code

But using result set in that manner is not correct. Read up on what happens when you do rs.next()