Uses of Class
org.dromara.hutool.db.sql.QueryBuilder

Packages that use QueryBuilder

Package	Description
org.dromara.hutool.db.sql	SQL语句和Statement构建封装

Uses of QueryBuilder in org.dromara.hutool.db.sql

Methods in org.dromara.hutool.db.sql that return QueryBuilder

Modifier and Type	Method and Description
QueryBuilder	QueryBuilder.addCondition(Condition condition) 添加自定义条件
QueryBuilder	QueryBuilder.addFields(String... fields) 批量添加字段，即select field1,field2,field3
QueryBuilder	QueryBuilder.addTableNames(String... tableNames) 添加多个表名，即from table1,table2
QueryBuilder	QueryBuilder.between(String field, Object start, Object end) 添加BETWEEN查询条件，即field BETWEEN start AND end
QueryBuilder	QueryBuilder.eq(String field, Object value) 添加相等条件，即field = value
QueryBuilder	QueryBuilder.ge(String field, Object value) 添加大于等于条件，即field >= value
QueryBuilder	QueryBuilder.gt(String field, Object value) 添加大于条件，即field > value
QueryBuilder	QueryBuilder.in(String field, Iterable<?> values) 添加IN查询条件，即field IN (value1,value2)
QueryBuilder	QueryBuilder.in(String field, Object... values) 添加IN查询条件，即field IN (value1,value2)
QueryBuilder	QueryBuilder.le(String field, Object value) 添加小于等于条件，即field <= value
QueryBuilder	QueryBuilder.like(String field, String value) 添加模糊查询条件，即field like '%value%'
QueryBuilder	QueryBuilder.likeEndWith(String field, String value) 添加以固定值结尾模糊查询条件，即field like '%value'
QueryBuilder	QueryBuilder.likeStartWith(String field, String value) 添加以固定值开头模糊查询条件，即field like 'value%'
QueryBuilder	QueryBuilder.lt(String field, Object value) 添加小于条件，即field < value
QueryBuilder	QueryBuilder.ne(String field, Object value) 添加不等条件，即{@code field !
QueryBuilder	QueryBuilder.notBetween(String field, Object start, Object end) 添加非BETWEEN查询条件，即field NOT BETWEEN start AND end
QueryBuilder	QueryBuilder.notIn(String field, Iterable<?> values) 添加非IN查询条件，即field NOT IN (value1,value2)
QueryBuilder	QueryBuilder.notIn(String field, Object... values) 添加非IN查询条件，即field NOT IN (value1,value2)