Example usage for org.springframework.jdbc.core RowMapper mapRow

Introduction

In this page you can find the example usage for org.springframework.jdbc.core RowMapper mapRow.

Prototype

@Nullable
T mapRow(ResultSet rs, int rowNum) throws SQLException;

Source Link

Document

Implementations must implement this method to map each row of data in the ResultSet.

Usage

From source file:com.ebay.pulsar.analytics.dao.RDBMS.java

public <T> T get(String query, Map<String, ?> parameters, final RowMapper<T> mapper) {
    return this.namedParameterJdbcTemplate.query(query, parameters, new ResultSetExtractor<T>() {
        @Override//from  www  . jav  a 2 s .co  m
        public T extractData(ResultSet rs) throws SQLException, DataAccessException {
            if (rs.next()) {
                return mapper.mapRow(rs, 0);
            }
            return null;
        }

    });
}

---

From source file:io.kahu.hawaii.util.pagination.PaginationHelper.java

public Page<E> fetchPage(final NamedParameterJdbcOperations jt, final String sqlCountRows,
        final String sqlFetchRows, final Map<String, Object> paramMap, final Pageable pageable,
        final RowMapper<E> rowMapper) {

    // first execute select count (needed for paging metadata)
    final int rowCount = jt.queryForObject(sqlCountRows, paramMap, Integer.class);

    if (maxRows != null && (rowCount > maxRows)) {
        // Threshold defined and total number of records is higher
        return new PageImpl<E>(new ArrayList<>(), new PageRequest(0, 1), rowCount);
    }/*from   www  .j a v a  2 s .c om*/
    // now fetch the actual objects (content)
    final List<E> pageItems = jt.query(sqlFetchRows, paramMap, (resultSet, rowNum) -> {
        return rowMapper.mapRow(resultSet, rowNum);
    });

    // return the page
    return new PageImpl<E>(pageItems, pageable, rowCount);
}

---

From source file:com.ebay.pulsar.analytics.dao.RDBMS.java

public <T> List<T> query(String sql, Map<String, ?> parameters, final int maxrows, final RowMapper<T> mapper) {
    return this.namedParameterJdbcTemplate.query(sql, parameters, new ResultSetExtractor<List<T>>() {
        @Override//from   w  w w  .  j  av a2s.c o  m
        public List<T> extractData(ResultSet rs) throws SQLException, DataAccessException {
            List<T> data = new ArrayList<T>();
            if (rs == null)
                return data;
            int rowNum = 0;
            while ((maxrows > 0 && rowNum < maxrows || maxrows < 0) && rs.next()) {
                data.add(mapper.mapRow(rs, rowNum++));
            }
            return data;
        }
    });
}

---

From source file:com.ebay.pulsar.analytics.dao.RDBMS.java

public <T> List<T> query(String sql, AbstractSqlParameterSource parameters, final int maxrows,
        final RowMapper<T> mapper) {
    return this.namedParameterJdbcTemplate.query(sql, parameters, new ResultSetExtractor<List<T>>() {
        @Override/*  w w  w .j  ava 2 s .  c  o  m*/
        public List<T> extractData(ResultSet rs) throws SQLException, DataAccessException {
            List<T> data = new ArrayList<T>();
            if (rs == null)
                return data;
            int rowNum = 0;
            while ((maxrows > 0 && rowNum < maxrows || maxrows < 0) && rs.next()) {
                data.add(mapper.mapRow(rs, rowNum++));
            }
            return data;
        }
    });
}

---

From source file:com.ebay.pulsar.analytics.dao.RDBMS.java

public <T> List<T> queryForList(String sql, Map<String, ?> parameters, final int maxrows) {
    final RowMapper<T> mapper = new SingleColumnRowMapper<T>();
    return this.namedParameterJdbcTemplate.query(sql, parameters, new ResultSetExtractor<List<T>>() {
        @Override//from w  ww  .  j av  a 2  s. co  m
        public List<T> extractData(ResultSet rs) throws SQLException, DataAccessException {
            List<T> data = new ArrayList<T>();
            if (rs == null)
                return data;
            int rowNum = 0;
            while ((maxrows > 0 && rowNum < maxrows || maxrows < 0) && rs.next()) {
                data.add(mapper.mapRow(rs, rowNum++));
            }
            return data;
        }
    });
}

---