com.jdc.rdb.sql.dml.insert
Class Values

java.lang.Object
  |
  +--com.jdc.lang.Object
        |
        +--com.jdc.rdb.sql.SQLClause
              |
              +--com.jdc.rdb.sql.dml.DMLClause
                    |
                    +--com.jdc.rdb.sql.dml.insert.Values

All Implemented Interfaces:

Clause, InsertClause, Serializable

public class Values

extends DMLClause

implements InsertClause

Values represents an Insert SQL statement VALUES clause. The VALUES clause provides a row of values to be inserted. The number of values for a row must equal the number of Column names in the Columns list. The first value is inserted in the first column in the list, the second value in the second column, and so on.

Invoke one of the addValue methods as many times as is required to create a list of Column values. Optionally, you may invoke addValue(Object) to add an Object value to the Values list. Refer to SQLClauseHelper.formatValue(Object) for a list of Object types supported.

Reference:

IBM® DB2 Universal Database™ SQL Reference Volume 2 Version 8, Page 605.

Note:

Expressions are not currently supported.

Version:

2.0

Author:

Jay Damon

See Also:

Insert, Serialized Form

Field Summary

Fields inherited from class com.jdc.rdb.sql.dml.DMLClause

sqlClause

Fields inherited from class com.jdc.lang.Object

string

Constructor Summary

Values()
Constructs a new Values clause object.

Values(String columnValues)
Constructs a new Values clause object for the specified Database Table Column values.

Method Summary

Values	addValue(boolean value) Adds a Column boolean value to the list of Column values.
Values	addValue(double value) Adds a Column float or double value to the list of Column values.
Values	addValue(long value) Adds a Column int or long value to the list of Column values.
Values	addValue(Object value) Adds a Column value to the list of Column values.
String	getKeyword() Returns the Values clause keyword.
String	getValue() Returns the Values clause.
void	setValue(String value) Sets the Values clause.
String	toString() Returns a String representation of this Values clause.

Methods inherited from class com.jdc.rdb.sql.dml.DMLClause

getKeyword

Methods inherited from class com.jdc.rdb.sql.SQLClause

contains, setKeyword

Methods inherited from class java.lang.Object

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

Constructor Detail

Values

public Values()

Constructs a new Values clause object.

Values

public Values(String columnValues)

Constructs a new Values clause object for the specified Database Table Column values.

Throws:

SQLInvalidException - No Column values are specified.

See Also:

#addValue(String, Object)

Method Detail

addValue

public Values addValue(boolean value)

Adds a Column boolean value to the list of Column values. The list of Column values is used to create the Values clause. Invoke this method as many times as is required to create a list of Column values.

Returns:

This Values clause object.

addValue

public Values addValue(long value)

Adds a Column int or long value to the list of Column values. The list of Column values is used to create the Values clause. Invoke this method as many times as is required to create a list of Column values.

Returns:

This Values clause object.

addValue

public Values addValue(double value)

Adds a Column float or double value to the list of Column values. The list of Column values is used to create the Values clause. Invoke this method as many times as is required to create a list of Column values.

Returns:

This Values clause object.

addValue

public Values addValue(Object value)

Adds a Column value to the list of Column values. The list of Column values is used to create the Values clause. Invoke this method as many times as is required to create a list of Column values.

Returns:

This Values clause object.

getKeyword

public String getKeyword()

Returns the Values clause keyword.

Overrides:

getKeyword in class SQLClause

Returns:

The Values clause keyword.

getValue

public String getValue()

Returns the Values clause.

Overrides:

getValue in class SQLClause

Returns:

The Values clause.

setValue

public void setValue(String value)

Sets the Values clause. Use this method to specify a custom Values clause.

Overrides:

setValue in class SQLClause

toString

public String toString()

Returns a String representation of this Values clause.

Specified by:

toString in interface InsertClause

Overrides:

toString in class SQLClause

Returns:

A String representation of this Values clause.