Uses of Interface
org.huiche.ast.statement.Select
Packages that use Select
Package
Description
SQL表达式
SQL引用,表|列|别名
可操作接口,包括表达式|语句|引用的操作
SQL语句
SQL子句
ast支持相关
查询相关
实体类查询
Dao实现的支持
-
Uses of Select in org.huiche.ast.expression
Methods in org.huiche.ast.expression that return SelectModifier and TypeMethodDescriptionSubQueryExpression.Default.select()SubQueryExpression.select()查询语句Methods in org.huiche.ast.expression with parameters of type Select -
Uses of Select in org.huiche.ast.metadata
Methods in org.huiche.ast.metadata that return SelectModifier and TypeMethodDescriptionDerivedTableRef.Default.select()DerivedTableRef.select()Select语句Methods in org.huiche.ast.metadata with parameters of type Select -
Uses of Select in org.huiche.ast.operable
Subinterfaces with type arguments of type Select in org.huiche.ast.operableMethods in org.huiche.ast.operable that return SelectModifier and TypeMethodDescriptionSelectOperable.clearSelect()清除当前selectiondefault Select交差连接default Select交差连接default Select交差连接default SelectSelectOperable.distinct()去重SelectOperable.distinct(boolean distinct) 去重default Selectfrom操作default Selectfrom操作from操作default Select分组default Select分组default Select分组default Select分组default SelectSelectOperable.groupBy(Collection<? extends Expression> groupBys) 分组SelectOperable.groupBy(Expression groupBy) 分组default SelectSelectOperable.groupBy(Expression... groupBys) 分组default <T> SelectSelectOperable.groupBy(SerializableFunction<T, ?> column) 分组default <T> SelectSelectOperable.groupBy(SerializableFunction<T, ?>... groupBys) 分组default <V> SelectSelectOperable.having(Enum<?> column, BiFunction<Expression, V, Condition> compareOperate, V val) havingdefault SelectSelectOperable.having(Enum<?> column, Function<Expression, Condition> compareOperate) havingdefault <V> SelectSelectOperable.having(String field, BiFunction<Expression, V, Condition> compareOperate, V val) havingdefault SelectSelectOperable.having(String field, Function<Expression, Condition> compareOperate) havingSelectOperable.having(Collection<? extends Condition> havings) 分组过滤分组过滤default Select分组过滤default <V> SelectSelectOperable.having(Expression expr, BiFunction<Expression, V, Condition> compareOperate, V val) havingdefault SelectSelectOperable.having(Expression expr, Function<Expression, Condition> compareOperate) havingdefault SelectSelectOperable.having(Searchable search) 分组过滤default <E,V> Select SelectOperable.having(SerializableFunction<E, ?> column, BiFunction<Expression, V, Condition> compareOperate, V val) havingdefault <E> SelectSelectOperable.having(SerializableFunction<E, ?> column, Function<Expression, Condition> compareOperate) havingSelectOperable.having(S search) 分组过滤default Select限制条数限制条数和跳过条数default Select限制条数default SelectSelectOperable.naturalJoin(Class<?> entityClass) 自然连接default SelectSelectOperable.naturalJoin(String tableName) 自然连接default SelectSelectOperable.naturalJoin(TableRef table) 自然连接default Select排序default Select排序default Select排序default Select排序SelectOperable.orderBy(Collection<? extends OrderBy> orderBys) 排序default SelectSelectOperable.orderBy(Expression column) 排序default SelectSelectOperable.orderBy(Expression column, Order order) 排序排序default Select排序default <T> SelectSelectOperable.orderBy(SerializableFunction<T, ?> column) 排序default <T> SelectSelectOperable.orderBy(SerializableFunction<T, ?> column, Order order) 排序default Selectselect操作SelectOperable.select(Collection<?> selects) default <T> SelectSelectOperable.select(SerializableFunction<T, ?> select) select操作default <T> SelectSelectOperable.select(SerializableFunction<T, ?>... selects) select操作Methods in org.huiche.ast.operable that return types with arguments of type SelectModifier and TypeMethodDescriptiondefault JoinOperable<Select> 全连接default JoinOperable<Select> 全连接default JoinOperable<Select> 全连接default JoinOperable<Select> 内连接default JoinOperable<Select> 内连接default JoinOperable<Select> 内连接连接查询default JoinOperable<Select> 左连接default JoinOperable<Select> 左连接default JoinOperable<Select> 左连接default JoinOperable<Select> 右连接default JoinOperable<Select> 右连接default JoinOperable<Select> 右连接Methods in org.huiche.ast.operable with parameters of type Select -
Uses of Select in org.huiche.ast.statement
Classes in org.huiche.ast.statement that implement SelectSubclasses with type arguments of type Select in org.huiche.ast.statementSubinterfaces with type arguments of type Select in org.huiche.ast.statementMethods in org.huiche.ast.statement that return SelectModifier and TypeMethodDescriptionSelect.Default.clearSelect()Select.Default.distinct(boolean distinct) Select.Default.groupBy(Expression groupBy) Select.Default.having(Collection<? extends Condition> havings) static SelectSelect.of()创建查询语句static Select创建查询语句Select.Default.orderBy(Collection<? extends OrderBy> orderBys) Insert.Default.select()Insert.select()查询Select.Default.select(Collection<?> selects) Methods in org.huiche.ast.statement that return types with arguments of type SelectMethods in org.huiche.ast.statement with parameters of type Select -
Uses of Select in org.huiche.ast.statement.clause
Methods in org.huiche.ast.statement.clause that return SelectModifier and TypeMethodDescription根据CTE创建查询语句根据CTE创建查询语句default <T> SelectWith.select(SerializableFunction<T, ?> select) 根据CTE创建查询语句default <T> SelectWith.select(SerializableFunction<T, ?>... selects) 根据CTE创建查询语句 -
Uses of Select in org.huiche.ast.support
Methods in org.huiche.ast.support that return SelectModifier and TypeMethodDescriptionstatic Selectselect语句static SelectSql.select(Collection<?> selects) select语句static <T> SelectSql.select(SerializableFunction<T, ?>... selects) select语句static SelectSql.selectFrom(Class<?> entityClass) select * from 语句static SelectSql.selectFrom(String tableName) select * from 语句static SelectSql.selectFrom(TableRef table) select * from 语句Methods in org.huiche.ast.support with parameters of type Select -
Uses of Select in org.huiche.dao.query
Method parameters in org.huiche.dao.query with type arguments of type SelectModifier and TypeMethodDescriptiondefault long条数查询default longCountQuery.countColumn(Class<?> entityClass, Enum<?> column, Consumer<Select> customizer) 指定列条数查询default longCountQuery.countColumn(Class<?> entityClass, String field, Consumer<Select> customizer) 指定列条数查询default longCountQuery.countColumn(Class<?> entityClass, Expression column, Consumer<Select> customizer) 指定列条数查询default <T> longCountQuery.countColumn(Class<T> entityClass, SerializableFunction<T, ?> column, Consumer<Select> customizer) 指定列条数查询default longCountQuery.countColumnDistinct(Class<?> entityClass, Enum<?> column, Consumer<Select> customizer) 指定列条数去重查询default longCountQuery.countColumnDistinct(Class<?> entityClass, String field, Consumer<Select> customizer) 指定列条数去重查询default longCountQuery.countColumnDistinct(Class<?> entityClass, Expression column, Consumer<Select> customizer) 指定列条数去重查询default <T> longCountQuery.countColumnDistinct(Class<T> entityClass, SerializableFunction<T, ?> column, Consumer<Select> customizer) 指定列条数去重查询default <R> R单条记录查询default <E> List<E> ListQuery.doList(Class<?> entityClass, Type elementType, Pageable pageable, Consumer<Select> customizer) 执行列表查询default <R> Optional<R> OptionalQuery.doOptional(Class<?> entityClass, Type resultType, Consumer<Select> customizer) 单条记录查询default <E> Stream<E> StreamQuery.doStream(Class<?> entityClass, Type elementType, Integer limit, Consumer<Select> customizer) 列表查询default boolean存在查询default <T> T单条记录查询default <R> R单条记录查询default <R> R单条记录查询default <R> RGetColumnQuery.getColumn(Class<?> entityClass, Enum<?> column, Class<R> columnClass, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> RGetColumnQuery.getColumn(Class<?> entityClass, Enum<?> column, TypeRef<R> columnTypeRef, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> RGetColumnQuery.getColumn(Class<?> entityClass, String field, Class<R> columnClass, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> RGetColumnQuery.getColumn(Class<?> entityClass, String field, TypeRef<R> columnTypeRef, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> RGetColumnQuery.getColumn(Class<?> entityClass, Expression column, Class<R> columnClass, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> RGetColumnQuery.getColumn(Class<?> entityClass, Expression column, TypeRef<R> columnTypeRef, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <T,R> R GetColumnQuery.getColumn(Class<T> entityClass, SerializableFunction<T, R> column, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <T,R> R GetColumnQuery.getColumn(SerializableFunction<T, R> column, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <T> List<T> 列表查询default <T> List<T> 列表查询default <T> List<T> 列表查询default <E> List<E> ListQuery.listAs(Class<?> entityClass, Class<E> elementClass, Integer limit, Consumer<Select> customizer) 列表查询default <E> List<E> 列表查询default <T,E> List <E> ListQuery.listAs(Class<?> entityClass, Class<E> elementClass, Pageable pageable, Consumer<Select> customizer) 列表查询default <E> List<E> ListQuery.listAs(Class<?> entityClass, TypeRef<E> elementTypeRef, Integer limit, Consumer<Select> customizer) 列表查询default <E> List<E> 列表查询default <E> List<E> ListQuery.listAs(Class<?> entityClass, TypeRef<E> elementTypeRef, Pageable pageable, Consumer<Select> customizer) 列表查询default <E> List<E> ListColumnQuery.listColumn(Class<?> entityClass, Enum<?> column, Class<E> columnClass, Integer limit, Consumer<Select> customizer) 列表查询default <E> List<E> ListColumnQuery.listColumn(Class<?> entityClass, Enum<?> column, Class<E> columnClass, Consumer<Select> customizer) 列表查询default <E> List<E> ListColumnQuery.listColumn(Class<?> entityClass, Enum<?> column, Class<E> columnClass, Pageable pageable, Consumer<Select> customizer) 列表查询default <E> List<E> ListColumnQuery.listColumn(Class<?> entityClass, String field, Class<E> columnClass, Integer limit, Consumer<Select> customizer) 列表查询default <E> List<E> ListColumnQuery.listColumn(Class<?> entityClass, String field, Class<E> columnClass, Consumer<Select> customizer) 列表查询default <E> List<E> ListColumnQuery.listColumn(Class<?> entityClass, String field, Class<E> columnClass, Pageable pageable, Consumer<Select> customizer) 列表查询default <E> List<E> ListColumnQuery.listColumn(Class<?> entityClass, Expression column, Class<E> columnClass, Integer limit, Consumer<Select> customizer) 列表查询default <E> List<E> ListColumnQuery.listColumn(Class<?> entityClass, Expression column, Class<E> columnClass, Consumer<Select> customizer) 列表查询default <E> List<E> ListColumnQuery.listColumn(Class<?> entityClass, Expression column, Class<E> columnClass, Pageable pageable, Consumer<Select> customizer) 列表查询default <T,E> List <E> ListColumnQuery.listColumn(Class<T> entityClass, SerializableFunction<T, E> column, Integer limit, Consumer<Select> customizer) 列表查询default <T,E> List <E> ListColumnQuery.listColumn(Class<T> entityClass, SerializableFunction<T, E> column, Consumer<Select> customizer) 列表查询default <T,E> List <E> ListColumnQuery.listColumn(Class<T> entityClass, SerializableFunction<T, E> column, Pageable pageable, Consumer<Select> customizer) 列表查询default <T,E> List <E> ListColumnQuery.listColumn(SerializableFunction<T, E> column, Integer limit, Consumer<Select> customizer) 列表查询default <T,E> List <E> ListColumnQuery.listColumn(SerializableFunction<T, E> column, Consumer<Select> customizer) 列表查询default <T,E> List <E> ListColumnQuery.listColumn(SerializableFunction<T, E> column, Pageable pageable, Consumer<Select> customizer) 列表查询default <T> Optional<T> 单条记录查询default <R> Optional<R> OptionalQuery.optionalAs(Class<?> entityClass, Class<R> resultClass, Consumer<Select> customizer) 单条记录查询default <R> Optional<R> OptionalQuery.optionalAs(Class<?> entityClass, TypeRef<R> resultTypeRef, Consumer<Select> customizer) 单条记录查询default <R> Optional<R> OptionalQuery.optionalColumn(Class<?> entityClass, Enum<?> column, Class<R> columnClass, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> Optional<R> OptionalQuery.optionalColumn(Class<?> entityClass, Enum<?> column, TypeRef<R> columnTypeRef, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> Optional<R> OptionalQuery.optionalColumn(Class<?> entityClass, String field, Class<R> columnClass, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> Optional<R> OptionalQuery.optionalColumn(Class<?> entityClass, String field, TypeRef<R> columnTypeRef, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> Optional<R> OptionalQuery.optionalColumn(Class<?> entityClass, Expression column, Class<R> columnClass, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> Optional<R> OptionalQuery.optionalColumn(Class<?> entityClass, Expression column, TypeRef<R> columnTypeRef, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <T,R> Optional <R> OptionalQuery.optionalColumn(Class<T> entityClass, SerializableFunction<T, R> column, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <T,R> Optional <R> OptionalQuery.optionalColumn(SerializableFunction<T, R> column, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <T> Page<T> 分页查询default <E> Page<E> PageQuery.pageAs(Class<?> entityClass, Class<E> elementClass, Pageable pageable, Consumer<Select> customizer) 分页查询default <E> Page<E> PageQuery.pageAs(Class<?> entityClass, TypeRef<E> elementTypeRef, Pageable pageable, Consumer<Select> customizer) 分页查询default <T> Stream<T> 列表查询default <T> Stream<T> 列表查询default <E> Stream<E> StreamQuery.streamAs(Class<?> entityClass, Class<E> elementClass, Integer limit, Consumer<Select> customizer) 列表查询default <E> Stream<E> 列表查询default <E> Stream<E> StreamQuery.streamAs(Class<?> entityClass, TypeRef<E> elementTypeRef, Integer limit, Consumer<Select> customizer) 列表查询default <E> Stream<E> 列表查询 -
Uses of Select in org.huiche.dao.query.entity
Method parameters in org.huiche.dao.query.entity with type arguments of type SelectModifier and TypeMethodDescriptiondefault long条数查询default longEntityCountQuery.countColumn(Enum<?> column, Consumer<Select> customizer) 指定列条数查询default longEntityCountQuery.countColumn(String field, Consumer<Select> customizer) 指定列条数查询default longEntityCountQuery.countColumn(Expression column, Consumer<Select> customizer) 指定列条数查询default longEntityCountQuery.countColumn(SerializableFunction<T, ?> column, Consumer<Select> customizer) 指定列条数查询default longEntityCountQuery.countColumnDistinct(Enum<?> column, Consumer<Select> customizer) 指定列条数去重查询default longEntityCountQuery.countColumnDistinct(String field, Consumer<Select> customizer) 指定列条数去重查询default longEntityCountQuery.countColumnDistinct(Expression column, Consumer<Select> customizer) 指定列条数去重查询default longEntityCountQuery.countColumnDistinct(SerializableFunction<T, ?> column, Consumer<Select> customizer) 指定列条数去重查询default boolean存在查询default T单条记录查询default <R> R单条记录查询default <R> R单条记录查询default <R> R单条记录查询单例(或表达式)default <R> REntityGetColumnQuery.getColumn(Enum<?> column, TypeRef<R> columnTypeRef, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> R单条记录查询单例(或表达式)default <R> R单条记录查询单例(或表达式)default <R> REntityGetColumnQuery.getColumn(Expression column, Class<R> columnClass, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> REntityGetColumnQuery.getColumn(Expression column, TypeRef<R> columnTypeRef, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> REntityGetColumnQuery.getColumn(SerializableFunction<T, R> column, Consumer<Select> customizer) 单条记录查询单例(或表达式)列表查询列表查询列表查询default <E> List<E> 列表查询default <E> List<E> 列表查询default <E> List<E> 列表查询default <E> List<E> 列表查询default <E> List<E> 列表查询default <E> List<E> 列表查询default <E> List<E> EntityListColumnQuery.listColumn(Enum<?> column, Class<E> columnClass, Integer limit, Consumer<Select> customizer) 列表查询default <E> List<E> EntityListColumnQuery.listColumn(Enum<?> column, Class<E> columnClass, Consumer<Select> customizer) 列表查询default <E> List<E> EntityListColumnQuery.listColumn(Enum<?> column, Class<E> columnClass, Pageable pageable, Consumer<Select> customizer) 列表查询default <E> List<E> EntityListColumnQuery.listColumn(String field, Class<E> columnClass, Integer limit, Consumer<Select> customizer) 列表查询default <E> List<E> EntityListColumnQuery.listColumn(String field, Class<E> columnClass, Consumer<Select> customizer) 列表查询default <E> List<E> EntityListColumnQuery.listColumn(String field, Class<E> columnClass, Pageable pageable, Consumer<Select> customizer) 列表查询default <E> List<E> EntityListColumnQuery.listColumn(Expression column, Class<E> columnClass, Integer limit, Consumer<Select> customizer) 列表查询default <E> List<E> EntityListColumnQuery.listColumn(Expression column, Class<E> columnClass, Consumer<Select> customizer) 列表查询default <E> List<E> EntityListColumnQuery.listColumn(Expression column, Class<E> columnClass, Pageable pageable, Consumer<Select> customizer) 列表查询default <E> List<E> EntityListColumnQuery.listColumn(SerializableFunction<T, E> column, Integer limit, Consumer<Select> customizer) 列表查询default <E> List<E> EntityListColumnQuery.listColumn(SerializableFunction<T, E> column, Consumer<Select> customizer) 列表查询default <E> List<E> EntityListColumnQuery.listColumn(SerializableFunction<T, E> column, Pageable pageable, Consumer<Select> customizer) 列表查询单条记录查询default <R> Optional<R> EntityOptionalQuery.optionalAs(Class<R> resultClass, Consumer<Select> customizer) 单条记录查询default <R> Optional<R> EntityOptionalQuery.optionalAs(TypeRef<R> resultTypeRef, Consumer<Select> customizer) 单条记录查询default <R> Optional<R> EntityOptionalQuery.optionalColumn(Enum<?> column, Class<R> columnClass, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> Optional<R> EntityOptionalQuery.optionalColumn(Enum<?> column, TypeRef<R> columnTypeRef, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> Optional<R> EntityOptionalQuery.optionalColumn(String field, Class<R> columnClass, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> Optional<R> EntityOptionalQuery.optionalColumn(String field, TypeRef<R> columnTypeRef, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> Optional<R> EntityOptionalQuery.optionalColumn(Expression column, Class<R> columnClass, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> Optional<R> EntityOptionalQuery.optionalColumn(Expression column, TypeRef<R> columnTypeRef, Consumer<Select> customizer) 单条记录查询单例(或表达式)default <R> Optional<R> EntityOptionalQuery.optionalColumn(SerializableFunction<T, R> column, Consumer<Select> customizer) 单条记录查询单例(或表达式)分页查询default <E> Page<E> 分页查询default <E> Page<E> 分页查询列表查询列表查询default <E> Stream<E> 列表查询default <E> Stream<E> 列表查询default <E> Stream<E> 列表查询default <E> Stream<E> 列表查询 -
Uses of Select in org.huiche.dao.support
Methods in org.huiche.dao.support that return types with arguments of type SelectModifier and TypeMethodDescription单条查询前置处理列表查询前置处理stream查询前置处理Methods in org.huiche.dao.support with parameters of type SelectModifier and TypeMethodDescriptiondefault void单条查询执行之后voiddefault void列表查询执行之后voiddefault voidDaoInterceptor.afterStream(Class<?> entityClass, Type elementType, Select select, Stream<?> result) stream查询执行之后voidDaoInterceptors.afterStream(Class<?> entityClass, Type elementType, Select select, Stream<?> result) default void单条查询执行之前,可调整语句,作用于业务参数之后voiddefault voidDaoInterceptor.beforeList(Class<?> entityClass, Type elementType, Select select) 列表查询执行之前,可调整语句,作用于业务参数之后voidDaoInterceptors.beforeList(Class<?> entityClass, Type elementType, Select select) default voidDaoInterceptor.beforeStream(Class<?> entityClass, Type elementType, Select select) stream查询执行之前,可调整语句,作用于业务参数之后voidDaoInterceptors.beforeStream(Class<?> entityClass, Type elementType, Select select)