接口的使用
cn.schoolwow.quickdao.dao.condition.Condition

使用Condition的程序包

程序包	说明
cn.schoolwow.quickdao.dao
cn.schoolwow.quickdao.dao.condition
cn.schoolwow.quickdao.dao.condition.subCondition
cn.schoolwow.quickdao.dao.sql.dql

cn.schoolwow.quickdao.dao中Condition的使用

返回Condition的cn.schoolwow.quickdao.dao中的方法

限定符和类型	方法和说明
Condition	AbstractDAO.query(Class clazz)

cn.schoolwow.quickdao.dao.condition中Condition的使用

实现Condition的cn.schoolwow.quickdao.dao.condition中的类

限定符和类型	类和说明
class	AbstractCondition<T>
class	H2Condition
class	MySQLCondition
class	PostgreCondition
class	SQLiteCondition
class	SQLServerCondition

返回Condition的cn.schoolwow.quickdao.dao.condition中的方法

限定符和类型	方法和说明
Condition<T>	Condition.addAggregate(String aggregate, String field) 添加聚合字段,用于Response.getAggerateList() 默认返回字段名为aggerate(field)
Condition<T>	AbstractCondition.addAggregate(String aggerate, String field)
Condition<T>	Condition.addAggregate(String aggregate, String field, String alias) 添加聚合字段,用于Response.getAggerateList()
Condition<T>	AbstractCondition.addAggregate(String aggerate, String field, String alias)
Condition<T>	Condition.addBetweenQuery(String field, Object start, Object end) 添加between语句
Condition<T>	AbstractCondition.addBetweenQuery(String field, Object start, Object end)
Condition<T>	Condition.addColumn(String... fields) 部分查询,用于Response.getPartList()
Condition<T>	AbstractCondition.addColumn(String... fields)
Condition<T>	Condition.addEmptyQuery(String field) 添加空查询
Condition<T>	AbstractCondition.addEmptyQuery(String field)
Condition<T>	Condition.addHaving(String having, List parameterList) 添加having查询 调用此方法您需要知道以下几点 实体类字段使用驼峰式命名映射到数据库中.例如字段firstName映射到数据库后字段名为first_name 对于所有的查询语句,主表别名为t,使用join方法添加的表按照添加顺序依次为t1,t2,t3......
Condition<T>	AbstractCondition.addHaving(String having, List parameterList)
Condition<T>	Condition.addInQuery(String field, List values) 添加范围查询语句
Condition<T>	AbstractCondition.addInQuery(String field, List values)
Condition<T>	Condition.addInQuery(String field, Object[] values) 添加范围查询语句
Condition<T>	AbstractCondition.addInQuery(String field, Object[] values)
Condition<T>	Condition.addJSONObjectQuery(com.alibaba.fastjson.JSONObject queryCondition) 添加自定义查询条件 { {field}:{value},字段查询 {field}Start:{value},添加大于等于查询 {field}End:{value},添加小于等于查询 {field}LIKE:{value},添加Like查询 {field}IN:[array],添加IN查询 {field}NOTNULL:{value},添加not null查询 {field}NULL:{value},添加null查询 _orderBy:{value},升序排列 _orderByDesc:{value},降序排列 _pageNumber:{value},页码 _pageSize:{value},每页个数 //关联查询部分 _joinTables:[ { _class:{className} 关联类,例如top.cqscrb.courage.entity.User _primaryField:{primaryField} 主表关联字段 _joinTableField:{joinTableField} 子表关联字段 {field}:{value},字段查询 {field}Start:{value},添加大于等于查询 {field}End:{value},添加小于等于查询 {field}LIKE:{value},添加like查询 {field}IN:[array],添加IN查询 {field}NOTNULL:{value},添加not null查询 {field}NULL:{value},添加null查询 _orderBy:{value},升序排列 _orderByDesc:{value},降序排列 _joinTables:[...] } ] }
Condition<T>	AbstractCondition.addJSONObjectQuery(com.alibaba.fastjson.JSONObject queryCondition)
Condition	SQLServerCondition.addLikeQuery(String field, Object value)
Condition<T>	Condition.addLikeQuery(String field, Object value) 添加Like查询
Condition<T>	AbstractCondition.addLikeQuery(String field, Object value)
Condition<T>	Condition.addNotEmptyQuery(String field) 添加非空查询
Condition<T>	AbstractCondition.addNotEmptyQuery(String field)
Condition<T>	Condition.addNotInQuery(String field, List values) 添加范围查询语句
Condition<T>	AbstractCondition.addNotInQuery(String field, List values)
Condition<T>	Condition.addNotInQuery(String field, Object[] values) 添加范围查询语句
Condition<T>	AbstractCondition.addNotInQuery(String field, Object[] values)
Condition<T>	Condition.addNotNullQuery(String field) 添加非空查询
Condition<T>	AbstractCondition.addNotNullQuery(String field)
Condition<T>	Condition.addNullQuery(String field) 添加空查询
Condition<T>	AbstractCondition.addNullQuery(String field)
Condition<T>	Condition.addQuery(String query, List parameterList) 添加自定义查询条件 调用此方法您需要知道以下几点 实体类字段使用驼峰式命名映射到数据库中.例如字段firstName映射到数据库后字段名为first_name 对于所有的查询语句,主表别名为t,使用join方法添加的表按照添加顺序依次为t1,t2,t3......
Condition<T>	AbstractCondition.addQuery(String query, List parameterList)
Condition<T>	Condition.addQuery(String field, Object value) 添加字段查询
Condition<T>	AbstractCondition.addQuery(String field, Object value)
Condition<T>	Condition.addQuery(String field, String operator, Object value) 添加字段查询
Condition<T>	AbstractCondition.addQuery(String field, String operator, Object value)
Condition<T>	Condition.addSpecialColumn(String... fields) 自定义查询列,用于Response.getSpecialList() ()}
Condition<T>	AbstractCondition.addSpecialColumn(String... fields)
Condition<T>	Condition.addUpdate(String field, Object value) 添加更新字段,用于Response.update()方法
Condition<T>	AbstractCondition.addUpdate(String field, Object value)
Condition<T>	Condition.compositField() 返回子表实体类字段信息
Condition<T>	AbstractCondition.compositField()
Condition<T>	Condition.distinct() 添加distinct关键字
Condition<T>	AbstractCondition.distinct()
Condition<T>	Condition.done() 调用or()方法后返回主Condition
Condition<T>	AbstractCondition.done()
Condition<T>	Condition.excludeColumn(String... fields) 排除部分字段,用于Response.getPartList()
Condition<T>	AbstractCondition.excludeColumn(String... fields)
Condition<T>	Condition.groupBy(String field) 添加分组查询
Condition<T>	AbstractCondition.groupBy(String field)
Condition<T>	Condition.groupBy(String[] fields) 添加分组查询
Condition<T>	AbstractCondition.groupBy(String[] fields)
Condition<T>	Condition.having(String aggregate, String field, Object value) 添加having查询,最终拼接为 {{aggregate}}({{field}}) = {{value}}
Condition<T>	AbstractCondition.having(String aggregate, String field, Object value)
Condition<T>	Condition.having(String sourceAggregate, String sourceField, String operator, Object value) 添加having查询,最终拼接为 {{field}} {{operator}} {{aggregate}}({{targetField}})
Condition<T>	AbstractCondition.having(String sourceAggregate, String sourceField, String operator, Object value)
Condition<T>	Condition.having(String sourceAggregate, String sourceField, String targetAggregate, String targetField) 添加having查询,最终拼接为 {{sourceAggregate}}({{sourceField}}) = {{targetAggregate}}({{targetField}})
Condition<T>	AbstractCondition.having(String sourceAggregate, String sourceField, String targetAggregate, String targetField)
Condition<T>	Condition.having(String sourceAggregate, String sourceField, String operator, String targetAggregate, String targetField) 添加having查询,最终拼接为 {{sourceAggregate}}({{sourceField}}) {{operator}} {{targetAggregate}}({{targetField}})
Condition<T>	AbstractCondition.having(String sourceAggregate, String sourceField, String operator, String targetAggregate, String targetField)
Condition	SQLServerCondition.limit(long offset, long limit)
Condition	PostgreCondition.limit(long offset, long limit)
Condition<T>	Condition.limit(long offset, long limit) 分页操作
Condition<T>	AbstractCondition.limit(long offset, long limit)
Condition<T>	Condition.or() 添加Or查询条件 在返回Condition对象上添加的查询条件,会以or(......)的方式拼接到SQL字符串上.
Condition<T>	AbstractCondition.or()
Condition<T>	Condition.orderBy(String field) 根据指定字段升序排列
Condition<T>	AbstractCondition.orderBy(String field)
Condition<T>	Condition.orderByDesc(String field) 根据指定字段降序排列
Condition<T>	AbstractCondition.orderByDesc(String field)
Condition	SQLServerCondition.page(int pageNum, int pageSize)
Condition	PostgreCondition.page(int pageNum, int pageSize)
Condition<T>	Condition.page(int pageNum, int pageSize) 分页操作
Condition<T>	AbstractCondition.page(int pageNum, int pageSize)
Condition<T>	Condition.tableAliasName(String tableAliasName) 手动设置主表别名
Condition<T>	AbstractCondition.tableAliasName(String tableAliasName)
Condition<T>	Condition.union(Condition<T> condition) 添加联合查询,需确保返回字段个数和含义一致 默认union类型为 union
Condition<T>	AbstractCondition.union(Condition<T> condition)
Condition<T>	Condition.union(Condition<T> condition, UnionType unionType) 添加联合查询,需确保返回字段个数和含义一致
Condition<T>	AbstractCondition.union(Condition<T> condition, UnionType unionType)

参数类型为Condition的cn.schoolwow.quickdao.dao.condition中的方法

限定符和类型	方法和说明
Condition<T>	Condition.union(Condition<T> condition) 添加联合查询,需确保返回字段个数和含义一致 默认union类型为 union
Condition<T>	AbstractCondition.union(Condition<T> condition)
Condition<T>	Condition.union(Condition<T> condition, UnionType unionType) 添加联合查询,需确保返回字段个数和含义一致
Condition<T>	AbstractCondition.union(Condition<T> condition, UnionType unionType)

cn.schoolwow.quickdao.dao.condition.subCondition中Condition的使用

返回Condition的cn.schoolwow.quickdao.dao.condition.subCondition中的方法

限定符和类型	方法和说明
Condition<T>	SubCondition.done() 返回主表
Condition<T>	AbstractSubCondition.done()

cn.schoolwow.quickdao.dao.sql.dql中Condition的使用

返回Condition的cn.schoolwow.quickdao.dao.sql.dql中的方法

限定符和类型	方法和说明
Condition	DQLDAO.query(Class clazz) 复杂查询
Condition	AbstractDQLDAO.query(Class clazz)