java.lang.Object
- com.alibaba.druid.sql.ast.SQLObjectImpl
- - com.alibaba.druid.sql.ast.SQLStatementImpl
  - - com.alibaba.druid.sql.ast.statement.SQLUpdateStatement

All Implemented Interfaces:

SQLDbTypedObject, SQLObject, SQLReplaceable, SQLStatement

Direct Known Subclasses:

MySqlUpdateStatement, OracleUpdateStatement, OscarUpdateStatement, PGUpdateStatement, SQLServerUpdateStatement
```
public class SQLUpdateStatement
extends SQLStatementImpl
implements SQLReplaceable
```

Field Summary

Fields
Modifier and Type	Field	Description
`protected SQLTableSource`	`from`
`protected List<SQLUpdateSetItem>`	`items`
`protected SQLLimit`	`limit`
`protected SQLOrderBy`	`orderBy`
`protected List<SQLAssignItem>`	`partitions`
`protected List<SQLExpr>`	`returning`
`protected SQLTableSource`	`tableSource`
`protected SQLExpr`	`where`
`protected SQLWithSubqueryClause`	`with`

Fields inherited from class com.alibaba.druid.sql.ast.SQLStatementImpl
afterSemi, dbType, headHints

Fields inherited from class com.alibaba.druid.sql.ast.SQLObjectImpl
attributes, hint, parent, sourceColumn, sourceLine

Constructor Summary

Constructors
Constructor Description

SQLUpdateStatement()

SQLUpdateStatement(DbType dbType)

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`protected void`	`accept0(SQLASTVisitor visitor)`
`protected void`	`acceptChild(SQLASTVisitor visitor)`
`void`	`addCondition(SQLExpr expr)`
`void`	`addCondition(String conditionSql)`
`void`	`addItem(SQLUpdateSetItem item)`
`boolean`	`addWhere(SQLExpr where)`
`SQLUpdateStatement`	`clone()`
`void`	`cloneTo(SQLUpdateStatement x)`
`boolean`	`equals(Object o)`
`List<SQLObject>`	`getChildren()`
`SQLTableSource`	`getFrom()`
`List<SQLUpdateSetItem>`	`getItems()`
`SQLLimit`	`getLimit()`
`SQLOrderBy`	`getOrderBy()`
`List<SQLAssignItem>`	`getPartitions()`
`List<SQLExpr>`	`getReturning()`
`SQLName`	`getTableName()`
`SQLName`	`getTableName(boolean lastFlag)`
`SQLTableSource`	`getTableSource()`
`SQLExpr`	`getWhere()`
`SQLWithSubqueryClause`	`getWith()`
`int`	`hashCode()`
`boolean`	`removeCondition(SQLExpr condition)`
`boolean`	`removeCondition(String conditionSql)`
`boolean`	`replace(SQLExpr expr, SQLExpr target)`
`void`	`setFrom(SQLTableSource from)`
`void`	`setLimit(SQLLimit limit)`
`void`	`setOrderBy(SQLOrderBy orderBy)`
`void`	`setPartitions(List<SQLAssignItem> partitions)`
`void`	`setTableSource(SQLExpr expr)`
`void`	`setTableSource(SQLTableSource tableSource)`
`void`	`setWhere(SQLExpr where)`
`void`	`setWith(SQLWithSubqueryClause with)`

Methods inherited from class com.alibaba.druid.sql.ast.SQLStatementImpl
cloneTo, getDbType, getHeadHintsDirect, isAfterSemi, setAfterSemi, setDbType, setHeadHints, toLowerCaseString, toParameterizedString, toString, toString, toUnformattedString

Methods inherited from class com.alibaba.druid.sql.ast.SQLObjectImpl
accept, acceptChild, acceptChild, addAfterComment, addAfterComment, addBeforeComment, addBeforeComment, cloneTo, computeDataType, containsAttribute, getAfterCommentsDirect, getAttribute, getAttributes, getAttributesDirect, getBeforeCommentsDirect, getHint, getParent, getParent, getSourceColumn, getSourceLine, hasAfterComment, hasBeforeComment, output, putAttribute, setHint, setParent, setSource, setSourceLine

Methods inherited from class java.lang.Object
finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.alibaba.druid.sql.ast.SQLObject
accept, addAfterComment, addAfterComment, addBeforeComment, addBeforeComment, containsAttribute, getAfterCommentsDirect, getAttribute, getAttributes, getAttributesDirect, getBeforeCommentsDirect, getParent, getParent, getSourceColumn, getSourceLine, hasAfterComment, hasBeforeComment, output, putAttribute, setParent, setSource

Field Detail

with
```
protected SQLWithSubqueryClause with
```

items

protected final List<SQLUpdateSetItem> items

where
```
protected SQLExpr where
```

limit
```
protected SQLLimit limit
```

from
```
protected SQLTableSource from
```

tableSource
```
protected SQLTableSource tableSource
```

returning
```
protected List<SQLExpr> returning
```

partitions

protected List<SQLAssignItem> partitions

orderBy
```
protected SQLOrderBy orderBy
```

Constructor Detail

SQLUpdateStatement
```
public SQLUpdateStatement()
```

SQLUpdateStatement

public SQLUpdateStatement(DbType dbType)

Method Detail

getLimit
```
public SQLLimit getLimit()
```

setLimit

public void setLimit(SQLLimit limit)

cloneTo

public void cloneTo(SQLUpdateStatement x)

clone
```
public SQLUpdateStatement clone()
```
Specified by:

clone in interface SQLObject

Specified by:

clone in interface SQLStatement

Overrides:

clone in class SQLStatementImpl

getTableSource

public SQLTableSource getTableSource()

setTableSource

public void setTableSource(SQLExpr expr)

setTableSource

public void setTableSource(SQLTableSource tableSource)

getTableName
```
public SQLName getTableName()
```

getTableName

public SQLName getTableName(boolean lastFlag)

getPartitions

public List<SQLAssignItem> getPartitions()

setPartitions

public void setPartitions(List<SQLAssignItem> partitions)

getWhere
```
public SQLExpr getWhere()
```

setWhere

public void setWhere(SQLExpr where)

getItems

public List<SQLUpdateSetItem> getItems()

addItem

public void addItem(SQLUpdateSetItem item)

getReturning
```
public List<SQLExpr> getReturning()
```

getFrom
```
public SQLTableSource getFrom()
```

setFrom

public void setFrom(SQLTableSource from)

accept0

protected void accept0(SQLASTVisitor visitor)

Overrides:: accept0 in class SQLStatementImpl

acceptChild

protected void acceptChild(SQLASTVisitor visitor)

getChildren
```
public List<SQLObject> getChildren()
```
Specified by:

getChildren in interface SQLStatement

Overrides:

getChildren in class SQLStatementImpl

replace

public boolean replace(SQLExpr expr,
                       SQLExpr target)

Specified by:: replace in interface SQLReplaceable

getOrderBy
```
public SQLOrderBy getOrderBy()
```

setOrderBy

public void setOrderBy(SQLOrderBy orderBy)

getWith

public SQLWithSubqueryClause getWith()

setWith

public void setWith(SQLWithSubqueryClause with)

addCondition

public void addCondition(String conditionSql)

addCondition

public void addCondition(SQLExpr expr)

removeCondition

public boolean removeCondition(String conditionSql)

removeCondition

public boolean removeCondition(SQLExpr condition)

equals
```
public boolean equals(Object o)
```
Overrides:

equals in class Object

hashCode
```
public int hashCode()
```
Overrides:

hashCode in class Object

addWhere

public boolean addWhere(SQLExpr where)

Constructors
Constructor	Description
`SQLUpdateStatement()`
`SQLUpdateStatement(DbType dbType)`

Class SQLUpdateStatement

Field Summary

Fields inherited from class com.alibaba.druid.sql.ast.SQLStatementImpl

Fields inherited from class com.alibaba.druid.sql.ast.SQLObjectImpl

Constructor Summary

Method Summary

Methods inherited from class com.alibaba.druid.sql.ast.SQLStatementImpl

Methods inherited from class com.alibaba.druid.sql.ast.SQLObjectImpl

Methods inherited from class java.lang.Object

Methods inherited from interface com.alibaba.druid.sql.ast.SQLObject

Field Detail

with

items

where

limit

from

tableSource

returning

partitions

orderBy

Constructor Detail

SQLUpdateStatement

SQLUpdateStatement

Method Detail

getLimit

setLimit

cloneTo

clone

getTableSource

setTableSource

setTableSource

getTableName

getTableName

getPartitions

setPartitions

getWhere

setWhere

getItems

addItem

getReturning

getFrom

setFrom

accept0

acceptChild

getChildren

replace

getOrderBy

setOrderBy

getWith

setWith

addCondition

addCondition

removeCondition

removeCondition

equals

hashCode

addWhere