addCondition
public void addCondition(String tableName,
String columnName,
String condOp,
String value)
- addCondition in interface QueryExpression
addInnerJoin
public void addInnerJoin(String leftTable,
String leftColumn,
String rightTable,
String rightColumn)
- addInnerJoin in interface QueryExpression
addInnerJoin
public void addInnerJoin(String leftTable,
String leftColumn,
String leftTableAlias,
String rightTable,
String rightColumn,
String rightTableAlias)
- addInnerJoin in interface QueryExpression
addInnerJoin
public void addInnerJoin(String leftTable,
String[] leftColumn,
String leftTableAlias,
String rightTable,
String[] rightColumn,
String rightTableAlias)
- addInnerJoin in interface QueryExpression
addInnerJoin
public void addInnerJoin(String leftTable,
String[] leftColumn,
String rightTable,
String[] rightColumn)
- addInnerJoin in interface QueryExpression
addOuterJoin
public void addOuterJoin(String leftTable,
String leftColumn,
String rightTable,
String rightColumn)
- addOuterJoin in interface QueryExpression
addOuterJoin
public void addOuterJoin(String leftTable,
String leftColumn,
String rightTable,
String rightColumn,
String rightTableAlias)
- addOuterJoin in interface QueryExpression
addOuterJoin
public void addOuterJoin(String leftTable,
String[] leftColumn,
String rightTable,
String[] rightColumn)
- addOuterJoin in interface QueryExpression
addOuterJoin
public void addOuterJoin(String leftTable,
String[] leftColumn,
String rightTable,
String[] rightColumn,
String rightTableAlias)
- addOuterJoin in interface QueryExpression
addWhereClause
protected boolean addWhereClause(StringBuffer sql,
boolean first)
getColumnList
protected String getColumnList()
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); .
lock
- whether to lock selected tablesoj
- true in the first case above, false in the second case.
getStatement
public String getStatement(boolean lock)
This should work for JDBC drivers with a full support of JDBC specification.
- getStatement in interface QueryExpression
toString
public String toString()