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