609ppa
Last Updated: November 21, 2017
·
52.5K
· lukasz-madon
B2bc42f69510d6a1d2c9cde1c2214d24

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("");
   }
Say Thanks
Respond

2 Responses
Add your response

12651
Breaddays

Thank you! :D

over 1 year ago ·
17312
None

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

over 1 year ago ·