JDSA
Interface JAVA_Dynamic_SQL_Assistant_API

All Known Implementing Classes:

Oracle_8i_SQL_Assistant

public interface JAVA_Dynamic_SQL_Assistant_API

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, 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.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)

Method Detail

Initialize

public void Initialize()

setUser

public void setUser(java.lang.String User)

setTable

public void setTable(java.lang.String Table)

addToFrom

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

JDSA.outOfOrderException

addToFrom

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

JDSA.outOfOrderException

addToListOfValues

public void addToListOfValues(java.lang.String Value)

addToListOfValues

public void addToListOfValues(long Value)

addToListOfValues

public void addToListOfValues(double Value)

getListOfValues

public java.lang.String getListOfValues()

setDistinct

public void setDistinct()

addToSelect

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

JDSA.outOfOrderException

addGroupFunctionToSelect

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

JDSA.outOfOrderException

getSelect

public java.lang.String getSelect()

addToInsert

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

JDSA.outOfOrderException

addToInsert

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

JDSA.outOfOrderException

addToInsert

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

JDSA.outOfOrderException

addToInsertSelect

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

JDSA.outOfOrderException

JDSA.nessecaryElementDoesNotExistException

getInsert

public java.lang.String getInsert()

getDelete

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

JDSA.outOfOrderException

addToUpdate

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

addToUpdate

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

addToUpdate

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

getUpdate

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

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)

addToWhere

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

addToWhere

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

addToWhere

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

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)

addOtherOperatorToWhere

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

getWhere

public java.lang.String getWhere()

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

JDSA.badSyntaxException

addToOrderBy

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

JDSA.badSyntaxException

getOrderBy

public java.lang.String getOrderBy()

addToGroupBy

public void addToGroupBy(java.lang.String Column)

getGroupBy

public java.lang.String getGroupBy()