public class AbstractSubCondition<T> extends Object implements SubCondition<T>
| 构造器和说明 |
|---|
AbstractSubCondition(SubQuery subQuery) |
| 限定符和类型 | 方法和说明 |
|---|---|
SubCondition<T> |
addBetweenQuery(String field,
Object start,
Object end)
添加between语句
|
SubCondition<T> |
addColumn(String... fields)
添加自定义字段,具体映射规则请看Condition类的JavaDoc注释
|
SubCondition<T> |
addEmptyQuery(String field)
添加空查询
|
SubCondition<T> |
addInQuery(String field,
List values)
添加范围查询语句
|
SubCondition<T> |
addInQuery(String field,
Object... values)
添加范围查询语句
|
SubCondition<T> |
addLikeQuery(String field,
Object value)
添加Like查询
|
SubCondition<T> |
addNotEmptyQuery(String field)
添加非空查询
|
SubCondition<T> |
addNotInQuery(String field,
List values)
添加范围查询语句
|
SubCondition<T> |
addNotInQuery(String field,
Object... values)
添加范围查询语句
|
SubCondition<T> |
addNotNullQuery(String field)
添加非空查询
|
SubCondition<T> |
addNullQuery(String field)
添加空查询
|
SubCondition<T> |
addQuery(String field,
Object value)
添加字段查询
|
SubCondition<T> |
addQuery(String field,
String operator,
Object value)
添加字段查询
|
SubCondition<T> |
addRawQuery(String query,
Object... parameterList)
添加自定义查询条件
调用本方法时请先查看Condition类JavaDoc注释和SubCondition类的JavaDoc注释
|
Condition<T> |
done()
返回主表
|
SubCondition<T> |
doneSubCondition()
返回父表
|
SubCondition<T> |
fullJoin()
全外连接
|
SubCondition<T> |
groupBy(String... fields)
添加分组查询
|
<E> SubCondition<E> |
joinTable(Class<E> clazz,
String primaryField,
String joinTableField)
关联表查询,子表可再次关联子表
调用本方法时请先查看Condition类JavaDoc注释和SubCondition类的JavaDoc注释
|
<E> SubCondition<E> |
joinTable(Class<E> clazz,
String primaryField,
String joinTableField,
String compositField)
关联表查询,子表可再次关联子表
调用本方法时请先查看Condition类JavaDoc注释和SubCondition类的JavaDoc注释
|
SubCondition |
joinTable(String tableName,
String primaryField,
String joinTableField)
关联表查询,子表可再次关联子表
调用本方法时请先查看Condition类JavaDoc注释和SubCondition类的JavaDoc注释
|
SubCondition<T> |
leftJoin()
左外连接
|
SubCondition<T> |
orderBy(String... fields)
根据指定字段升序排列
|
SubCondition<T> |
orderByDesc(String... fields)
根据指定字段降序排列
|
SubCondition<T> |
rightJoin()
右外连接
|
SubCondition<T> |
tableAliasName(String tableAliasName)
手动设置表别名
|
public AbstractSubCondition(SubQuery subQuery)
public SubCondition<T> tableAliasName(String tableAliasName)
SubConditiontableAliasName 在接口中 SubCondition<T>public SubCondition<T> leftJoin()
SubConditionleftJoin 在接口中 SubCondition<T>public SubCondition<T> rightJoin()
SubConditionrightJoin 在接口中 SubCondition<T>public SubCondition<T> fullJoin()
SubConditionfullJoin 在接口中 SubCondition<T>public SubCondition<T> addNullQuery(String field)
SubConditionaddNullQuery 在接口中 SubCondition<T>field - 指明哪个字段为Nullpublic SubCondition<T> addNotNullQuery(String field)
SubConditionaddNotNullQuery 在接口中 SubCondition<T>field - 指明哪个字段不为Nullpublic SubCondition<T> addEmptyQuery(String field)
SubConditionaddEmptyQuery 在接口中 SubCondition<T>field - 指明哪个字段不为空字符串public SubCondition<T> addNotEmptyQuery(String field)
SubConditionaddNotEmptyQuery 在接口中 SubCondition<T>field - 指明哪个字段不为空字符串public SubCondition<T> addInQuery(String field, Object... values)
SubConditionaddInQuery 在接口中 SubCondition<T>field - 字段名values - 指明在该范围内的值public SubCondition<T> addInQuery(String field, List values)
SubConditionaddInQuery 在接口中 SubCondition<T>field - 字段名values - 指明在该范围内的值public SubCondition<T> addNotInQuery(String field, Object... values)
SubConditionaddNotInQuery 在接口中 SubCondition<T>field - 字段名values - 指明在不该范围内的值public SubCondition<T> addNotInQuery(String field, List values)
SubConditionaddNotInQuery 在接口中 SubCondition<T>field - 字段名values - 指明在不该范围内的值public SubCondition<T> addBetweenQuery(String field, Object start, Object end)
SubConditionaddBetweenQuery 在接口中 SubCondition<T>field - 字段名start - 范围开始值end - 范围结束值public SubCondition<T> addLikeQuery(String field, Object value)
SubConditionaddLikeQuery 在接口中 SubCondition<T>field - 字段名value - 字段值public SubCondition<T> addQuery(String field, Object value)
SubConditionaddQuery 在接口中 SubCondition<T>field - 字段名value - 字段值public SubCondition<T> addQuery(String field, String operator, Object value)
SubConditionaddQuery 在接口中 SubCondition<T>field - 字段名operator - 操作符,可为>,>=,=,<<=value - 字段值public SubCondition<T> addRawQuery(String query, Object... parameterList)
SubCondition调用本方法时请先查看Condition类JavaDoc注释和SubCondition类的JavaDoc注释
addRawQuery 在接口中 SubCondition<T>query - 子查询条件parameterList - 查询参数Condition,
SubConditionpublic SubCondition<T> addColumn(String... fields)
SubConditionaddColumn 在接口中 SubCondition<T>fields - 自定义查询列\Conditionpublic <E> SubCondition<E> joinTable(Class<E> clazz, String primaryField, String joinTableField)
SubCondition调用本方法时请先查看Condition类JavaDoc注释和SubCondition类的JavaDoc注释
joinTable 在接口中 SubCondition<T>clazz - 待关联的子表primaryField - 主表关联字段joinTableField - 子表关联字段Condition,
SubConditionpublic <E> SubCondition<E> joinTable(Class<E> clazz, String primaryField, String joinTableField, String compositField)
SubCondition调用本方法时请先查看Condition类JavaDoc注释和SubCondition类的JavaDoc注释
joinTable 在接口中 SubCondition<T>clazz - 待关联的子表primaryField - 主表关联字段joinTableField - 子表关联字段compositField - 子表实体类成员变量名Condition,
SubConditionpublic SubCondition joinTable(String tableName, String primaryField, String joinTableField)
SubCondition调用本方法时请先查看Condition类JavaDoc注释和SubCondition类的JavaDoc注释
joinTable 在接口中 SubCondition<T>tableName - 待关联的子表primaryField - 主表关联字段joinTableField - 子表关联字段Condition,
SubConditionpublic SubCondition<T> groupBy(String... fields)
SubConditiongroupBy 在接口中 SubCondition<T>fields - 分组字段public SubCondition<T> orderBy(String... fields)
SubConditionorderBy 在接口中 SubCondition<T>fields - 升序排列字段名public SubCondition<T> orderByDesc(String... fields)
SubConditionorderByDesc 在接口中 SubCondition<T>fields - 降序排列字段名public SubCondition<T> doneSubCondition()
SubConditiondoneSubCondition 在接口中 SubCondition<T>SubCondition#joinTable(Class, String, String)}public Condition<T> done()
SubConditiondone 在接口中 SubCondition<T>Condition#joinTable(Class, String, String)}Copyright © 2020. All rights reserved.