Last Updated: February 20, 2019
·
136.1K
· lukasz-madon

Printing the result of ResultSet

Sample code for printing java.sql.ResultSet

ResultSet rs = statement.executeQuery();
 ResultSetMetaData rsmd = rs.getMetaData();
 System.out.println("querying SELECT * FROM XXX");
 int columnsNumber = rsmd.getColumnCount();
 while (rs.next()) {
 for (int i = 1; i <= columnsNumber; i++) {
 if (i > 1) System.out.print(", ");
 String columnValue = rs.getString(i);
 System.out.print(columnValue + " " + rsmd.getColumnName(i));
 }
 System.out.println("");
 }

2 Responses
Add your response

Thank you! :D

over 1 year ago ·

THX! If I delete the empty string, it doesnt work anymore, any idea why?

over 1 year ago ·