org.apache.ws.jaxme.sqls
Interface SetStatement

All Superinterfaces:
Statement
All Known Subinterfaces:
InsertStatement, UpdateStatement
All Known Implementing Classes:
InsertStatementImpl, SetStatementImpl, UpdateStatementImpl

public interface SetStatement
extends Statement

A common base interface for InsertStatement and UpdateStatement.


Nested Class Summary
static interface SetStatement.SetValue
          A tupel of column name and value being assigned.
 
Method Summary
 void addSet(Column.Name pColumn)
          Adds a SET clause setting the given column to a value given by a placeholder.
 void addSet(Column.Name pColumn, boolean pValue)
          Adds a SET clause setting the given column to the value TRUE or FALSE, depending on pValue.
 void addSet(Column.Name pColumn, byte pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(Column.Name pColumn, float pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(Column.Name pColumn, int pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(Column.Name pColumn, long pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(Column.Name pColumn, java.lang.Object pObject)
          Adds a SET clause setting the given column to the given value.
 void addSet(Column.Name pColumn, short pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(Column.Name pColumn, java.lang.String pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(Column pColumn)
          Adds a SET clause setting the given column to a value given by a placeholder.
 void addSet(Column pColumn, boolean pValue)
          Adds a SET clause setting the given column to the value TRUE or FALSE, depending on pValue.
 void addSet(Column pColumn, byte pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(Column pColumn, float pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(Column pColumn, int pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(Column pColumn, long pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(Column pColumn, java.lang.Object pObject)
          Adds a SET clause setting the given column to the given value.
 void addSet(Column pColumn, short pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(Column pColumn, java.lang.String pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(java.lang.String pColumn)
          Adds a SET clause setting the given column to a value given by a placeholder.
 void addSet(java.lang.String pColumn, boolean pValue)
          Adds a SET clause setting the given column to the value TRUE or FALSE, depending on pValue.
 void addSet(java.lang.String pColumn, byte pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(java.lang.String pColumn, float pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(java.lang.String pColumn, int pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(java.lang.String pColumn, long pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(java.lang.String pColumn, java.lang.Object pObject)
          Adds a SET clause setting the given column to the given value.
 void addSet(java.lang.String pColumn, short pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSet(java.lang.String pColumn, java.lang.String pValue)
          Adds a SET clause setting the given column to the value pValue.
 void addSetDate(Column.Name pColumn, java.util.Calendar pValue)
          Adds a SET clause setting the given column to the date value pValue.
 void addSetDate(Column pColumn, java.util.Calendar pValue)
          Adds a SET clause setting the given column to the date value pValue.
 void addSetDate(java.lang.String pColumn, java.util.Calendar pValue)
          Adds a SET clause setting the given column to the date value pValue.
 void addSetDateTime(Column.Name pColumn, java.util.Calendar pValue)
          Adds a SET clause setting the given column to the datetime value pValue.
 void addSetDateTime(Column pColumn, java.util.Calendar pValue)
          Adds a SET clause setting the given column to the datetime value pValue.
 void addSetDateTime(java.lang.String pColumn, java.util.Calendar pValue)
          Adds a SET clause setting the given column to the datetime value pValue.
 void addSetNull(Column.Name pColumn)
          Adds a SET clause setting the given column to NULL.
 void addSetNull(Column pColumn)
          Adds a SET clause setting the given column to NULL.
 void addSetNull(java.lang.String pColumn)
          Adds a SET clause setting the given column to NULL.
 void addSetTime(Column.Name pColumn, java.util.Calendar pValue)
          Adds a SET clause setting the given column to the time value pValue.
 void addSetTime(Column pColumn, java.util.Calendar pValue)
          Adds a SET clause setting the given column to the time value pValue.
 void addSetTime(java.lang.String pColumn, java.util.Calendar pValue)
          Adds a SET clause setting the given column to the time value pValue.
 java.util.Iterator getSetValues()
          Returns an Iterator to all values being set.
 
Methods inherited from interface org.apache.ws.jaxme.sqls.Statement
createFunction, getSQLFactory, getTableReference, newCase, setTable
 

Method Detail

getSetValues

public java.util.Iterator getSetValues()
Returns an Iterator to all values being set. Any element in the iterator is an instance of SetStatement.SetValue.


addSetNull

public void addSetNull(Column pColumn)
Adds a SET clause setting the given column to NULL.


addSetNull

public void addSetNull(Column.Name pColumn)
Adds a SET clause setting the given column to NULL.


addSetNull

public void addSetNull(java.lang.String pColumn)
Adds a SET clause setting the given column to NULL.


addSet

public void addSet(Column pColumn)
Adds a SET clause setting the given column to a value given by a placeholder.


addSet

public void addSet(Column.Name pColumn)
Adds a SET clause setting the given column to a value given by a placeholder.


addSet

public void addSet(java.lang.String pColumn)
Adds a SET clause setting the given column to a value given by a placeholder.


addSet

public void addSet(Column pColumn,
                   byte pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(Column.Name pColumn,
                   byte pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(java.lang.String pColumn,
                   byte pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(Column pColumn,
                   short pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(Column.Name pColumn,
                   short pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(java.lang.String pColumn,
                   short pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(Column pColumn,
                   int pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(Column.Name pColumn,
                   int pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(java.lang.String pColumn,
                   int pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(Column pColumn,
                   long pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(Column.Name pColumn,
                   long pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(java.lang.String pColumn,
                   long pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(Column pColumn,
                   float pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(Column.Name pColumn,
                   float pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(java.lang.String pColumn,
                   float pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(Column pColumn,
                   boolean pValue)
Adds a SET clause setting the given column to the value TRUE or FALSE, depending on pValue.


addSet

public void addSet(Column.Name pColumn,
                   boolean pValue)
Adds a SET clause setting the given column to the value TRUE or FALSE, depending on pValue.


addSet

public void addSet(java.lang.String pColumn,
                   boolean pValue)
Adds a SET clause setting the given column to the value TRUE or FALSE, depending on pValue.


addSet

public void addSet(Column pColumn,
                   java.lang.String pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(Column.Name pColumn,
                   java.lang.String pValue)
Adds a SET clause setting the given column to the value pValue.


addSet

public void addSet(java.lang.String pColumn,
                   java.lang.String pValue)
Adds a SET clause setting the given column to the value pValue.


addSetDateTime

public void addSetDateTime(Column pColumn,
                           java.util.Calendar pValue)
Adds a SET clause setting the given column to the datetime value pValue.


addSetDateTime

public void addSetDateTime(Column.Name pColumn,
                           java.util.Calendar pValue)
Adds a SET clause setting the given column to the datetime value pValue.


addSetDateTime

public void addSetDateTime(java.lang.String pColumn,
                           java.util.Calendar pValue)
Adds a SET clause setting the given column to the datetime value pValue.


addSetTime

public void addSetTime(Column pColumn,
                       java.util.Calendar pValue)
Adds a SET clause setting the given column to the time value pValue. Shortcut for addSet(getTable().newColumnReference(pColumn), pValue).


addSetTime

public void addSetTime(Column.Name pColumn,
                       java.util.Calendar pValue)
Adds a SET clause setting the given column to the time value pValue. Shortcut for addSet(getTable().newColumnReference(pColumn), pValue).


addSetTime

public void addSetTime(java.lang.String pColumn,
                       java.util.Calendar pValue)
Adds a SET clause setting the given column to the time value pValue.


addSetDate

public void addSetDate(Column pColumn,
                       java.util.Calendar pValue)
Adds a SET clause setting the given column to the date value pValue.


addSetDate

public void addSetDate(Column.Name pColumn,
                       java.util.Calendar pValue)
Adds a SET clause setting the given column to the date value pValue.


addSetDate

public void addSetDate(java.lang.String pColumn,
                       java.util.Calendar pValue)
Adds a SET clause setting the given column to the date value pValue.


addSet

public void addSet(Column pColumn,
                   java.lang.Object pObject)
Adds a SET clause setting the given column to the given value. The value may be, for example, a subselect, a function, or a piece of raw SQL code.


addSet

public void addSet(java.lang.String pColumn,
                   java.lang.Object pObject)
Adds a SET clause setting the given column to the given value. The value may be, for example, a subselect, a function, or a piece of raw SQL code.


addSet

public void addSet(Column.Name pColumn,
                   java.lang.Object pObject)
Adds a SET clause setting the given column to the given value. The value may be, for example, a subselect, a function, or a piece of raw SQL code.