com.is.jrf
Class OuterJoinTable

java.lang.Object
  |
  +--com.is.jrf.JoinTable
        |
        +--com.is.jrf.OuterJoinTable

public class OuterJoinTable

extends JoinTable

This class can be used in place of the JoinTable class since it is a subclass. Use it whenever you want an outer join instead of an inner join.

Fields inherited from class com.is.jrf.JoinTable

i_joinColumnNames, i_joinColumns, i_joinTables, i_mainColumnNames, i_tableAlias, i_tableName

Constructor Summary

OuterJoinTable(java.lang.String tableName, java.lang.String mainColumnNames, java.lang.String joinColumnNames)

Method Summary

protected java.lang.String	ansiJoinCommand() Return something like "JOIN" or "LEFT OUTER JOIN", etc...
protected java.lang.String	buildWhereJoin(java.lang.String mainColumnName, java.lang.String joinColumnName, DatabasePolicy dbPolicy) This method overrides the superclass method.

Methods inherited from class com.is.jrf.JoinTable

addJoinColumn, addJoinTable, buildANSIJoin, buildFromString, buildNonANSIJoin, buildSelectColumnString, copyColumnValuesToPersistentObject, getJoinColumnNames, getJoinColumns, getJoinTables, getMainColumnNames, getTableAlias, getTableName, setJoinColumnNames, setMainColumnNames, setTableAlias, setTableName

Methods inherited from class java.lang.Object

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

Constructor Detail

OuterJoinTable

public OuterJoinTable(java.lang.String tableName,
                      java.lang.String mainColumnNames,
                      java.lang.String joinColumnNames)

Method Detail

ansiJoinCommand

protected java.lang.String ansiJoinCommand()

Return something like "JOIN" or "LEFT OUTER JOIN", etc... Subclasses should override.

Overrides:

ansiJoinCommand in class JoinTable

Returns:

a value of type 'String'

buildWhereJoin

protected java.lang.String buildWhereJoin(java.lang.String mainColumnName,
                                          java.lang.String joinColumnName,
                                          DatabasePolicy dbPolicy)

This method overrides the superclass method. It returns a name/value pair that can be used in a where clause for a non-standard join. Return value example: T1.id = T2.id(+) (Oracle)

Overrides:

buildWhereJoin in class JoinTable

Parameters:

mainColumnName - a value of type 'String'

joinColumnName - a value of type 'String'

dbPolicy - a value of type 'DatabasePolicy'

Returns:

a value of type 'String'