com.dynamic.sql.core.column.function.string

类 GroupConcat.GroupConcatOptions

java.lang.Object

com.dynamic.sql.core.column.function.string.GroupConcat.GroupConcatOptions

封闭类:

GroupConcat

public static class GroupConcat.GroupConcatOptions
extends Object

group_concat 子句配置对象。

用于描述 group_concat 的可选子句，包括：

• distinct
• order by 多字段
• separator 分隔符

示例：

 new GroupConcatOptions(User::getName)
     .distinct(User::getName)
     .orderBy(User::getAge, ASC)
     .thenOrderBy(User::getId, DESC)
     .separator("; ");
 

构造器概要

构造器

构造器和说明
GroupConcatOptions()
GroupConcatOptions(FieldFn<T,F> fn)

方法概要

限定符和类型	方法和说明
<T,F> GroupConcat.GroupConcatOptions	distinct(FieldFn<T,F> fn) DISTINCT
protected Distinct	getDistinct()
protected FieldFn	getFn()
protected List<OrderBy>	getOrderByList()
protected String	getSeparator()
<T2,F2> GroupConcat.GroupConcatOptions	orderBy(FieldFn<T2,F2> fn, SortOrder sortOrder) ORDER BY ASC
GroupConcat.GroupConcatOptions	orderBy(OrderBy orderBy)
GroupConcat.GroupConcatOptions	separator(String separator) SEPARATOR
<T2,F2> GroupConcat.GroupConcatOptions	thenOrderBy(FieldFn<T2,F2> fn, SortOrder sortOrder)
GroupConcat.GroupConcatOptions	thenOrderBy(OrderBy orderBy)

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

构造器详细资料

GroupConcatOptions

public GroupConcatOptions()

GroupConcatOptions

public GroupConcatOptions(FieldFn<T,F> fn)

方法详细资料

distinct

public <T,F> GroupConcat.GroupConcatOptions distinct(FieldFn<T,F> fn)

DISTINCT

orderBy

public <T2,F2> GroupConcat.GroupConcatOptions orderBy(FieldFn<T2,F2> fn,
                                                      SortOrder sortOrder)

ORDER BY ASC

thenOrderBy

public <T2,F2> GroupConcat.GroupConcatOptions thenOrderBy(FieldFn<T2,F2> fn,
                                                          SortOrder sortOrder)

orderBy

public GroupConcat.GroupConcatOptions orderBy(OrderBy orderBy)

thenOrderBy

public GroupConcat.GroupConcatOptions thenOrderBy(OrderBy orderBy)

separator

public GroupConcat.GroupConcatOptions separator(String separator)

SEPARATOR

getOrderByList

protected List<OrderBy> getOrderByList()

getSeparator

protected String getSeparator()

getDistinct

protected Distinct getDistinct()

getFn

protected FieldFn getFn()