Print an ResultSet to the console (STDOUT)

print-resultset.java

// Imports required
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

/**
 * Print a result set to system out.
 *
 * @param  rs           The ResultSet to print
 * @throws SQLException If there is a problem reading the ResultSet
 */
final public static void printResultSet(ResultSet rs) throws SQLException
{
    ResultSetMetaData rsmd = rs.getMetaData();
    int columnsNumber = rsmd.getColumnCount();
    while (rs.next()) {
        for (int i = 1; i <= columnsNumber; i++) {
            if (i > 1) System.out.print(" | ");
            System.out.print(rs.getString(i));
        }
        System.out.println("");
    }
}

Hi, I added printing column names (header):
// Print column names (a header).
for (int i = 1; i <= columnsNumber; i++) {
if (i > 1) System.out.print(" | ");
System.out.print(rsmd.getColumnName(i));
}

Check my forked version here: https://gist.github.com/mikbuch/299568988fa7997cb28c7c84309232b1