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(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 Type	Method	Description
static SQLBuilder	batchInsert(Collection<?> propsList)	Generate the MySQL style batch insert sql.
static SQLBuilder	count(Class<?> entityClass)
static SQLBuilder	count(String tableName)
static SQLBuilder	count(String tableName, Class<?> entityClass)
static SQLBuilder	deleteFrom(Class<?> entityClass)
static SQLBuilder	deleteFrom(String tableName)
static SQLBuilder	deleteFrom(String tableName, Class<?> entityClass)
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... propOrColumnNames)
static SQLBuilder	insert(Collection<String> propOrColumnNames)
static SQLBuilder	insert(Map<String,Object> props)
static SQLBuilder	insertInto(Class<?> entityClass)
static SQLBuilder	insertInto(Class<?> entityClass, Set<String> excludedPropNames)
static SQLBuilder	parse(Condition cond, Class<?> entityClass)	To generate sql part for the specified cond only.
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<?> 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	select(Class<?> entityClass, Set<String> excludedPropNames)
static SQLBuilder	select(String selectPart)
static SQLBuilder	select(String... propOrColumnNames)
static SQLBuilder	select(Collection<String> propOrColumnNames)
static SQLBuilder	select(List<Selection> multiSelects)
static SQLBuilder	select(Map<String,String> propOrColumnNameAliases)
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	update(Class<?> entityClass)
static SQLBuilder	update(Class<?> entityClass, Set<String> excludedPropNames)
static SQLBuilder	update(String tableName)
static SQLBuilder	update(String tableName, Class<?> entityClass)

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

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Method Details

insert

public static SQLBuilder insert(String expr)

Parameters:

expr -

Returns:

insert

@SafeVarargs
public static SQLBuilder insert(String... propOrColumnNames)

Parameters:

propOrColumnNames -

Returns:

insert

public static SQLBuilder insert(Collection<String> propOrColumnNames)

Parameters:

propOrColumnNames -

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:

update

public static SQLBuilder update(String tableName)

Parameters:

tableName -

Returns:

update

public static SQLBuilder update(String tableName,
 Class<?> entityClass)

Parameters:

tableName -

entityClass -

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(String tableName,
 Class<?> entityClass)

Parameters:

tableName -

entityClass -

Returns:

deleteFrom

public static SQLBuilder deleteFrom(Class<?> entityClass)

Parameters:

entityClass -

Returns:

select

public static SQLBuilder select(String selectPart)

Parameters:

selectPart -

Returns:

select

@SafeVarargs
public static SQLBuilder select(String... propOrColumnNames)

Parameters:

propOrColumnNames -

Returns:

select

public static SQLBuilder select(Collection<String> propOrColumnNames)

Parameters:

propOrColumnNames -

Returns:

select

public static SQLBuilder select(Map<String,String> propOrColumnNameAliases)

Parameters:

propOrColumnNameAliases -

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,
 String alias)

Parameters:

entityClass -

alias -

Returns:

selectFrom

public static SQLBuilder selectFrom(Class<?> entityClass,
 boolean includeSubEntityProperties)

Parameters:

entityClass -

includeSubEntityProperties -

Returns:

selectFrom

public static SQLBuilder selectFrom(Class<?> entityClass,
 String alias,
 boolean includeSubEntityProperties)

Parameters:

entityClass -

alias -

includeSubEntityProperties -

Returns:

selectFrom

public static SQLBuilder selectFrom(Class<?> entityClass,
 Set<String> excludedPropNames)

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

public static SQLBuilder select(List<Selection> multiSelects)

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

public static SQLBuilder selectFrom(List<Selection> multiSelects)

Parameters:

multiSelects -

Returns:

count

public static SQLBuilder count(String tableName)

Parameters:

tableName -

Returns:

count

public static SQLBuilder count(String tableName,
 Class<?> entityClass)

Parameters:

tableName -

entityClass -

Returns:

count

public static SQLBuilder count(Class<?> entityClass)

Parameters:

entityClass -

Returns:

parse

public static SQLBuilder parse(Condition cond,
 Class<?> entityClass)

To generate sql part for the specified cond only.

Parameters:

cond -

entityClass -

Returns: