public interface InsertSetMoreStep<R extends Record> extends InsertOnDuplicateStep<R>
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();
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(Map<? extends Field<?>,?> map)
Set values in the
INSERT statement. |
InsertSetMoreStep<R> |
set(Record record)
Set values in the
INSERT statement. |
onConflict, onConflict, onConflictDoNothing, onDuplicateKeyIgnore, onDuplicateKeyUpdate
returning, returning, returning
bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout
attach, detach
@Support <T> InsertSetMoreStep<R> set(Field<T> field, T value)
INSERT
statement.@Support <T> InsertSetMoreStep<R> set(Field<T> field, Field<T> value)
INSERT
statement.@Support <T> InsertSetMoreStep<R> set(Field<T> field, Select<? extends Record1<T>> value)
INSERT
statement.@Support InsertSetMoreStep<R> set(Map<? extends Field<?>,?> map)
INSERT
statement.
Values can either be of type <T>
or
Field<T>
. jOOQ will attempt to convert values to their
corresponding field's type.
@Support InsertSetMoreStep<R> set(Record record)
INSERT
statement.
This is the same as calling set(Map)
with the argument record
treated as a Map<Field<?>, Object>
.
set(Map)
@Support InsertSetStep<R> newRecord()
INSERT
statementInsertQuery.newRecord()
Copyright © 2017. All Rights Reserved.