/** * Return a concatened and human readable format of provided result set * @param rs result set to read * @param maxFieldLength Maximum field length to print * @param maxPrintedRows Maximum printed rows * @param addColumns Add column header * @param alignColumns Align columns by using padding * @return human readable format of provided result set * @throws SQLException */ public static String resultSetToString(ResultSet rs,int maxFieldLength, int maxPrintedRows, boolean addColumns, boolean alignColumns) throws SQLException { return resultSetToString(rs, maxFieldLength, maxPrintedRows, addColumns, alignColumns, new AcceptAllFilter()); }
/** * Return a concatened and human readable format of provided result set * @param rs result set to read * @param maxFieldLength Maximum field length to print * @param maxPrintedRows Maximum printed rows * @param addColumns Add column header * @param alignColumns Align columns by using padding * @return human readable format of provided result set * @throws SQLException */ public static String resultSetToString(ResultSet rs,int maxFieldLength, int maxPrintedRows, boolean addColumns, boolean alignColumns) throws SQLException { return resultSetToString(rs, maxFieldLength, maxPrintedRows, addColumns, alignColumns, new AcceptAllFilter()); }
if(isExecuteQuery(lowerCaseQuery)) { try(ResultSet rs = st.executeQuery(query)) { LOGGER.info("\n" + ReadTable.resultSetToString(rs, MAX_FIELD_LENGTH, MAX_PRINTED_ROWS, true, true)); } catch (SQLException ex) {
pst.setObject(1, envGeom); try(ResultSet rs = pst.executeQuery()) { String lines = ReadTable.resultSetToString(rs, MAX_FIELD_LENGTH, MAX_PRINTED_ROWS, false, false, new EnvelopeFilter(envelope)); UILOGGER.info(lines);