java.lang.Object
javatools.db.DbExpr
javatools.db.DbCriterion
javatools.db.DbOrExpr
- All Implemented Interfaces:
- DbTableUser
- public class DbOrExpr
- extends DbCriterion
An expression of the form A OR B. The reason we have this class as well as
DbCriterion, is that this class will optimise away unnecessary segments.
i.e. A OR FALSE will be optimised to just A. The reason you may find a FALSE
expression in your code is the use of DbDatabase.falseExpr(). This is a very
convenient thing for dynamically generated queries.
Of course we could just leave the dummy false 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.
- Version:
- 0.7
| 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 |
DbOrExpr
public DbOrExpr(DbDatabase db,
java.lang.Object o1,
java.lang.Object o2)
- Creates a new OR expression.
setSqlValues
public int setSqlValues(java.sql.PreparedStatement ps,
int i)
throws java.sql.SQLException,
DbException
- Puts data into a statement.
- Overrides:
setSqlValues in class DbCriterion
getQueryString
public java.lang.String getQueryString()
throws DbException
- Returns the query string related to this expression.
- Overrides:
getQueryString in class DbCriterion
JAVADOC | 
SOURCE | 
DOWNLOAD | NESTED | FIELD | CONSTR | METHOD