Print the data in ResultSet along with column names
ResultSet resultSet = statement.executeQuery("SELECT * from foo");ResultSetMetaData rsmd = resultSet.getMetaData();int columnsNumber = rsmd.getColumnCount();while (resultSet.next()) { for (int i = 1; i <= columnsNumber; i++) { if (i > 1) System.out.print(", "); String columnValue = resultSet.getString(i); System.out.print(columnValue + " " + rsmd.getColumnName(i)); } System.out.println("");}
Reference : Printing the result of ResultSet