Package rife.database.queries

Class Insert

java.lang.Object

rife.database.queries.Insert

All Implemented Interfaces:

Cloneable, Query

public class Insert
extends Object
implements Cloneable

Object representation of a SQL "INSERT" 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_

Constructor Summary

Constructors

Constructor	Description
Insert(Datasource datasource)

Method Summary

Modifier and Type	Method	Description
protected Insert	_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	clear()
protected void	clearGenerated()
protected void	clearWhereParameters()
Insert	clone()
Insert	field(String field, boolean value)
Insert	field(String field, Object value)
Insert	field(String field, Select query)
Insert	fieldCustom(String field, String expression)
Insert	fieldParameter(String field)
Insert	fieldParameter(String field, String alias)
Insert	fieldParameterCustom(String field, String expression)
Insert	fieldParameterCustom(String field, String alias, String expression)
Insert	fields(Object bean)
Insert	fields(Object[] keyValues)
Insert	fieldsExcluded(Object bean, String[] excludedFields)
Insert	fieldsFiltered(Object bean, String[] includedFields, String[] excludedFields)
Insert	fieldsIncluded(Object bean, String[] includedFields)
Insert	fieldsParameters(Class beanClass)
Insert	fieldsParametersExcluded(Class beanClass, String[] excludedFields)
Insert	fieldSubselect(Select query)
rife.database.capabilities.Capabilities	getCapabilities()
Datasource	getDatasource()
Map<String,List<Object>>	getFields()
String	getHint()
String	getInto()
String	getLimitParameter()
String	getOffsetParameter()
QueryParameters	getParameters()
String	getSql()
protected List<String>	getWhereParameters()
Insert	hint(String hint)
Insert	into(String into)
protected boolean	isLimitBeforeOffset()
void	setExcludeUnsupportedCapabilities(boolean flag)
protected void	setLimitParameter(String limitParameter)
protected void	setOffsetParameter(String offsetParameter)
String	toString()

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

Insert

public Insert(Datasource datasource)

Method Details

clear

public void clear()

Specified by:

clear in interface Query

getHint

public String getHint()

getInto

public String getInto()

getFields

public Map<String,List<Object>> getFields()

getCapabilities

public rife.database.capabilities.Capabilities getCapabilities()

Specified by:

getCapabilities in interface Query

getSql

public String getSql()
              throws DbQueryException

Specified by:

getSql in interface Query

Throws:

DbQueryException

hint

public Insert hint(String hint)

into

public Insert into(String into)

fieldSubselect

public Insert fieldSubselect(Select query)

_field

protected Insert _field(String field,
 Object value)

fieldParameter

public Insert fieldParameter(String field)

fieldParameter

public Insert fieldParameter(String field,
 String alias)

fieldParameterCustom

public Insert fieldParameterCustom(String field,
 String expression)

fieldParameterCustom

public Insert fieldParameterCustom(String field,
 String alias,
 String expression)

field

public Insert field(String field,
 boolean value)

field

public Insert field(String field,
 Select query)

field

public Insert field(String field,
 Object value)

fieldCustom

public Insert fieldCustom(String field,
 String expression)

fields

public Insert fields(Object[] keyValues)

fields

public Insert fields(Object bean)
              throws DbQueryException

Throws:

DbQueryException

fieldsIncluded

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

Throws:

DbQueryException

fieldsExcluded

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

Throws:

DbQueryException

fieldsFiltered

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

Throws:

DbQueryException

fieldsParameters

public Insert fieldsParameters(Class beanClass)
                        throws DbQueryException

Throws:

DbQueryException

fieldsParametersExcluded

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

Throws:

DbQueryException

clone

public Insert clone()

_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