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 private static void printResultSet(ResultSet rs) throws SQLException {

    // Prepare metadata object and get the number of columns.
    ResultSetMetaData rsmd = rs.getMetaData();
    int columnsNumber = rsmd.getColumnCount();

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

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