org.exolab.castor.jdo.drivers

Class JDBCQueryExpression

public class JDBCQueryExpression extends Object implements QueryExpression

Version: $Revision: 6230 $ $Date: 2006-04-10 16:39:24 -0600 (Mon, 10 Apr 2006) $

Nested Class Summary
static class	JDBCQueryExpression.Join

Field Summary
protected Vector	_cols
protected Vector	_conds
protected DbMetaInfo	_dbInfo MetaInfo as acquired from the RDBMS
protected boolean	_distinct
protected PersistenceFactory	_factory
protected Vector	_joins
protected String	_limit
protected String	_offset
protected String	_order
protected String	_select
protected Hashtable	_tables
protected String	_where

Constructor Summary
	JDBCQueryExpression(PersistenceFactory factory)

Method Summary
void	addColumn(String tableName, String columnName)
void	addCondition(String tableName, String columnName, String condOp, String value)
void	addInnerJoin(String leftTable, String leftColumn, String rightTable, String rightColumn)
void	addInnerJoin(String leftTable, String leftColumn, String leftTableAlias, String rightTable, String rightColumn, String rightTableAlias)
void	addInnerJoin(String leftTable, String[] leftColumn, String rightTable, String[] rightColumn)
void	addInnerJoin(String leftTable, String[] leftColumn, String leftTableAlias, String rightTable, String[] rightColumn, String rightTableAlias)
void	addLimitClause(String limit)
void	addOffsetClause(String offset)
void	addOrderClause(String order)
void	addOuterJoin(String leftTable, String leftColumn, String rightTable, String rightColumn)
void	addOuterJoin(String leftTable, String leftColumn, String rightTable, String rightColumn, String rightTableAlias)
void	addOuterJoin(String leftTable, String[] leftColumn, String rightTable, String[] rightColumn)
void	addOuterJoin(String leftTable, String[] leftColumn, String rightTable, String[] rightColumn, String rightTableAlias)
void	addParameter(String tableName, String columnName, String condOp)
void	addSelect(String selectClause)
void	addTable(String tableName)
void	addTable(String tableName, String tableAlias)
void	addWhereClause(String where)
protected boolean	addWhereClause(StringBuffer sql, boolean first)
Object	clone()
String	encodeColumn(String tableName, String columnName)
protected String	getColumnList()
protected StringBuffer	getStandardStatement(boolean lock, boolean oj) Helper method.
String	getStatement(boolean lock) Creates a SQL statement.
boolean	isLimitClauseSupported() Provides a default implementation of isLimitClauseSupported.
boolean	isOffsetClauseSupported() Provides a default implementation of isOffsetClauseSupported.
void	setDbMetaInfo(DbMetaInfo dbInfo) Store database meta information
void	setDistinct(boolean distinct)
String	toString()

Field Detail

_dbInfo

protected DbMetaInfo _dbInfo

MetaInfo as acquired from the RDBMS

Constructor Detail

JDBCQueryExpression

public JDBCQueryExpression(PersistenceFactory factory)

Method Detail

addColumn

public void addColumn(String tableName, String columnName)

addCondition

public void addCondition(String tableName, String columnName, String condOp, String value)

addInnerJoin

public void addInnerJoin(String leftTable, String leftColumn, String rightTable, String rightColumn)

addInnerJoin

public void addInnerJoin(String leftTable, String leftColumn, String leftTableAlias, String rightTable, String rightColumn, String rightTableAlias)

addInnerJoin

public void addInnerJoin(String leftTable, String[] leftColumn, String rightTable, String[] rightColumn)

addInnerJoin

public void addInnerJoin(String leftTable, String[] leftColumn, String leftTableAlias, String rightTable, String[] rightColumn, String rightTableAlias)

addLimitClause

public void addLimitClause(String limit)

addOffsetClause

public void addOffsetClause(String offset)

addOrderClause

public void addOrderClause(String order)

addOuterJoin

public void addOuterJoin(String leftTable, String leftColumn, String rightTable, String rightColumn)

addOuterJoin

public void addOuterJoin(String leftTable, String leftColumn, String rightTable, String rightColumn, String rightTableAlias)

addOuterJoin

public void addOuterJoin(String leftTable, String[] leftColumn, String rightTable, String[] rightColumn)

addOuterJoin

public void addOuterJoin(String leftTable, String[] leftColumn, String rightTable, String[] rightColumn, String rightTableAlias)

addParameter

public void addParameter(String tableName, String columnName, String condOp)

addSelect

public void addSelect(String selectClause)

addTable

public void addTable(String tableName, String tableAlias)

addWhereClause

public void addWhereClause(String where)

addWhereClause

protected boolean addWhereClause(StringBuffer sql, boolean first)

encodeColumn

public String encodeColumn(String tableName, String columnName)

getStandardStatement

protected StringBuffer getStandardStatement(boolean lock, boolean oj)

Helper method. Can be used in two cases: 1) for JDBC drivers which support "{oj ...OUTER JOIN ...}" notation (in accordance with JDBC specification); 2) for the databases which support "... OUTER JOIN ..." notation (in accordance with SQL-92 standard); .

Parameters: lock whether to lock selected tables oj true in the first case above, false in the second case.

getStatement

public String getStatement(boolean lock)

Creates a SQL statement. In general, for a RDBMS/JDBC driver with a full support of the SQL standard/JDBC specification, this will return a valid SQL statement. For some features, a particular RDBMS might indicate that it does not support this feature by throwing a SyntaxNotSupportedException.

Throws: SyntaxNotSupportedException If the RDBMS does not support a particular feature.

isLimitClauseSupported

public boolean isLimitClauseSupported()

Provides a default implementation of isLimitClauseSupported.

Returns: false to indicate that this feature is not supported by default.

isOffsetClauseSupported

public boolean isOffsetClauseSupported()

Provides a default implementation of isOffsetClauseSupported.

Returns: false to indicate that this feature is not supported by default.

setDbMetaInfo

public void setDbMetaInfo(DbMetaInfo dbInfo)

Store database meta information

Parameters: dbInfo DbMetaInfo instance

setDistinct

public void setDistinct(boolean distinct)

toString

public String toString()