com.landawn.abacus.util

Class SQLBuilder.RE3

java.lang.Object

com.landawn.abacus.util.SQLBuilder

com.landawn.abacus.util.SQLBuilder.RE3

Enclosing class:

SQLBuilder

public static final class SQLBuilder.RE3
extends SQLBuilder

All the property/column names in collection/map/entity/condition will be kept without any change and the sql will be parameterized with question mark.

Author:

haiyang li

Nested Class Summary

Nested classes/interfaces inherited from class com.landawn.abacus.util.SQLBuilder

SQLBuilder.E, SQLBuilder.E2, SQLBuilder.E3, SQLBuilder.NE, SQLBuilder.NE2, SQLBuilder.NE3, SQLBuilder.RE, SQLBuilder.RE2, SQLBuilder.RE3, SQLBuilder.SE, SQLBuilder.SE2, SQLBuilder.SE3, 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

Modifier and Type	Method and Description
static SQLBuilder	batchInsert(java.util.Collection<?> propsList) Generate the MySQL style batch insert sql.
static SQLBuilder	deleteFrom(java.lang.Class<?> entityClass)
static SQLBuilder	deleteFrom(java.lang.String tableName)
static SQLBuilder	insert(java.lang.Class<?> entityClass)
static SQLBuilder	insert(java.lang.Class<?> entityClass, java.util.Set<java.lang.String> excludedPropNames)
static SQLBuilder	insert(java.util.Collection<java.lang.String> columnNames)
static SQLBuilder	insert(java.util.Map<java.lang.String,java.lang.Object> props)
static SQLBuilder	insert(java.lang.Object entity)
static SQLBuilder	insert(java.lang.Object entity, java.util.Set<java.lang.String> excludedPropNames)
static SQLBuilder	insert(java.lang.String... columnNames)
static SQLBuilder	insert(java.lang.String expr)
static SQLBuilder	insertInto(java.lang.Class<?> entityClass)
static SQLBuilder	insertInto(java.lang.Class<?> entityClass, java.util.Set<java.lang.String> excludedPropNames)
static SQLBuilder	select(java.lang.Class<?> entityClass)
static SQLBuilder	select(java.lang.Class<?> entityClass, java.util.Set<java.lang.String> excludedPropNames)
static SQLBuilder	select(java.util.Collection<java.lang.String> columnNames)
static SQLBuilder	select(java.util.Map<java.lang.String,java.lang.String> columnAliases)
static SQLBuilder	select(java.lang.String... columnNames)
static SQLBuilder	select(java.lang.String expr)
static SQLBuilder	select(java.lang.String expr, java.util.Collection<java.lang.String> columnNames)
static SQLBuilder	select(java.lang.String expr, java.util.Map<java.lang.String,java.lang.String> columnAliases)
static SQLBuilder	selectFrom(java.lang.Class<?> entityClass)
static SQLBuilder	selectFrom(java.lang.Class<?> entityClass, java.util.Set<java.lang.String> excludedPropNames)
static SQLBuilder	update(java.lang.Class<?> entityClass)
static SQLBuilder	update(java.lang.Class<?> entityClass, java.util.Set<java.lang.String> excludedPropNames)
static SQLBuilder	update(java.lang.String tableName)

Methods inherited from class com.landawn.abacus.util.SQLBuilder

crossJoin, crossJoin, except, except, except, except, forUpdate, from, from, from, from, from, fullJoin, fullJoin, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, having, having, innerJoin, innerJoin, intersect, intersect, intersect, intersect, into, into, join, join, leftJoin, leftJoin, limit, limit, minus, minus, minus, minus, naturalJoin, naturalJoin, offset, on, on, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, pair, parameters, registerColumnName, rightJoin, rightJoin, set, set, set, set, set, set, set, set, sql, 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 Detail

insert

public static SQLBuilder insert(java.lang.String expr)

insert

@SafeVarargs
public static SQLBuilder insert(java.lang.String... columnNames)

insert

public static SQLBuilder insert(java.util.Collection<java.lang.String> columnNames)

insert

public static SQLBuilder insert(java.util.Map<java.lang.String,java.lang.Object> props)

insert

public static SQLBuilder insert(java.lang.Object entity)

insert

public static SQLBuilder insert(java.lang.Object entity,
                                java.util.Set<java.lang.String> excludedPropNames)

insert

public static SQLBuilder insert(java.lang.Class<?> entityClass)

insert

public static SQLBuilder insert(java.lang.Class<?> entityClass,
                                java.util.Set<java.lang.String> excludedPropNames)

insertInto

public static SQLBuilder insertInto(java.lang.Class<?> entityClass)

insertInto

public static SQLBuilder insertInto(java.lang.Class<?> entityClass,
                                    java.util.Set<java.lang.String> excludedPropNames)

batchInsert

@Beta
public static SQLBuilder batchInsert(java.util.Collection<?> propsList)

Generate the MySQL style batch insert sql.

Parameters:

propsList - list of entity or properties map.

Returns:

select

public static SQLBuilder select(java.lang.String expr)

select

@SafeVarargs
public static SQLBuilder select(java.lang.String... columnNames)

select

public static SQLBuilder select(java.util.Collection<java.lang.String> columnNames)

select

public static SQLBuilder select(java.lang.String expr,
                                java.util.Collection<java.lang.String> columnNames)

Parameters:

expr - ALL | DISTINCT | DISTINCTROW...

columnNames -

Returns:

select

public static SQLBuilder select(java.util.Map<java.lang.String,java.lang.String> columnAliases)

select

public static SQLBuilder select(java.lang.String expr,
                                java.util.Map<java.lang.String,java.lang.String> columnAliases)

Parameters:

expr - ALL | DISTINCT | DISTINCTROW...

columnAliases -

Returns:

select

public static SQLBuilder select(java.lang.Class<?> entityClass)

select

public static SQLBuilder select(java.lang.Class<?> entityClass,
                                java.util.Set<java.lang.String> excludedPropNames)

selectFrom

public static SQLBuilder selectFrom(java.lang.Class<?> entityClass)

selectFrom

public static SQLBuilder selectFrom(java.lang.Class<?> entityClass,
                                    java.util.Set<java.lang.String> excludedPropNames)

update

public static SQLBuilder update(java.lang.String tableName)

update

public static SQLBuilder update(java.lang.Class<?> entityClass)

update

public static SQLBuilder update(java.lang.Class<?> entityClass,
                                java.util.Set<java.lang.String> excludedPropNames)

deleteFrom

public static SQLBuilder deleteFrom(java.lang.String tableName)

deleteFrom

public static SQLBuilder deleteFrom(java.lang.Class<?> entityClass)