org.axiondb.engine.commands

Class InsertCommand

java.lang.Object

org.axiondb.engine.commands.BaseAxionCommand

org.axiondb.engine.commands.InsertCommand

All Implemented Interfaces:

AxionCommand

public class InsertCommand
extends BaseAxionCommand

An INSERT statement.

Version:

$Revision: 1.59 $ $Date: 2005/12/22 09:02:29 $

Field Summary

Fields

Modifier and Type	Field and Description
static int	WHEN_ALL
static int	WHEN_FIRST

Constructor Summary

Constructors

Constructor and Description
InsertCommand()
InsertCommand(TableIdentifier table, java.util.List columns, AxionCommand subSelect)
InsertCommand(TableIdentifier table, java.util.List columns, boolean defaultVAlues)
InsertCommand(TableIdentifier table, java.util.List columns, java.util.List values)
InsertCommand(TableIdentifier table, java.util.List columns, SubSelectCommand subSelect)

Method Summary

Modifier and Type	Method and Description
void	addInsertIntoClause(DMLWhenClause when, TableIdentifier table, java.util.List columns, java.util.List values)
protected void	buildBindVariables()
boolean	execute(Database database) Executes an SQL statement that may return multiple results.
AxionResultSet	executeQuery(Database database) Unsupported, use executeUpdate(org.axiondb.Database)instead.
int	executeUpdate(Database db) Executes an SQL that may add, delete or modify zero or more rows within the database, such as an INSERT, UPDATE or DELETE statement.
java.util.Iterator	getColumnIterator()
TableIdentifier	getTable()
java.util.Iterator	getValueIterator()
boolean	isInsertIntoListEmpty()
protected void	resolve(Database db)
void	setElseClause(TableIdentifier table, java.util.List tableColumns, java.util.List tableValues)
void	setMultiTableEvaluationMode(int mode)
void	setSubSelect(SubSelectCommand select)

Methods inherited from class org.axiondb.engine.commands.BaseAxionCommand

assertNotReadOnly, attemptToConvertValue, bindAll, clearBindings, createResolveSelectableVisitor, executeQuery, getBindVariableIterator, getBindVariableIterator, getBindVariables, getBindVariableVisitor, getColIdentifierList, getCommitSize, getEffectedRowCount, getResultSet, getRowIterator, makeRowDecorator, populateDefaultValues, populateSequenceColumns, resolveGeneratedColumns, resolveGeneratedColumns, resolveSelectable, resolveSelectable, resolveSelectableList, resolveSelectableList, setBindVariableVisitor, setDeferAllConstraintIfRequired, setEffectedRowCount, setResultSet, updateGeneratedValues

Methods inherited from class java.lang.Object

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

Field Detail

WHEN_ALL

public static final int WHEN_ALL

See Also:

Constant Field Values

WHEN_FIRST

public static final int WHEN_FIRST

See Also:

Constant Field Values

Constructor Detail

InsertCommand

public InsertCommand()

InsertCommand

public InsertCommand(TableIdentifier table,
                     java.util.List columns,
                     AxionCommand subSelect)

InsertCommand

public InsertCommand(TableIdentifier table,
                     java.util.List columns,
                     SubSelectCommand subSelect)

InsertCommand

public InsertCommand(TableIdentifier table,
                     java.util.List columns,
                     java.util.List values)

Parameters:

table - The table in which to insert

columns - List of ColumnIdentifiers, which may be null

values - List of Objects, which may be null

Throws:

InvalidArgumentException - if columns.size() > 0 && columns.size() != values.size()

InsertCommand

public InsertCommand(TableIdentifier table,
                     java.util.List columns,
                     boolean defaultVAlues)

Method Detail

addInsertIntoClause

public void addInsertIntoClause(DMLWhenClause when,
                                TableIdentifier table,
                                java.util.List columns,
                                java.util.List values)

isInsertIntoListEmpty

public final boolean isInsertIntoListEmpty()

execute

public boolean execute(Database database)
                throws AxionException

Description copied from interface: AxionCommand

Executes an SQL statement that may return multiple results.

Returns:

true if one or more ResultSets were generated, false otherwise

Throws:

AxionException

See Also:

Statement.execute(java.lang.String), PreparedStatement.execute()

executeQuery

public AxionResultSet executeQuery(Database database)
                            throws AxionException

Unsupported, use executeUpdate(org.axiondb.Database)instead.

Returns:

the generated ResultSet

Throws:

java.lang.UnsupportedOperationException

AxionException

See Also:

Statement.executeQuery(java.lang.String), PreparedStatement.executeQuery()

executeUpdate

public int executeUpdate(Database db)
                  throws AxionException

Description copied from interface: AxionCommand

Executes an SQL that may add, delete or modify zero or more rows within the database, such as an INSERT, UPDATE or DELETE statement. In addition, SQL statements that return nothing, such as SQL DDL statements, can be executed via this method.

Returns:

the number of rows modified

Throws:

AxionException

See Also:

Statement.executeUpdate(java.lang.String), PreparedStatement.executeUpdate()

getColumnIterator

public final java.util.Iterator getColumnIterator()

getTable

public final TableIdentifier getTable()

getValueIterator

public final java.util.Iterator getValueIterator()

setElseClause

public void setElseClause(TableIdentifier table,
                          java.util.List tableColumns,
                          java.util.List tableValues)

setMultiTableEvaluationMode

public void setMultiTableEvaluationMode(int mode)

setSubSelect

public void setSubSelect(SubSelectCommand select)

buildBindVariables

protected void buildBindVariables()

Overrides:

buildBindVariables in class BaseAxionCommand

resolve

protected void resolve(Database db)
                throws AxionException

Throws:

AxionException