Uses of Interface
com.hp.util.sql.Expr

Packages that use Expr

Package	Description
com.hp.util.sql	A set of building blocks to facilitate the construction of SQL statements.

Uses of Expr in com.hp.util.sql

Classes in com.hp.util.sql that implement Expr

Modifier and Type	Class and Description
class	SqlStatement A class representing an SQL Statement.

Methods in com.hp.util.sql that return Expr

Modifier and Type	Method and Description
static Expr	SqlUtils.and(Collection<Expr> exprs) This method returns an expression that combines the sub-expressions with logical AND.
static Expr	SqlUtils.and(Expr... exprs) This method returns an expression that combines the sub-expressions with logical AND.
static Expr	SqlUtils.bool(String columnName, boolean value) This method returns an expression for the specified column name and boolean value.
static Expr[]	SqlUtils.exprWrap(Object... objs) This method returns the specified objects wrapped as expressions.
static Expr	SqlUtils.exprWrapQuoted(String s) This method returns the specified string wrapped as an expression of that string in single quotes.
static Expr	SqlUtils.in(String columnName, Collection<String> values) This method returns an IN expression for the specified column name and the given collection of string values, wrapping each value in single quotes.
static Expr	SqlUtils.in(String columnName, Expr... exprs) This method returns an IN expression for the specified column name and sub expressions.
static Expr	SqlUtils.leaf(String s) This is a temporary method which may go away in the future.
static Expr	SqlUtils.like(String columnName, String string) This method returns a LIKE expression for the specified column name and substring to match.
static Expr	SqlUtils.notIn(String columnName, Collection<String> values) This method returns a NOT IN expression for the specified column name and the given collection of string values, wrapping each value in single quotes.
static Expr	SqlUtils.notIn(String columnName, Expr... exprs) This method returns a NOT IN expression for the specified column name and sub expressions.
static Expr	SqlUtils.or(Collection<Expr> exprs) This method returns an expression that combines the sub-expressions with logical OR.
static Expr	SqlUtils.or(Expr... exprs) This method returns an expression that combines the sub-expressions with logical OR.

Methods in com.hp.util.sql with parameters of type Expr

Modifier and Type	Method and Description
static Expr	SqlUtils.and(Expr... exprs) This method returns an expression that combines the sub-expressions with logical AND.
static Expr	SqlUtils.in(String columnName, Expr... exprs) This method returns an IN expression for the specified column name and sub expressions.
static Expr	SqlUtils.notIn(String columnName, Expr... exprs) This method returns a NOT IN expression for the specified column name and sub expressions.
static Expr	SqlUtils.or(Expr... exprs) This method returns an expression that combines the sub-expressions with logical OR.
static SelectClause	SqlUtils.select(Expr e) Convenience method to create a select clause.
static SelectClause	SqlUtils.select(Expr e, String tableName) Convenience method to create a select clause.
static WhereClause	SqlUtils.where(Expr e) Convenience method to create a where clause.

Method parameters in com.hp.util.sql with type arguments of type Expr

Modifier and Type	Method and Description
static Expr	SqlUtils.and(Collection<Expr> exprs) This method returns an expression that combines the sub-expressions with logical AND.
static Expr	SqlUtils.or(Collection<Expr> exprs) This method returns an expression that combines the sub-expressions with logical OR.