public class QueryBuilder extends Object implements Builder<Query>
Query query = QueryBuilder.of()
.select("id", "name")
.from("user")
.where("id", 1)
.and("name", "hutool")
.or("age", 18)
.build();
| Constructor and Description |
|---|
QueryBuilder()
构造
|
| Modifier and Type | Method and Description |
|---|---|
QueryBuilder |
addCondition(Condition condition)
添加自定义条件
|
QueryBuilder |
addFields(String... fields)
批量添加字段，即
select field1,field2,field3 |
QueryBuilder |
addTableNames(String... tableNames)
添加多个表名，即
from table1,table2 |
QueryBuilder |
between(String field,
Object start,
Object end)
添加BETWEEN查询条件，即
field BETWEEN start AND end |
Query |
build()
构建
|
QueryBuilder |
eq(String field,
Object value)
添加相等条件，即
field = value |
QueryBuilder |
ge(String field,
Object value)
添加大于等于条件，即
field >= value |
QueryBuilder |
gt(String field,
Object value)
添加大于条件，即
field > value |
QueryBuilder |
in(String field,
Iterable<?> values)
添加IN查询条件，即
field IN (value1,value2) |
QueryBuilder |
in(String field,
Object... values)
添加IN查询条件，即
field IN (value1,value2) |
QueryBuilder |
le(String field,
Object value)
添加小于等于条件，即
field <= value |
QueryBuilder |
like(String field,
String value)
添加模糊查询条件，即
field like '%value%' |
QueryBuilder |
likeEndWith(String field,
String value)
添加以固定值结尾模糊查询条件，即
field like '%value' |
QueryBuilder |
likeStartWith(String field,
String value)
添加以固定值开头模糊查询条件，即
field like 'value%' |
QueryBuilder |
lt(String field,
Object value)
添加小于条件，即
field < value |
QueryBuilder |
ne(String field,
Object value)
添加不等条件，即{@code field !
|
QueryBuilder |
notBetween(String field,
Object start,
Object end)
添加非BETWEEN查询条件，即
field NOT BETWEEN start AND end |
QueryBuilder |
notIn(String field,
Iterable<?> values)
添加非IN查询条件，即
field NOT IN (value1,value2) |
QueryBuilder |
notIn(String field,
Object... values)
添加非IN查询条件，即
field NOT IN (value1,value2) |
public QueryBuilder addFields(String... fields)
select field1,field2,field3 fields - 字段名public QueryBuilder addTableNames(String... tableNames)
from table1,table2 tableNames - 表名public QueryBuilder eq(String field, Object value)
field = value field - 字段名value - 值public QueryBuilder ne(String field, Object value)
field != value field - 字段名value - 值public QueryBuilder gt(String field, Object value)
field > valuefield - 字段名value - 值public QueryBuilder lt(String field, Object value)
field < valuefield - 字段名value - 值public QueryBuilder ge(String field, Object value)
field >= valuefield - 字段名value - 值public QueryBuilder le(String field, Object value)
field <= valuefield - 字段名value - 值public QueryBuilder like(String field, String value)
field like '%value%'field - 字段名value - 值public QueryBuilder likeStartWith(String field, String value)
field like 'value%'field - 字段名value - 值public QueryBuilder likeEndWith(String field, String value)
field like '%value'field - 字段名value - 值public QueryBuilder in(String field, Object... values)
field IN (value1,value2)field - 字段名values - 值public QueryBuilder in(String field, Iterable<?> values)
field IN (value1,value2)field - 字段名values - 值public QueryBuilder notIn(String field, Object... values)
field NOT IN (value1,value2)field - 字段名values - 值public QueryBuilder notIn(String field, Iterable<?> values)
field NOT IN (value1,value2)field - 字段名values - 值public QueryBuilder between(String field, Object start, Object end)
field BETWEEN start AND endfield - 字段名start - 开始值end - 结束值public QueryBuilder notBetween(String field, Object start, Object end)
field NOT BETWEEN start AND endfield - 字段名start - 开始值end - 结束值public QueryBuilder addCondition(Condition condition)
condition - 条件Copyright © 2025. All rights reserved.