org.jooq
Interface InsertSetStep

All Known Subinterfaces:

InsertSetMoreStep

public interface InsertSetStep

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

Example:

 Factory create = new Factory();

 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

InsertSetMoreStep	set(Field<?> field, Field<?> value) Set a value for a field in the UPDATE statement
InsertSetMoreStep	set(Field<?> field, Object value) Set a value for a field in the UPDATE statement
InsertSetMoreStep	set(Map<? extends Field<?>,?> map) Set a value for a field in the UPDATE statement Please assure that key/value pairs have matching <T> types.
InsertValuesStep	values(Collection<?> values) Add values to the insert statement with implicit field names
InsertValuesStep	values(Field<?>... values) Add values to the insert statement with implicit field names
InsertValuesStep	values(Object... values) Add values to the insert statement with implicit field names

Method Detail

set

InsertSetMoreStep set(Field<?> field,
                      Object value)

Set a value for a field in the UPDATE statement

set

InsertSetMoreStep set(Field<?> field,
                      Field<?> value)

Set a value for a field in the UPDATE statement

set

InsertSetMoreStep set(Map<? extends Field<?>,?> map)

Set a value for a field in the UPDATE statement

Please assure that key/value pairs have matching <T> types. Values can either be of type <T> or Field<T>

values

InsertValuesStep values(Object... values)

Add values to the insert statement with implicit field names

values

InsertValuesStep values(Field<?>... values)

Add values to the insert statement with implicit field names

values

InsertValuesStep values(Collection<?> values)

Add values to the insert statement with implicit field names