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 = ?
 
 
  • 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: