Prev Class | Next Class | Frames | No Frames |
Summary: Nested | Field | Method | Constr | Detail: Nested | Field | Method | Constr |
java.lang.Object
org.exolab.castor.jdo.drivers.JDBCQueryExpression
Nested Class Summary | |
(package private) static class |
Field Summary | |
protected Vector | |
protected Vector | |
protected DbMetaInfo |
|
protected boolean | |
protected PersistenceFactory | |
protected Vector | |
protected String | |
protected String | |
protected String | |
protected String | |
protected Hashtable | |
protected String |
Fields inherited from interface org.exolab.castor.persist.spi.QueryExpression | |
OpBetween , OpBetweenAnd , OpEquals , OpGreater , OpGreaterEquals , OpLess , OpLessEquals , OpLike , OpNotEquals , OpNotLike |
Constructor Summary | |
|
Method Summary | |
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
protected boolean |
|
Object |
|
String |
|
protected String | |
protected StringBuffer |
|
String |
|
boolean |
|
boolean |
|
void |
|
void |
|
String |
|
protected Vector _cols
protected Vector _conds
protected boolean _distinct
protected Vector _joins
protected String _limit
protected String _offset
protected String _order
protected String _select
protected Hashtable _tables
protected String _where
public void addColumn(String tableName, String columnName)
- Specified by:
- addColumn in interface QueryExpression
public void addCondition(String tableName, String columnName, String condOp, String value)
- Specified by:
- addCondition in interface QueryExpression
public void addInnerJoin(String leftTable, String leftColumn, String rightTable, String rightColumn)
- Specified by:
- addInnerJoin in interface QueryExpression
public void addInnerJoin(String leftTable, String leftColumn, String leftTableAlias, String rightTable, String rightColumn, String rightTableAlias)
- Specified by:
- addInnerJoin in interface QueryExpression
public void addInnerJoin(String leftTable, String[] leftColumn, String leftTableAlias, String rightTable, String[] rightColumn, String rightTableAlias)
- Specified by:
- addInnerJoin in interface QueryExpression
public void addInnerJoin(String leftTable, String[] leftColumn, String rightTable, String[] rightColumn)
- Specified by:
- addInnerJoin in interface QueryExpression
public void addLimitClause(String limit) throws SyntaxNotSupportedException
- Specified by:
- addLimitClause in interface QueryExpression
public void addOffsetClause(String offset) throws SyntaxNotSupportedException
- Specified by:
- addOffsetClause in interface QueryExpression
public void addOrderClause(String order)
- Specified by:
- addOrderClause in interface QueryExpression
public void addOuterJoin(String leftTable, String leftColumn, String rightTable, String rightColumn)
- Specified by:
- addOuterJoin in interface QueryExpression
public void addOuterJoin(String leftTable, String leftColumn, String rightTable, String rightColumn, String rightTableAlias)
- Specified by:
- addOuterJoin in interface QueryExpression
public void addOuterJoin(String leftTable, String[] leftColumn, String rightTable, String[] rightColumn)
- Specified by:
- addOuterJoin in interface QueryExpression
public void addOuterJoin(String leftTable, String[] leftColumn, String rightTable, String[] rightColumn, String rightTableAlias)
- Specified by:
- addOuterJoin in interface QueryExpression
public void addParameter(String tableName, String columnName, String condOp)
- Specified by:
- addParameter in interface QueryExpression
public void addSelect(String selectClause)
- Specified by:
- addSelect in interface QueryExpression
public void addTable(String tableName, String tableAlias)
- Specified by:
- addTable in interface QueryExpression
public void addWhereClause(String where)
- Specified by:
- addWhereClause in interface QueryExpression
protected boolean addWhereClause(StringBuffer sql, boolean first)
public String encodeColumn(String tableName, String columnName)
- Specified by:
- encodeColumn in interface QueryExpression
protected String getColumnList()
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 tablesoj
- true in the first case above, false in the second case.
public String getStatement(boolean lock) throws SyntaxNotSupportedException
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 aSyntaxNotSupportedException
.
- Specified by:
- getStatement in interface QueryExpression
- Throws:
SyntaxNotSupportedException
- If the RDBMS does not support a particular feature.
public boolean isLimitClauseSupported()
Provides a default implementation ofQueryExpression.isLimitClauseSupported()
.
- Specified by:
- isLimitClauseSupported in interface QueryExpression
- Returns:
- false to indicate that this feature is not supported by default.
public boolean isOffsetClauseSupported()
Provides a default implementation ofQueryExpression.isOffsetClauseSupported()
.
- Specified by:
- isOffsetClauseSupported in interface QueryExpression
- Returns:
- false to indicate that this feature is not supported by default.
public void setDbMetaInfo(DbMetaInfo dbInfo)
Store database meta information
- Specified by:
- setDbMetaInfo in interface QueryExpression
- Parameters:
dbInfo
- DbMetaInfo instance
public void setDistinct(boolean distinct)
- Specified by:
- setDistinct in interface QueryExpression
public String toString()