org.h2.command.dml
Class Insert

java.lang.Object
  extended by org.h2.command.Prepared
      extended by org.h2.command.dml.Insert
All Implemented Interfaces:
ResultTarget

public class Insert
extends Prepared
implements ResultTarget

This class represents the statement INSERT


Field Summary
 
Fields inherited from class org.h2.command.Prepared
create, parameters, prepareAlways, session, sqlStatement
 
Constructor Summary
Insert(Session session)
           
 
Method Summary
 void addRow(Expression[] expr)
          Add a row to this merge statement.
 void addRow(Value[] values)
          Add the row to the result set.
 java.lang.String getPlanSQL()
          Get the SQL statement with the execution plan.
 int getRowCount()
          Get the number of rows.
 int getType()
          Get the command type as defined in CommandInterface
 boolean isTransactional()
          Check if this command is transactional.
 void prepare()
          Prepare this statement.
 ResultInterface queryMeta()
          Get an empty result set containing the meta data.
 void setColumns(Column[] columns)
           
 void setCommand(Command command)
          Set the command.
 void setInsertFromSelect(boolean value)
           
 void setQuery(Query query)
           
 void setSortedInsertMode(boolean sortedInsertMode)
           
 void setTable(Table table)
           
 int update()
          Execute the statement.
 
Methods inherited from class org.h2.command.Prepared
checkCanceled, checkParameters, getCurrentObjectId, getCurrentRowNumber, getObjectId, getParameters, getSQL, getSQL, getSQL, isCacheable, isQuery, isReadOnly, needRecompile, query, setCurrentRowNumber, setObjectId, setParameterList, setPrepareAlways, setRow, setSession, setSQL, toString
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

Insert

public Insert(Session session)
Method Detail

setCommand

public void setCommand(Command command)
Description copied from class: Prepared
Set the command.

Overrides:
setCommand in class Prepared
Parameters:
command - the new command

setTable

public void setTable(Table table)

setColumns

public void setColumns(Column[] columns)

setQuery

public void setQuery(Query query)

addRow

public void addRow(Expression[] expr)
Add a row to this merge statement.

Parameters:
expr - the list of values

update

public int update()
Description copied from class: Prepared
Execute the statement.

Overrides:
update in class Prepared
Returns:
the update count

addRow

public void addRow(Value[] values)
Description copied from interface: ResultTarget
Add the row to the result set.

Specified by:
addRow in interface ResultTarget
Parameters:
values - the values

getRowCount

public int getRowCount()
Description copied from interface: ResultTarget
Get the number of rows.

Specified by:
getRowCount in interface ResultTarget
Returns:
the number of rows

getPlanSQL

public java.lang.String getPlanSQL()
Description copied from class: Prepared
Get the SQL statement with the execution plan.

Overrides:
getPlanSQL in class Prepared
Returns:
the execution plan

prepare

public void prepare()
Description copied from class: Prepared
Prepare this statement.

Overrides:
prepare in class Prepared

isTransactional

public boolean isTransactional()
Description copied from class: Prepared
Check if this command is transactional. If it is not, then it forces the current transaction to commit.

Specified by:
isTransactional in class Prepared
Returns:
true if it is

queryMeta

public ResultInterface queryMeta()
Description copied from class: Prepared
Get an empty result set containing the meta data.

Specified by:
queryMeta in class Prepared
Returns:
the result set

setSortedInsertMode

public void setSortedInsertMode(boolean sortedInsertMode)

getType

public int getType()
Description copied from class: Prepared
Get the command type as defined in CommandInterface

Specified by:
getType in class Prepared
Returns:
the statement type

setInsertFromSelect

public void setInsertFromSelect(boolean value)