Package de.chojo.sqlutil.wrapper.stage

Interface StatementStage<T>

Type Parameters:

T - type

All Known Implementing Classes:

QueryBuilder

public interface StatementStage<T>

Statement stage of a QueryBuilder

Method Summary

Modifier and Type	Method	Description
default ResultStage<T>	emptyParams()	Skip this stage and set no parameters in the query.
ResultStage<T>	parameter(ThrowingConsumer<ParamBuilder,SQLException> stmt)	Set the parameter of the PreparedStatement of the query.
ResultStage<T>	params(ThrowingConsumer<PreparedStatement,SQLException> stmt)	Deprecated. This method exists for the sole purpose of backwards compatibility.
default ResultStage<T>	paramsBuilder(ThrowingConsumer<ParamBuilder,SQLException> params)	Deprecated, for removal: This API element is subject to removal in a future version. use parameter(ThrowingConsumer) instead

Method Details

params

@Deprecated
ResultStage<T> params(ThrowingConsumer<PreparedStatement,SQLException> stmt)

Deprecated.

This method exists for the sole purpose of backwards compatibility. Usage of parameter(ThrowingConsumer) is prefered.

Set the parameter of the PreparedStatement of the query.

Parameters:

stmt - statement to change

Returns:

The QueryBuilder in a ResultStage with the parameters applied to the query.

paramsBuilder

@Deprecated(forRemoval=true)
default ResultStage<T> paramsBuilder(ThrowingConsumer<ParamBuilder,SQLException> params)

Deprecated, for removal: This API element is subject to removal in a future version.

use parameter(ThrowingConsumer) instead

Set the parameter of the PreparedStatement of the query.

Use the query builder so set the parameters in the defined order.

stmt -> stmt.setString("value").setInt(1)

Parameters:

params - a consumer of a param builder used for simple setting of params.

Returns:

The QueryBuilder in a ResultStage with the parameters applied to the query.

parameter

ResultStage<T> parameter(ThrowingConsumer<ParamBuilder,SQLException> stmt)

Set the parameter of the PreparedStatement of the query.

Use the query builder so set the parameters in the defined order.

stmt -> stmt.setString("value").setInt(1)

Parameters:

stmt - a consumer of a param builder used for simple setting of params.

Returns:

The QueryBuilder in a ResultStage with the parameters applied to the query.

emptyParams

default ResultStage<T> emptyParams()

Skip this stage and set no parameters in the query.

You can also call QueryStage.queryWithoutParams(String) on the previous QueryStage instead to avoid this step completely.

Returns:

The QueryBuilder in a ResultStage with no parameters set.