| Prev Class | Next Class | Frames | No Frames |
| Summary: Nested | Field | Method | Constr | Detail: Nested | Field | Method | Constr |
java.lang.Objectorg.exolab.castor.jdo.drivers.JDBCQueryExpressionNested Class Summary | |
(package private) static class | |
Field Summary | |
protected Vector | |
protected Vector | |
protected boolean | |
protected PersistenceFactory | |
protected Vector | |
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 |
|
protected boolean |
|
Object |
|
String |
|
protected String | |
protected StringBuffer |
|
String |
|
void |
|
String |
|
protected Vector _cols
protected Vector _conds
protected boolean _distinct
protected Vector _joins
protected String _limit
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)
- Specified by:
- addLimitClause 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)
This should work for JDBC drivers with a full support of JDBC specification.
- Specified by:
- getStatement in interface QueryExpression
public void setDistinct(boolean distinct)
- Specified by:
- setDistinct in interface QueryExpression
public String toString()