net.ymate.platform.persistence.jdbc.query

Interface Func.Strings

All Known Implementing Classes:

QueryBuilder

Enclosing interface:

Func

public static interface Func.Strings

String Functions

Method Summary

Modifier and Type	Method and Description
default IFunction	ASCII(IFunction str)
default IFunction	ASCII(String str)
default IFunction	BIN(IFunction str)
default IFunction	BIN(String str)
default IFunction	BIT_LENGTH(IFunction str)
default IFunction	BIT_LENGTH(String str)
default IFunction	CHAR_LENGTH(IFunction str)
default IFunction	CHAR_LENGTH(String str)
default IFunction	CHAR(IFunction... n)
default IFunction	CHAR(String... n)
default IFunction	CHARACTER_LENGTH(IFunction str)
default IFunction	CHARACTER_LENGTH(String str)
default IFunction	CONCAT_WS(String separator, IFunction... n)
default IFunction	CONCAT_WS(String separator, String... n)
default IFunction	CONCAT(IFunction... n)
default IFunction	CONCAT(String... n)
default IFunction	ELT(IFunction n, IFunction... strs)
default IFunction	ELT(String n, String... strs)
default IFunction	FIELD(IFunction str, IFunction... n)
default IFunction	FIELD(String str, String... n)
default IFunction	FIND_IN_SET(IFunction x, IFunction strlist)
default IFunction	FIND_IN_SET(String x, String strlist)
default IFunction	FORMAT(IFunction x, Number d)
default IFunction	FORMAT(IFunction x, Number d, String locale)
default IFunction	FORMAT(String x, Number d)
default IFunction	FORMAT(String x, Number d, String locale)
default IFunction	FROM_BASE64(IFunction str)
default IFunction	FROM_BASE64(String str)
default IFunction	HEX(IFunction str)
default IFunction	HEX(String str)
default IFunction	INSERT(IFunction str, Number pos, Number len, IFunction newstr)
default IFunction	INSERT(String str, Number pos, Number len, String newstr)
default IFunction	INSTR(IFunction str, IFunction substr)
default IFunction	INSTR(String str, String substr)
default IFunction	LEFT(IFunction str, Number len)
default IFunction	LEFT(String str, Number len)
default IFunction	LENGTH(IFunction str)
default IFunction	LENGTH(String str)
default IFunction	LOAD_FILE(IFunction str)
default IFunction	LOAD_FILE(String str)
default IFunction	LOCATE(IFunction substr, IFunction str)
default IFunction	LOCATE(IFunction substr, IFunction str, String pos)
default IFunction	LOCATE(String substr, String str)
default IFunction	LOCATE(String substr, String str, String pos)
default IFunction	LOWER(IFunction str)
default IFunction	LOWER(String str)
default IFunction	LPAD(IFunction str, Number len, IFunction padstr)
default IFunction	LPAD(String str, Number len, String padstr)
default IFunction	LTRIM(IFunction str)
default IFunction	LTRIM(String str)
default IFunction	OCT(IFunction str)
default IFunction	OCT(String str)
default IFunction	ORD(IFunction str)
default IFunction	ORD(String str)
default IFunction	QUOTE(IFunction str)
default IFunction	QUOTE(String str)
default IFunction	REPEAT(IFunction str, Number count)
default IFunction	REPEAT(String str, Number count)
default IFunction	REPLACE(IFunction str, IFunction fromStr, IFunction toStr)
default IFunction	REPLACE(String str, String fromStr, String toStr)
default IFunction	REVERSE(IFunction str)
default IFunction	REVERSE(String str)
default IFunction	RIGHT(IFunction str, Number len)
default IFunction	RIGHT(String str, Number len)
default IFunction	RPAD(IFunction str, Number len, IFunction padstr)
default IFunction	RPAD(String str, Number len, String padstr)
default IFunction	RTRIM(IFunction str)
default IFunction	RTRIM(String str)
default IFunction	SOUNDEX(IFunction str)
default IFunction	SOUNDEX(String str)
default IFunction	SPACE(Number n)
default IFunction	STRCMP(IFunction expr1, IFunction expr2)
default IFunction	STRCMP(String expr1, String expr2)
default IFunction	SUBSTRING_INDEX(IFunction str, IFunction delim, Number count)
default IFunction	SUBSTRING_INDEX(String str, String delim, Number count)
default IFunction	SUBSTRING(IFunction str, Number pos)
default IFunction	SUBSTRING(IFunction str, Number pos, Number len)
default IFunction	SUBSTRING(String str, Number pos)
default IFunction	SUBSTRING(String str, Number pos, Number len)
default IFunction	TO_BASE64(IFunction str)
default IFunction	TO_BASE64(String str)
default IFunction	TRIM_BOTH(IFunction remstr, IFunction str)
default IFunction	TRIM_BOTH(String remstr, String str)
default IFunction	TRIM_LEADIN(IFunction remstr, IFunction str)
default IFunction	TRIM_LEADIN(String remstr, String str)
default IFunction	TRIM_TRAILING(IFunction remstr, IFunction str)
default IFunction	TRIM_TRAILING(String remstr, String str)
default IFunction	TRIM(IFunction str)
default IFunction	TRIM(String str)
default IFunction	UNHEX(IFunction str)
default IFunction	UNHEX(String str)
default IFunction	UPPER(IFunction str)
default IFunction	UPPER(String str)

Method Detail

ASCII

default IFunction ASCII(String str)

ASCII

default IFunction ASCII(IFunction str)

BIN

default IFunction BIN(String str)

BIN

default IFunction BIN(IFunction str)

BIT_LENGTH

default IFunction BIT_LENGTH(String str)

BIT_LENGTH

default IFunction BIT_LENGTH(IFunction str)

CHAR

default IFunction CHAR(String... n)

CHAR

default IFunction CHAR(IFunction... n)

CHAR_LENGTH

default IFunction CHAR_LENGTH(String str)

CHAR_LENGTH

default IFunction CHAR_LENGTH(IFunction str)

CHARACTER_LENGTH

default IFunction CHARACTER_LENGTH(String str)

CHARACTER_LENGTH

default IFunction CHARACTER_LENGTH(IFunction str)

CONCAT

default IFunction CONCAT(String... n)

CONCAT

default IFunction CONCAT(IFunction... n)

CONCAT_WS

default IFunction CONCAT_WS(String separator,
                            String... n)

CONCAT_WS

default IFunction CONCAT_WS(String separator,
                            IFunction... n)

ELT

default IFunction ELT(String n,
                      String... strs)

ELT

default IFunction ELT(IFunction n,
                      IFunction... strs)

FIELD

default IFunction FIELD(String str,
                        String... n)

FIELD

default IFunction FIELD(IFunction str,
                        IFunction... n)

FIND_IN_SET

default IFunction FIND_IN_SET(String x,
                              String strlist)

FIND_IN_SET

default IFunction FIND_IN_SET(IFunction x,
                              IFunction strlist)

FORMAT

default IFunction FORMAT(String x,
                         Number d)

FORMAT

default IFunction FORMAT(IFunction x,
                         Number d)

FORMAT

default IFunction FORMAT(String x,
                         Number d,
                         String locale)

FORMAT

default IFunction FORMAT(IFunction x,
                         Number d,
                         String locale)

HEX

default IFunction HEX(String str)

HEX

default IFunction HEX(IFunction str)

FROM_BASE64

default IFunction FROM_BASE64(String str)

FROM_BASE64

default IFunction FROM_BASE64(IFunction str)

TO_BASE64

default IFunction TO_BASE64(String str)

TO_BASE64

default IFunction TO_BASE64(IFunction str)

INSERT

default IFunction INSERT(String str,
                         Number pos,
                         Number len,
                         String newstr)

INSERT

default IFunction INSERT(IFunction str,
                         Number pos,
                         Number len,
                         IFunction newstr)

INSTR

default IFunction INSTR(String str,
                        String substr)

INSTR

default IFunction INSTR(IFunction str,
                        IFunction substr)

LEFT

default IFunction LEFT(String str,
                       Number len)

LEFT

default IFunction LEFT(IFunction str,
                       Number len)

LENGTH

default IFunction LENGTH(String str)

LENGTH

default IFunction LENGTH(IFunction str)

LOAD_FILE

default IFunction LOAD_FILE(String str)

LOAD_FILE

default IFunction LOAD_FILE(IFunction str)

LOCATE

default IFunction LOCATE(String substr,
                         String str)

LOCATE

default IFunction LOCATE(IFunction substr,
                         IFunction str)

LOCATE

default IFunction LOCATE(String substr,
                         String str,
                         String pos)

LOCATE

default IFunction LOCATE(IFunction substr,
                         IFunction str,
                         String pos)

LOWER

default IFunction LOWER(String str)

LOWER

default IFunction LOWER(IFunction str)

LPAD

default IFunction LPAD(String str,
                       Number len,
                       String padstr)

LPAD

default IFunction LPAD(IFunction str,
                       Number len,
                       IFunction padstr)

LTRIM

default IFunction LTRIM(String str)

LTRIM

default IFunction LTRIM(IFunction str)

OCT

default IFunction OCT(String str)

OCT

default IFunction OCT(IFunction str)

ORD

default IFunction ORD(String str)

ORD

default IFunction ORD(IFunction str)

QUOTE

default IFunction QUOTE(String str)

QUOTE

default IFunction QUOTE(IFunction str)

REPEAT

default IFunction REPEAT(String str,
                         Number count)

REPEAT

default IFunction REPEAT(IFunction str,
                         Number count)

REPLACE

default IFunction REPLACE(String str,
                          String fromStr,
                          String toStr)

REPLACE

default IFunction REPLACE(IFunction str,
                          IFunction fromStr,
                          IFunction toStr)

REVERSE

default IFunction REVERSE(String str)

REVERSE

default IFunction REVERSE(IFunction str)

RIGHT

default IFunction RIGHT(String str,
                        Number len)

RIGHT

default IFunction RIGHT(IFunction str,
                        Number len)

RPAD

default IFunction RPAD(String str,
                       Number len,
                       String padstr)

RPAD

default IFunction RPAD(IFunction str,
                       Number len,
                       IFunction padstr)

RTRIM

default IFunction RTRIM(String str)

RTRIM

default IFunction RTRIM(IFunction str)

SOUNDEX

default IFunction SOUNDEX(String str)

SOUNDEX

default IFunction SOUNDEX(IFunction str)

SPACE

default IFunction SPACE(Number n)

STRCMP

default IFunction STRCMP(String expr1,
                         String expr2)

STRCMP

default IFunction STRCMP(IFunction expr1,
                         IFunction expr2)

SUBSTRING

default IFunction SUBSTRING(String str,
                            Number pos)

SUBSTRING

default IFunction SUBSTRING(IFunction str,
                            Number pos)

SUBSTRING

default IFunction SUBSTRING(String str,
                            Number pos,
                            Number len)

SUBSTRING

default IFunction SUBSTRING(IFunction str,
                            Number pos,
                            Number len)

SUBSTRING_INDEX

default IFunction SUBSTRING_INDEX(String str,
                                  String delim,
                                  Number count)

SUBSTRING_INDEX

default IFunction SUBSTRING_INDEX(IFunction str,
                                  IFunction delim,
                                  Number count)

TRIM

default IFunction TRIM(String str)

TRIM

default IFunction TRIM(IFunction str)

TRIM_BOTH

default IFunction TRIM_BOTH(String remstr,
                            String str)

TRIM_BOTH

default IFunction TRIM_BOTH(IFunction remstr,
                            IFunction str)

TRIM_LEADIN

default IFunction TRIM_LEADIN(String remstr,
                              String str)

TRIM_LEADIN

default IFunction TRIM_LEADIN(IFunction remstr,
                              IFunction str)

TRIM_TRAILING

default IFunction TRIM_TRAILING(String remstr,
                                String str)

TRIM_TRAILING

default IFunction TRIM_TRAILING(IFunction remstr,
                                IFunction str)

UNHEX

default IFunction UNHEX(String str)

UNHEX

default IFunction UNHEX(IFunction str)

UPPER

default IFunction UPPER(String str)

UPPER

default IFunction UPPER(IFunction str)