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
public static class SQLBuilder.PSC extends 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(L.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.MSC, SQLBuilder.NAC, SQLBuilder.NLC, SQLBuilder.NSC, SQLBuilder.PAC, SQLBuilder.PLC, SQLBuilder.PSC, SQLBuilder.SCSB, SQLBuilder.SP
-
-
Field Summary
-
Fields inherited from class com.landawn.abacus.util.SQLBuilder
_1, _1_list, ALL, ASTERISK, COUNT_ALL, DISTINCT, DISTINCTROW, TOP, UNIQUE
-
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static SQLBuilder
batchInsert(Collection<?> propsList)
Generate the MySQL style batch insert sql.static SQLBuilder
deleteFrom(Class<?> entityClass)
static SQLBuilder
deleteFrom(String tableName)
static SQLBuilder
insert(Class<?> entityClass)
static SQLBuilder
insert(Class<?> entityClass, Set<String> excludedPropNames)
static SQLBuilder
insert(Object entity)
static SQLBuilder
insert(Object entity, Set<String> excludedPropNames)
static SQLBuilder
insert(String expr)
static SQLBuilder
insert(String... columnNames)
static SQLBuilder
insert(Collection<String> columnNames)
static SQLBuilder
insert(Map<String,Object> props)
static SQLBuilder
insertInto(Class<?> entityClass)
static SQLBuilder
insertInto(Class<?> entityClass, Set<String> excludedPropNames)
static SQLBuilder
select(Class<?> entityClass)
static SQLBuilder
select(Class<?> entityClass, boolean includeSubEntityProperties)
static SQLBuilder
select(Class<?> entityClass, boolean includeSubEntityProperties, Set<String> excludedPropNames)
static SQLBuilder
select(Class<?> entityClass, Set<String> excludedPropNames)
static SQLBuilder
select(String... columnNames)
static SQLBuilder
select(String expr, String[] columnNames)
static SQLBuilder
select(String expr, Collection<String> columnNames)
static SQLBuilder
select(String expr, Map<String,String> columnAliases)
static SQLBuilder
select(Collection<String> columnNames)
static SQLBuilder
select(Map<String,String> columnAliases)
static SQLBuilder
selectFrom(Class<?> entityClass)
static SQLBuilder
selectFrom(Class<?> entityClass, boolean includeSubEntityProperties)
static SQLBuilder
selectFrom(Class<?> entityClass, boolean includeSubEntityProperties, String expr)
static SQLBuilder
selectFrom(Class<?> entityClass, boolean includeSubEntityProperties, Set<String> excludedPropNames)
static SQLBuilder
selectFrom(Class<?> entityClass, boolean includeSubEntityProperties, Set<String> excludedPropNames, String expr)
static SQLBuilder
selectFrom(Class<?> entityClass, String expr)
static SQLBuilder
selectFrom(Class<?> entityClass, Set<String> excludedPropNames)
static SQLBuilder
selectFrom(Class<?> entityClass, Set<String> excludedPropNames, String expr)
static SQLBuilder
update(Class<?> entityClass)
static SQLBuilder
update(Class<?> entityClass, Set<String> excludedPropNames)
static SQLBuilder
update(String tableName)
-
Methods inherited from class com.landawn.abacus.util.SQLBuilder
accept, apply, crossJoin, crossJoin, except, except, except, except, forUpdate, from, from, from, from, from, fullJoin, fullJoin, getInsertPropNames, getInsertPropNamesByClass, getPropColumnNameMap, getSelectPropNamesByClass, getUpdatePropNamesByClass, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, having, having, innerJoin, innerJoin, intersect, intersect, intersect, intersect, into, into, join, join, leftJoin, leftJoin, limit, limit, limitByRowNum, minus, minus, minus, minus, naturalJoin, naturalJoin, offset, on, on, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, pair, parameters, registerNonSubEntityPropNames, repeatQM, rightJoin, rightJoin, set, set, set, set, set, set, set, set, sql, toString, union, union, union, union, unionAll, unionAll, unionAll, unionAll, using, where, where
-
-
-
-
Method Detail
-
insert
public static SQLBuilder insert(String expr)
- Parameters:
expr
-- Returns:
-
insert
@SafeVarargs public static SQLBuilder insert(String... columnNames)
- Parameters:
columnNames
-- Returns:
-
insert
public static SQLBuilder insert(Collection<String> columnNames)
- Parameters:
columnNames
-- Returns:
-
insert
public static SQLBuilder insert(Map<String,Object> props)
- Parameters:
props
-- Returns:
-
insert
public static SQLBuilder insert(Object entity)
- Parameters:
entity
-- Returns:
-
insert
public static SQLBuilder insert(Object entity, Set<String> excludedPropNames)
- Parameters:
entity
-excludedPropNames
-- Returns:
-
insert
public static SQLBuilder insert(Class<?> entityClass)
- Parameters:
entityClass
-- Returns:
-
insert
public static SQLBuilder insert(Class<?> entityClass, Set<String> excludedPropNames)
- Parameters:
entityClass
-excludedPropNames
-- Returns:
-
insertInto
public static SQLBuilder insertInto(Class<?> entityClass)
- Parameters:
entityClass
-- Returns:
-
insertInto
public static SQLBuilder insertInto(Class<?> entityClass, Set<String> excludedPropNames)
- Parameters:
entityClass
-excludedPropNames
-- Returns:
-
batchInsert
@Beta public static SQLBuilder batchInsert(Collection<?> propsList)
Generate the MySQL style batch insert sql.- Parameters:
propsList
- list of entity or properties map.- Returns:
-
select
@SafeVarargs public static SQLBuilder select(String... columnNames)
- Parameters:
columnNames
-- Returns:
-
select
public static SQLBuilder select(String expr, String[] columnNames)
- Parameters:
expr
-ALL | DISTINCT | DISTINCTROW...
columnNames
-- Returns:
-
select
public static SQLBuilder select(Collection<String> columnNames)
- Parameters:
columnNames
-- Returns:
-
select
public static SQLBuilder select(String expr, Collection<String> columnNames)
- Parameters:
expr
-ALL | DISTINCT | DISTINCTROW...
columnNames
-- Returns:
-
select
public static SQLBuilder select(Map<String,String> columnAliases)
- Parameters:
columnAliases
-- Returns:
-
select
public static SQLBuilder select(String expr, Map<String,String> columnAliases)
- Parameters:
expr
-ALL | DISTINCT | DISTINCTROW...
columnAliases
-- Returns:
-
select
public static SQLBuilder select(Class<?> entityClass)
- Parameters:
entityClass
-- Returns:
-
select
public static SQLBuilder select(Class<?> entityClass, boolean includeSubEntityProperties)
- Parameters:
entityClass
-includeSubEntityProperties
-- Returns:
-
select
public static SQLBuilder select(Class<?> entityClass, Set<String> excludedPropNames)
- Parameters:
entityClass
-excludedPropNames
-- Returns:
-
select
public static SQLBuilder select(Class<?> entityClass, boolean includeSubEntityProperties, Set<String> excludedPropNames)
- Parameters:
entityClass
-includeSubEntityProperties
-excludedPropNames
-- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClass)
- Parameters:
entityClass
-- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClass, boolean includeSubEntityProperties)
- Parameters:
entityClass
-includeSubEntityProperties
-- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClass, Set<String> excludedPropNames)
- Parameters:
entityClass
-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 expr)
- Parameters:
entityClass
-expr
-ALL | DISTINCT | DISTINCTROW...
- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClass, boolean includeSubEntityProperties, String expr)
- Parameters:
entityClass
-includeSubEntityProperties
-expr
-ALL | DISTINCT | DISTINCTROW...
- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClass, Set<String> excludedPropNames, String expr)
- Parameters:
entityClass
-excludedPropNames
-expr
-ALL | DISTINCT | DISTINCTROW...
- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClass, boolean includeSubEntityProperties, Set<String> excludedPropNames, String expr)
- Parameters:
entityClass
-includeSubEntityProperties
-excludedPropNames
-expr
-ALL | DISTINCT | DISTINCTROW...
- Returns:
-
update
public static SQLBuilder update(String tableName)
- Parameters:
tableName
-- Returns:
-
update
public static SQLBuilder update(Class<?> entityClass)
- Parameters:
entityClass
-- Returns:
-
update
public static SQLBuilder update(Class<?> entityClass, Set<String> excludedPropNames)
- Parameters:
entityClass
-excludedPropNames
-- Returns:
-
deleteFrom
public static SQLBuilder deleteFrom(String tableName)
- Parameters:
tableName
-- Returns:
-
deleteFrom
public static SQLBuilder deleteFrom(Class<?> entityClass)
- Parameters:
entityClass
-- Returns:
-
-