程序包 org.babyfish.jimmer.sql.ast.impl

接口 StringExpressionImplementor

所有超级接口:

ComparableExpression<String>, ComparableExpressionImplementor<String>, Expression<String>, ExpressionImplementor<String>, Selection<String>, StringExpression

public interface StringExpressionImplementor
extends StringExpression, ComparableExpressionImplementor<String>

嵌套类概要

从接口继承的嵌套类/接口 org.babyfish.jimmer.sql.ast.Expression

Expression.AnyFactory, Expression.ComparableFactory, Expression.DateFactory, Expression.NumericFactory, Expression.StringFactory, Expression.TemporalFactory

方法概要

修饰符和类型	方法	说明
default @NotNull StringExpression	coalesce(String defaultValue)
default @NotNull StringExpression	coalesce(Expression<String> defaultExpr)
default @NotNull CoalesceBuilder.Str	coalesceBuilder()
default StringExpression	concat(String... others)
default @NotNull StringExpression	concat(Expression<String>... others)
default Class<String>	getType()
default @NotNull Predicate	ilike(@NotNull String pattern, @NotNull LikeMode likeMode)	Returns a case-insensitive LIKE predicate with the given pattern and match mode.
default StringExpression	left(Expression<Integer> length)	Returns the leftmost characters from a string.
default NumericExpression<Integer>	length()	Returns the length of the string.
default @NotNull Predicate	like(@NotNull String pattern, @NotNull LikeMode likeMode)	Returns a LIKE predicate with the given pattern and match mode.
default StringExpression	lower()
default StringExpression	lpad(int length, String padString)	Left-pads a string with a specified pad string to a certain length.
default StringExpression	lpad(Expression<Integer> length, String padString)	Left-pads a string with a specified pad string to a certain length.
default StringExpression	ltrim()	Returns a string with leading whitespace removed.
default NumericExpression<Integer>	position(String substring, Expression<Integer> start)	Returns the position of the first occurrence of a substring in a string, starting the search at a specified position.
default StringExpression	replace(String target, String replacement)	Replaces all occurrences of a specified target string with a specified replacement string.
default StringExpression	reverse()	Returns a string with characters in reverse order.
default StringExpression	right(Expression<Integer> length)	Returns the rightmost characters from a string.
default StringExpression	rpad(int length, String padString)	Right-pads a string with a specified pad string to a certain length.
default StringExpression	rpad(Expression<Integer> length, String padString)	Right-pads a string with a specified pad string to a certain length.
default StringExpression	rtrim()	Returns a string with trailing whitespace removed.
default StringExpression	substring(Expression<Integer> start, Expression<Integer> length)	Returns a substring starting from the specified position with the specified length.
default StringExpression	trim()	Returns a string with leading and trailing whitespace removed.
default StringExpression	upper()

从接口继承的方法 org.babyfish.jimmer.sql.ast.ComparableExpression

betweenIf, betweenIf, geIf, geIf, gtIf, gtIf, leIf, leIf, ltIf, ltIf, notBetweenIf, notBetweenIf

从接口继承的方法 org.babyfish.jimmer.sql.ast.impl.ComparableExpressionImplementor

between, between, ge, ge, gt, gt, le, le, lt, lt, max, min, notBetween, notBetween

从接口继承的方法 org.babyfish.jimmer.sql.ast.Expression

eqIf, eqIf, expressionIn, expressionNotIn, inIf, inIf, inIf, inIf, neIf, neIf, notInIf, notInIf, notInIf, notInIf, nullableInIf, nullableInIf, nullableNotInIf, nullableNotInIf

从接口继承的方法 org.babyfish.jimmer.sql.ast.impl.ExpressionImplementor

asc, count, count, desc, eq, eq, in, in, isNotNull, isNull, ne, ne, notIn, notIn, nullableIn, nullableNotIn, precedence

从接口继承的方法 org.babyfish.jimmer.sql.ast.StringExpression

ilike, ilikeIf, ilikeIf, ilikeIf, ilikeIf, left, like, likeIf, likeIf, likeIf, likeIf, position, position, right, substring, substring, substring

方法详细资料

getType

default Class<String> getType()

指定者:

getType 在接口中 ExpressionImplementor<String>

like

@NotNull
default @NotNull Predicate like(@NotNull
 @NotNull String pattern,
 @NotNull
 @NotNull LikeMode likeMode)

从接口复制的说明: StringExpression

Returns a LIKE predicate with the given pattern and match mode.

Neither the pattern nor match mode may be null.

指定者:

like 在接口中 StringExpression

参数:

pattern - the pattern to match, must not be null

likeMode - the mode determining how to match the pattern, must not be null

返回:

the LIKE predicate

ilike

@NotNull
default @NotNull Predicate ilike(@NotNull
 @NotNull String pattern,
 @NotNull
 @NotNull LikeMode likeMode)

从接口复制的说明: StringExpression

Returns a case-insensitive LIKE predicate with the given pattern and match mode.

Neither the pattern nor like mode may be null, otherwise NullPointerException will be thrown.

指定者:

ilike 在接口中 StringExpression

参数:

pattern - the pattern to match in the LIKE predicate, must not be null

likeMode - the mode determining how to match the pattern, must not be null

返回:

the case-insensitive LIKE predicate

upper

default StringExpression upper()

指定者:

upper 在接口中 StringExpression

lower

default StringExpression lower()

指定者:

lower 在接口中 StringExpression

trim

default StringExpression trim()

从接口复制的说明: StringExpression

Returns a string with leading and trailing whitespace removed.

指定者:

trim 在接口中 StringExpression

返回:

a trimmed version of this string expression

ltrim

default StringExpression ltrim()

从接口复制的说明: StringExpression

Returns a string with leading whitespace removed.

指定者:

ltrim 在接口中 StringExpression

返回:

a left-trimmed version of this string expression

rtrim

default StringExpression rtrim()

从接口复制的说明: StringExpression

Returns a string with trailing whitespace removed.

指定者:

rtrim 在接口中 StringExpression

返回:

a right-trimmed version of this string expression

length

default NumericExpression<Integer> length()

从接口复制的说明: StringExpression

Returns the length of the string.

指定者:

length 在接口中 StringExpression

返回:

an expression representing the length of this string

concat

default StringExpression concat(String... others)

指定者:

concat 在接口中 StringExpression

concat

@NotNull
default @NotNull StringExpression concat(Expression<String>... others)

指定者:

concat 在接口中 StringExpression

substring

default StringExpression substring(Expression<Integer> start,
 Expression<Integer> length)

从接口复制的说明: StringExpression

Returns a substring starting from the specified position with the specified length.

指定者:

substring 在接口中 StringExpression

参数:

start - the starting position expression (1-based index)

length - the length expression of the substring

返回:

a substring of this string expression

coalesce

@NotNull
default @NotNull StringExpression coalesce(String defaultValue)

指定者:

coalesce 在接口中 ComparableExpression<String>

指定者:

coalesce 在接口中 ComparableExpressionImplementor<String>

指定者:

coalesce 在接口中 Expression<String>

指定者:

coalesce 在接口中 ExpressionImplementor<String>

指定者:

coalesce 在接口中 StringExpression

coalesce

@NotNull
default @NotNull StringExpression coalesce(Expression<String> defaultExpr)

指定者:

coalesce 在接口中 ComparableExpression<String>

指定者:

coalesce 在接口中 ComparableExpressionImplementor<String>

指定者:

coalesce 在接口中 Expression<String>

指定者:

coalesce 在接口中 ExpressionImplementor<String>

指定者:

coalesce 在接口中 StringExpression

coalesceBuilder

default @NotNull CoalesceBuilder.Str coalesceBuilder()

指定者:

coalesceBuilder 在接口中 ComparableExpression<String>

指定者:

coalesceBuilder 在接口中 ComparableExpressionImplementor<String>

指定者:

coalesceBuilder 在接口中 Expression<String>

指定者:

coalesceBuilder 在接口中 ExpressionImplementor<String>

指定者:

coalesceBuilder 在接口中 StringExpression

replace

default StringExpression replace(String target,
 String replacement)

从接口复制的说明: StringExpression

Replaces all occurrences of a specified target string with a specified replacement string.

指定者:

replace 在接口中 StringExpression

参数:

target - the string to be replaced

replacement - the string to replace all occurrences of target

返回:

a new string expression with all occurrences of target replaced by replacement

reverse

default StringExpression reverse()

从接口复制的说明: StringExpression

Returns a string with characters in reverse order. For example, reverse("SQL Tutorial") returns "lairotuT LQS".

指定者:

reverse 在接口中 StringExpression

返回:

a new string expression with all characters in reverse order

lpad

default StringExpression lpad(int length,
 String padString)

从接口复制的说明: StringExpression

Left-pads a string with a specified pad string to a certain length. If the original string is longer than the specified length, the result is truncated.

指定者:

lpad 在接口中 StringExpression

参数:

length - the desired length of the output string

padString - the string to use for padding

返回:

a left-padded string expression

lpad

default StringExpression lpad(Expression<Integer> length,
 String padString)

从接口复制的说明: StringExpression

Left-pads a string with a specified pad string to a certain length. If the original string is longer than the specified length, the result is truncated.

指定者:

lpad 在接口中 StringExpression

参数:

length - the expression representing the desired length of the output string

padString - the string to use for padding

返回:

a left-padded string expression

rpad

default StringExpression rpad(int length,
 String padString)

从接口复制的说明: StringExpression

Right-pads a string with a specified pad string to a certain length. If the original string is longer than the specified length, the result is truncated.

指定者:

rpad 在接口中 StringExpression

参数:

length - the desired length of the output string

padString - the string to use for padding

返回:

a right-padded string expression

rpad

default StringExpression rpad(Expression<Integer> length,
 String padString)

从接口复制的说明: StringExpression

Right-pads a string with a specified pad string to a certain length. If the original string is longer than the specified length, the result is truncated.

指定者:

rpad 在接口中 StringExpression

参数:

length - the expression representing the desired length of the output string

padString - the string to use for padding

返回:

a right-padded string expression

position

default NumericExpression<Integer> position(String substring,
 Expression<Integer> start)

从接口复制的说明: StringExpression

Returns the position of the first occurrence of a substring in a string, starting the search at a specified position. The position is 1-based (the first position is 1, not 0). Returns 0 if the substring is not found.

指定者:

position 在接口中 StringExpression

参数:

substring - the substring to find

start - the expression representing the position to start the search from (1-based)

返回:

an expression representing the position of the substring

left

default StringExpression left(Expression<Integer> length)

从接口复制的说明: StringExpression

Returns the leftmost characters from a string.

指定者:

left 在接口中 StringExpression

参数:

length - an expression representing the number of characters to extract

返回:

a string expression containing the leftmost characters

right

default StringExpression right(Expression<Integer> length)

从接口复制的说明: StringExpression

Returns the rightmost characters from a string.

指定者:

right 在接口中 StringExpression

参数:

length - an expression representing the number of characters to extract

返回:

a string expression containing the rightmost characters