Uses of Interface org.huiche.core.support.SerializableFunction (huiche 4.0.5 API)

Packages that use SerializableFunction

Package

Description

org.huiche.ast.metadata

SQL引用,表|列|别名

org.huiche.ast.operable

可操作接口,包括表达式|语句|引用的操作

org.huiche.ast.statement.clause

SQL子句

org.huiche.ast.support

ast支持相关

org.huiche.dao.query

查询相关

org.huiche.dao.query.entity

实体类查询

Uses of SerializableFunction in org.huiche.ast.metadata

Methods in org.huiche.ast.metadata with parameters of type SerializableFunction

Modifier and Type

Method

Description

default <T> Column

AliasTableRef.col(SerializableFunction<T,?> column)

从table创建列

static LambdaCache.Payload

LambdaCache.get(SerializableFunction<?,?> lambda)

获取lamdba方法引用对应的信息

static <T> Column

Column.of(SerializableFunction<T,?> column)

创建列
Uses of SerializableFunction in org.huiche.ast.operable

Methods in org.huiche.ast.operable with parameters of type SerializableFunction

Modifier and Type

Method

Description

default <E,V> Condition

LogicalOperable.and(SerializableFunction<E,?> column, BiFunction<Expression, V, Condition> compareOperate, V val)

AND

default <E> Condition

LogicalOperable.and(SerializableFunction<E,?> column, Function<Expression, Condition> compareOperate)

AND

default <T> Insert

InsertOperable.columns(SerializableFunction<T,?>... columns)

设置插入列, 只能设置1次或0次(等同插入全部列),再次设置则覆盖

default <T> Expression

ArithmeticOperable.div(SerializableFunction<T,?> column)

除法

default <T> Condition

ComparisonOperable.eq(SerializableFunction<T,?> column)

等于

default <T> Select

SelectOperable.groupBy(SerializableFunction<T,?> column)

分组

default <T> Select

SelectOperable.groupBy(SerializableFunction<T,?>... groupBys)

分组

default <T> Condition

ComparisonOperable.gt(SerializableFunction<T,?> column)

大于

default <T> Condition

ComparisonOperable.gte(SerializableFunction<T,?> column)

大于等于

default <E,V> Select

SelectOperable.having(SerializableFunction<E,?> column, BiFunction<Expression, V, Condition> compareOperate, V val)

having

default <E> Select

SelectOperable.having(SerializableFunction<E,?> column, Function<Expression, Condition> compareOperate)

having

default <T> Condition

ComparisonOperable.lt(SerializableFunction<T,?> column)

小于

default <T> Condition

ComparisonOperable.lte(SerializableFunction<T,?> column)

小于等于

default <T> Expression

ArithmeticOperable.minus(SerializableFunction<T,?> column)

减法

default <T> Expression

ArithmeticOperable.mul(SerializableFunction<T,?> column)

乘法

default <T> Condition

ComparisonOperable.ne(SerializableFunction<T,?> column)

不等于

default <A,B> T

JoinOperable.on(SerializableFunction<A,?> column1, SerializableFunction<B,?> column2)

列相等关联

default <E,V> Condition

LogicalOperable.or(SerializableFunction<E,?> column, BiFunction<Expression, V, Condition> compareOperate, V val)

OR

default <E> Condition

LogicalOperable.or(SerializableFunction<E,?> column, Function<Expression, Condition> compareOperate)

OR

default <T> Select

SelectOperable.orderBy(SerializableFunction<T,?> column)

排序

default <T> Select

SelectOperable.orderBy(SerializableFunction<T,?> column, Order order)

排序

default <T> Expression

ArithmeticOperable.plus(SerializableFunction<T,?> column)

加法

default <T> Select

SelectOperable.select(SerializableFunction<T,?> select)

select操作

default <T> Select

SelectOperable.select(SerializableFunction<T,?>... selects)

select操作

default <T,R> Update

UpdateOperable.set(SerializableFunction<T,R> column, Expression expr)

set单个列和值,设置多个值请多次调用

default <T,R> Update

UpdateOperable.set(SerializableFunction<T,R> column, R val)

set单个列和值,设置多个值请多次调用

default <T> Update

UpdateOperable.setNull(SerializableFunction<T,?> column)

设置指定列为NULL

default <E,V> T

WhereOperable.where(SerializableFunction<E,?> column, BiFunction<Expression, V, Condition> compareOperate, V val)

where

default <E> T

WhereOperable.where(SerializableFunction<E,?> column, Function<Expression, Condition> compareOperate)

where
Uses of SerializableFunction in org.huiche.ast.statement.clause

Methods in org.huiche.ast.statement.clause with parameters of type SerializableFunction

Modifier and Type

Method

Description

default <T> Select

With.select(SerializableFunction<T,?> select)

根据CTE创建查询语句

default <T> Select

With.select(SerializableFunction<T,?>... selects)

根据CTE创建查询语句
Uses of SerializableFunction in org.huiche.ast.support

Methods in org.huiche.ast.support with parameters of type SerializableFunction

Modifier and Type

Method

Description

static <T> Expression

Sql.abs(SerializableFunction<T,?> column)

绝对值

static <T> Expression

Sql.anyValue(SerializableFunction<T,?> column)

分组内任一值

static <T> Expression

Sql.avg(SerializableFunction<T,?> column)

AVG 平均值函数

static <T> CaseExpression.When

Sql.case_(SerializableFunction<T,?> column)

简单 CASE

static <T> Expression

Sql.ceiling(SerializableFunction<T,?> column)

向上取整

static <T> Expression

Sql.charLength(SerializableFunction<T,?> column)

字符长度

static <T,E> Condition

Sql.condition(T val, SerializableFunction<E,?> column, BiFunction<Column, T, Condition> compareOperate)

空值判断条件

static <T> Expression

Sql.count(SerializableFunction<T,?> column)

count 计数函数

static <T> Expression

Sql.countDistinct(SerializableFunction<T,?> column)

去重count 计数函数

static <T> List<Column>

Sql.execludeColumn(Class<T> entityClass, SerializableFunction<T,?>... execludeColumns)

实体类排除列

static <T> Expression

Sql.floor(SerializableFunction<T,?> column)

向下取整

static <T> Insert

Sql.insertInto(Class<T> entityClass, SerializableFunction<T,?>... columns)

创建insert语句

static <T> Condition

Sql.jsonExists(SerializableFunction<T,?> column, String path)

json查询存在

static <T> Expression

Sql.jsonValue(SerializableFunction<T,?> column, String path)

json查询值

static <T> Condition

Sql.keyword(String keyword, SerializableFunction<T,?>... columns)

关键字条件
关键字不为空返回条件,否则返回null

static <T> Expression

Sql.lower(SerializableFunction<T,?> column)

转小写

static <T> Expression

Sql.max(SerializableFunction<T,?> column)

max 最大值

static <T> Expression

Sql.min(SerializableFunction<T,?> column)

min 最小值

static <T> Expression

Sql.mod(SerializableFunction<T,?> column, Number m)

取余

static <T> Expression

Sql.nullIf(SerializableFunction<T,?> column1, SerializableFunction<T,?> column2)

等值置空

static <T> Expression

Sql.octetLength(SerializableFunction<T,?> column)

字符长度

static <T> Expression

Sql.position(String substr, SerializableFunction<T,?> column)

获取字符串在列中下标

static <T> Condition

Sql.regexpLike(SerializableFunction<T,?> column, String pattern)

正则匹配

static <T> Expression

Sql.replace(SerializableFunction<T,?> column, String oldStr, String newStr)

替换字符串

static <T> Expression

Sql.round(SerializableFunction<T,?> column)

整数四舍五入(保留0位小数)

static <T> Expression

Sql.round(SerializableFunction<T,?> column, int scale)

四舍五入

static <T> Expression

Sql.row(SerializableFunction<T,?>... columns)

行构造器

static <T> Select

Sql.select(SerializableFunction<T,?>... selects)

select语句

static <T> Expression

Sql.stringAgg(SerializableFunction<T,?> column, String delimiter)

分组内字符串拼接

static <T> Expression

Sql.stringAggDistinct(SerializableFunction<T,?> column, String delimiter)

分组内字符串去重拼接

static <T> Expression

Sql.substring(SerializableFunction<T,?> column, int start, int length)

截取字符串

static <T> Expression

Sql.sum(SerializableFunction<T,?> column)

sum 求和

static <T> Expression

Sql.trim(SerializableFunction<T,?> column)

头尾去空格

static <T> Expression

Sql.upper(SerializableFunction<T,?> column)

转大写
Uses of SerializableFunction in org.huiche.dao.query

Methods in org.huiche.dao.query with parameters of type SerializableFunction

Modifier and Type

Method

Description

default <T> long

CountQuery.countColumn(Class<T> entityClass, SerializableFunction<T,?> column, Collection<? extends Condition> conditions)

指定列条数查询

default <T> long

CountQuery.countColumn(Class<T> entityClass, SerializableFunction<T,?> column, Consumer<Select> customizer)

指定列条数查询

default <T> long

CountQuery.countColumn(Class<T> entityClass, SerializableFunction<T,?> column, Condition... conditions)

指定列条数查询

default <T> long

CountQuery.countColumnDistinct(Class<T> entityClass, SerializableFunction<T,?> column, Collection<? extends Condition> conditions)

指定列条数去重查询

default <T> long

CountQuery.countColumnDistinct(Class<T> entityClass, SerializableFunction<T,?> column, Consumer<Select> customizer)

指定列条数去重查询

default <T> long

CountQuery.countColumnDistinct(Class<T> entityClass, SerializableFunction<T,?> column, Condition... conditions)

指定列条数去重查询

default <T,R> R

GetColumnQuery.getColumn(Class<T> entityClass, SerializableFunction<T,R> column, Collection<? extends Condition> conditions)

单条记录查询单例(或表达式)

default <T,R> R

GetColumnQuery.getColumn(Class<T> entityClass, SerializableFunction<T,R> column, Consumer<Select> customizer)

单条记录查询单例(或表达式)

default <T,R> R

GetColumnQuery.getColumn(Class<T> entityClass, SerializableFunction<T,R> column, Condition... conditions)

单条记录查询单例(或表达式)

default <T,R> R

GetColumnQuery.getColumn(SerializableFunction<T,R> column, Collection<? extends Condition> conditions)

单条记录查询单例(或表达式)

default <T,R> R

GetColumnQuery.getColumn(SerializableFunction<T,R> column, Consumer<Select> customizer)

单条记录查询单例(或表达式)

default <T,R> R

GetColumnQuery.getColumn(SerializableFunction<T,R> column, Condition... conditions)

单条记录查询单例(或表达式)

default <T,R> R

GetColumnQuery.getColumnById(Class<T> entityClass, SerializableFunction<T,R> column, Serializable id, Collection<? extends Condition> conditions)

单条记录查询单例(或表达式)

default <T,R> R

GetColumnQuery.getColumnById(Class<T> entityClass, SerializableFunction<T,R> column, Serializable id, Condition... conditions)

单条记录查询单例(或表达式)

default <T,R> R

GetColumnQuery.getColumnById(SerializableFunction<T,R> column, Serializable id, Collection<? extends Condition> conditions)

单条记录查询单例(或表达式)

default <T,R> R

GetColumnQuery.getColumnById(SerializableFunction<T,R> column, Serializable id, Condition... conditions)

单条记录查询单例(或表达式)

default <T,E> List<E>

ListColumnQuery.listColumn(Class<T> entityClass, SerializableFunction<T,E> column, Integer limit, Collection<? extends Condition> conditions)

列表查询

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, Integer limit, Condition... conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(Class<T> entityClass, SerializableFunction<T,E> column, Integer limit, Searchable search, Collection<? extends Condition> conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(Class<T> entityClass, SerializableFunction<T,E> column, Integer limit, Searchable search, Condition... conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(Class<T> entityClass, SerializableFunction<T,E> column, Collection<? extends Condition> conditions)

列表查询

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, Condition... conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(Class<T> entityClass, SerializableFunction<T,E> column, Pageable pageable, Collection<? extends Condition> conditions)

列表查询

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(Class<T> entityClass, SerializableFunction<T,E> column, Pageable pageable, Condition... conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(Class<T> entityClass, SerializableFunction<T,E> column, Pageable pageable, Searchable search, Collection<? extends Condition> conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(Class<T> entityClass, SerializableFunction<T,E> column, Pageable pageable, Searchable search, Condition... conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(Class<T> entityClass, SerializableFunction<T,E> column, Searchable search, Collection<? extends Condition> conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(Class<T> entityClass, SerializableFunction<T,E> column, Searchable search, Condition... conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(SerializableFunction<T,E> column, Integer limit, Collection<? extends Condition> conditions)

列表查询

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, Integer limit, Searchable search, Collection<? extends Condition> conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(SerializableFunction<T,E> column, Integer limit, Searchable search, Condition... conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(SerializableFunction<T,E> column, Collection<? extends Condition> conditions)

列表查询

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, Condition... conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(SerializableFunction<T,E> column, Pageable pageable, Collection<? extends Condition> conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(SerializableFunction<T,E> column, Pageable pageable, Consumer<Select> customizer)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(SerializableFunction<T,E> column, Pageable pageable, Condition... conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(SerializableFunction<T,E> column, Pageable pageable, Searchable search, Collection<? extends Condition> conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(SerializableFunction<T,E> column, Pageable pageable, Searchable search, Condition... conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(SerializableFunction<T,E> column, Searchable search, Collection<? extends Condition> conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumn(SerializableFunction<T,E> column, Searchable search, Condition... conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumnByIds(Class<T> entityClass, SerializableFunction<T,E> column, Serializable... ids)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumnByIds(Class<T> entityClass, SerializableFunction<T,E> column, Collection<?> ids, Collection<? extends Condition> conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumnByIds(Class<T> entityClass, SerializableFunction<T,E> column, Collection<?> ids, Condition... conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumnByIds(SerializableFunction<T,E> column, Serializable... ids)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumnByIds(SerializableFunction<T,E> column, Collection<?> ids, Collection<? extends Condition> conditions)

列表查询

default <T,E> List<E>

ListColumnQuery.listColumnByIds(SerializableFunction<T,E> column, Collection<?> ids, Condition... conditions)

列表查询

default <T,R> Optional<R>

OptionalQuery.optionalColumn(Class<T> entityClass, SerializableFunction<T,R> column, Collection<? extends Condition> conditions)

单条记录查询单例(或表达式)

default <T,R> Optional<R>

OptionalQuery.optionalColumn(Class<T> entityClass, SerializableFunction<T,R> column, Consumer<Select> customizer)

单条记录查询单例(或表达式)

default <T,R> Optional<R>

OptionalQuery.optionalColumn(Class<T> entityClass, SerializableFunction<T,R> column, Condition... conditions)

单条记录查询单例(或表达式)

default <T,R> Optional<R>

OptionalQuery.optionalColumn(SerializableFunction<T,R> column, Collection<? extends Condition> conditions)

单条记录查询单例(或表达式)

default <T,R> Optional<R>

OptionalQuery.optionalColumn(SerializableFunction<T,R> column, Consumer<Select> customizer)

单条记录查询单例(或表达式)

default <T,R> Optional<R>

OptionalQuery.optionalColumn(SerializableFunction<T,R> column, Condition... conditions)

单条记录查询单例(或表达式)

default <T,R> Optional<R>

OptionalQuery.optionalColumnById(Class<T> entityClass, SerializableFunction<T,R> column, Serializable id, Collection<? extends Condition> conditions)

单条记录查询单例(或表达式)

default <T,R> Optional<R>

OptionalQuery.optionalColumnById(Class<T> entityClass, SerializableFunction<T,R> column, Serializable id, Condition... conditions)

单条记录查询单例(或表达式)

default <T,R> Optional<R>

OptionalQuery.optionalColumnById(SerializableFunction<T,R> column, Serializable id, Collection<? extends Condition> conditions)

单条记录查询单例(或表达式)
Uses of SerializableFunction in org.huiche.dao.query.entity

Methods in org.huiche.dao.query.entity with parameters of type SerializableFunction

Modifier and Type

Method

Description

default long

EntityCountQuery.countColumn(SerializableFunction<T,?> column, Collection<? extends Condition> conditions)

指定列条数查询

default long

EntityCountQuery.countColumn(SerializableFunction<T,?> column, Consumer<Select> customizer)

指定列条数查询

default long

EntityCountQuery.countColumn(SerializableFunction<T,?> column, Condition... conditions)

指定列条数查询

default long

EntityCountQuery.countColumnDistinct(SerializableFunction<T,?> column, Collection<? extends Condition> conditions)

指定列条数去重查询

default long

EntityCountQuery.countColumnDistinct(SerializableFunction<T,?> column, Consumer<Select> customizer)

指定列条数去重查询

default long

EntityCountQuery.countColumnDistinct(SerializableFunction<T,?> column, Condition... conditions)

指定列条数去重查询

default <R> R

EntityGetColumnQuery.getColumn(SerializableFunction<T,R> column, Collection<? extends Condition> conditions)

单条记录查询单例(或表达式)

default <R> R

EntityGetColumnQuery.getColumn(SerializableFunction<T,R> column, Consumer<Select> customizer)

单条记录查询单例(或表达式)

default <R> R

EntityGetColumnQuery.getColumn(SerializableFunction<T,R> column, Condition... conditions)

单条记录查询单例(或表达式)

default <R> R

EntityGetColumnQuery.getColumnById(SerializableFunction<T,R> column, Serializable id, Collection<? extends Condition> conditions)

单条记录查询单例(或表达式)

default <R> R

EntityGetColumnQuery.getColumnById(SerializableFunction<T,R> column, Serializable id, Condition... conditions)

单条记录查询单例(或表达式)

default <E> List<E>

EntityListColumnQuery.listColumn(SerializableFunction<T,E> column, Integer limit, Collection<? extends Condition> conditions)

列表查询

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, Integer limit, Condition... conditions)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumn(SerializableFunction<T,E> column, Integer limit, Searchable search, Collection<? extends Condition> conditions)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumn(SerializableFunction<T,E> column, Integer limit, Searchable search, Condition... conditions)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumn(SerializableFunction<T,E> column, Collection<? extends Condition> conditions)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumn(SerializableFunction<T,E> column, Consumer<Select> customizer)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumn(SerializableFunction<T,E> column, Condition... conditions)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumn(SerializableFunction<T,E> column, Pageable pageable, Collection<? extends Condition> conditions)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumn(SerializableFunction<T,E> column, Pageable pageable, Consumer<Select> customizer)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumn(SerializableFunction<T,E> column, Pageable pageable, Condition... conditions)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumn(SerializableFunction<T,E> column, Pageable pageable, Searchable search, Collection<? extends Condition> conditions)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumn(SerializableFunction<T,E> column, Pageable pageable, Searchable search, Condition... conditions)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumn(SerializableFunction<T,E> column, Searchable search, Collection<? extends Condition> conditions)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumn(SerializableFunction<T,E> column, Searchable search, Condition... conditions)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumnByIds(SerializableFunction<T,E> column, Serializable... ids)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumnByIds(SerializableFunction<T,E> column, Collection<?> ids, Collection<? extends Condition> conditions)

列表查询

default <E> List<E>

EntityListColumnQuery.listColumnByIds(SerializableFunction<T,E> column, Collection<?> ids, Condition... conditions)

列表查询

default <R> Optional<R>

EntityOptionalQuery.optionalColumn(SerializableFunction<T,R> column, Collection<? extends Condition> conditions)

单条记录查询单例(或表达式)

default <R> Optional<R>

EntityOptionalQuery.optionalColumn(SerializableFunction<T,R> column, Consumer<Select> customizer)

单条记录查询单例(或表达式)

default <R> Optional<R>

EntityOptionalQuery.optionalColumn(SerializableFunction<T,R> column, Condition... conditions)

单条记录查询单例(或表达式)

default <R> Optional<R>

EntityOptionalQuery.optionalColumnById(SerializableFunction<T,R> column, Serializable id, Collection<? extends Condition> conditions)

单条记录查询单例(或表达式)

default <R> Optional<R>

EntityOptionalQuery.optionalColumnById(SerializableFunction<T,R> column, Serializable id, Condition... conditions)

单条记录查询单例(或表达式)

Uses of Interfaceorg.huiche.core.support.SerializableFunction

Uses of SerializableFunction in org.huiche.ast.metadata

Uses of SerializableFunction in org.huiche.ast.operable

Uses of SerializableFunction in org.huiche.ast.statement.clause

Uses of SerializableFunction in org.huiche.ast.support

Uses of SerializableFunction in org.huiche.dao.query

Uses of SerializableFunction in org.huiche.dao.query.entity

Uses of Interface
org.huiche.core.support.SerializableFunction