接口的使用
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)
Condition	AbstractDAO.query(Condition condition)
Condition	AbstractDAO.query(String tableName)

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

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

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.addBetweenQuery(String field, Object start, Object end) 添加between语句
Condition<T>	AbstractCondition.addBetweenQuery(String field, Object start, Object end)
Condition<T>	Condition.addColumn(Condition subQuery) 添加select子查询
Condition<T>	AbstractCondition.addColumn(Condition subQuery)
Condition<T>	Condition.addColumn(Condition subQuery, String columnNameAlias) 添加select子查询
Condition<T>	AbstractCondition.addColumn(Condition subQuery, String columnNameAlias)
Condition<T>	Condition.addColumn(String... fields) 添加自定义字段,具体映射规则请看此Condition
Condition<T>	AbstractCondition.addColumn(String... fields)
Condition<T>	Condition.addEmptyQuery(String field) 添加空查询
Condition<T>	AbstractCondition.addEmptyQuery(String field)
Condition<T>	Condition.addExistSubQuery(Condition subQuery) 添加exist子查询
Condition<T>	AbstractCondition.addExistSubQuery(Condition subQuery)
Condition<T>	Condition.addInQuery(String field, Collection values) 添加范围查询语句
Condition<T>	AbstractCondition.addInQuery(String field, Collection values)
Condition<T>	Condition.addInQuery(String field, Object... values) 添加范围查询语句
Condition<T>	AbstractCondition.addInQuery(String field, Object... values)
Condition<T>	Condition.addInsert(String field, Object value) 添加插入字段,用于Response.insert()方法
Condition<T>	AbstractCondition.addInsert(String field, Object value)
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.addNotExistSubQuery(Condition subQuery) 添加not exist子查询
Condition<T>	AbstractCondition.addNotExistSubQuery(Condition subQuery)
Condition<T>	Condition.addNotInQuery(String field, Collection values) 添加范围查询语句
Condition<T>	AbstractCondition.addNotInQuery(String field, Collection 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 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.addRawQuery(String query, Object... parameterList) 自定义查询语句,具体映射规则请看此Condition
Condition<T>	AbstractCondition.addRawQuery(String query, Object... parameterList)
Condition<T>	Condition.addSubQuery(String field, String operator, Condition subQuery) 添加where子查询
Condition<T>	AbstractCondition.addSubQuery(String field, String operator, Condition subQuery)
Condition<T>	Condition.addUpdate(String field, Object value) 添加更新字段,用于Response.update()方法
Condition<T>	AbstractCondition.addUpdate(String field, Object value)
Condition<T>	Condition.clone() 执行并返回Response实例
Condition<T>	AbstractCondition.clone()
Condition<T>	Condition.compositField() 返回子表实体类字段信息
Condition<T>	AbstractCondition.compositField()
Condition<T>	Condition.distinct() 添加distinct关键字
Condition<T>	AbstractCondition.distinct()
Condition<T>	Condition.groupBy(String... fields) 添加分组查询
Condition<T>	AbstractCondition.groupBy(String... fields)
Condition<T>	Condition.having(String having, Object... parameterList) 添加having查询 调用本方法时请先查看Condition类JavaDoc注释
Condition<T>	AbstractCondition.having(String having, Object... parameterList)
Condition<T>	Condition.having(String field, String operator, Condition subQuery) 添加having子查询 调用本方法时请先查看Condition类JavaDoc注释
Condition<T>	AbstractCondition.having(String field, String operator, Condition subQuery)
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查询条件,返回一个新的OrCondition对象 在返回Condition对象上添加的查询条件,会以or(......)的方式拼接到SQL字符串上.
Condition<T>	AbstractCondition.or()
Condition<T>	Condition.or(String or, Object... parameterList) 添加or查询,具体映射规则请看此Condition
Condition<T>	AbstractCondition.or(String or, Object... parameterList)
Condition<T>	Condition.orderBy(String... field) 根据指定字段升序排列 注意若调用了addColumn方法,请将调用本方法放在addColumn方法之后
Condition<T>	AbstractCondition.orderBy(String... fields)
Condition<T>	Condition.orderByDesc(String... field) 根据指定字段降序排列 注意若调用了addColumn方法,请将调用本方法放在addColumn方法之后
Condition<T>	AbstractCondition.orderByDesc(String... fields)
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.addColumn(Condition subQuery) 添加select子查询
Condition<T>	AbstractCondition.addColumn(Condition subQuery)
Condition<T>	Condition.addColumn(Condition subQuery, String columnNameAlias) 添加select子查询
Condition<T>	AbstractCondition.addColumn(Condition subQuery, String columnNameAlias)
Condition<T>	Condition.addExistSubQuery(Condition subQuery) 添加exist子查询
Condition<T>	AbstractCondition.addExistSubQuery(Condition subQuery)
Condition<T>	Condition.addNotExistSubQuery(Condition subQuery) 添加not exist子查询
Condition<T>	AbstractCondition.addNotExistSubQuery(Condition subQuery)
Condition<T>	Condition.addSubQuery(String field, String operator, Condition subQuery) 添加where子查询
Condition<T>	AbstractCondition.addSubQuery(String field, String operator, Condition subQuery)
Condition<T>	Condition.having(String field, String operator, Condition subQuery) 添加having子查询 调用本方法时请先查看Condition类JavaDoc注释
Condition<T>	AbstractCondition.having(String field, String operator, Condition subQuery)
<E> SubCondition<E>	Condition.joinTable(Condition<E> joinCondition, String primaryField, String joinConditionField) 关联子查询 调用本方法时请先查看Condition类JavaDoc注释 调用本方法将在sql语句中拼接如下字符串 join #{condition子表} as t1 on t.primaryField = t1.joinTableField
<E> SubCondition<E>	AbstractCondition.joinTable(Condition<E> joinCondition, String primaryField, String joinConditionField)
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)
Condition	DQLDAO.query(Condition condition) 添加FROM子查询
Condition	AbstractDQLDAO.query(Condition condition)
Condition	DQLDAO.query(String tableName) 复杂查询
Condition	AbstractDQLDAO.query(String tableName)

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

限定符和类型	方法和说明
Condition	DQLDAO.query(Condition condition) 添加FROM子查询
Condition	AbstractDQLDAO.query(Condition condition)