cn.schoolwow.quickdao.condition

接口 Condition<T>

所有已知实现类:

AbstractCondition, SqliteCondition

public interface Condition<T>

方法概要

限定符和类型	方法和说明
Condition	addAggerate(String aggerate, String field) 添加聚合字段
Condition	addAggerate(String aggerate, String field, String alias) 添加聚合字段
Condition	addColumn(String field)
Condition	addInQuery(String field, List values) 添加范围语句
Condition	addInQuery(String field, Object[] values) 添加范围语句
Condition	addNotEmptyQuery(String field) 添加非空查询
Condition	addNotInQuery(String field, List values) 添加范围语句
Condition	addNotInQuery(String field, Object[] values) 添加范围语句
Condition	addNotNullQuery(String field) 添加非空查询
Condition	addNullQuery(String field) 添加空查询
Condition	addQuery(String query) 添加自定义查询条件
Condition	addQuery(String property, Object value) 添加属性查询
Condition	addQuery(String property, String operator, Object value) 添加属性查询
Condition	addUpdate(String property, Object value) 添加更新字段
long	count()
long	delete()
Condition	distinct()
com.alibaba.fastjson.JSONArray	getAggerateList()
com.alibaba.fastjson.JSONArray	getCompositArray()
List<T>	getCompositList() 获取复合列表(即返回关联表字段)
List<T>	getList()
PageVo<T>	getPagingList()
List<T>	getPartList() 获取部分列
List<T>	getValueList(Class<T> _class, String column)
Condition	groupBy(String field) 分组
<T> SubCondition<T>	joinTable(Class<T> _class, String primaryField, String joinTableField) 关联表
Condition	limit(long offset, long limit) 分页操作
Condition	orderBy(String field) 排序字段(升序)
Condition	orderByDesc(String field) 排序字段(降序)
Condition	page(int pageNum, int pageSize) 分页操作
long	update()

方法详细资料

distinct

Condition distinct()

addNullQuery

Condition addNullQuery(String field)

添加空查询

addNotNullQuery

Condition addNotNullQuery(String field)

添加非空查询

addNotEmptyQuery

Condition addNotEmptyQuery(String field)

添加非空查询

addInQuery

Condition addInQuery(String field,
                     Object[] values)

添加范围语句

addInQuery

Condition addInQuery(String field,
                     List values)

添加范围语句

addNotInQuery

Condition addNotInQuery(String field,
                        Object[] values)

添加范围语句

addNotInQuery

Condition addNotInQuery(String field,
                        List values)

添加范围语句

addQuery

Condition addQuery(String query)

添加自定义查询条件

addQuery

Condition addQuery(String property,
                   Object value)

添加属性查询

addQuery

Condition addQuery(String property,
                   String operator,
                   Object value)

添加属性查询

addUpdate

Condition addUpdate(String property,
                    Object value)

添加更新字段

addAggerate

Condition addAggerate(String aggerate,
                      String field)

添加聚合字段

参数:

aggerate - COUNT,SUM,MAX,MIN,AVG

field - 字段名

addAggerate

Condition addAggerate(String aggerate,
                      String field,
                      String alias)

添加聚合字段

groupBy

Condition groupBy(String field)

分组

joinTable

<T> SubCondition<T> joinTable(Class<T> _class,
                              String primaryField,
                              String joinTableField)

关联表

orderBy

Condition orderBy(String field)

排序字段(升序)

orderByDesc

Condition orderByDesc(String field)

排序字段(降序)

limit

Condition limit(long offset,
                long limit)

分页操作

page

Condition page(int pageNum,
               int pageSize)

分页操作

addColumn

Condition addColumn(String field)

count

long count()

update

long update()

delete

long delete()

getList

List<T> getList()

getPagingList

PageVo<T> getPagingList()

getCompositList

List<T> getCompositList()

获取复合列表(即返回关联表字段)

getCompositArray

com.alibaba.fastjson.JSONArray getCompositArray()

getPartList

List<T> getPartList()

获取部分列

getValueList

List<T> getValueList(Class<T> _class,
                     String column)

getAggerateList

com.alibaba.fastjson.JSONArray getAggerateList()