db.sql.api.impl.cmd.dbFun

接口 FunctionInterface

所有超级接口:

Cmd

所有已知实现类:

Abs, AbstractDatasetField, AbstractField, Acos, AllField, Asin, Atan, Avg, BasicFunction, BasicValue, Case, Ceil, CharLength, Column, Concat, ConcatAs, Cos, Cot, Count, Count1, CountAll, CurrentDate, CurrentDateTime, CurrentTime, DatasetField, DateAdd, DateDiff, DateFormat, Day, Degrees, Divide, Exp, Field, FindInSet, Floor, FromUnixTime, FunTemplate, Hour, If, IfNull, InetAton, InetNtoa, Instr, JsonContains, JsonContainsPath, JsonExtract, JsonQuote, Left, Length, Log, Log10, Log2, Lower, Lpad, Ltrim, Max, Md5, Min, Mod, Month, Multiply, Pi, Plus, Pow, Radians, Rand, Repeat, Replace, Reverse, Right, Round, Rpad, Rtrim, Sign, Sin, Sqrt, Strcmp, SubStr, Subtract, Sum, TableField, Tan, Trim, Truncate, UnixTimestamp, Upper, Weekday, Year

public interface FunctionInterface
extends Cmd

方法概要

限定符和类型	方法和说明
default Abs	abs()
default Acos	acos()
default Asin	asin()
default Atan	atan()
default Avg	avg()
default Between	between(Serializable value1, Serializable value2)
default Ceil	ceil()
default CharLength	charLength()
default Concat	concat(Cmd... values)
default Concat	concat(Serializable... values)
default ConcatAs	concatAs(String split, Cmd... values)
default ConcatAs	concatAs(String split, Serializable... values)
default Cos	cos()
default Cot	cot()
default Count	count()
default Count	count(boolean distinct)
default DateFormat	date()
default DateAdd	dateAdd(int n)
default DateAdd	dateAdd(int n, TimeUnit timeUnit)
default DateDiff	dateDiff(Cmd another) 返回 日期差（正数）
default DateDiff	dateDiff(Object another) 返回 日期差（正数）
default DateFormat	dateFormat(DatePattern pattern)
default DateFormat	dateFormat(String pattern)
default DateAdd	dateSub(int n)
default DateAdd	dateSub(int n, TimeUnit timeUnit)
default Day	day()
default Degrees	degrees()
default Divide	divide(Cmd value)
default Divide	divide(Number value)
default Empty	empty()
default Eq	eq(Object value)
default Exp	exp()
default Floor	floor()
default Gt	gt(Object value)
default Gte	gte(Object value)
default Hour	hour()
default IfNull	ifNull(Object value)
default In	in(Serializable... values)
default InetAton	inetAton()
default InetNtoa	inetNtoa()
default Instr	instr(String str)
default IsNull	isNull()
default Left	left(int length)
default Length	length()
default Like	like(LikeMode mode, Cmd value)
default Like	like(LikeMode mode, String value)
default Like	like(String value)
default Log	log()
default Log10	log10()
default Log2	log2()
default Lower	lower()
default Lpad	lpad(int length, String pad)
default Lt	lt(Object value)
default Lte	lte(Object value)
default Ltrim	ltrim()
default Max	max()
default Min	min()
default Mod	mod(Number number)
default Month	month()
default Multiply	multiply(Cmd value)
default Multiply	multiply(Number value)
default MysqlFunctions	mysql()
default Ne	ne(Object value)
default Between	notBetween(Serializable value1, Serializable value2)
default NotEmpty	notEmpty()
default NotIn	notIn(Serializable... values)
default NotLike	notLike(LikeMode mode, Cmd value)
default NotLike	notLike(LikeMode mode, String value)
default NotLike	notLike(String value)
default Plus	plus(Cmd value)
default Plus	plus(Number value)
default Pow	pow(int n)
default Radians	radians()
default Rand	rand()
default Rand	rand(Number max)
default Repeat	repeat(int n)
default Replace	replace(String target, String replacement)
default Reverse	reverse()
default Right	right(int length)
default Round	round()
default Round	round(int precision)
default Rpad	rpad(int length, String pad)
default Rtrim	rtrim()
default Sign	sign()
default Sin	sin()
default Sqrt	sqrt()
default Strcmp	strcmp(String s)
default SubStr	subStr(int start) 字段串截取
default SubStr	subStr(int start, int length) 字段串截取
default Subtract	subtract(Cmd value)
default Subtract	subtract(Number value)
default Sum	sum()
default Tan	tan()
default Trim	trim()
default Truncate	truncate()
default Truncate	truncate(int precision)
default Upper	upper()
default Weekday	weekday()
default Year	year()

从接口继承的方法 db.sql.api.Cmd

contain, sql

方法详细资料

mysql

default MysqlFunctions mysql()

sum

default Sum sum()

max

default Max max()

min

default Min min()

avg

default Avg avg()

abs

default Abs abs()

pow

default Pow pow(int n)

count

default Count count()

count

default Count count(boolean distinct)

round

default Round round()

round

default Round round(int precision)

ceil

default Ceil ceil()

floor

default Floor floor()

rand

default Rand rand()

rand

default Rand rand(Number max)

sign

default Sign sign()

truncate

default Truncate truncate()

truncate

default Truncate truncate(int precision)

sqrt

default Sqrt sqrt()

mod

default Mod mod(Number number)

exp

default Exp exp()

log

default Log log()

log2

default Log2 log2()

log10

default Log10 log10()

degrees

default Degrees degrees()

radians

default Radians radians()

sin

default Sin sin()

asin

default Asin asin()

cos

default Cos cos()

acos

default Acos acos()

tan

default Tan tan()

atan

default Atan atan()

cot

default Cot cot()

charLength

default CharLength charLength()

length

default Length length()

left

default Left left(int length)

right

default Right right(int length)

subStr

default SubStr subStr(int start)

字段串截取

参数:

start - 默认从1开始

返回:

subStr

default SubStr subStr(int start,
                      int length)

字段串截取

参数:

start - 默认从1开始

length - 截取长度

返回:

upper

default Upper upper()

lower

default Lower lower()

lpad

default Lpad lpad(int length,
                  String pad)

rpad

default Rpad rpad(int length,
                  String pad)

trim

default Trim trim()

ltrim

default Ltrim ltrim()

rtrim

default Rtrim rtrim()

strcmp

default Strcmp strcmp(String s)

repeat

default Repeat repeat(int n)

replace

default Replace replace(String target,
                        String replacement)

reverse

default Reverse reverse()

year

default Year year()

month

default Month month()

day

default Day day()

date

default DateFormat date()

dateFormat

default DateFormat dateFormat(String pattern)

dateFormat

default DateFormat dateFormat(DatePattern pattern)

weekday

default Weekday weekday()

hour

default Hour hour()

dateDiff

default DateDiff dateDiff(Cmd another)

返回 日期差（正数）

参数:

another -

返回:

dateDiff

default DateDiff dateDiff(Object another)

返回 日期差（正数）

参数:

another -

返回:

dateAdd

default DateAdd dateAdd(int n)

dateAdd

default DateAdd dateAdd(int n,
                        TimeUnit timeUnit)

dateSub

default DateAdd dateSub(int n)

dateSub

default DateAdd dateSub(int n,
                        TimeUnit timeUnit)

inetAton

default InetAton inetAton()

inetNtoa

default InetNtoa inetNtoa()

multiply

default Multiply multiply(Number value)

multiply

default Multiply multiply(Cmd value)

divide

default Divide divide(Number value)

divide

default Divide divide(Cmd value)

subtract

default Subtract subtract(Number value)

subtract

default Subtract subtract(Cmd value)

plus

default Plus plus(Number value)

plus

default Plus plus(Cmd value)

concat

default Concat concat(Serializable... values)

concat

default Concat concat(Cmd... values)

concatAs

default ConcatAs concatAs(String split,
                          Serializable... values)

concatAs

default ConcatAs concatAs(String split,
                          Cmd... values)

ifNull

default IfNull ifNull(Object value)

eq

default Eq eq(Object value)

gt

default Gt gt(Object value)

gte

default Gte gte(Object value)

lt

default Lt lt(Object value)

lte

default Lte lte(Object value)

ne

default Ne ne(Object value)

between

default Between between(Serializable value1,
                        Serializable value2)

notBetween

default Between notBetween(Serializable value1,
                           Serializable value2)

like

default Like like(String value)

like

default Like like(LikeMode mode,
                  String value)

like

default Like like(LikeMode mode,
                  Cmd value)

notLike

default NotLike notLike(String value)

notLike

default NotLike notLike(LikeMode mode,
                        String value)

notLike

default NotLike notLike(LikeMode mode,
                        Cmd value)

in

default In in(Serializable... values)

notIn

default NotIn notIn(Serializable... values)

isNull

default IsNull isNull()

empty

default Empty empty()

notEmpty

default NotEmpty notEmpty()

instr

default Instr instr(String str)