org.jooq

Interface InsertSetMoreStep<R extends Record>

All Superinterfaces:

Attachable, java.lang.AutoCloseable, Insert<R>, InsertFinalStep<R>, InsertOnDuplicateStep<R>, InsertReturningStep<R>, Query, QueryPart, java.io.Serializable

public interface InsertSetMoreStep<R extends Record>
extends InsertOnDuplicateStep<R>

This type is used for the Insert's alternative DSL API.

Example:

 DSLContext create = DSL.using(configuration);

 create.insertInto(table)
       .set(field1, value1)
       .set(field2, value2)
       .newRecord()
       .set(field1, value3)
       .set(field2, value4)
       .onDuplicateKeyUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .execute();
 

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
InsertSetStep<R>	newRecord() Add an additional record to the INSERT statement
<T> InsertSetMoreStep<R>	set(Field<T> field, Field<T> value) Set a value for a field in the INSERT statement.
<T> InsertSetMoreStep<R>	set(Field<T> field, Select<? extends Record1<T>> value) Set a value for a field in the INSERT statement.
<T> InsertSetMoreStep<R>	set(Field<T> field, T value) Set a value for a field in the INSERT statement.
InsertSetMoreStep<R>	set(java.util.Map<?,?> map) Set values in the INSERT statement.
InsertSetMoreStep<R>	set(Record record) Set values in the INSERT statement.

Methods inherited from interface org.jooq.InsertOnDuplicateStep

onConflict, onConflict, onConflictDoNothing, onDuplicateKeyIgnore, onDuplicateKeyUpdate

Methods inherited from interface org.jooq.InsertReturningStep

returning, returning, returning

Methods inherited from interface org.jooq.Query

bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Methods inherited from interface org.jooq.Attachable

attach, configuration, detach

Method Detail

set

@Support
<T> InsertSetMoreStep<R> set(Field<T> field,
                                       T value)

Set a value for a field in the INSERT statement.

set

@Support
<T> InsertSetMoreStep<R> set(Field<T> field,
                                       Field<T> value)

Set a value for a field in the INSERT statement.

set

@Support
<T> InsertSetMoreStep<R> set(Field<T> field,
                                       Select<? extends Record1<T>> value)

Set a value for a field in the INSERT statement.

set

@Support
InsertSetMoreStep<R> set(java.util.Map<?,?> map)

Set values in the INSERT 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.

set

@Support
InsertSetMoreStep<R> set(Record record)

Set values in the INSERT statement.

This is the same as calling set(Map) with the argument record treated as a Map<Field<?>, Object>.

See Also:

set(Map)

newRecord

@Support
InsertSetStep<R> newRecord()

Add an additional record to the INSERT statement

See Also:

InsertQuery.newRecord()