Package top.codef.sqlfilter

Class CommonFilter

java.lang.Object

top.codef.sqlfilter.CommonFilter

Direct Known Subclasses:

TypedCommonFilter

public class CommonFilter
extends Object

Field Summary

Fields

Modifier and Type	Field	Description
protected final List<GroupCondition>	groupingBy
protected final List<JoinCondition>	joinList
protected Integer	limitCount
protected Integer	limitStart
protected final List<FilterCondition>	list
protected final List<OrderCondition>	orderList
protected final List<SelectCondition>	selectors
protected final List<Element<? extends Object>>	updatableList

Constructor Summary

Constructors

Constructor	Description
CommonFilter()

Method Summary

Modifier and Type	Method	Description
<T extends Comparable<T>> CommonFilter	between(String field, T minValue, T maxValue)
protected <T> boolean	checkNotNull(T value)
<T> CommonFilter	eq(String field, T value)
CommonFilter	eqFeild(String field1, String field2)
<T extends Number> CommonFilter	ge(String field, T value)
List<GroupCondition>	getGroupingBy()
List<JoinCondition>	getJoinList()
Integer	getLimitCount()
Integer	getLimitStart()
List<FilterCondition>	getList()
List<OrderCondition>	getOrderList()
List<SelectCondition>	getSelectors()
List<Element<? extends Object>>	getUpdatableList()
CommonFilter	groupBy(String... fields)
<T extends Number> CommonFilter	gt(String field, T value)
boolean	hasLimit()
<T> CommonFilter	in(String field, Collection<T> value)
<T> CommonFilter	in(String field, T... value)
CommonFilter	innerJoin(String field)
<T> CommonFilter	isNotNull(String field)
CommonFilter	isNull(String field)
<T extends Number> CommonFilter	le(String field, T value)
CommonFilter	leftJoin(String table)
CommonFilter	like(String field, String value)
CommonFilter	limit(int limit)
CommonFilter	limit(int limitStart, int limitCount)
<T extends Number> CommonFilter	lt(String field, T value)
CommonFilter	neq(String field1, String Field2)
<T> CommonFilter	neq(String field, T value)
<T> CommonFilter	notIn(String field, Collection<T> value)
<T> CommonFilter	notIn(String field, T... value)
CommonFilter	orderByAsc(String... fields)
CommonFilter	orderByDesc(String... fields)
CommonFilter	rightJoin(String table)
CommonFilter	select(String... selectField)
CommonFilter	select(Collection<String> selectField)
CommonFilter	select(SelectCondition... elements)
void	setLimitCount(Integer limitCount)
void	setLimitStart(Integer limitStart)
<T> CommonFilter	update(String field, T value)

Methods inherited from class java.lang.Object

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

Field Details

updatableList

protected final List<Element<? extends Object>> updatableList

list

protected final List<FilterCondition> list

joinList

protected final List<JoinCondition> joinList

orderList

protected final List<OrderCondition> orderList

selectors

protected final List<SelectCondition> selectors

groupingBy

protected final List<GroupCondition> groupingBy

limitCount

protected Integer limitCount

limitStart

protected Integer limitStart

Constructor Details

CommonFilter

public CommonFilter()

Method Details

checkNotNull

protected <T> boolean checkNotNull(T value)

getList

public List<FilterCondition> getList()

getSelectors

public List<SelectCondition> getSelectors()

getJoinList

public List<JoinCondition> getJoinList()

getOrderList

public List<OrderCondition> getOrderList()

getGroupingBy

public List<GroupCondition> getGroupingBy()

update

public <T> CommonFilter update(String field,
 T value)

getUpdatableList

public List<Element<? extends Object>> getUpdatableList()

eq

public <T> CommonFilter eq(String field,
 T value)

eqFeild

public CommonFilter eqFeild(String field1,
 String field2)

neq

public <T> CommonFilter neq(String field,
 T value)

neq

public CommonFilter neq(String field1,
 String Field2)

like

public CommonFilter like(String field,
 String value)

isNull

public CommonFilter isNull(String field)

isNotNull

public <T> CommonFilter isNotNull(String field)

in

public <T> CommonFilter in(String field,
 Collection<T> value)

in

public <T> CommonFilter in(String field,
 T... value)

notIn

public <T> CommonFilter notIn(String field,
 Collection<T> value)

notIn

public <T> CommonFilter notIn(String field,
 T... value)

lt

public <T extends Number> CommonFilter lt(String field,
 T value)

le

public <T extends Number> CommonFilter le(String field,
 T value)

gt

public <T extends Number> CommonFilter gt(String field,
 T value)

ge

public <T extends Number> CommonFilter ge(String field,
 T value)

between

public <T extends Comparable<T>> CommonFilter between(String field,
 T minValue,
 T maxValue)

orderByAsc

public CommonFilter orderByAsc(String... fields)

orderByDesc

public CommonFilter orderByDesc(String... fields)

groupBy

public CommonFilter groupBy(String... fields)

select

public CommonFilter select(String... selectField)

select

public CommonFilter select(SelectCondition... elements)

select

public CommonFilter select(Collection<String> selectField)

innerJoin

public CommonFilter innerJoin(String field)

leftJoin

public CommonFilter leftJoin(String table)

rightJoin

public CommonFilter rightJoin(String table)

limit

public CommonFilter limit(int limit)

limit

public CommonFilter limit(int limitStart,
 int limitCount)

hasLimit

public boolean hasLimit()

getLimitCount

public Integer getLimitCount()

Returns:

the limitCount

setLimitCount

public void setLimitCount(Integer limitCount)

Parameters:

limitCount - the limitCount to set

getLimitStart

public Integer getLimitStart()

Returns:

the limitStart

setLimitStart

public void setLimitStart(Integer limitStart)

Parameters:

limitStart - the limitStart to set