Class Statement (6.51.0)

public final class Statement implements Serializable

A SQL statement and optional bound parameters that can be executed in a ReadContext.

The SQL query string can contain parameter placeholders. A parameter placeholder consists of @ followed by the parameter name. Parameter names consist of any combination of letters, numbers, and underscores.

Parameters can appear anywhere that a literal value is expected. The same parameter name can be used more than once, for example: WHERE id > @msg_id AND id < @msg_id + 100

It is an error to execute an SQL query with placeholders for unbound parameters.

Statements are constructed using a builder. Parameter values are specified by calling Builder#bind(String). For example, code to build a query using the clause above and bind a value to id might look like the following:


 Statement statement = Statement
     .newBuilder("SELECT name WHERE id > @msg_id AND id < @msg_id="" +="" 100")="" .bind("msg_id").to(500)="" .build();="">

Statement instances are immutable.

Inheritance

Object > Statement

Implements

Serializable

Inherited Members

Object.clone()

Object.equals(Object)

Object.finalize()

Object.getClass()

Object.hashCode()

Object.notify()

Object.notifyAll()

Object.toString()

Object.wait()

Object.wait(long)

Object.wait(long,int)

Static Methods

newBuilder(String sql)

public static Statement.Builder newBuilder(String sql)

Creates a new statement builder with the SQL text sql.

Parameter
Name	Description
`sql`	`String`

Returns
Type	Description
`Statement.Builder`

of(String sql)

public static Statement of(String sql)

Creates a Statement with the given SQL text sql.

Parameter
Name	Description
`sql`	`String`

Returns
Type	Description
`Statement`

Methods

analyzeQuery(ReadContext context, ReadContext.QueryAnalyzeMode queryMode)

public ResultSet analyzeQuery(ReadContext context, ReadContext.QueryAnalyzeMode queryMode)

Analyzes the query in context. statement.analyzeQuery(context, queryMode) is exactly equivalent to context.analyzeQuery(statement, queryMode). See Also: ReadContext#analyzeQuery(Statement, com.google.cloud.spanner.ReadContext.QueryAnalyzeMode)

Parameters
Name	Description
`context`	`ReadContext`
`queryMode`	`ReadContext.QueryAnalyzeMode`

Returns
Type	Description
`ResultSet`

equals(Object o)

public boolean equals(Object o)

Parameter
Name	Description
`o`	`Object`

Returns
Type	Description
`boolean`

Overrides

Object.equals(Object)

executeQuery(ReadContext context, Options.QueryOption[] options)

public ResultSet executeQuery(ReadContext context, Options.QueryOption[] options)

Executes the query in context. statement.executeQuery(context) is exactly equivalent to context.executeQuery(statement). See Also: ReadContext#executeQuery(Statement, Options.QueryOption...)

Parameters
Name	Description
`context`	`ReadContext`
`options`	`QueryOption[]`

Returns
Type	Description
`ResultSet`

getParameters()

public Map<String,Value> getParameters()

Returns the parameters bound to this Statement.

Returns
Type	Description
`Map<String,Value>`

getQueryOptions()

public ExecuteSqlRequest.QueryOptions getQueryOptions()

Returns the QueryOptions that will be used with this Statement.

Returns
Type	Description
`ExecuteSqlRequest.QueryOptions`

getSql()

public String getSql()

Returns the current SQL statement text.

Returns
Type	Description
`String`

hasBinding(String parameter)

public boolean hasBinding(String parameter)

Returns true if a binding exists for parameter.

Parameter
Name	Description
`parameter`	`String`

Returns
Type	Description
`boolean`

hashCode()

public int hashCode()

Returns
Type	Description
`int`

Overrides

Object.hashCode()

toBuilder()

public Statement.Builder toBuilder()

Returns
Type	Description
`Statement.Builder`

toString()

public String toString()

Returns
Type	Description
`String`

Overrides

Object.toString()