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

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


addSetNull

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


addSetNull

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


addSetNull

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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


addSet

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

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

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


addSet

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


addSet

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


addSetDateTime

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


addSetDateTime

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


addSetDateTime

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


addSetTime

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

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

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


addSetDate

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


addSetDate

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


addSetDate

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


addSet

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

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

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.