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

Method Summary

Modifier and Type	Method and Description
public FindStatement	Returns: `FindStatement` fields(String... projection expression projections) Add/replace the field projections defining the result.
public FindStatement	Returns: `FindStatement` fields(Expression projection expression docProjection) Add/replace the field projection defining the result.
public FindStatement	Returns: `FindStatement` groupBy(String... groupBy expression groupBy) Add/replace the aggregation fields for this query.
public FindStatement	Returns: `FindStatement` having(String having expression having) Add/replace the aggregate criteria for this query.
public FindStatement	Returns: `FindStatement` limit(long limit numberOfRows) Add/replace the document limit for this query.
public FindStatement	Returns: `FindStatement` lockExclusive() Locks matching rows exclusively so no other transactions can read or write to them.
public FindStatement	Returns: `FindStatement` 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 FindStatement	Returns: `FindStatement` lockShared() Locks matching rows against updates.
public FindStatement	Returns: `FindStatement` 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 FindStatement	Returns: `FindStatement` offset(long number of documents to skip limitOffset) Add/replace the document offset for this query.
public FindStatement	Returns: `FindStatement` orderBy(String... sort expression sortFields) Add/replace the order specification for this query.
public default FindStatement	Returns: `FindStatement` skip(long number of documents to skip limitOffset) Deprecated Deprecated in c/J 8.0.12, please use `offset(long)` instead. Add/replace the document offset for this query.
public FindStatement	Returns: `FindStatement` sort(String... sort expression sortFields) Add/replace the order specification for this query.

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

Method Detail

fields back to summary

fields	back to summary
public FindStatement fields(String... projections) Add/replace the field projections defining the result. Parameters projections:String[] projection expression Returns:FindStatement `FindStatement`

public FindStatement fields(String... projections)

Add/replace the field projections defining the result.

Parameters

projections:String[]: projection expression

Returns:FindStatement

FindStatement

fields back to summary

fields	back to summary
public FindStatement fields(Expression docProjection) Add/replace the field projection defining the result. Parameters docProjection:Expression projection expression Returns:FindStatement `FindStatement`

public FindStatement fields(Expression docProjection)

Add/replace the field projection defining the result.

Parameters

docProjection:Expression: projection expression

Returns:FindStatement

FindStatement

groupBy back to summary

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

public FindStatement groupBy(String... groupBy)

Add/replace the aggregation fields for this query.

Parameters

groupBy:String[]: groupBy expression

Returns:FindStatement

FindStatement

having back to summary

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

public FindStatement having(String having)

Add/replace the aggregate criteria for this query.

Parameters

having:String: having expression

Returns:FindStatement

FindStatement

limit back to summary

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

public FindStatement limit(long numberOfRows)

Add/replace the document limit for this query.

Parameters

numberOfRows:long: limit

Returns:FindStatement

FindStatement

lockExclusive back to summary

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

public FindStatement lockExclusive()

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

Returns:FindStatement: FindStatement

lockExclusive back to summary

lockExclusive	back to summary
public FindStatement 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:FindStatement `FindStatement`

public FindStatement 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:FindStatement

FindStatement

lockShared back to summary

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

public FindStatement lockShared()

Locks matching rows against updates.

Returns:FindStatement: FindStatement

lockShared back to summary

lockShared	back to summary
public FindStatement 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:FindStatement `FindStatement`

public FindStatement 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:FindStatement

FindStatement

offset back to summary

offset	back to summary
public FindStatement offset(long limitOffset) Add/replace the document offset for this query. Parameters limitOffset:long number of documents to skip Returns:FindStatement `FindStatement`

public FindStatement offset(long limitOffset)

Add/replace the document offset for this query.

Parameters

limitOffset:long: number of documents to skip

Returns:FindStatement

FindStatement

orderBy back to summary

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

public FindStatement orderBy(String... sortFields)

Add/replace the order specification for this query.

Parameters

sortFields:String[]: sort expression

Returns:FindStatement

FindStatement

skip back to summary

skip	back to summary
public default FindStatement skip(long limitOffset) Deprecated Deprecated in c/J 8.0.12, please use `offset(long)` instead. Add/replace the document offset for this query. Parameters limitOffset:long number of documents to skip Returns:FindStatement `FindStatement` Annotations @Deprecated

public default FindStatement skip(long limitOffset)

Deprecated

Deprecated in c/J 8.0.12, please use offset(long) instead.

Add/replace the document offset for this query.

Parameters

limitOffset:long: number of documents to skip

Returns:FindStatement

FindStatement

Annotations

@Deprecated

sort back to summary

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

public FindStatement sort(String... sortFields)

Add/replace the order specification for this query.

Synonym for orderBy(String...)

Parameters

sortFields:String[]: sort expression

Returns:FindStatement

FindStatement

public Interface FindStatement

Method Summary

Method Detail