net.ymate.platform.persistence.jdbc.query

Class Where

java.lang.Object

net.ymate.platform.persistence.jdbc.query.QueryHandleAdapter<Where>

net.ymate.platform.persistence.jdbc.query.Where

public final class Where
extends QueryHandleAdapter<Where>

Where条件及参数对象

Author:

刘镇 (suninformation@163.com) on 15/5/7 下午1:19

Constructor Summary

Constructors

Constructor and Description
Where(Cond cond)
Where(IDatabase owner, String dataSourceName)
Where(IDatabase owner, String dataSourceName, String whereCond)

Method Summary

Modifier and Type	Method and Description
Cond	cond()
static Where	create()
static Where	create(Cond cond)
static Where	create(IDatabase owner)
static Where	create(IDatabase owner, String whereCond)
static Where	create(Query<?> query)
static Where	create(String whereCond)
Slot	getSlot()
GroupBy	groupBy()
Where	groupBy(Fields fields)
Where	groupBy(Fields fields, boolean wrapIdentifier)
Where	groupBy(Fields fields, boolean desc, boolean wrapIdentifier)
Where	groupBy(GroupBy groupBy)
Where	groupBy(IFunction func)
Where	groupBy(IFunction func, boolean desc)
Where	groupBy(String field)
Where	groupBy(String field, boolean wrapIdentifier)
Where	groupBy(String field, boolean desc, boolean wrapIdentifier)
Where	groupBy(String prefix, Fields fields)
Where	groupBy(String prefix, Fields fields, boolean wrapIdentifier)
Where	groupBy(String prefix, Fields fields, boolean desc, boolean wrapIdentifier)
Where	groupBy(String prefix, String field)
Where	groupBy(String prefix, String field, boolean wrapIdentifier)
Where	groupBy(String prefix, String field, boolean desc, boolean wrapIdentifier)
Where	groupByDesc(Fields fields)
Where	groupByDesc(Fields fields, boolean wrapIdentifier)
Where	groupByDesc(IFunction func)
Where	groupByDesc(String field)
Where	groupByDesc(String field, boolean wrapIdentifier)
Where	groupByDesc(String prefix, Fields fields)
Where	groupByDesc(String prefix, Fields fields, boolean wrapIdentifier)
Where	groupByDesc(String prefix, String field)
Where	groupByDesc(String prefix, String field, boolean wrapIdentifier)
Where	groupByRollup()
Where	having(Cond cond)
OrderBy	orderBy()
Where	orderBy(OrderBy orderBy)
Where	orderByAsc(Fields fields)
Where	orderByAsc(Fields fields, boolean wrapIdentifier)
Where	orderByAsc(IFunction func)
Where	orderByAsc(String field)
Where	orderByAsc(String field, boolean wrapIdentifier)
Where	orderByAsc(String prefix, Fields fields)
Where	orderByAsc(String prefix, Fields fields, boolean wrapIdentifier)
Where	orderByAsc(String prefix, String field)
Where	orderByAsc(String prefix, String field, boolean wrapIdentifier)
Where	orderByDesc(Fields fields)
Where	orderByDesc(Fields fields, boolean wrapIdentifier)
Where	orderByDesc(IFunction func)
Where	orderByDesc(String field)
Where	orderByDesc(String field, boolean wrapIdentifier)
Where	orderByDesc(String prefix, Fields fields)
Where	orderByDesc(String prefix, Fields fields, boolean wrapIdentifier)
Where	orderByDesc(String prefix, String field)
Where	orderByDesc(String prefix, String field, boolean wrapIdentifier)
Where	param(Object param)
Where	param(Params params)
Params	params()
String	toSQL()
String	toString()
Where	where(Where where)

Methods inherited from class net.ymate.platform.persistence.jdbc.query.QueryHandleAdapter

getExpressionStr, queryHandler, queryHandler

Methods inherited from class java.lang.Object

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

Constructor Detail

Where

public Where(IDatabase owner,
             String dataSourceName)

Where

public Where(IDatabase owner,
             String dataSourceName,
             String whereCond)

Where

public Where(Cond cond)

Method Detail

create

public static Where create()

create

public static Where create(String whereCond)

create

public static Where create(IDatabase owner)

create

public static Where create(IDatabase owner,
                           String whereCond)

create

public static Where create(Cond cond)

create

public static Where create(Query<?> query)

where

public Where where(Where where)

cond

public Cond cond()

groupBy

public GroupBy groupBy()

orderBy

public OrderBy orderBy()

getSlot

public Slot getSlot()

params

public Params params()

Returns:

此方法仅返回只读参数集合, 若要维护参数请调用where().param(...)相关方法

param

public Where param(Object param)

param

public Where param(Params params)

groupByRollup

public Where groupByRollup()

groupBy

public Where groupBy(GroupBy groupBy)

groupBy

public Where groupBy(Fields fields)

groupBy

public Where groupBy(Fields fields,
                     boolean wrapIdentifier)

groupBy

public Where groupBy(Fields fields,
                     boolean desc,
                     boolean wrapIdentifier)

groupBy

public Where groupBy(String prefix,
                     Fields fields)

groupBy

public Where groupBy(String prefix,
                     Fields fields,
                     boolean wrapIdentifier)

groupBy

public Where groupBy(String prefix,
                     Fields fields,
                     boolean desc,
                     boolean wrapIdentifier)

groupBy

public Where groupBy(String field)

groupBy

public Where groupBy(String field,
                     boolean wrapIdentifier)

groupBy

public Where groupBy(String field,
                     boolean desc,
                     boolean wrapIdentifier)

groupBy

public Where groupBy(String prefix,
                     String field)

groupBy

public Where groupBy(String prefix,
                     String field,
                     boolean wrapIdentifier)

groupBy

public Where groupBy(String prefix,
                     String field,
                     boolean desc,
                     boolean wrapIdentifier)

groupBy

public Where groupBy(IFunction func)

groupBy

public Where groupBy(IFunction func,
                     boolean desc)

groupByDesc

public Where groupByDesc(Fields fields)

groupByDesc

public Where groupByDesc(Fields fields,
                         boolean wrapIdentifier)

groupByDesc

public Where groupByDesc(String prefix,
                         Fields fields)

groupByDesc

public Where groupByDesc(String prefix,
                         Fields fields,
                         boolean wrapIdentifier)

groupByDesc

public Where groupByDesc(String field)

groupByDesc

public Where groupByDesc(String field,
                         boolean wrapIdentifier)

groupByDesc

public Where groupByDesc(String prefix,
                         String field)

groupByDesc

public Where groupByDesc(String prefix,
                         String field,
                         boolean wrapIdentifier)

groupByDesc

public Where groupByDesc(IFunction func)

having

public Where having(Cond cond)

orderBy

public Where orderBy(OrderBy orderBy)

orderByAsc

public Where orderByAsc(Fields fields)

orderByAsc

public Where orderByAsc(Fields fields,
                        boolean wrapIdentifier)

orderByAsc

public Where orderByAsc(String prefix,
                        Fields fields)

orderByAsc

public Where orderByAsc(String prefix,
                        Fields fields,
                        boolean wrapIdentifier)

orderByAsc

public Where orderByAsc(String field)

orderByAsc

public Where orderByAsc(String field,
                        boolean wrapIdentifier)

orderByAsc

public Where orderByAsc(String prefix,
                        String field)

orderByAsc

public Where orderByAsc(String prefix,
                        String field,
                        boolean wrapIdentifier)

orderByAsc

public Where orderByAsc(IFunction func)

orderByDesc

public Where orderByDesc(Fields fields)

orderByDesc

public Where orderByDesc(Fields fields,
                         boolean wrapIdentifier)

orderByDesc

public Where orderByDesc(String prefix,
                         Fields fields)

orderByDesc

public Where orderByDesc(String prefix,
                         Fields fields,
                         boolean wrapIdentifier)

orderByDesc

public Where orderByDesc(String field)

orderByDesc

public Where orderByDesc(String field,
                         boolean wrapIdentifier)

orderByDesc

public Where orderByDesc(String prefix,
                         String field)

orderByDesc

public Where orderByDesc(String prefix,
                         String field,
                         boolean wrapIdentifier)

orderByDesc

public Where orderByDesc(IFunction func)

toSQL

public String toSQL()

toString

public String toString()

Overrides:

toString in class Object