edu.jhu.tmaj.database.sql
Class AbstractModifySQL

java.lang.Object
  edu.jhu.tmaj.database.sql.ModifySQL
      edu.jhu.tmaj.database.sql.AbstractModifySQL

All Implemented Interfaces:

SQL

Direct Known Subclasses:

InsertSQL, UpdateSQL

public abstract class AbstractModifySQL
extends ModifySQL

The superclass of InsertSQL and updateSQL.

Constructor Summary

AbstractModifySQL(java.lang.String tableName)

Method Summary

void	addBoolean(java.lang.String columnName, java.lang.Boolean bool) Add/Change the value(s) in columnName to value for a bit column.
void	addDate(java.lang.String columnName, java.util.Date value) Add/Change the values in columnName to value for an date/time column.
void	addDateTime(java.lang.String columnname, java.util.Date date)
void	addDouble(java.lang.String columnName, java.lang.Double value) Add/Change the value(s) in columnName to value for a double column.
void	addFloat(java.lang.String columnName, java.lang.Float value)
void	addInputLog(int userID, java.lang.String application)
void	addInteger(java.lang.String columnName, java.lang.Integer value)
void	addLiteralValue(java.lang.String columnName, LiteralValue value)
void	addLong(java.lang.String columnName, java.lang.Long value) Add/Change the value(s) in columnName to value for an integer column.
void	addString(java.lang.String columnName, java.lang.String string) Add/Change the value(s) in columnName to value for a varchar column.
SQLValues	getSetSQLValues()

Methods inherited from class edu.jhu.tmaj.database.sql.ModifySQL

getTableName

Methods inherited from class java.lang.Object

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

Constructor Detail

AbstractModifySQL

public AbstractModifySQL(java.lang.String tableName)

Method Detail

addLiteralValue

public void addLiteralValue(java.lang.String columnName,
                            LiteralValue value)

addDate

public void addDate(java.lang.String columnName,
                    java.util.Date value)

Add/Change the values in columnName to value for an date/time column.

addDateTime

public void addDateTime(java.lang.String columnname,
                        java.util.Date date)

addDouble

public void addDouble(java.lang.String columnName,
                      java.lang.Double value)

Add/Change the value(s) in columnName to value for a double column.

addFloat

public void addFloat(java.lang.String columnName,
                     java.lang.Float value)

addLong

public void addLong(java.lang.String columnName,
                    java.lang.Long value)

Add/Change the value(s) in columnName to value for an integer column.

addInteger

public void addInteger(java.lang.String columnName,
                       java.lang.Integer value)

addString

public void addString(java.lang.String columnName,
                      java.lang.String string)

Add/Change the value(s) in columnName to value for a varchar column.

addBoolean

public void addBoolean(java.lang.String columnName,
                       java.lang.Boolean bool)

Add/Change the value(s) in columnName to value for a bit column.

addInputLog

public void addInputLog(int userID,
                        java.lang.String application)

getSetSQLValues

public SQLValues getSetSQLValues()