org.jpox.store.query
Class QueryStatement.Join

java.lang.Object
  org.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).

Overrides:

toString in class java.lang.Object

Returns:

The join statement