java.lang.Object
javatools.db.DbExpr
javatools.db.DbCriterion
javatools.db.DbAndExpr
- All Implemented Interfaces:
- DbTableUser
- public class DbAndExpr
- extends DbCriterion
An expression of the form A AND B. The reason we have this class as well as
DbCriterion, is that this class will optimise away unnecessary segments.
i.e. A AND TRUE will be optimised to just A. The reason you may find a
TRUE expression in your code is the use of DbDatabase.trueExpr().
Of course we could just leave the dummy true expressions in the final SQL
and presumably the dbms can optimise it away fine, but it looks a bit ugly
and nasty to have these dummy expressions in the result.
| Fields inherited from class javatools.db.DbExpr |
db |
| Methods inherited from class javatools.db.DbExpr |
and, containsAllStrings, containsAllStrings, count, dateTrunc, equal, getString, greaterThan, greaterThanOrEqual, in, in, isNotNull, isNull, lessThan, lessThanOrEqual, like, lower, max, min, notEqual, notIn, notIn, or, setSqlValue, upper, usesTables |
| Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
DbAndExpr
public DbAndExpr(DbDatabase db,
java.lang.Object o1,
java.lang.Object o2)
- Builds a new "and" expression in the form "o1 AND o2".
getQueryString
public java.lang.String getQueryString()
throws DbException
- Returns the query string related to this expression.
- Overrides:
getQueryString in class DbCriterion
setSqlValues
public int setSqlValues(java.sql.PreparedStatement ps,
int i)
throws java.sql.SQLException,
DbException
- Obscure... Talk to Chris.
- Overrides:
setSqlValues in class DbCriterion
JAVADOC | 
SOURCE | 
DOWNLOAD | NESTED | FIELD | CONSTR | METHOD