Пример #1
0
  public <E> List<E> list(RowMapper<E> rowMapper) throws SQLException {
    List<E> result = new LinkedList<>();

    try (ResultSet resultSet = execute(toString())) {
      int rowNum = 0;
      while (resultSet.next()) {
        E obj = rowMapper.convert(resultSet, rowNum++);
        result.add(obj);
      }
    }

    return result;
  }
Пример #2
0
  public <E> E single(RowMapper<E> rowMapper) throws SQLException {
    E result = null;

    try (ResultSet resultSet = execute(toString())) {
      if (resultSet.next()) {
        result = rowMapper.convert(resultSet, 1);

        if (resultSet.next()) {
          throw new SQLException("The query returned more than one result");
        }
      }
    }

    return result;
  }