Package com.landawn.abacus.util
Class SQLBuilder.MSB
java.lang.Object
com.landawn.abacus.util.SQLBuilder
com.landawn.abacus.util.SQLBuilder.MSB
- Enclosing class:
- SQLBuilder
Deprecated.
Named SQL builder with
NamingPolicy.NO_CHANGE
field/column naming strategy.
For example:
N.println(MSB.select("first_Name", "last_NaMe").from("account").where(CF.eq("last_NaMe", 1)).sql());
// SELECT first_Name, last_NaMe FROM account WHERE last_NaMe = #{last_NaMe}
-
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) Deprecated.Generate the MySQL style batch insert sql.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
deleteFrom
(Class<?> entityClass) Deprecated.static SQLBuilder
deleteFrom
(String tableName) Deprecated.static SQLBuilder
deleteFrom
(String tableName, Class<?> entityClass) Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
insert
(Collection<String> propOrColumnNames) Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
insertInto
(Class<?> entityClass) Deprecated.static SQLBuilder
insertInto
(Class<?> entityClass, Set<String> excludedPropNames) Deprecated.static SQLBuilder
Deprecated.To generatesql
part for the specifiedcond
only.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
select
(Class<?> entityClassA, String tableAliasA, String classAliasA, Class<?> entityClassB, String tableAliasB, String classAliasB) Deprecated.static SQLBuilder
select
(Class<?> entityClassA, String tableAliasA, String classAliasA, Set<String> excludedPropNamesA, Class<?> entityClassB, String tableAliasB, String classAliasB, Set<String> excludedPropNamesB) Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
select
(Collection<String> propOrColumnNames) Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
selectFrom
(Class<?> entityClass) Deprecated.static SQLBuilder
selectFrom
(Class<?> entityClass, boolean includeSubEntityProperties) Deprecated.static SQLBuilder
selectFrom
(Class<?> entityClass, boolean includeSubEntityProperties, Set<String> excludedPropNames) Deprecated.static SQLBuilder
selectFrom
(Class<?> entityClass, String alias) Deprecated.static SQLBuilder
selectFrom
(Class<?> entityClass, String alias, boolean includeSubEntityProperties) Deprecated.static SQLBuilder
selectFrom
(Class<?> entityClass, String alias, boolean includeSubEntityProperties, Set<String> excludedPropNames) Deprecated.static SQLBuilder
selectFrom
(Class<?> entityClassA, String tableAliasA, String classAliasA, Class<?> entityClassB, String tableAliasB, String classAliasB) Deprecated.static SQLBuilder
selectFrom
(Class<?> entityClassA, String tableAliasA, String classAliasA, Set<String> excludedPropNamesA, Class<?> entityClassB, String tableAliasB, String classAliasB, Set<String> excludedPropNamesB) Deprecated.static SQLBuilder
selectFrom
(Class<?> entityClass, String alias, Set<String> excludedPropNames) Deprecated.static SQLBuilder
selectFrom
(Class<?> entityClass, Set<String> excludedPropNames) Deprecated.static SQLBuilder
selectFrom
(List<Selection> multiSelects) Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.static SQLBuilder
Deprecated.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
Deprecated.- Parameters:
expr
-- Returns:
-
insert
Deprecated.- Parameters:
propOrColumnNames
-- Returns:
-
insert
Deprecated.- Parameters:
propOrColumnNames
-- Returns:
-
insert
Deprecated.- Parameters:
props
-- Returns:
-
insert
Deprecated.- Parameters:
entity
-- Returns:
-
insert
Deprecated.- Parameters:
entity
-excludedPropNames
-- Returns:
-
insert
Deprecated.- Parameters:
entityClass
-- Returns:
-
insert
Deprecated.- Parameters:
entityClass
-excludedPropNames
-- Returns:
-
insertInto
Deprecated.- Parameters:
entityClass
-- Returns:
-
insertInto
Deprecated.- Parameters:
entityClass
-excludedPropNames
-- Returns:
-
batchInsert
Deprecated.Generate the MySQL style batch insert sql.- Parameters:
propsList
- list of entity or properties map.- Returns:
-
update
Deprecated.- Parameters:
tableName
-- Returns:
-
update
Deprecated.- Parameters:
tableName
-entityClass
-- Returns:
-
update
Deprecated.- Parameters:
entityClass
-- Returns:
-
update
Deprecated.- Parameters:
entityClass
-excludedPropNames
-- Returns:
-
deleteFrom
Deprecated.- Parameters:
tableName
-- Returns:
-
deleteFrom
Deprecated.- Parameters:
tableName
-entityClass
-- Returns:
-
deleteFrom
Deprecated.- Parameters:
entityClass
-- Returns:
-
select
Deprecated.- Parameters:
selectPart
-- Returns:
-
select
Deprecated.- Parameters:
propOrColumnNames
-- Returns:
-
select
Deprecated.- Parameters:
propOrColumnNames
-- Returns:
-
select
Deprecated.- Parameters:
propOrColumnNameAliases
-- Returns:
-
select
Deprecated.- Parameters:
entityClass
-- Returns:
-
select
Deprecated.- Parameters:
entityClass
-includeSubEntityProperties
-- Returns:
-
select
Deprecated.- Parameters:
entityClass
-excludedPropNames
-- Returns:
-
select
public static SQLBuilder select(Class<?> entityClass, boolean includeSubEntityProperties, Set<String> excludedPropNames) Deprecated.- Parameters:
entityClass
-includeSubEntityProperties
-excludedPropNames
-- Returns:
-
selectFrom
Deprecated.- Parameters:
entityClass
-- Returns:
-
selectFrom
Deprecated.- Parameters:
entityClass
-alias
-- Returns:
-
selectFrom
Deprecated.- Parameters:
entityClass
-includeSubEntityProperties
-- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClass, String alias, boolean includeSubEntityProperties) Deprecated.- Parameters:
entityClass
-alias
-includeSubEntityProperties
-- Returns:
-
selectFrom
Deprecated.- Parameters:
entityClass
-excludedPropNames
-- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClass, String alias, Set<String> excludedPropNames) Deprecated.- Parameters:
entityClass
-alias
-excludedPropNames
-- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClass, boolean includeSubEntityProperties, Set<String> excludedPropNames) Deprecated.- Parameters:
entityClass
-includeSubEntityProperties
-excludedPropNames
-- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClass, String alias, boolean includeSubEntityProperties, Set<String> excludedPropNames) Deprecated.- Parameters:
entityClass
-alias
-includeSubEntityProperties
-excludedPropNames
-- Returns:
-
select
public static SQLBuilder select(Class<?> entityClassA, String tableAliasA, String classAliasA, Class<?> entityClassB, String tableAliasB, String classAliasB) Deprecated.- 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) Deprecated.- Parameters:
entityClassA
-tableAliasA
-classAliasA
-excludedPropNamesA
-entityClassB
-tableAliasB
-classAliasB
-excludedPropNamesB
-- Returns:
-
select
Deprecated.- Parameters:
multiSelects
-- Returns:
-
selectFrom
public static SQLBuilder selectFrom(Class<?> entityClassA, String tableAliasA, String classAliasA, Class<?> entityClassB, String tableAliasB, String classAliasB) Deprecated.- 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) Deprecated.- Parameters:
entityClassA
-tableAliasA
-classAliasA
-excludedPropNamesA
-entityClassB
-tableAliasB
-classAliasB
-excludedPropNamesB
-- Returns:
-
selectFrom
Deprecated.- Parameters:
multiSelects
-- Returns:
-
count
Deprecated.- Parameters:
tableName
-- Returns:
-
count
Deprecated.- Parameters:
tableName
-entityClass
-- Returns:
-
count
Deprecated.- Parameters:
entityClass
-- Returns:
-
parse
Deprecated.To generatesql
part for the specifiedcond
only.- Parameters:
cond
-entityClass
-- Returns:
-