MySQL Connector/J 9.2.0 · com.mysql.cj.xdevapi.SelectStatement

Method Summary

Modifier and Type	Method and Description
public FilterParams	Returns: `FilterParams` getFilterParams() Return `FilterParams` defined for this statement.
public SelectStatement	Returns: `SelectStatement` groupBy(String... groupBy expression groupBy) Add/replace the aggregation fields for this query.
public SelectStatement	Returns: `SelectStatement` having(String having expression having) Add/replace the aggregate criteria for this query.
public SelectStatement	Returns: `SelectStatement` limit(long limit numberOfRows) Add/replace the row limit for this query.
public SelectStatement	Returns: `SelectStatement` lockExclusive() Locks matching rows exclusively so no other transactions can read or write to them.
public SelectStatement	Returns: `SelectStatement` lockExclusive(Statement.LockContention The `com.mysql.cj.xdevapi.Statement.LockContention` value to set. lockContention) Locks matching rows exclusively so no other transactions can read or write to them, using the provided lock contention option.
public SelectStatement	Returns: `SelectStatement` lockShared() Locks matching rows against updates.
public SelectStatement	Returns: `SelectStatement` lockShared(Statement.LockContention The `com.mysql.cj.xdevapi.Statement.LockContention` value to set. lockContention) Locks matching rows against updates using the provided lock contention option.
public SelectStatement	Returns: `SelectStatement` offset(long limit offset limitOffset) Add/replace the row offset for this query.
public SelectStatement	Returns: `SelectStatement` orderBy(String... sort expression sortFields) Add/replace the order specification for this query.
public SelectStatement	Returns: `SelectStatement` where(String search condition expression searchCondition) Add/replace the search condition for this query.

Inherited from com.mysql.cj.xdevapi.Statement:: bind bind bind bind clearBindings execute executeAsync

Method Detail

getFilterParams back to summary

getFilterParams	back to summary
public FilterParams getFilterParams() Return `FilterParams` defined for this statement. Returns:FilterParams `FilterParams`

public FilterParams getFilterParams()

Return FilterParams defined for this statement.

Returns:FilterParams: FilterParams

groupBy back to summary

groupBy	back to summary
public SelectStatement groupBy(String... groupBy) Add/replace the aggregation fields for this query. Parameters groupBy:String[] groupBy expression Returns:SelectStatement `SelectStatement`

public SelectStatement groupBy(String... groupBy)

Add/replace the aggregation fields for this query.

Parameters

groupBy:String[]: groupBy expression

Returns:SelectStatement

SelectStatement

having back to summary

having	back to summary
public SelectStatement having(String having) Add/replace the aggregate criteria for this query. Parameters having:String having expression Returns:SelectStatement `SelectStatement`

public SelectStatement having(String having)

Add/replace the aggregate criteria for this query.

Parameters

having:String: having expression

Returns:SelectStatement

SelectStatement

limit back to summary

limit	back to summary
public SelectStatement limit(long numberOfRows) Add/replace the row limit for this query. Parameters numberOfRows:long limit Returns:SelectStatement `SelectStatement`

public SelectStatement limit(long numberOfRows)

Add/replace the row limit for this query.

Parameters

numberOfRows:long: limit

Returns:SelectStatement

SelectStatement

lockExclusive back to summary

lockExclusive	back to summary
public SelectStatement lockExclusive() Locks matching rows exclusively so no other transactions can read or write to them. Returns:SelectStatement `SelectStatement`

public SelectStatement lockExclusive()

Locks matching rows exclusively so no other transactions can read or write to them.

Returns:SelectStatement: SelectStatement

lockExclusive back to summary

lockExclusive	back to summary
public SelectStatement lockExclusive(Statement.LockContention lockContention) Locks matching rows exclusively so no other transactions can read or write to them, using the provided lock contention option. Parameters lockContention:Statement.LockContention The `com.mysql.cj.xdevapi.Statement.LockContention` value to set. Returns:SelectStatement `SelectStatement`

public SelectStatement lockExclusive(Statement.LockContention lockContention)

Locks matching rows exclusively so no other transactions can read or write to them, using the provided lock contention option.

Parameters

lockContention:Statement.LockContention: The com.mysql.cj.xdevapi.Statement.LockContention value to set.

Returns:SelectStatement

SelectStatement

lockShared back to summary

lockShared	back to summary
public SelectStatement lockShared() Locks matching rows against updates. Returns:SelectStatement `SelectStatement`

public SelectStatement lockShared()

Locks matching rows against updates.

Returns:SelectStatement: SelectStatement

lockShared back to summary

lockShared	back to summary
public SelectStatement lockShared(Statement.LockContention lockContention) Locks matching rows against updates using the provided lock contention option. Parameters lockContention:Statement.LockContention The `com.mysql.cj.xdevapi.Statement.LockContention` value to set. Returns:SelectStatement `SelectStatement`

public SelectStatement lockShared(Statement.LockContention lockContention)

Locks matching rows against updates using the provided lock contention option.

Parameters

lockContention:Statement.LockContention: The com.mysql.cj.xdevapi.Statement.LockContention value to set.

Returns:SelectStatement

SelectStatement

offset back to summary

offset	back to summary
public SelectStatement offset(long limitOffset) Add/replace the row offset for this query. Parameters limitOffset:long limit offset Returns:SelectStatement `SelectStatement`

public SelectStatement offset(long limitOffset)

Add/replace the row offset for this query.

Parameters

limitOffset:long: limit offset

Returns:SelectStatement

SelectStatement

orderBy back to summary

orderBy	back to summary
public SelectStatement orderBy(String... sortFields) Add/replace the order specification for this query. Parameters sortFields:String[] sort expression Returns:SelectStatement `SelectStatement`

public SelectStatement orderBy(String... sortFields)

Add/replace the order specification for this query.

Parameters

sortFields:String[]: sort expression

Returns:SelectStatement

SelectStatement

where back to summary

where	back to summary
public SelectStatement where(String searchCondition) Add/replace the search condition for this query. Parameters searchCondition:String search condition expression Returns:SelectStatement `SelectStatement`

public SelectStatement where(String searchCondition)

Add/replace the search condition for this query.

Parameters

searchCondition:String: search condition expression

Returns:SelectStatement

SelectStatement

public Interface SelectStatement

Method Summary

Method Detail