Package org.springframework.jdbc.core.simple

Interface JdbcClient.ResultQuerySpec

Enclosing interface:
JdbcClient
public static interface JdbcClient.ResultQuerySpec
A specification for simple result queries.

  • Method Summary

    Modifier and Type
    Method
    Description
    List<Map<String,Object>>
    listOfRows()
    Retrieve the result as a list of rows, retaining the order from the original database result.
    SqlRowSet
    rowSet()
    Retrieve the result as a row set.
    <T> List<T>
    singleColumn()
    Retrieve a single column result, retaining the order from the original database result.
    Map<String,Object>
    singleRow()
    Retrieve a single row result.
    default <T> T
    singleValue()
    Retrieve a single value result.

  • Method Details

    • rowSet

      SqlRowSet rowSet()
      Retrieve the result as a row set.
      Returns:
      a detached row set representation of the original database result

    • listOfRows

      List<Map<String,Object>> listOfRows()
      Retrieve the result as a list of rows, retaining the order from the original database result.
      Returns:
      a (potentially empty) list of rows, with each result row represented as a map of case-insensitive column names to column values

    • singleRow

      Map<String,Object> singleRow()
      Retrieve a single row result.
      Returns:
      the result row represented as a map of case-insensitive column names to column values

    • singleColumn

      <T> List<T> singleColumn()
      Retrieve a single column result, retaining the order from the original database result.
      Returns:
      a (potentially empty) list of rows, with each row represented as a column value of the given type

    • singleValue

      default <T> T singleValue()
      Retrieve a single value result.
      Returns:
      the single row represented as its single column value of the given type
      See Also: