net.sohelp.boot.admin.core.db

类 SQLBuilder

java.lang.Object

net.sohelp.boot.admin.core.db.SQLBuilder

public class SQLBuilder
extends Object

SQL条件构建器

从以下版本开始:

2024/4/25 9:05

作者:

AaronFung

构造器概要

构造器

构造器和说明
SQLBuilder(Map<String,Object> dataMap)

方法概要

限定符和类型	方法和说明
SQLBuilder	and()
SQLBuilder	and(String... fields)
String	build()
String	buildGroupBy()
String	buildOrderBy()
String	buildWhere()
static String	camelToUnderscoreLowercase(String input) 将驼峰命名转为下划线小写
SQLBuilder	dateRange(String field)
SQLBuilder	dateRange(String field, String startDateParamName, String endDateParamName)
SQLBuilder	eq(String... fields)
SQLBuilder	groupBy(String... groupName) 数据分组
SQLBuilder	gt(String... fields)
SQLBuilder	in(String field)
SQLBuilder	keywords(String... fields)
SQLBuilder	like(String... fields)
SQLBuilder	lt(String... fields)
SQLBuilder	or()
SQLBuilder	or(String... fields)
SQLBuilder	orderBy()
SQLBuilder	orderBy(String fields)
SQLBuilder	orderBy(String fields, String orders) 数据排序
SQLBuilder	orLike(String... fields)
String	toString()
SQLBuilder	where(String sql)

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

构造器详细资料

SQLBuilder

public SQLBuilder(Map<String,Object> dataMap)

方法详细资料

camelToUnderscoreLowercase

public static String camelToUnderscoreLowercase(String input)

将驼峰命名转为下划线小写

参数:

input -

返回:

where

public SQLBuilder where(String sql)

orderBy

public SQLBuilder orderBy()

keywords

public SQLBuilder keywords(String... fields)

参数:

fields -

返回:

orLike

public SQLBuilder orLike(String... fields)

参数:

fields -

返回:

toString

public String toString()

覆盖:

toString 在类中 Object

buildOrderBy

public String buildOrderBy()

buildGroupBy

public String buildGroupBy()

build

public String build()

buildWhere

public String buildWhere()

groupBy

public SQLBuilder groupBy(String... groupName)

数据分组

参数:

groupName -

返回:

orderBy

public SQLBuilder orderBy(String fields,
                          String orders)

数据排序

参数:

fields - 字段列表

orders - 排序列表

返回:

orderBy

public SQLBuilder orderBy(String fields)

or

public SQLBuilder or(String... fields)

and

public SQLBuilder and(String... fields)

and

public SQLBuilder and()

or

public SQLBuilder or()

dateRange

public SQLBuilder dateRange(String field)

dateRange

public SQLBuilder dateRange(String field,
                            String startDateParamName,
                            String endDateParamName)

in

public SQLBuilder in(String field)

eq

public SQLBuilder eq(String... fields)

lt

public SQLBuilder lt(String... fields)

gt

public SQLBuilder gt(String... fields)

like

public SQLBuilder like(String... fields)