Package rife.database.queries

Class Update

java.lang.Object

rife.database.queries.AbstractWhereQuery<Update>

rife.database.queries.Update

All Implemented Interfaces:

Cloneable, Query

public class Update
extends AbstractWhereQuery<Update>
implements Cloneable

Object representation of a SQL "UPDATE" query.

This object may be used to dynamically construct a SQL statement in a database-independent fashion. After it is finished, it may be executed using DbQueryManager.executeUpdate().

Since:

1.0

Field Summary

Fields

Modifier and Type	Field	Description
protected Datasource	datasource_
protected boolean	excludeUnsupportedCapabilities_
protected String	sql_

Fields inherited from class rife.database.queries.AbstractWhereQuery

where_

Constructor Summary

Constructors

Constructor	Description
Update(Datasource datasource)

Method Summary

Modifier and Type	Method	Description
protected Update	_field(String field, Object value)
protected void	_fieldSubselect(Select query)
protected void	_tableSubselect(Select query)
protected void	_unionSubselect(Select query)
protected void	_whereSubselect(Select query)
protected void	addFieldParameter(String field)
protected void	addWhereParameter(String field)
void	addWhereParameters(List<String> parameters)
void	addWhereParameters(List<String> parameters)
void	clear()
protected void	clearGenerated()
protected void	clearWhereParameters()
Update	clone()
Update	field(String field, boolean value)
Update	field(String field, Object value)
Update	field(String field, Select query)
Update	fieldCustom(String field, String expression)
Update	fieldParameter(String field)
Update	fieldParameter(String field, String alias)
Update	fields(Object bean)
Update	fields(Object[] keyValues)
Update	fieldsExcluded(Object bean, String[] excludedFields)
Update	fieldsFiltered(Object bean, String[] includedFields, String[] excludedFields)
Update	fieldsIncluded(Object bean, String[] includedFields)
Update	fieldsParameters(Class beanClass)
Update	fieldsParametersExcluded(Class beanClass, String[] excludedFields)
Update	fieldSubselect(Select query)
rife.database.capabilities.Capabilities	getCapabilities()
Datasource	getDatasource()
Map<String,Object>	getFields()
String	getHint()
String	getLimitParameter()
String	getOffsetParameter()
QueryParameters	getParameters()
String	getSql()
String	getTable()
protected List<String>	getWhereParameters()
Update	hint(String hint)
protected boolean	isLimitBeforeOffset()
void	setExcludeUnsupportedCapabilities(boolean flag)
protected void	setLimitParameter(String limitParameter)
protected void	setOffsetParameter(String offsetParameter)
Update	table(String table)
String	toString()

Methods inherited from class rife.database.queries.AbstractWhereQuery

getWhere, startWhere, startWhereAnd, startWhereOr, where, where, where, where, where, whereAnd, whereAnd, whereAnd, whereAnd, whereExcluded, whereFiltered, whereIncluded, whereOr, whereOr, whereOr, whereOr, whereParameter, whereParameter, whereParameterAnd, whereParameterAnd, whereParameterOr, whereParameterOr, whereParameters, whereParametersExcluded, whereSubselect

Methods inherited from class java.lang.Object

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

Methods inherited from interface rife.database.queries.Query

setExcludeUnsupportedCapabilities

Field Details

datasource_

protected Datasource datasource_

sql_

protected String sql_

excludeUnsupportedCapabilities_

protected boolean excludeUnsupportedCapabilities_

Constructor Details

Update

public Update(Datasource datasource)

Method Details

clear

public void clear()

Specified by:

clear in interface Query

Overrides:

clear in class AbstractWhereQuery<Update>

getHint

public String getHint()

getTable

public String getTable()

getFields

public Map<String,Object> getFields()

getCapabilities

public rife.database.capabilities.Capabilities getCapabilities()

Specified by:

getCapabilities in interface Query

getSql

public String getSql()

Specified by:

getSql in interface Query

hint

public Update hint(String hint)

table

public Update table(String table)

fieldSubselect

public Update fieldSubselect(Select query)

_field

protected Update _field(String field,
 Object value)

fieldParameter

public Update fieldParameter(String field)

fieldParameter

public Update fieldParameter(String field,
 String alias)

field

public Update field(String field,
 boolean value)

field

public Update field(String field,
 Select query)

fieldCustom

public Update fieldCustom(String field,
 String expression)

field

public Update field(String field,
 Object value)

fields

public Update fields(Object[] keyValues)

fields

public Update fields(Object bean)
              throws DbQueryException

Throws:

DbQueryException

fieldsIncluded

public Update fieldsIncluded(Object bean,
 String[] includedFields)
                      throws DbQueryException

Throws:

DbQueryException

fieldsExcluded

public Update fieldsExcluded(Object bean,
 String[] excludedFields)
                      throws DbQueryException

Throws:

DbQueryException

fieldsFiltered

public Update fieldsFiltered(Object bean,
 String[] includedFields,
 String[] excludedFields)
                      throws DbQueryException

Throws:

DbQueryException

fieldsParameters

public Update fieldsParameters(Class beanClass)
                        throws DbQueryException

Throws:

DbQueryException

fieldsParametersExcluded

public Update fieldsParametersExcluded(Class beanClass,
 String[] excludedFields)
                                throws DbQueryException

Throws:

DbQueryException

clone

public Update clone()

Overrides:

clone in class AbstractWhereQuery<Update>

addWhereParameters

void addWhereParameters(List<String> parameters)

_fieldSubselect

protected void _fieldSubselect(Select query)

_tableSubselect

protected void _tableSubselect(Select query)

_whereSubselect

protected void _whereSubselect(Select query)

_unionSubselect

protected void _unionSubselect(Select query)

getParameters

public QueryParameters getParameters()

Specified by:

getParameters in interface Query

addFieldParameter

protected void addFieldParameter(String field)

clearWhereParameters

protected void clearWhereParameters()

addWhereParameter

protected void addWhereParameter(String field)

getWhereParameters

protected List<String> getWhereParameters()

addWhereParameters

public void addWhereParameters(List<String> parameters)

setLimitParameter

protected void setLimitParameter(String limitParameter)

getLimitParameter

public String getLimitParameter()

setOffsetParameter

protected void setOffsetParameter(String offsetParameter)

getOffsetParameter

public String getOffsetParameter()

isLimitBeforeOffset

protected boolean isLimitBeforeOffset()

getDatasource

public Datasource getDatasource()

setExcludeUnsupportedCapabilities

public void setExcludeUnsupportedCapabilities(boolean flag)

Specified by:

setExcludeUnsupportedCapabilities in interface Query

clearGenerated

protected void clearGenerated()

toString

public String toString()

Overrides:

toString in class Object