net.hasor.db.jdbc.lambda

Interface Compare<T,R>

All Known Subinterfaces:

LambdaOperations.LambdaQuery<T>

All Known Implementing Classes:

AbstractCompareQuery, LambdaQueryWrapper

public interface Compare<T,R>

动态拼条件。

主动调用or表示紧接着下一个方法不是用and连接!(不调用or则默认为使用and连接)

Version:

: 2020-10-31

Author:

赵永春 (zyc@hasor.net)

Method Summary

Modifier and Type	Method and Description
R	and() 等于条件 查询，类似：'or ...'
default R	and(Consumer<Compare<T,R>> lambda) 括号方式嵌套一组查询条件，与现有条件为并且关系。类似：'and ( ...where...
R	apply(String sqlString, Object... args) 拼接 sql
R	between(net.hasor.utils.reflect.SFunction<T> property, Object value1, Object value2) between 语句，类似：'col between ? and ?'
R	eq(net.hasor.utils.reflect.SFunction<T> property, Object value) 等于条件 查询，类似：'col = ?'
R	ge(net.hasor.utils.reflect.SFunction<T> property, Object value) 大于等于条件 查询，类似：'col >= ?'
R	gt(net.hasor.utils.reflect.SFunction<T> property, Object value) 大于条件 查询，类似：'col > ?'
R	in(net.hasor.utils.reflect.SFunction<T> property, Collection<?> value) in 查询，类似：'col in (?,?,?)'
R	isNotNull(net.hasor.utils.reflect.SFunction<T> property) not null 查询，类似：'col is not null'
R	isNull(net.hasor.utils.reflect.SFunction<T> property) is null 查询，类似：'col is null'
R	le(net.hasor.utils.reflect.SFunction<T> property, Object value) 小于等于条件 查询，类似：'col <= ?'
R	like(net.hasor.utils.reflect.SFunction<T> property, Object value) like 查询，类似：'col like CONCAT('%', ?, '%')'
R	likeLeft(net.hasor.utils.reflect.SFunction<T> property, Object value) like 查询，类似：'col like CONCAT('%', ?)'
R	likeRight(net.hasor.utils.reflect.SFunction<T> property, Object value) like 查询，类似：'col like CONCAT(?, '%')'
R	lt(net.hasor.utils.reflect.SFunction<T> property, Object value) 小于条件 查询，类似：'col < ?'
R	ne(net.hasor.utils.reflect.SFunction<T> property, Object value) 不等于条件 查询，类似：'col <> ?'
R	nested(Consumer<Compare<T,R>> lambda) 括号方式嵌套一组查询条件
R	notBetween(net.hasor.utils.reflect.SFunction<T> property, Object value1, Object value2) not between 语句，类似：'col not between ? and ?'
R	notIn(net.hasor.utils.reflect.SFunction<T> property, Collection<?> value) not in 查询，类似：'col not in (?,?,?)'
R	notLike(net.hasor.utils.reflect.SFunction<T> property, Object value) not like 查询，类似：'col not like CONCAT('%', ?, '%')'
R	notLikeLeft(net.hasor.utils.reflect.SFunction<T> property, Object value) not like 查询，类似：'col not like CONCAT('%', ?)'
R	notLikeRight(net.hasor.utils.reflect.SFunction<T> property, Object value) not like 查询，类似：'col not like CONCAT(?, '%')'
R	or() 等于条件 查询，类似：'or ...'
default R	or(Consumer<Compare<T,R>> lambda) 括号方式嵌套一组查询条件，与现有条件为或关系。类似：'or ( ...where...

Method Detail

or

R or()

等于条件 查询，类似：'or ...'

and

R and()

等于条件 查询，类似：'or ...'

and

default R and(Consumer<Compare<T,R>> lambda)

括号方式嵌套一组查询条件，与现有条件为并且关系。类似：'and ( ...where... )'

or

default R or(Consumer<Compare<T,R>> lambda)

括号方式嵌套一组查询条件，与现有条件为或关系。类似：'or ( ...where... )'

nested

R nested(Consumer<Compare<T,R>> lambda)

括号方式嵌套一组查询条件

eq

R eq(net.hasor.utils.reflect.SFunction<T> property,
     Object value)

等于条件 查询，类似：'col = ?'

ne

R ne(net.hasor.utils.reflect.SFunction<T> property,
     Object value)

不等于条件 查询，类似：'col <> ?'

gt

R gt(net.hasor.utils.reflect.SFunction<T> property,
     Object value)

大于条件 查询，类似：'col > ?'

ge

R ge(net.hasor.utils.reflect.SFunction<T> property,
     Object value)

大于等于条件 查询，类似：'col >= ?'

lt

R lt(net.hasor.utils.reflect.SFunction<T> property,
     Object value)

小于条件 查询，类似：'col < ?'

le

R le(net.hasor.utils.reflect.SFunction<T> property,
     Object value)

小于等于条件 查询，类似：'col <= ?'

like

R like(net.hasor.utils.reflect.SFunction<T> property,
       Object value)

like 查询，类似：'col like CONCAT('%', ?, '%')'

notLike

R notLike(net.hasor.utils.reflect.SFunction<T> property,
          Object value)

not like 查询，类似：'col not like CONCAT('%', ?, '%')'

likeRight

R likeRight(net.hasor.utils.reflect.SFunction<T> property,
            Object value)

like 查询，类似：'col like CONCAT(?, '%')'

notLikeRight

R notLikeRight(net.hasor.utils.reflect.SFunction<T> property,
               Object value)

not like 查询，类似：'col not like CONCAT(?, '%')'

likeLeft

R likeLeft(net.hasor.utils.reflect.SFunction<T> property,
           Object value)

like 查询，类似：'col like CONCAT('%', ?)'

notLikeLeft

R notLikeLeft(net.hasor.utils.reflect.SFunction<T> property,
              Object value)

not like 查询，类似：'col not like CONCAT('%', ?)'

isNull

R isNull(net.hasor.utils.reflect.SFunction<T> property)

is null 查询，类似：'col is null'

isNotNull

R isNotNull(net.hasor.utils.reflect.SFunction<T> property)

not null 查询，类似：'col is not null'

in

R in(net.hasor.utils.reflect.SFunction<T> property,
     Collection<?> value)

in 查询，类似：'col in (?,?,?)'

notIn

R notIn(net.hasor.utils.reflect.SFunction<T> property,
        Collection<?> value)

not in 查询，类似：'col not in (?,?,?)'

between

R between(net.hasor.utils.reflect.SFunction<T> property,
          Object value1,
          Object value2)

between 语句，类似：'col between ? and ?'

notBetween

R notBetween(net.hasor.utils.reflect.SFunction<T> property,
             Object value1,
             Object value2)

not between 语句，类似：'col not between ? and ?'

apply

R apply(String sqlString,
        Object... args)

拼接 sql

!! 会有 sql 注入风险 !!

例1: apply("id = 1")

例2: apply("date_format(dateColumn,'%Y-%m-%d') = '2008-08-08'")

例3: apply("date_format(dateColumn,'%Y-%m-%d') = {0}", LocalDate.now())