com.anylogic.engine.database

Class UpdateQuery

java.lang.Object

com.anylogic.engine.database.UpdateQuery

public class UpdateQuery
extends java.lang.Object

UpdateQuery for building and execution of UPDATE SQL statements

Constructor Summary

Constructors

Constructor and Description
UpdateQuery(ModelDatabase database, <any> table)

Method Summary

Modifier and Type	Method and Description
long	execute() Executes update query
SQLUpdateClause	getDSLQuery()
<T> UpdateQuery	set(<any> column, <any> value) Set column with its value to update with
<T> UpdateQuery	set(<any> column, T value) Set column with its value to update with
UpdateQuery	set(java.util.List<? extends <any>> columns, java.util.List<?> values) Set columns with its values to update with
UpdateQuery	where(Predicate... conditions) Add conditions to identify rows that have to be updated
UpdateQuery	where(Predicate condition) Add a condition to identify rows that have to be updated

Methods inherited from class java.lang.Object

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

Constructor Detail

UpdateQuery

@AnyLogicInternalAPI
public UpdateQuery(ModelDatabase database,
                                         <any> table)

Method Detail

getDSLQuery

@AnyLogicInternalAPI
public SQLUpdateClause getDSLQuery()

execute

public long execute()

Executes update query

Returns:

updated rows number

set

public UpdateQuery set(java.util.List<? extends <any>> columns,
                       java.util.List<?> values)

Set columns with its values to update with

Parameters:

columns - columns to update

values - values of that columns

Returns:

UpdateQuery

set

public <T> UpdateQuery set(<any> column,
                           <any> value)

Set column with its value to update with

Parameters:

column - column to update

value - value of that column

Returns:

UpdateQuery

set

public <T> UpdateQuery set(<any> column,
                           T value)

Set column with its value to update with

Parameters:

column - column to update

value - value of that column

Returns:

UpdateQuery

where

public UpdateQuery where(Predicate condition)

Add a condition to identify rows that have to be updated

Returns:

UpdateQuery

where

public UpdateQuery where(Predicate... conditions)

Add conditions to identify rows that have to be updated

Returns:

UpdateQuery