org.hrorm

Class Where

java.lang.Object

org.hrorm.Where

All Implemented Interfaces:

Iterable<WherePredicate>, StatementPopulator

public class Where
extends Object
implements Iterable<WherePredicate>, StatementPopulator

Representation of a SQL where clause: a possibly nested list of predicates that describes which records in the database to match.

Field Summary

Fields

Modifier and Type	Field and Description
static Where	EMPTY

Constructor Summary

Constructors

Constructor and Description
Where()
Where(String columnName, Operator operator, BigDecimal value)
Where(String columnName, Operator operator, Boolean value)
Where(String columnName, Operator operator, LocalDateTime value)
Where(String columnName, Operator operator, Long value)
Where(String columnName, Operator operator, String value)
Where(Where subWhere)
Where(WherePredicate atom)

Method Summary

Modifier and Type	Method and Description
Where	and(String columnName, Operator operator, BigDecimal value)
Where	and(String columnName, Operator operator, Boolean value)
Where	and(String columnName, Operator operator, LocalDateTime value)
Where	and(String columnName, Operator operator, Long value)
Where	and(String columnName, Operator operator, String value)
Where	and(Where where)
org.hrorm.WherePredicateTree.WherePredicateNode	getRootNode()
static Where	isNotNull(String columnName)
static Where	isNull(String columnName)
Iterator<WherePredicate>	iterator()
Where	or(String columnName, Operator operator, BigDecimal value)
Where	or(String columnName, Operator operator, Boolean value)
Where	or(String columnName, Operator operator, LocalDateTime value)
Where	or(String columnName, Operator operator, Long value)
Where	or(String columnName, Operator operator, String value)
void	populate(PreparedStatement preparedStatement)
String	render()
static Where	where()
static Where	where(String columnName, Operator operator, BigDecimal value)
static Where	where(String columnName, Operator operator, Boolean value)
static Where	where(String columnName, Operator operator, LocalDateTime value)
static Where	where(String columnName, Operator operator, Long value)
static Where	where(String columnName, Operator operator, String value)
static Where	where(Where subWhere)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.lang.Iterable

forEach, spliterator

Field Detail

EMPTY

public static final Where EMPTY

Constructor Detail

Where

public Where()

Where

public Where(Where subWhere)

Where

public Where(WherePredicate atom)

Where

public Where(String columnName,
             Operator operator,
             Boolean value)

Where

public Where(String columnName,
             Operator operator,
             Long value)

Where

public Where(String columnName,
             Operator operator,
             String value)

Where

public Where(String columnName,
             Operator operator,
             BigDecimal value)

Where

public Where(String columnName,
             Operator operator,
             LocalDateTime value)

Method Detail

where

public static Where where()

where

public static Where where(String columnName,
                          Operator operator,
                          Boolean value)

where

public static Where where(String columnName,
                          Operator operator,
                          Long value)

where

public static Where where(String columnName,
                          Operator operator,
                          String value)

where

public static Where where(String columnName,
                          Operator operator,
                          BigDecimal value)

where

public static Where where(String columnName,
                          Operator operator,
                          LocalDateTime value)

where

public static Where where(Where subWhere)

and

public Where and(Where where)

and

public Where and(String columnName,
                 Operator operator,
                 Long value)

and

public Where and(String columnName,
                 Operator operator,
                 BigDecimal value)

and

public Where and(String columnName,
                 Operator operator,
                 String value)

and

public Where and(String columnName,
                 Operator operator,
                 LocalDateTime value)

and

public Where and(String columnName,
                 Operator operator,
                 Boolean value)

or

public Where or(String columnName,
                Operator operator,
                Long value)

or

public Where or(String columnName,
                Operator operator,
                BigDecimal value)

or

public Where or(String columnName,
                Operator operator,
                String value)

or

public Where or(String columnName,
                Operator operator,
                Boolean value)

or

public Where or(String columnName,
                Operator operator,
                LocalDateTime value)

isNull

public static Where isNull(String columnName)

isNotNull

public static Where isNotNull(String columnName)

render

public String render()

getRootNode

public org.hrorm.WherePredicateTree.WherePredicateNode getRootNode()

iterator

public Iterator<WherePredicate> iterator()

Specified by:

iterator in interface Iterable<WherePredicate>

populate

public void populate(PreparedStatement preparedStatement)
              throws SQLException

Specified by:

populate in interface StatementPopulator

Throws:

SQLException