Package com.gengoai.sql.statement

Class Update

java.lang.Object

com.gengoai.sql.statement.Update

All Implemented Interfaces:

SQLElement, UpdateStatement, Serializable

public class Update
extends Object
implements UpdateStatement

SQL Update statement

See Also:

Serialized Form

Method Summary

Modifier and Type	Method	Description
Update	set(@NonNull SQLElement column, @NonNull SQLElement value)	Adds a set parameter to the update defined as a column and value.
Update	set(@NonNull String column, @NonNull SQLElement value)	Adds a set parameter to the update defined as a column and value.
Update	setIndexedParameter(@NonNull SQLElement column)	Adds a set parameter for the given column and using an indexed parameter value for use in PreparedStatement
Update	setNamedParameter(@NonNull SQLElement column)	Adds a set parameter for the given column and using a named parameter value for use in NamedPreparedStatement
static Update	table(@NonNull Table table)	Creates a new Update statement which will update the given table
static Update	table(@NonNull SQLElement table)	Creates a new Update statement which will update the given table
Update	type(@NonNull UpdateType type)	Sets the type of update to perform.
Update	where(SQLElement whereClause)	Sets the criteria (i.e.
Update	where(String whereClause)	Sets the criteria (i.e.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.gengoai.sql.SQLElement

getClassName

Methods inherited from interface com.gengoai.sql.statement.UpdateStatement

batch, batch, batch, batch, batch, batch, update, update, update, update

Method Detail

table

public static Update table(@NonNull
                           @NonNull Table table)

Creates a new Update statement which will update the given table

Parameters:

table - the table

Returns:

the Update statement

table

public static Update table(@NonNull
                           @NonNull SQLElement table)

Creates a new Update statement which will update the given table

Parameters:

table - the table

Returns:

the Update statement

set

public Update set(@NonNull
                  @NonNull SQLElement column,
                  @NonNull
                  @NonNull SQLElement value)

Adds a set parameter to the update defined as a column and value.

Parameters:

column - the column to update

value - the value to update the column to

Returns:

this Update statement

set

public Update set(@NonNull
                  @NonNull String column,
                  @NonNull
                  @NonNull SQLElement value)

Adds a set parameter to the update defined as a column and value.

Parameters:

column - the column to update

value - the value to update the column to

Returns:

this Update statement

setIndexedParameter

public Update setIndexedParameter(@NonNull
                                  @NonNull SQLElement column)

Adds a set parameter for the given column and using an indexed parameter value for use in PreparedStatement

Parameters:

column - the column to update

Returns:

this Update statement

setNamedParameter

public Update setNamedParameter(@NonNull
                                @NonNull SQLElement column)

Adds a set parameter for the given column and using a named parameter value for use in NamedPreparedStatement

Parameters:

column - the column to update

Returns:

this Update statement

type

public Update type(@NonNull
                   @NonNull UpdateType type)

Sets the type of update to perform.

Parameters:

type - the type of update to perform

Returns:

this Update statement

where

public Update where(SQLElement whereClause)

Sets the criteria (i.e. WHERE) for the update.

Parameters:

whereClause - the where clause

Returns:

this Update statement

where

public Update where(String whereClause)

Sets the criteria (i.e. WHERE) for the update.

Parameters:

whereClause - the where clause

Returns:

this Update statement