org.jooq

Interface StoreQuery<R extends Record>

Type Parameters:

R - The record type of the table being modified

All Superinterfaces:

Adapter, Attachable, Query, QueryPart, Serializable

All Known Subinterfaces:

InsertQuery<R>, UpdateQuery<R>

public interface StoreQuery<R extends Record>
extends Query

A query storing objects to the database. This is either an insert or an update query.

Author:

Lukas Eder

Method Summary

Methods

Modifier and Type	Method and Description
<T> void	addValue(Field<T> field, Field<T> value) Add a value to the store statement
<T> void	addValue(Field<T> field, T value) Add a value to the store statement
<A extends ArrayRecord<T>,T> void	addValueAsArray(Field<A> field, List<T> value) Add a value to the store statement
<A extends ArrayRecord<T>,T> void	addValueAsArray(Field<A> field, T... value) Add a value to the store statement
void	addValues(Map<? extends Field<?>,?> map) Add multiple values to the store statement.
void	setRecord(R record) Add values to the store statement

Methods inherited from interface org.jooq.Query

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

Methods inherited from interface org.jooq.QueryPart

attach

Methods inherited from interface org.jooq.Adapter

internalAPI

Method Detail

setRecord

@Support
void setRecord(R record)

Add values to the store statement

Parameters:

record - The record holding values that are stored by the query

addValue

@Support
<T> void addValue(Field<T> field,
                        T value)

Add a value to the store statement

Parameters:

field - The field

value - The value

addValue

@Support
<T> void addValue(Field<T> field,
                        Field<T> value)

Add a value to the store statement

Parameters:

field - The field

value - The value. If value is null, this results in calling addValue(Field, Object) with null as a value.

addValues

@Support
void addValues(Map<? extends Field<?>,?> map)

Add multiple values to the store statement.

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

addValueAsArray

@Support(value=ORACLE)
<A extends ArrayRecord<T>,T> void addValueAsArray(Field<A> field,
                                                                   T... value)

Add a value to the store statement

Type Parameters:

A - The field type

T - The array type

Parameters:

field - The field

value - The value

addValueAsArray

@Support(value=ORACLE)
<A extends ArrayRecord<T>,T> void addValueAsArray(Field<A> field,
                                                                   List<T> value)

Add a value to the store statement

Type Parameters:

A - The field type

T - The array type

Parameters:

field - The field

value - The value