JDSA
Class Oracle_8i_SQL_Assistant

java.lang.Object
  |
  +--JDSA.Oracle_8i_SQL_Assistant

All Implemented Interfaces:

java.lang.Cloneable, JAVA_Dynamic_SQL_Assistant_API

public class Oracle_8i_SQL_Assistant

extends java.lang.Object

implements JAVA_Dynamic_SQL_Assistant_API, java.lang.Cloneable

Field Summary

boolean	Distinct
boolean	Error
boolean	InsertClauseExists
boolean	InsertSelectExists

Method Summary

void	addGroupFunctionToSelect(java.lang.String Function, java.lang.String Column)
void	addListToWhere(java.lang.String AND_OR, java.lang.String Column, java.lang.String Condition, java.lang.String ValueComparison, java.lang.String List)
void	addOtherOperatorToWhere(java.lang.String AND_OR, java.lang.String Column, java.lang.String Condition, java.lang.String Value)
void	addToFrom(java.lang.String Table)
void	addToFrom(java.lang.String Table, java.lang.String As)
void	addToGroupBy(java.lang.String Column)
void	addToHaving(java.lang.String AND_OR, java.lang.String Function, java.lang.String Column, java.lang.String Condition, double Value)
void	addToHaving(java.lang.String AND_OR, java.lang.String Function, java.lang.String Column, java.lang.String Condition, long Value)
void	addToHaving(java.lang.String AND_OR, java.lang.String Function, java.lang.String Column, java.lang.String Condition, java.lang.String Value)
void	addToInsert(java.lang.String Column, double Value)
void	addToInsert(java.lang.String Column, long Value)
void	addToInsert(java.lang.String Column, java.lang.String Value)
void	addToInsertSelect(java.lang.String SelectStatement)
void	addToListOfValues(double Value)
void	addToListOfValues(long Value)
void	addToListOfValues(java.lang.String Value)
void	addToOrderBy(java.lang.String Column, java.lang.String Direction)
void	addToSelect(java.lang.String Column)
void	addToUpdate(java.lang.String Column, double Value)
void	addToUpdate(java.lang.String Column, long Value)
void	addToUpdate(java.lang.String Column, java.lang.String Value)
void	addToWhere(java.lang.String AND_OR, java.lang.String Column, java.lang.String Condition, double Value)
void	addToWhere(java.lang.String AND_OR, java.lang.String Column, java.lang.String Condition, long Value)
void	addToWhere(java.lang.String AND_OR, java.lang.String Column, java.lang.String Condition, java.lang.String Value)
java.lang.Object	clone()
java.lang.String	getDelete()
java.lang.String	getGroupBy()
java.lang.String	getInsert()
java.lang.String	getListOfValues()
java.lang.String	getOrderBy()
java.lang.String	getSelect()
java.lang.String	getUpdate()
java.lang.String	getWhere()
void	Initialize()
void	join(java.lang.String User1, java.lang.String Table1, java.lang.String Column1, java.lang.String Condition, java.lang.String User2, java.lang.String Table2, java.lang.String Column2)
void	setDistinct()
void	setTable(java.lang.String Table)
void	setUser(java.lang.String User)

Methods inherited from class java.lang.Object

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

Field Detail

InsertClauseExists

public boolean InsertClauseExists

InsertSelectExists

public boolean InsertSelectExists

Error

public boolean Error

Distinct

public boolean Distinct

Method Detail

clone

public java.lang.Object clone()

Overrides:

clone in class java.lang.Object

Initialize

public void Initialize()

Specified by:

Initialize in interface JAVA_Dynamic_SQL_Assistant_API

setUser

public void setUser(java.lang.String User)

Specified by:

setUser in interface JAVA_Dynamic_SQL_Assistant_API

setTable

public void setTable(java.lang.String Table)

Specified by:

setTable in interface JAVA_Dynamic_SQL_Assistant_API

addToFrom

public void addToFrom(java.lang.String Table)
               throws JDSA.outOfOrderException

Specified by:

addToFrom in interface JAVA_Dynamic_SQL_Assistant_API

JDSA.outOfOrderException

addToFrom

public void addToFrom(java.lang.String Table,
                      java.lang.String As)
               throws JDSA.outOfOrderException

Specified by:

addToFrom in interface JAVA_Dynamic_SQL_Assistant_API

JDSA.outOfOrderException

addToListOfValues

public void addToListOfValues(java.lang.String Value)

Specified by:

addToListOfValues in interface JAVA_Dynamic_SQL_Assistant_API

addToListOfValues

public void addToListOfValues(long Value)

Specified by:

addToListOfValues in interface JAVA_Dynamic_SQL_Assistant_API

addToListOfValues

public void addToListOfValues(double Value)

Specified by:

addToListOfValues in interface JAVA_Dynamic_SQL_Assistant_API

getListOfValues

public java.lang.String getListOfValues()

Specified by:

getListOfValues in interface JAVA_Dynamic_SQL_Assistant_API

setDistinct

public void setDistinct()

Specified by:

setDistinct in interface JAVA_Dynamic_SQL_Assistant_API

addToSelect

public void addToSelect(java.lang.String Column)
                 throws JDSA.outOfOrderException

Specified by:

addToSelect in interface JAVA_Dynamic_SQL_Assistant_API

JDSA.outOfOrderException

addGroupFunctionToSelect

public void addGroupFunctionToSelect(java.lang.String Function,
                                     java.lang.String Column)
                              throws JDSA.outOfOrderException

Specified by:

addGroupFunctionToSelect in interface JAVA_Dynamic_SQL_Assistant_API

JDSA.outOfOrderException

getSelect

public java.lang.String getSelect()

Specified by:

getSelect in interface JAVA_Dynamic_SQL_Assistant_API

addToInsert

public void addToInsert(java.lang.String Column,
                        java.lang.String Value)
                 throws JDSA.outOfOrderException

Specified by:

addToInsert in interface JAVA_Dynamic_SQL_Assistant_API

JDSA.outOfOrderException

addToInsert

public void addToInsert(java.lang.String Column,
                        long Value)
                 throws JDSA.outOfOrderException

Specified by:

addToInsert in interface JAVA_Dynamic_SQL_Assistant_API

JDSA.outOfOrderException

addToInsert

public void addToInsert(java.lang.String Column,
                        double Value)
                 throws JDSA.outOfOrderException

Specified by:

addToInsert in interface JAVA_Dynamic_SQL_Assistant_API

JDSA.outOfOrderException

addToInsertSelect

public void addToInsertSelect(java.lang.String SelectStatement)
                       throws JDSA.outOfOrderException,
                              JDSA.nessecaryElementDoesNotExistException

Specified by:

addToInsertSelect in interface JAVA_Dynamic_SQL_Assistant_API

JDSA.outOfOrderException

JDSA.nessecaryElementDoesNotExistException

getInsert

public java.lang.String getInsert()

Specified by:

getInsert in interface JAVA_Dynamic_SQL_Assistant_API

getDelete

public java.lang.String getDelete()
                           throws JDSA.outOfOrderException

Specified by:

getDelete in interface JAVA_Dynamic_SQL_Assistant_API

JDSA.outOfOrderException

addToUpdate

public void addToUpdate(java.lang.String Column,
                        java.lang.String Value)

Specified by:

addToUpdate in interface JAVA_Dynamic_SQL_Assistant_API

addToUpdate

public void addToUpdate(java.lang.String Column,
                        long Value)

Specified by:

addToUpdate in interface JAVA_Dynamic_SQL_Assistant_API

addToUpdate

public void addToUpdate(java.lang.String Column,
                        double Value)

Specified by:

addToUpdate in interface JAVA_Dynamic_SQL_Assistant_API

getUpdate

public java.lang.String getUpdate()
                           throws JDSA.outOfOrderException

Specified by:

getUpdate in interface JAVA_Dynamic_SQL_Assistant_API

JDSA.outOfOrderException

join

public void join(java.lang.String User1,
                 java.lang.String Table1,
                 java.lang.String Column1,
                 java.lang.String Condition,
                 java.lang.String User2,
                 java.lang.String Table2,
                 java.lang.String Column2)

Specified by:

join in interface JAVA_Dynamic_SQL_Assistant_API

addToWhere

public void addToWhere(java.lang.String AND_OR,
                       java.lang.String Column,
                       java.lang.String Condition,
                       java.lang.String Value)

Specified by:

addToWhere in interface JAVA_Dynamic_SQL_Assistant_API

addToWhere

public void addToWhere(java.lang.String AND_OR,
                       java.lang.String Column,
                       java.lang.String Condition,
                       long Value)

Specified by:

addToWhere in interface JAVA_Dynamic_SQL_Assistant_API

addToWhere

public void addToWhere(java.lang.String AND_OR,
                       java.lang.String Column,
                       java.lang.String Condition,
                       double Value)

Specified by:

addToWhere in interface JAVA_Dynamic_SQL_Assistant_API

addListToWhere

public void addListToWhere(java.lang.String AND_OR,
                           java.lang.String Column,
                           java.lang.String Condition,
                           java.lang.String ValueComparison,
                           java.lang.String List)

Specified by:

addListToWhere in interface JAVA_Dynamic_SQL_Assistant_API

addOtherOperatorToWhere

public void addOtherOperatorToWhere(java.lang.String AND_OR,
                                    java.lang.String Column,
                                    java.lang.String Condition,
                                    java.lang.String Value)

Specified by:

addOtherOperatorToWhere in interface JAVA_Dynamic_SQL_Assistant_API

getWhere

public java.lang.String getWhere()

Specified by:

getWhere in interface JAVA_Dynamic_SQL_Assistant_API

addToHaving

public void addToHaving(java.lang.String AND_OR,
                        java.lang.String Function,
                        java.lang.String Column,
                        java.lang.String Condition,
                        java.lang.String Value)
                 throws JDSA.badSyntaxException

Specified by:

addToHaving in interface JAVA_Dynamic_SQL_Assistant_API

JDSA.badSyntaxException

addToHaving

public void addToHaving(java.lang.String AND_OR,
                        java.lang.String Function,
                        java.lang.String Column,
                        java.lang.String Condition,
                        long Value)
                 throws JDSA.badSyntaxException

JDSA.badSyntaxException

addToHaving

public void addToHaving(java.lang.String AND_OR,
                        java.lang.String Function,
                        java.lang.String Column,
                        java.lang.String Condition,
                        double Value)
                 throws JDSA.badSyntaxException

JDSA.badSyntaxException

addToOrderBy

public void addToOrderBy(java.lang.String Column,
                         java.lang.String Direction)
                  throws JDSA.badSyntaxException

Specified by:

addToOrderBy in interface JAVA_Dynamic_SQL_Assistant_API

JDSA.badSyntaxException

getOrderBy

public java.lang.String getOrderBy()

Specified by:

getOrderBy in interface JAVA_Dynamic_SQL_Assistant_API

addToGroupBy

public void addToGroupBy(java.lang.String Column)

Specified by:

addToGroupBy in interface JAVA_Dynamic_SQL_Assistant_API

getGroupBy

public java.lang.String getGroupBy()

Specified by:

getGroupBy in interface JAVA_Dynamic_SQL_Assistant_API