public class ANSIJoinFragment extends JoinFragment
FULL_JOIN, INNER_JOIN, LEFT_OUTER_JOIN, RIGHT_OUTER_JOIN| Constructor and Description | 
|---|
ANSIJoinFragment()  | 
| Modifier and Type | Method and Description | 
|---|---|
boolean | 
addCondition(String condition)
Adds a free-form condition fragment 
 | 
void | 
addCondition(String alias,
            String[] columns,
            String condition)
Adds a condition to the join fragment. 
 | 
void | 
addCondition(String alias,
            String[] fkColumns,
            String[] pkColumns)
Adds a condition to the join fragment. 
 | 
void | 
addCrossJoin(String tableName,
            String alias)
Adds a cross join to the specified table. 
 | 
void | 
addFromFragmentString(String fromFragmentString)
Adds an externally built join fragment. 
 | 
void | 
addJoin(String tableName,
       String alias,
       String[] fkColumns,
       String[] pkColumns,
       JoinType joinType)
Adds a join, represented by the given information, to the fragment. 
 | 
void | 
addJoin(String rhsTableName,
       String rhsAlias,
       String[] lhsColumns,
       String[] rhsColumns,
       JoinType joinType,
       String on)
Adds a join, represented by the given information, to the fragment. 
 | 
void | 
addJoins(String fromFragment,
        String whereFragment)
Free-form form of adding theta-style joins taking the necessary FROM and WHERE clause fragments 
 | 
JoinFragment | 
copy()
Make a copy. 
 | 
String | 
toFromFragmentString()
Render this fragment to its FROM clause portion 
 | 
String | 
toWhereFragmentString()
Render this fragment to its WHERE clause portion 
 | 
addCondition, addFragment, hasFilterCondition, hasThetaJoins, setHasFilterCondition, setHasThetaJoinspublic void addJoin(String tableName, String alias, String[] fkColumns, String[] pkColumns, JoinType joinType)
addJoin in class JoinFragmenttableName - The name of the table being joined.alias - The alias applied to the table being joined.fkColumns - The columns (from the table being joined) used to define the join-restriction (the ON)pkColumns - The columns (from the table being joined to) used to define the join-restriction (the ON)joinType - The type of join to produce (INNER, etc).public void addJoin(String rhsTableName, String rhsAlias, String[] lhsColumns, String[] rhsColumns, JoinType joinType, String on)
addJoin in class JoinFragmentrhsTableName - The name of the table being joined (the RHS table).rhsAlias - The alias applied to the table being joined (the alias for the RHS table).lhsColumns - The columns (from the table being joined) used to define the join-restriction (the ON).  These
 are the LHS columns, and are expected to be qualified.rhsColumns - The columns (from the table being joined to) used to define the join-restriction (the ON).  These
 are the RHS columns and are expected to *not* be qualified.joinType - The type of join to produce (INNER, etc).on - Any extra join restrictionspublic String toFromFragmentString()
JoinFragmenttoFromFragmentString in class JoinFragmentpublic String toWhereFragmentString()
JoinFragmenttoWhereFragmentString in class JoinFragmentpublic void addJoins(String fromFragment, String whereFragment)
JoinFragmentaddJoins in class JoinFragmentfromFragment - The FROM clause fragmentwhereFragment - The WHERE clause fragmentpublic JoinFragment copy()
JoinFragmentcopy in class JoinFragmentpublic void addCondition(String alias, String[] columns, String condition)
[alias.[column] = [condition]alias - The alias to apply to column(s)columns - The columns to apply restrictioncondition - The restriction conditionpublic void addCrossJoin(String tableName, String alias)
JoinFragmentaddCrossJoin in class JoinFragmenttableName - The name of the table to be joinedalias - The alias to apply to the joined tablepublic void addCondition(String alias, String[] fkColumns, String[] pkColumns)
JoinFragmentaddCondition in class JoinFragmentalias - The alias of the joined tablefkColumns - The names of the columns which reference the joined tablepkColumns - The columns in the joined table being referencedpublic boolean addCondition(String condition)
JoinFragmentaddCondition in class JoinFragmentcondition - The fragmenttrue if the condition was addedpublic void addFromFragmentString(String fromFragmentString)
fromFragmentString - The join fragment stringCopyright © 2001-2015 Red Hat, Inc. All Rights Reserved.