Example usage for org.springframework.jdbc.core RowCountCallbackHandler processRow

Introduction

In this page you can find the example usage for org.springframework.jdbc.core RowCountCallbackHandler processRow.

Prototype

@Override
public final void processRow(ResultSet rs) throws SQLException 

Source Link

Document

Implementation of ResultSetCallbackHandler.

Usage

From source file:io.github.benas.jql.shell.StringResultSetExtractor.java

@Override
public String extractData(ResultSet resultSet) throws SQLException, DataAccessException {
    RowCountCallbackHandler rowCountCallbackHandler = new RowCountCallbackHandler();
    rowCountCallbackHandler.processRow(resultSet);
    int columnCount = resultSet.getMetaData().getColumnCount();
    List<String> columnNames = asList(rowCountCallbackHandler.getColumnNames());
    String header = getHeader(columnNames);

    StringBuilder result = new StringBuilder(header);
    result.append("\n");

    while (resultSet.next()) {
        StringBuilder stringBuilder = new StringBuilder();
        int i = 1;
        while (i <= columnCount) {
            stringBuilder.append(resultSet.getObject(i));
            if (i < columnCount) {
                stringBuilder.append(" | ");
            }/*from w w w. j  av  a  2 s  . c om*/
            i++;
        }
        result.append(stringBuilder.toString()).append("\n");
    }

    return result.toString();
}

---