org.jpox.store.query
Class QueryStatement.Join

java.lang.Object
  extended byorg.jpox.store.query.QueryStatement.Join
Enclosing class:
QueryStatement

public static class QueryStatement.Join
extends java.lang.Object

A join in a query. Supports ANSI-92, or ANSI-86 style joins. Provides the FROM clause only.


Field Summary
static int INNER_JOIN
          INNER JOIN
static int LEFT_OUTER_JOIN
          LEFT OUTER JOIN
static int RIGHT_OUTER_JOIN
          RIGHT OUTER JOIN
 
Constructor Summary
QueryStatement.Join(int type, ScalarExpression expr1, ScalarExpression expr2, LogicSetExpression tblExpr)
          Constructor generating ANSI-92 style join.
QueryStatement.Join(ScalarExpression expr1, ScalarExpression expr2, LogicSetExpression tblExpr)
          Constructor generating ANSI-86 style join.
 
Method Summary
 java.lang.String toString()
          Accessor for the join statement FROM clause (ANSI-92).
 java.lang.String toString(RDBMSAdapter rdbmsAdapter, boolean lock)
          Method to return the FROM clause to add.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

INNER_JOIN

public static final int INNER_JOIN
INNER JOIN

See Also:
Constant Field Values

LEFT_OUTER_JOIN

public static final int LEFT_OUTER_JOIN
LEFT OUTER JOIN

See Also:
Constant Field Values

RIGHT_OUTER_JOIN

public static final int RIGHT_OUTER_JOIN
RIGHT OUTER JOIN

See Also:
Constant Field Values
Constructor Detail

QueryStatement.Join

public QueryStatement.Join(int type,
                           ScalarExpression expr1,
                           ScalarExpression expr2,
                           LogicSetExpression tblExpr)
Constructor generating ANSI-92 style join. This creates a FROM clause like "INNER JOIN TABLE1 ON THIS.COL1 = TABLE1.COL2"

Parameters:
type - Type of Join
expr1 - left side expression
expr2 - right side expression
tblExpr - Table expression for the table to apply the join

QueryStatement.Join

public QueryStatement.Join(ScalarExpression expr1,
                           ScalarExpression expr2,
                           LogicSetExpression tblExpr)
Constructor generating ANSI-86 style join.

Parameters:
expr1 - left side expression
expr2 - right side expression
tblExpr - Table expression
Method Detail

toString

public java.lang.String toString(RDBMSAdapter rdbmsAdapter,
                                 boolean lock)
Method to return the FROM clause to add. This outputs the ANSI-92 style FROM clause.

Parameters:
rdbmsAdapter - The datastore adapter
lock - Whether to lock the query statement
Returns:
The FROM clause of this join

toString

public java.lang.String toString()
Accessor for the join statement FROM clause (ANSI-92).

Returns:
The join statement


Copyright © -2007 . All Rights Reserved.