com.ibm.tivoli.maximo.dbmanage.statement

Class InsertSql

java.lang.Object

com.ibm.tivoli.maximo.dbmanage.statement.InsertSql

public class InsertSql
extends java.lang.Object

Creates an insert statement, given list of column names and values for those columns.

Author:

John_Neville

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	InsertSql.CurrentDateTime special replacement when creating insert

Constructor Summary

Constructors

Constructor and Description
InsertSql(java.lang.String table, java.sql.Connection connection) Constructor

Method Summary

Modifier and Type	Method and Description
void	addColumnStringValue(java.lang.String column, java.lang.String value) Add a string column value for the insert.
void	addColumnValue(java.lang.String column, java.lang.Object value) Add a column value for the insert.
java.lang.Integer	addedUniqueIdPosition()
void	addHexColumnValue(java.lang.String column, java.lang.String value)
void	changeTable(java.lang.String table) Change the target table of the insert.
java.lang.String	generateInsertSelectSql() Returns SQL in the form of: "insert into () select from " Add " where " to complete the select-for-insert statement.
java.lang.String	generateInsertSql() Produce the insert statement given the data given.
java.lang.String	getAddedUid()
java.lang.String	getAddedUidSequence()
void	setColumnValues(AttributeStorage sequenceDef) Set values from the AttributeStorage object.

Methods inherited from class java.lang.Object

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

Constructor Detail

InsertSql

public InsertSql(java.lang.String table,
                 java.sql.Connection connection)
          throws java.sql.SQLException

Constructor

Parameters:

table - Name of the table to insert into.

serverType - Type of database server to create the insert for.

Throws:

MXException

java.sql.SQLException

Method Detail

addColumnValue

public void addColumnValue(java.lang.String column,
                           java.lang.Object value)

Add a column value for the insert. Calling this a second time for the same value will replace the earlier value. Null value will remove the column from the insert.

Parameters:

column - The name of the column.

value - The value can be a String (which will be quoted), a Boolean (converted to 0 or 1), a CurrentDateTime (depends on server), or other (toString() will be used.)

addColumnStringValue

public void addColumnStringValue(java.lang.String column,
                                 java.lang.String value)

Add a string column value for the insert. The value will be quote correctly.

Parameters:

column - The name of the column.

value - The value string, which will be formatted with quotes and internal double single quotes.

generateInsertSql

public java.lang.String generateInsertSql()
                                   throws java.sql.SQLException

Produce the insert statement given the data given.

Returns:

The insert sql.

Throws:

MXException

MXException

java.sql.SQLException

generateInsertSelectSql

public java.lang.String generateInsertSelectSql()
                                         throws java.sql.SQLException

Returns SQL in the form of: "insert into () select from " Add " where " to complete the select-for-insert statement.

Throws:

MXException

java.sql.SQLException

changeTable

public void changeTable(java.lang.String table)

Change the target table of the insert. Good when you need to insert into MaxObject & MaxObjectCFG.

Parameters:

table - Name of new table to generate an insert for.

setColumnValues

public void setColumnValues(AttributeStorage sequenceDef)

Set values from the AttributeStorage object. All not-null values will be set. Strings will be quoted.

Parameters:

sequenceDef -

addHexColumnValue

public void addHexColumnValue(java.lang.String column,
                              java.lang.String value)

addedUniqueIdPosition

public java.lang.Integer addedUniqueIdPosition()
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getAddedUidSequence

public java.lang.String getAddedUidSequence()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getAddedUid

public java.lang.String getAddedUid()
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

Skip navigation links

• Overview
• Package
• Class
• Use
• Tree
• Deprecated
• Index
• Help

• Prev Class
• Next Class

• Frames
• No Frames

• All Classes

• Summary:
• Nested |
• Field |
• Constr |
• Method

• Detail:
• Field |
• Constr |
• Method