Statement (Reactive Relational Database Connectivity

```
public interface Statement
```
A statement that can be executed multiple times in a prepared and optimized way.

See Also:

Result, Row, Blob, Clob

Method Summary

All Methods Instance Methods Abstract Methods Default Methods
Modifier and Type	Method and Description
`Statement`	`add()` Save the current binding and create a new one.
`default Statement`	`bind(int index, boolean value)` Bind a value to an indexed parameter.
`default Statement`	`bind(int index, byte value)` Bind a value to an indexed parameter.
`default Statement`	`bind(int index, char value)` Bind a value to an indexed parameter.
`default Statement`	`bind(int index, double value)` Bind a value to an indexed parameter.
`default Statement`	`bind(int index, float value)` Bind a value to an indexed parameter.
`default Statement`	`bind(int index, int value)` Bind a value to an indexed parameter.
`default Statement`	`bind(int index, long value)` Bind a value to an indexed parameter.
`Statement`	`bind(int index, Object value)` Bind a value to an indexed parameter.
`default Statement`	`bind(int index, short value)` Bind a value to an indexed parameter.
`Statement`	`bind(String name, Object value)` Bind a value to a named parameter.
`Statement`	`bindNull(int index, Class<?> type)` Bind a `null` value to an indexed parametered parameter.
`Statement`	`bindNull(String name, Class<?> type)` Bind a `null` value to a named parameter.
`Publisher<? extends Result>`	`execute()` Executes one or more SQL statements and returns the `Result`s.
`default Statement`	`fetchSize(int rows)` Configures `Statement` to retrieve a fixed number of rows when fetching results from a query instead deriving fetch size from back pressure.
`default Statement`	`returnGeneratedValues(String... columns)` Configures `Statement` to return the generated values from any rows created by this `Statement` in the `Result` returned from `execute()`.

- Method Detail
  - add
```
Statement add()
```
    Save the current binding and create a new one.
    
    Returns:
    
    this Statement
    
    Throws:
    
    IllegalStateException - if the statement is parametrized and not all parameter values are provided
  - bind
```
Statement bind(int index,
               Object value)
```
    Bind a value to an indexed parameter. Indexes are zero-based.
    
    Parameters:
    
    index - the index to bind to
    
    value - the value to bind
    
    Returns:
    
    this Statement
    
    Throws:
    
    IllegalArgumentException - if value is null
    
    IndexOutOfBoundsException - if the parameter index is out of range
  - bind
```
Statement bind(String name,
               Object value)
```
    Bind a value to a named parameter.
    
    Parameters:
    
    name - the name of identifier to bind to
    
    value - the value to bind
    
    Returns:
    
    this Statement
    
    Throws:
    
    IllegalArgumentException - if name or value is null
  - bind
```
default Statement bind(int index,
                       boolean value)
```
    Bind a value to an indexed parameter. Indexes are zero-based.
    
    Parameters:
    
    index - the index to bind to
    
    value - the value to bind
    
    Returns:
    
    this Statement
    
    Throws:
    
    IndexOutOfBoundsException - if the parameter index is out of range
  - bind
```
default Statement bind(int index,
                       byte value)
```
    Bind a value to an indexed parameter. Indexes are zero-based.
    
    Parameters:
    
    index - the index to bind to
    
    value - the value to bind
    
    Returns:
    
    this Statement
    
    Throws:
    
    IndexOutOfBoundsException - if the parameter index is out of range
  - bind
```
default Statement bind(int index,
                       char value)
```
    Bind a value to an indexed parameter. Indexes are zero-based.
    
    Parameters:
    
    index - the index to bind to
    
    value - the value to bind
    
    Returns:
    
    this Statement
    
    Throws:
    
    IndexOutOfBoundsException - if the parameter index is out of range
  - bind
```
default Statement bind(int index,
                       double value)
```
    Bind a value to an indexed parameter. Indexes are zero-based.
    
    Parameters:
    
    index - the index to bind to
    
    value - the value to bind
    
    Returns:
    
    this Statement
    
    Throws:
    
    IndexOutOfBoundsException - if the parameter index is out of range
  - bind
```
default Statement bind(int index,
                       float value)
```
    Bind a value to an indexed parameter. Indexes are zero-based.
    
    Parameters:
    
    index - the index to bind to
    
    value - the value to bind
    
    Returns:
    
    this Statement
    
    Throws:
    
    IndexOutOfBoundsException - if the parameter index is out of range
  - bind
```
default Statement bind(int index,
                       int value)
```
    Bind a value to an indexed parameter. Indexes are zero-based.
    
    Parameters:
    
    index - the index to bind to
    
    value - the value to bind
    
    Returns:
    
    this Statement
    
    Throws:
    
    IndexOutOfBoundsException - if the parameter index is out of range
  - bind
```
default Statement bind(int index,
                       long value)
```
    Bind a value to an indexed parameter. Indexes are zero-based.
    
    Parameters:
    
    index - the index to bind to
    
    value - the value to bind
    
    Returns:
    
    this Statement
    
    Throws:
    
    IndexOutOfBoundsException - if the parameter index is out of range
  - bind
```
default Statement bind(int index,
                       short value)
```
    Bind a value to an indexed parameter. Indexes are zero-based.
    
    Parameters:
    
    index - the index to bind to
    
    value - the value to bind
    
    Returns:
    
    this Statement
    
    Throws:
    
    IndexOutOfBoundsException - if the parameter index is out of range
  - bindNull
```
Statement bindNull(int index,
                   Class<?> type)
```
    Bind a null value to an indexed parametered parameter. Indexes are zero-based.
    
    Parameters:
    
    index - the index to bind to
    
    type - the type of null value
    
    Returns:
    
    this Statement
    
    Throws:
    
    IllegalArgumentException - if type is null
    
    IndexOutOfBoundsException - if the parameter index is out of range
  - bindNull
```
Statement bindNull(String name,
                   Class<?> type)
```
    Bind a null value to a named parameter.
    
    Parameters:
    
    name - the name of identifier to bind to
    
    type - the type of null value
    
    Returns:
    
    this Statement
    
    Throws:
    
    IllegalArgumentException - if name or type is null
  - execute
```
Publisher<? extends Result> execute()
```
    Executes one or more SQL statements and returns the Results.
    
    Returns:
    
    the Results, returned by each statement
    
    Throws:
    
    IllegalStateException - if the statement is parametrized and not all parameter values are provided
  - returnGeneratedValues
```
default Statement returnGeneratedValues(String... columns)
```
    Configures Statement to return the generated values from any rows created by this Statement in the Result returned from execute(). If no columns are specified, implementations are free to choose which columns will be returned. If called multiple times, only the columns requested in the final invocation will be returned.
    The default implementation of this method is a no op.
    
    Parameters:
    
    columns - the names of the columns to return
    
    Returns:
    
    this Statement
    
    Throws:
    
    IllegalArgumentException - if columns, or any item in columns is null
  - fetchSize
```
default Statement fetchSize(int rows)
```
    Configures Statement to retrieve a fixed number of rows when fetching results from a query instead deriving fetch size from back pressure. If called multiple times, only the fetch size configured in the final invocation will be applied. If the value specified is zero, then the hint is ignored.
    The default implementation of this method is a no op and the default value is zero.
    
    Parameters:
    
    rows - the number of rows to fetch
    
    Returns:
    
    this Statement

Interface Statement

Method Summary

Method Detail

add

bind

bind

bind

bind

bind

bind

bind

bind

bind

bind

bindNull

bindNull

execute

returnGeneratedValues

fetchSize