Package com.landawn.abacus.util
Class SQLBuilder.PSC
java.lang.Object
com.landawn.abacus.util.SQLBuilder
com.landawn.abacus.util.SQLBuilder.PSC
- Enclosing class:
- SQLBuilder
Parameterized('?') SQL builder with snake case (lower case with underscore) field/column naming strategy.
For example:
N.println(PSC.select("firstName", "lastName").from("account").where(CF.eq("id", 1)).sql());
// SELECT first_name AS "firstName", last_name AS "lastName" FROM account WHERE id = ?
-
Nested Class Summary
Nested classes/interfaces inherited from class com.landawn.abacus.util.SQLBuilder
SQLBuilder.ACSB, SQLBuilder.LCSB, SQLBuilder.MAC, SQLBuilder.MLC, SQLBuilder.MSB, SQLBuilder.MSC, SQLBuilder.NAC, SQLBuilder.NLC, SQLBuilder.NSB, SQLBuilder.NSC, SQLBuilder.PAC, SQLBuilder.PLC, SQLBuilder.PSB, SQLBuilder.PSC, SQLBuilder.SCSB, SQLBuilder.SP
-
Field Summary
Fields inherited from class com.landawn.abacus.util.SQLBuilder
ALL, ASTERISK, COUNT_ALL, DISTINCT, DISTINCTROW, TOP, UNIQUE
-
Method Summary
Modifier and TypeMethodDescriptionstatic SQLBuilder
batchInsert
(Collection<?> propsList) Generate the MySQL style batch insert sql.static SQLBuilder
static SQLBuilder
static SQLBuilder
static SQLBuilder
deleteFrom
(Class<?> entityClass) static SQLBuilder
deleteFrom
(String tableName) static SQLBuilder
deleteFrom
(String tableName, Class<?> entityClass) static SQLBuilder
static SQLBuilder
static SQLBuilder
static SQLBuilder
static SQLBuilder
static SQLBuilder
static SQLBuilder
insert
(Collection<String> propOrColumnNames) static SQLBuilder
static SQLBuilder
insertInto
(Class<?> entityClass) static SQLBuilder
insertInto
(Class<?> entityClass, Set<String> excludedPropNames) static SQLBuilder
To generatesql
part for the specifiedcond
only.static SQLBuilder
static SQLBuilder
static SQLBuilder
static SQLBuilder
select
(Class<?> entityClassA, String tableAliasA, String classAliasA, Class<?> entityClassB, String tableAliasB, String classAliasB) static SQLBuilder
select
(Class<?> entityClassA, String tableAliasA, String classAliasA, Set<String> excludedPropNamesA, Class<?> entityClassB, String tableAliasB, String classAliasB, Set<String> excludedPropNamesB) static SQLBuilder
static SQLBuilder
static SQLBuilder
static SQLBuilder
select
(Collection<String> propOrColumnNames) static SQLBuilder
static SQLBuilder
static SQLBuilder
selectFrom
(Class<?> entityClass) static SQLBuilder
selectFrom
(Class<?> entityClass, boolean includeSubEntityProperties) static SQLBuilder
selectFrom
(Class<?> entityClass, boolean includeSubEntityProperties, Set<String> excludedPropNames) static SQLBuilder
selectFrom
(Class<?> entityClass, String alias) static SQLBuilder
selectFrom
(Class<?> entityClass, String alias, boolean includeSubEntityProperties) static SQLBuilder
selectFrom
(Class<?> entityClass, String alias, boolean includeSubEntityProperties, Set<String> excludedPropNames) static SQLBuilder
selectFrom
(Class<?> entityClassA, String tableAliasA, String classAliasA, Class<?> entityClassB, String tableAliasB, String classAliasB) static SQLBuilder
selectFrom
(Class<?> entityClassA, String tableAliasA, String classAliasA, Set<String> excludedPropNamesA, Class<?> entityClassB, String tableAliasB, String classAliasB, Set<String> excludedPropNamesB) static SQLBuilder
selectFrom
(Class<?> entityClass, String alias, Set<String> excludedPropNames) static SQLBuilder
selectFrom
(Class<?> entityClass, Set<String> excludedPropNames) static SQLBuilder
selectFrom
(List<Selection> multiSelects) static SQLBuilder
static SQLBuilder
static SQLBuilder
static SQLBuilder
Methods inherited from class com.landawn.abacus.util.SQLBuilder
accept, accept, append, append, appendIf, appendIf, appendIf, appendIfOrElse, appendIfOrElse, apply, apply, crossJoin, crossJoin, crossJoin, crossJoin, distinct, except, except, except, except, fetchFirstNRowsOnly, fetchNextNRowsOnly, forUpdate, from, from, from, from, from, from, fullJoin, fullJoin, fullJoin, fullJoin, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, having, having, innerJoin, innerJoin, innerJoin, innerJoin, intersect, intersect, intersect, intersect, into, into, into, join, join, join, join, leftJoin, leftJoin, leftJoin, leftJoin, limit, limit, minus, minus, minus, minus, naturalJoin, naturalJoin, naturalJoin, naturalJoin, offset, offsetRows, on, on, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderByAsc, orderByAsc, orderByAsc, orderByDesc, orderByDesc, orderByDesc, pair, parameters, preselect, println, resetHandlerForNamedParameter, rightJoin, rightJoin, rightJoin, rightJoin, set, set, set, set, set, set, set, set, setHandlerForNamedParameter, sql, toPreparedQuery, toPreparedQuery, toPreparedQuery, toPreparedQuery, toPreparedQueryForBigResult, toPreparedQueryForBigResult, toString, union, union, union, union, unionAll, unionAll, unionAll, unionAll, using, where, where
-
Method Details
-
insert
- Parameters:
expr
-- Returns:
-
insert
- Parameters:
propOrColumnNames
-- Returns:
-
insert
- Parameters:
propOrColumnNames
-- Returns:
-
insert
- Parameters:
props
-- Returns:
-
insert
- Parameters:
entity
-- Returns:
-
insert
- Parameters:
entity
-excludedPropNames
-- Returns:
-
insert
- Parameters:
entityClass
-- Returns:
-
insert
- Parameters:
entityClass
-excludedPropNames
-- Returns:
-
insertInto
- Parameters:
entityClass
-- Returns:
-
insertInto
- Parameters:
entityClass
-excludedPropNames
-- Returns:
-
batchInsert
Generate the MySQL style batch insert sql.- Parameters:
propsList
- list of entity or properties map.- Returns:
-
update
- Parameters:
tableName
-- Returns:
-
update
- Parameters:
tableName
-entityClass
-- Returns:
-
update
- Parameters:
entityClass
-- Returns:
-
update
- Parameters:
entityClass
-excludedPropNames
-- Returns:
-
deleteFrom
- Parameters:
tableName
-- Returns:
-
deleteFrom
- Parameters:
tableName
-entityClass
-- Returns:
-
deleteFrom
- Parameters:
entityClass
-- Returns:
-
select
- Parameters:
selectPart
-- Returns:
-
select
- Parameters:
propOrColumnNames
-- Returns:
-
select
- Parameters:
propOrColumnNames
-- Returns:
-
select
- Parameters:
propOrColumnNameAliases
-- Returns:
-
select
- Parameters:
entityClass
-- Returns:
-
select
- Parameters:
entityClass
-includeSubEntityProperties
-- Returns:
-
select
- Parameters:
entityClass
-excludedPropNames
-- Returns:
-
select
public static SQLBuilder select(Class<?> entityClass, boolean includeSubEntityProperties, Set<String> excludedPropNames) - Parameters:
entityClass
-includeSubEntityProperties
-excludedPropNames
-- Returns:
-
selectFrom
- Parameters:
entityClass
-- Returns:
-
selectFrom
- Parameters:
entityClass
-alias
-- Returns:
-
selectFrom
- Parameters:
entityClass
-includeSubEntityProperties
-- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClass, String alias, boolean includeSubEntityProperties) - Parameters:
entityClass
-alias
-includeSubEntityProperties
-- Returns:
-
selectFrom
- Parameters:
entityClass
-excludedPropNames
-- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClass, String alias, Set<String> excludedPropNames) - Parameters:
entityClass
-alias
-excludedPropNames
-- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClass, boolean includeSubEntityProperties, Set<String> excludedPropNames) - Parameters:
entityClass
-includeSubEntityProperties
-excludedPropNames
-- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClass, String alias, boolean includeSubEntityProperties, Set<String> excludedPropNames) - Parameters:
entityClass
-alias
-includeSubEntityProperties
-excludedPropNames
-- Returns:
-
select
public static SQLBuilder select(Class<?> entityClassA, String tableAliasA, String classAliasA, Class<?> entityClassB, String tableAliasB, String classAliasB) - Parameters:
entityClassA
-tableAliasA
-classAliasA
-entityClassB
-tableAliasB
-classAliasB
-- Returns:
-
select
public static SQLBuilder select(Class<?> entityClassA, String tableAliasA, String classAliasA, Set<String> excludedPropNamesA, Class<?> entityClassB, String tableAliasB, String classAliasB, Set<String> excludedPropNamesB) - Parameters:
entityClassA
-tableAliasA
-classAliasA
-excludedPropNamesA
-entityClassB
-tableAliasB
-classAliasB
-excludedPropNamesB
-- Returns:
-
select
- Parameters:
multiSelects
-- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClassA, String tableAliasA, String classAliasA, Class<?> entityClassB, String tableAliasB, String classAliasB) - Parameters:
entityClassA
-tableAliasA
-classAliasA
-entityClassB
-tableAliasB
-classAliasB
-- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClassA, String tableAliasA, String classAliasA, Set<String> excludedPropNamesA, Class<?> entityClassB, String tableAliasB, String classAliasB, Set<String> excludedPropNamesB) - Parameters:
entityClassA
-tableAliasA
-classAliasA
-excludedPropNamesA
-entityClassB
-tableAliasB
-classAliasB
-excludedPropNamesB
-- Returns:
-
selectFrom
- Parameters:
multiSelects
-- Returns:
-
count
- Parameters:
tableName
-- Returns:
-
count
- Parameters:
tableName
-entityClass
-- Returns:
-
count
- Parameters:
entityClass
-- Returns:
-
parse
To generatesql
part for the specifiedcond
only.- Parameters:
cond
-entityClass
-- Returns:
-