jOOQ 3.18.7 · org.jooq.UpdateSetStep

This type is used for the Update's DSL API.

Example:


DSLContext create = DSL.using(configuration);

create.update(table)
      .set(field1, value1)
      .set(field2, value2)
      .where(field1.greaterThan(100))
      .execute();

Referencing `XYZ*Step` types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

They're operating on mutable implementations (as of jOOQ 3.x)
They're less composable and not easy to get right when dynamic SQL gets complex
They're less readable
They might have binary incompatible changes between minor releases

Method Summary

Modifier and Type	Method and Description
public <T> @NotNull UpdateSetMoreStep<R>	set(Field<T> field, T value) Deprecated as a consequence of `Field` and `UpdateSetMoreStep` being deprecated. Set a value for a field in the `UPDATE` statement.
public <T> @NotNull UpdateSetMoreStep<R>	set(Field<T> field, Field<T> value) Deprecated as a consequence of `Field` and `UpdateSetMoreStep` being deprecated. Set a value for a field in the `UPDATE` statement.
public <T> @NotNull UpdateSetMoreStep<R>	set(Field<T> field, Select<? extends Record1<T>> value) Deprecated as a consequence of `Field` and `UpdateSetMoreStep` being deprecated. Set a value for a field in the `UPDATE` statement.
public @NotNull UpdateSetMoreStep<R>	set(Map<?, ?> map) Deprecated as a consequence of `UpdateSetMoreStep` being deprecated. Set a value for a field in the `UPDATE` statement.
public @NotNull UpdateSetMoreStep<R>	set(Record record) Deprecated as a consequence of `UpdateSetMoreStep` being deprecated. Set a value for a field in the `UPDATE` statement.
public <T> @NotNull UpdateSetMoreStep<R>	setNull(Field<T> field) Deprecated as a consequence of `Field` and `UpdateSetMoreStep` being deprecated. Set a `null` value for a field in the `UPDATE` statement.

Method Detail

set back to summary

set	back to summary
public <T> @NotNull UpdateSetMoreStep<R> set(Field<T> field, T value) Deprecated as a consequence of `Field` and `UpdateSetMoreStep` being deprecated. See corresponding docs for further information. Set a value for a field in the `UPDATE` statement. Annotations @NotNull @CheckReturnValue @Support

public <T> @NotNull UpdateSetMoreStep<R> set(Field<T> field, T value)

Deprecated

as a consequence of Field and UpdateSetMoreStep being deprecated. See corresponding docs for further information.

Set a value for a field in the UPDATE statement.

Annotations

@NotNull
@CheckReturnValue
@Support

set back to summary

set	back to summary
public <T> @NotNull UpdateSetMoreStep<R> set(Field<T> field, Field<T> value) Deprecated as a consequence of `Field` and `UpdateSetMoreStep` being deprecated. See corresponding docs for further information. Set a value for a field in the `UPDATE` statement. Annotations @NotNull @CheckReturnValue @Support

public <T> @NotNull UpdateSetMoreStep<R> set(Field<T> field, Field<T> value)

Deprecated

as a consequence of Field and UpdateSetMoreStep being deprecated. See corresponding docs for further information.

Set a value for a field in the UPDATE statement.

Annotations

@NotNull
@CheckReturnValue
@Support

set back to summary

set	back to summary
public <T> @NotNull UpdateSetMoreStep<R> set(Field<T> field, Select<? extends Record1<T>> value) Deprecated as a consequence of `Field` and `UpdateSetMoreStep` being deprecated. See corresponding docs for further information. Set a value for a field in the `UPDATE` statement. Annotations @NotNull @CheckReturnValue @Support

public <T> @NotNull UpdateSetMoreStep<R> set(Field<T> field, Select<? extends Record1<T>> value)

Deprecated

as a consequence of Field and UpdateSetMoreStep being deprecated. See corresponding docs for further information.

Set a value for a field in the UPDATE statement.

Annotations

@NotNull
@CheckReturnValue
@Support

set back to summary

set	back to summary
public @NotNull UpdateSetMoreStep<R> set(Map<?, ?> map) Deprecated as a consequence of `UpdateSetMoreStep` being deprecated. See corresponding docs for further information. Set a value for a field in the `UPDATE` statement. Keys can either be of type `String`, `Name`, or `Field`. Values can either be of type `<T>` or `Field<T>`. jOOQ will attempt to convert values to their corresponding field's type. Annotations @NotNull @CheckReturnValue @Support

public @NotNull UpdateSetMoreStep<R> set(Map<?, ?> map)

Deprecated

as a consequence of UpdateSetMoreStep being deprecated. See corresponding docs for further information.

Set a value for a field in the UPDATE statement.

Keys can either be of type String, Name, or Field.

Values can either be of type <T> or Field<T>. jOOQ will attempt to convert values to their corresponding field's type.

Annotations

@NotNull
@CheckReturnValue
@Support

set back to summary

set	back to summary
public @NotNull UpdateSetMoreStep<R> set(Record record) Deprecated as a consequence of `UpdateSetMoreStep` being deprecated. See corresponding docs for further information. Set a value for a field in the `UPDATE` statement. This is the same as calling `set(Map)` with the argument record treated as a `Map<Field<?>, Object>`, except that the `Record#changed()` flags are taken into consideration in order to update only changed values. Annotations @NotNull @CheckReturnValue @Support See Also `set(Map)`

public @NotNull UpdateSetMoreStep<R> set(Record record)

Deprecated

as a consequence of UpdateSetMoreStep being deprecated. See corresponding docs for further information.

Set a value for a field in the UPDATE statement.

This is the same as calling set(Map) with the argument record treated as a Map<Field<?>, Object>, except that the Record#changed() flags are taken into consideration in order to update only changed values.

Annotations

@NotNull
@CheckReturnValue
@Support

See Also

set(Map)

setNull back to summary

setNull	back to summary
public <T> @NotNull UpdateSetMoreStep<R> setNull(Field<T> field) Deprecated as a consequence of `Field` and `UpdateSetMoreStep` being deprecated. See corresponding docs for further information. Set a `null` value for a field in the `UPDATE` statement. This method is convenience for calling `set(Field, Object)`, without the necessity of casting the Java `null` literal to `(T)`. Annotations @NotNull @CheckReturnValue @Support

public <T> @NotNull UpdateSetMoreStep<R> setNull(Field<T> field)

Deprecated

as a consequence of Field and UpdateSetMoreStep being deprecated. See corresponding docs for further information.

Set a null value for a field in the UPDATE statement.

This method is convenience for calling set(Field, Object), without the necessity of casting the Java null literal to (T).

Annotations

@NotNull
@CheckReturnValue
@Support

public Interface UpdateSetStep<R extends org.jooq.Record>

Referencing XYZ*Step types directly from client code

Method Summary

Method Detail

Referencing `XYZ*Step` types directly from client code