Package com.landawn.abacus.jdbc.dao

Interface UncheckedDao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>

Type Parameters:
T -
SB - SQLBuilder used to generate sql scripts. Only can be SQLBuilder.PSC/PAC/PLC
TD -
All Superinterfaces:
Dao<T,SB,TD>
All Known Subinterfaces:
UncheckedCrudDao<T,ID,SB,TD>, UncheckedCrudDaoL<T,SB,TD>, UncheckedNoUpdateCrudDao<T,ID,SB,TD>, UncheckedNoUpdateCrudDaoL<T,SB,TD>, UncheckedNoUpdateDao<T,SB,TD>, UncheckedReadOnlyCrudDao<T,ID,SB,TD>, UncheckedReadOnlyCrudDaoL<T,SB,TD>, UncheckedReadOnlyDao<T,SB,TD>
@Beta public interface UncheckedDao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>> extends Dao<T,SB,TD>
Author:
haiyangl
See Also:
  • ConditionFactory
  • ConditionFactory.CF

  • Method Summary

    Modifier and Type
    Method
    Description
    default void
    batchSave(String namedInsertSQL, Collection<? extends T> entitiesToSave)
    Insert the specified entities to database by batch.
    void
    batchSave(String namedInsertSQL, Collection<? extends T> entitiesToSave, int batchSize)
    Insert the specified entities to database by batch.
    default void
    batchSave(Collection<? extends T> entitiesToSave)
    Insert the specified entities to database by batch.
    void
    batchSave(Collection<? extends T> entitiesToSave, int batchSize)
    Insert the specified entities to database by batch.
    default void
    batchSave(Collection<? extends T> entitiesToSave, Collection<String> propNamesToSave)
    Insert the specified entities to database by batch.
    void
    batchSave(Collection<? extends T> entitiesToSave, Collection<String> propNamesToSave, int batchSize)
    Insert the specified entities to database by batch.
    int
    count(com.landawn.abacus.condition.Condition cond)
     
    int
    delete(com.landawn.abacus.condition.Condition cond)
     
    boolean
    exists(com.landawn.abacus.condition.Condition cond)
     
    com.landawn.abacus.util.u.Optional<T>
    findFirst(com.landawn.abacus.condition.Condition cond)
     
    <R> com.landawn.abacus.util.u.Optional<R>
    findFirst(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<? extends R> rowMapper)
     
    <R> com.landawn.abacus.util.u.Optional<R>
    findFirst(com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends R> rowMapper)
     
    com.landawn.abacus.util.u.Optional<T>
    findFirst(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond)
     
    <R> com.landawn.abacus.util.u.Optional<R>
    findFirst(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<? extends R> rowMapper)
     
    <R> com.landawn.abacus.util.u.Optional<R>
    findFirst(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends R> rowMapper)
     
    com.landawn.abacus.util.u.Optional<T>
    findOnlyOne(com.landawn.abacus.condition.Condition cond)
     
    <R> com.landawn.abacus.util.u.Optional<R>
    findOnlyOne(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<? extends R> rowMapper)
     
    <R> com.landawn.abacus.util.u.Optional<R>
    findOnlyOne(com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends R> rowMapper)
     
    com.landawn.abacus.util.u.Optional<T>
    findOnlyOne(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond)
     
    <R> com.landawn.abacus.util.u.Optional<R>
    findOnlyOne(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<? extends R> rowMapper)
     
    <R> com.landawn.abacus.util.u.Optional<R>
    findOnlyOne(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends R> rowMapper)
     
    default void
    foreach(com.landawn.abacus.condition.Condition cond, Consumer<com.landawn.abacus.util.NoCachingNoUpdating.DisposableObjArray> rowConsumer)
     
    default void
    foreach(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Consumer<com.landawn.abacus.util.NoCachingNoUpdating.DisposableObjArray> rowConsumer)
     
    void
    forEach(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowConsumer rowConsumer)
     
    void
    forEach(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowFilter rowFilter, Jdbc.BiRowConsumer rowConsumer)
     
    void
    forEach(com.landawn.abacus.condition.Condition cond, Jdbc.RowConsumer rowConsumer)
     
    void
    forEach(com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter, Jdbc.RowConsumer rowConsumer)
     
    void
    forEach(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowConsumer rowConsumer)
     
    void
    forEach(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowFilter rowFilter, Jdbc.BiRowConsumer rowConsumer)
     
    void
    forEach(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowConsumer rowConsumer)
     
    void
    forEach(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter, Jdbc.RowConsumer rowConsumer)
     
    List<T>
    list(com.landawn.abacus.condition.Condition cond)
     
    <R> List<R>
    list(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowFilter rowFilter, Jdbc.BiRowMapper<? extends R> rowMapper)
     
    <R> List<R>
    list(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<? extends R> rowMapper)
     
    <R> List<R>
    list(com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter, Jdbc.RowMapper<? extends R> rowMapper)
     
    <R> List<R>
    list(com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends R> rowMapper)
     
    default <R> List<R>
    list(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
     
    default <R> List<R>
    list(String singleSelectPropName, com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter, Jdbc.RowMapper<? extends R> rowMapper)
     
    default <R> List<R>
    list(String singleSelectPropName, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends R> rowMapper)
     
    List<T>
    list(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond)
     
    <R> List<R>
    list(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowFilter rowFilter, Jdbc.BiRowMapper<? extends R> rowMapper)
     
    <R> List<R>
    list(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<? extends R> rowMapper)
     
    <R> List<R>
    list(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter, Jdbc.RowMapper<? extends R> rowMapper)
     
    <R> List<R>
    list(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends R> rowMapper)
     
    default boolean
    notExists(com.landawn.abacus.condition.Condition cond)
     
    com.landawn.abacus.util.DataSet
    query(com.landawn.abacus.condition.Condition cond)
     
    <R> R
    query(com.landawn.abacus.condition.Condition cond, Jdbc.BiResultExtractor<? extends R> resultExtractor)
     
    <R> R
    query(com.landawn.abacus.condition.Condition cond, Jdbc.ResultExtractor<? extends R> resultExtractor)
     
    com.landawn.abacus.util.DataSet
    query(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond)
     
    <R> R
    query(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiResultExtractor<? extends R> resultExtractor)
     
    <R> R
    query(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.ResultExtractor<? extends R> resultExtractor)
     
    com.landawn.abacus.util.u.OptionalBoolean
    queryForBoolean(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns an OptionalBoolean describing the value in the first row/column if it exists, otherwise return an empty OptionalBoolean.
    com.landawn.abacus.util.u.OptionalByte
    queryForByte(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns an OptionalByte describing the value in the first row/column if it exists, otherwise return an empty OptionalByte.
    com.landawn.abacus.util.u.Nullable<byte[]>
    queryForBytes(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns a Nullable<byte[]> describing the value in the first row/column if it exists, otherwise return an empty Nullable.
    com.landawn.abacus.util.u.OptionalChar
    queryForChar(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns an OptionalChar describing the value in the first row/column if it exists, otherwise return an empty OptionalChar.
    com.landawn.abacus.util.u.Nullable<Date>
    queryForDate(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns a Nullable<java.sql.Date> describing the value in the first row/column if it exists, otherwise return an empty Nullable.
    com.landawn.abacus.util.u.OptionalDouble
    queryForDouble(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns an OptionalDouble describing the value in the first row/column if it exists, otherwise return an empty OptionalDouble.
    com.landawn.abacus.util.u.OptionalFloat
    queryForFloat(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns an OptionalFloat describing the value in the first row/column if it exists, otherwise return an empty OptionalFloat.
    com.landawn.abacus.util.u.OptionalInt
    queryForInt(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns an OptionalInt describing the value in the first row/column if it exists, otherwise return an empty OptionalInt.
    com.landawn.abacus.util.u.OptionalLong
    queryForLong(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns an OptionalLong describing the value in the first row/column if it exists, otherwise return an empty OptionalLong.
    com.landawn.abacus.util.u.OptionalShort
    queryForShort(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns an OptionalShort describing the value in the first row/column if it exists, otherwise return an empty OptionalShort.
    <V> com.landawn.abacus.util.u.Optional<V>
    queryForSingleNonNull(Class<? extends V> targetValueClass, String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns an Optional describing the value in the first row/column if it exists, otherwise return an empty Optional.
    <V> com.landawn.abacus.util.u.Optional<V>
    queryForSingleNonNull(String singleSelectPropName, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends V> rowMapper)
    Returns an Optional describing the value in the first row/column if it exists, otherwise return an empty Optional.
    <V> com.landawn.abacus.util.u.Nullable<V>
    queryForSingleResult(Class<? extends V> targetValueClass, String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns a Nullable<V> describing the value in the first row/column if it exists, otherwise return an empty Nullable.
    com.landawn.abacus.util.u.Nullable<String>
    queryForString(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns a Nullable<String> describing the value in the first row/column if it exists, otherwise return an empty Nullable.
    com.landawn.abacus.util.u.Nullable<Time>
    queryForTime(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns a Nullable<java.sql.Time> describing the value in the first row/column if it exists, otherwise return an empty Nullable.
    com.landawn.abacus.util.u.Nullable<Timestamp>
    queryForTimestamp(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns a Nullable<java.sql.Timestamp> describing the value in the first row/column if it exists, otherwise return an empty Nullable.
    <V> com.landawn.abacus.util.u.Optional<V>
    queryForUniqueNonNull(Class<? extends V> targetValueClass, String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns an Optional describing the value in the first row/column if it exists, otherwise return an empty Optional.
    <V> com.landawn.abacus.util.u.Optional<V>
    queryForUniqueNonNull(String singleSelectPropName, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends V> rowMapper)
    Returns an Optional describing the value in the first row/column if it exists, otherwise return an empty Optional.
    <V> com.landawn.abacus.util.u.Nullable<V>
    queryForUniqueResult(Class<? extends V> targetValueClass, String singleSelectPropName, com.landawn.abacus.condition.Condition cond)
    Returns a Nullable describing the value in the first row/column if it exists, otherwise return an empty Nullable.
    void
    save(String namedInsertSQL, T entityToSave)
     
    void
    save(T entityToSave)
     
    void
    save(T entityToSave, Collection<String> propNamesToSave)
     
    default int
    update(String propName, Object propValue, com.landawn.abacus.condition.Condition cond)
     
    int
    update(Map<String,Object> updateProps, com.landawn.abacus.condition.Condition cond)
    Update all the records found by specified cond with all the properties from specified updateProps.
    default int
    update(T entity, com.landawn.abacus.condition.Condition cond)
    Update all the records found by specified cond with the properties from specified entity.
    int
    update(T entity, Collection<String> propNamesToUpdate, com.landawn.abacus.condition.Condition cond)
    Update all the records found by specified cond with specified propNamesToUpdate from specified entity.
    default T
    upsert(T entity, com.landawn.abacus.condition.Condition cond)
    Execute add and return the added entity if the record doesn't, otherwise, update is executed and updated db record is returned.

    Methods inherited from interface com.landawn.abacus.jdbc.dao.Dao

    asyncCall, asyncCall, asyncExecutor, asyncRun, asyncRun, dataSource, executor, prepareCallableQuery, prepareCallableQuery, prepareNamedQuery, prepareNamedQuery, prepareNamedQuery, prepareNamedQuery, prepareNamedQuery, prepareNamedQuery, prepareNamedQuery, prepareNamedQuery, prepareNamedQuery, prepareNamedQuery, prepareNamedQuery, prepareNamedQuery, prepareNamedQueryForBigResult, prepareNamedQueryForBigResult, prepareNamedQueryForBigResult, prepareQuery, prepareQuery, prepareQuery, prepareQuery, prepareQuery, prepareQuery, prepareQuery, prepareQueryForBigResult, prepareQueryForBigResult, prepareQueryForBigResult, sqlMapper, stream, stream, stream, stream, stream, stream, stream, stream, stream, stream, stream, stream, stream, targetEntityClass

  • Method Details

    • save

      void save(T entityToSave) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      save in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      entityToSave -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception

    • save

      void save(T entityToSave, Collection<String> propNamesToSave) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      save in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      entityToSave -
      propNamesToSave -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception

    • save

      void save(String namedInsertSQL, T entityToSave) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      save in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      namedInsertSQL -
      entityToSave -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception

    • batchSave

      default void batchSave(Collection<? extends T> entitiesToSave) throws com.landawn.abacus.exception.UncheckedSQLException
      Insert the specified entities to database by batch.
      Specified by:
      batchSave in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      entitiesToSave -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:

    • batchSave

      void batchSave(Collection<? extends T> entitiesToSave, int batchSize) throws com.landawn.abacus.exception.UncheckedSQLException
      Insert the specified entities to database by batch.
      Specified by:
      batchSave in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      entitiesToSave -
      batchSize -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:

    • batchSave

      default void batchSave(Collection<? extends T> entitiesToSave, Collection<String> propNamesToSave) throws com.landawn.abacus.exception.UncheckedSQLException
      Insert the specified entities to database by batch.
      Specified by:
      batchSave in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      entitiesToSave -
      propNamesToSave -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:

    • batchSave

      void batchSave(Collection<? extends T> entitiesToSave, Collection<String> propNamesToSave, int batchSize) throws com.landawn.abacus.exception.UncheckedSQLException
      Insert the specified entities to database by batch.
      Specified by:
      batchSave in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      entitiesToSave -
      propNamesToSave -
      batchSize -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:

    • batchSave

      @Beta default void batchSave(String namedInsertSQL, Collection<? extends T> entitiesToSave) throws com.landawn.abacus.exception.UncheckedSQLException
      Insert the specified entities to database by batch.
      Specified by:
      batchSave in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      namedInsertSQL -
      entitiesToSave -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:

    • batchSave

      @Beta void batchSave(String namedInsertSQL, Collection<? extends T> entitiesToSave, int batchSize) throws com.landawn.abacus.exception.UncheckedSQLException
      Insert the specified entities to database by batch.
      Specified by:
      batchSave in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      namedInsertSQL -
      entitiesToSave -
      batchSize -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:

    • exists

      boolean exists(com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      exists in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      cond -
      Returns:
      true, if there is at least one record found.
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:

    • notExists

      @Beta default boolean notExists(com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      notExists in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      cond -
      Returns:
      true, if there is no record found.
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • count

      int count(com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      count in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • findFirst

      com.landawn.abacus.util.u.Optional<T> findFirst(com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      findFirst in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • findFirst

      <R> com.landawn.abacus.util.u.Optional<R> findFirst(com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      findFirst in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • findFirst

      <R> com.landawn.abacus.util.u.Optional<R> findFirst(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      findFirst in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • findFirst

      com.landawn.abacus.util.u.Optional<T> findFirst(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      findFirst in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      selectPropNames - all properties(columns) will be selected, excluding the properties of joining entities, if the specified selectPropNames is null.
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • findFirst

      <R> com.landawn.abacus.util.u.Optional<R> findFirst(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      findFirst in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      selectPropNames - all properties(columns) will be selected, excluding the properties of joining entities, if the specified selectPropNames is null.
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • findFirst

      <R> com.landawn.abacus.util.u.Optional<R> findFirst(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      findFirst in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      selectPropNames - all properties(columns) will be selected, excluding the properties of joining entities, if the specified selectPropNames is null.
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • findOnlyOne

      com.landawn.abacus.util.u.Optional<T> findOnlyOne(com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.DuplicatedResultException, com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      findOnlyOne in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.DuplicatedResultException - if more than one record found by the specified id (or condition).
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • findOnlyOne

      <R> com.landawn.abacus.util.u.Optional<R> findOnlyOne(com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.DuplicatedResultException, com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      findOnlyOne in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.DuplicatedResultException - if more than one record found by the specified id (or condition).
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • findOnlyOne

      <R> com.landawn.abacus.util.u.Optional<R> findOnlyOne(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.DuplicatedResultException, com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      findOnlyOne in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.DuplicatedResultException - if more than one record found by the specified id (or condition).
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • findOnlyOne

      com.landawn.abacus.util.u.Optional<T> findOnlyOne(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.DuplicatedResultException, com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      findOnlyOne in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      selectPropNames - all properties(columns) will be selected, excluding the properties of joining entities, if the specified selectPropNames is null.
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.DuplicatedResultException - if more than one record found by the specified id (or condition).
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • findOnlyOne

      <R> com.landawn.abacus.util.u.Optional<R> findOnlyOne(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.DuplicatedResultException, com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      findOnlyOne in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      selectPropNames - all properties(columns) will be selected, excluding the properties of joining entities, if the specified selectPropNames is null.
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.DuplicatedResultException - if more than one record found by the specified id (or condition).
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception

    • findOnlyOne

      <R> com.landawn.abacus.util.u.Optional<R> findOnlyOne(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.DuplicatedResultException, com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      findOnlyOne in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      selectPropNames - all properties(columns) will be selected, excluding the properties of joining entities, if the specified selectPropNames is null.
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.DuplicatedResultException - if more than one record found by the specified id (or condition).
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • queryForBoolean

      com.landawn.abacus.util.u.OptionalBoolean queryForBoolean(String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns an OptionalBoolean describing the value in the first row/column if it exists, otherwise return an empty OptionalBoolean.
      Specified by:
      queryForBoolean in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForChar

      com.landawn.abacus.util.u.OptionalChar queryForChar(String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns an OptionalChar describing the value in the first row/column if it exists, otherwise return an empty OptionalChar.
      Specified by:
      queryForChar in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForByte

      com.landawn.abacus.util.u.OptionalByte queryForByte(String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns an OptionalByte describing the value in the first row/column if it exists, otherwise return an empty OptionalByte.
      Specified by:
      queryForByte in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForShort

      com.landawn.abacus.util.u.OptionalShort queryForShort(String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns an OptionalShort describing the value in the first row/column if it exists, otherwise return an empty OptionalShort.
      Specified by:
      queryForShort in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForInt

      com.landawn.abacus.util.u.OptionalInt queryForInt(String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns an OptionalInt describing the value in the first row/column if it exists, otherwise return an empty OptionalInt.
      Specified by:
      queryForInt in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForLong

      com.landawn.abacus.util.u.OptionalLong queryForLong(String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns an OptionalLong describing the value in the first row/column if it exists, otherwise return an empty OptionalLong.
      Specified by:
      queryForLong in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForFloat

      com.landawn.abacus.util.u.OptionalFloat queryForFloat(String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns an OptionalFloat describing the value in the first row/column if it exists, otherwise return an empty OptionalFloat.
      Specified by:
      queryForFloat in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForDouble

      com.landawn.abacus.util.u.OptionalDouble queryForDouble(String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns an OptionalDouble describing the value in the first row/column if it exists, otherwise return an empty OptionalDouble.
      Specified by:
      queryForDouble in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForString

      com.landawn.abacus.util.u.Nullable<String> queryForString(String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns a Nullable<String> describing the value in the first row/column if it exists, otherwise return an empty Nullable.
      Specified by:
      queryForString in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForDate

      com.landawn.abacus.util.u.Nullable<Date> queryForDate(String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns a Nullable<java.sql.Date> describing the value in the first row/column if it exists, otherwise return an empty Nullable.
      Specified by:
      queryForDate in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForTime

      com.landawn.abacus.util.u.Nullable<Time> queryForTime(String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns a Nullable<java.sql.Time> describing the value in the first row/column if it exists, otherwise return an empty Nullable.
      Specified by:
      queryForTime in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForTimestamp

      com.landawn.abacus.util.u.Nullable<Timestamp> queryForTimestamp(String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns a Nullable<java.sql.Timestamp> describing the value in the first row/column if it exists, otherwise return an empty Nullable.
      Specified by:
      queryForTimestamp in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForBytes

      com.landawn.abacus.util.u.Nullable<byte[]> queryForBytes(String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns a Nullable<byte[]> describing the value in the first row/column if it exists, otherwise return an empty Nullable.
      Specified by:
      queryForBytes in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForSingleResult

      <V> com.landawn.abacus.util.u.Nullable<V> queryForSingleResult(Class<? extends V> targetValueClass, String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns a Nullable<V> describing the value in the first row/column if it exists, otherwise return an empty Nullable.
      Specified by:
      queryForSingleResult in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForSingleNonNull

      <V> com.landawn.abacus.util.u.Optional<V> queryForSingleNonNull(Class<? extends V> targetValueClass, String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns an Optional describing the value in the first row/column if it exists, otherwise return an empty Optional.
      Specified by:
      queryForSingleNonNull in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      V - the value type
      Parameters:
      targetValueClass -
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForSingleNonNull

      <V> com.landawn.abacus.util.u.Optional<V> queryForSingleNonNull(String singleSelectPropName, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends V> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Returns an Optional describing the value in the first row/column if it exists, otherwise return an empty Optional.
      Specified by:
      queryForSingleNonNull in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      V - the value type
      Parameters:
      singleSelectPropName -
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForUniqueResult

      <V> com.landawn.abacus.util.u.Nullable<V> queryForUniqueResult(Class<? extends V> targetValueClass, String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.DuplicatedResultException, com.landawn.abacus.exception.UncheckedSQLException
      Returns a Nullable describing the value in the first row/column if it exists, otherwise return an empty Nullable. And throws DuplicatedResultException if more than one record found.
      Specified by:
      queryForUniqueResult in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      V - the value type
      Parameters:
      targetValueClass -
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.DuplicatedResultException - if more than one record found by the specified id (or condition).
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForUniqueNonNull

      <V> com.landawn.abacus.util.u.Optional<V> queryForUniqueNonNull(Class<? extends V> targetValueClass, String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.DuplicatedResultException, com.landawn.abacus.exception.UncheckedSQLException
      Returns an Optional describing the value in the first row/column if it exists, otherwise return an empty Optional.
      Specified by:
      queryForUniqueNonNull in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      V - the value type
      Parameters:
      targetValueClass -
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.DuplicatedResultException - if more than one record found by the specified id (or condition).
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • queryForUniqueNonNull

      <V> com.landawn.abacus.util.u.Optional<V> queryForUniqueNonNull(String singleSelectPropName, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends V> rowMapper) throws com.landawn.abacus.exception.DuplicatedResultException, com.landawn.abacus.exception.UncheckedSQLException
      Returns an Optional describing the value in the first row/column if it exists, otherwise return an empty Optional.
      Specified by:
      queryForUniqueNonNull in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      V - the value type
      Parameters:
      singleSelectPropName -
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.DuplicatedResultException - if more than one record found by the specified id (or condition).
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:

    • query

      com.landawn.abacus.util.DataSet query(com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      query in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • query

      com.landawn.abacus.util.DataSet query(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      query in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      selectPropNames - all properties(columns) will be selected, excluding the properties of joining entities, if the specified selectPropNames is null.
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • query

      <R> R query(com.landawn.abacus.condition.Condition cond, Jdbc.ResultExtractor<? extends R> resultExtractor) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      query in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      cond -
      resultExtractor - Don't save/return ResultSet. It will be closed after this call.
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • query

      <R> R query(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.ResultExtractor<? extends R> resultExtractor) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      query in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      selectPropNames - all properties(columns) will be selected, excluding the properties of joining entities, if the specified selectPropNames is null.
      cond -
      resultExtractor - Don't save/return ResultSet. It will be closed after this call.
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • query

      <R> R query(com.landawn.abacus.condition.Condition cond, Jdbc.BiResultExtractor<? extends R> resultExtractor) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      query in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      cond -
      resultExtractor - Don't save/return ResultSet. It will be closed after this call.
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception

    • query

      <R> R query(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiResultExtractor<? extends R> resultExtractor) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      query in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      selectPropNames - all properties(columns) will be selected, excluding the properties of joining entities, if the specified selectPropNames is null.
      cond -
      resultExtractor - Don't save/return ResultSet. It will be closed after this call.
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • list

      List<T> list(com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      list in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • list

      <R> List<R> list(com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      list in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • list

      <R> List<R> list(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      list in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • list

      <R> List<R> list(com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter, Jdbc.RowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      list in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      cond -
      rowFilter -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • list

      <R> List<R> list(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowFilter rowFilter, Jdbc.BiRowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      list in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      cond -
      rowFilter -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • list

      List<T> list(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      list in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      selectPropNames - all properties(columns) will be selected, excluding the properties of joining entities, if the specified selectPropNames is null.
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • list

      <R> List<R> list(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      list in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      selectPropNames - all properties(columns) will be selected, excluding the properties of joining entities, if the specified selectPropNames is null.
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • list

      <R> List<R> list(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      list in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      selectPropNames - all properties(columns) will be selected, excluding the properties of joining entities, if the specified selectPropNames is null.
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • list

      <R> List<R> list(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter, Jdbc.RowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      list in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      selectPropNames - all properties(columns) will be selected, excluding the properties of joining entities, if the specified selectPropNames is null.
      cond -
      rowFilter -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • list

      <R> List<R> list(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowFilter rowFilter, Jdbc.BiRowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      list in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      selectPropNames - all properties(columns) will be selected, excluding the properties of joining entities, if the specified selectPropNames is null.
      cond -
      rowFilter -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • list

      default <R> List<R> list(String singleSelectPropName, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      list in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      singleSelectPropName -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • list

      default <R> List<R> list(String singleSelectPropName, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      list in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      singleSelectPropName -
      cond -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • list

      default <R> List<R> list(String singleSelectPropName, com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter, Jdbc.RowMapper<? extends R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      list in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Type Parameters:
      R -
      Parameters:
      singleSelectPropName -
      cond -
      rowFilter -
      rowMapper -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • forEach

      void forEach(com.landawn.abacus.condition.Condition cond, Jdbc.RowConsumer rowConsumer) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      forEach in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      cond -
      rowConsumer -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • forEach

      void forEach(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowConsumer rowConsumer) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      forEach in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      cond -
      rowConsumer -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • forEach

      void forEach(com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter, Jdbc.RowConsumer rowConsumer) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      forEach in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      cond -
      rowFilter -
      rowConsumer -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • forEach

      void forEach(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowFilter rowFilter, Jdbc.BiRowConsumer rowConsumer) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      forEach in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      cond -
      rowFilter -
      rowConsumer -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • forEach

      void forEach(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowConsumer rowConsumer) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      forEach in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      selectPropNames -
      cond -
      rowConsumer -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • forEach

      void forEach(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowConsumer rowConsumer) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      forEach in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      selectPropNames -
      cond -
      rowConsumer -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • forEach

      void forEach(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter, Jdbc.RowConsumer rowConsumer) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      forEach in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      selectPropNames -
      cond -
      rowFilter -
      rowConsumer -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • forEach

      void forEach(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowFilter rowFilter, Jdbc.BiRowConsumer rowConsumer) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      forEach in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      selectPropNames -
      cond -
      rowFilter -
      rowConsumer -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • foreach

      @Beta default void foreach(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Consumer<com.landawn.abacus.util.NoCachingNoUpdating.DisposableObjArray> rowConsumer) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      foreach in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      selectPropNames -
      cond -
      rowConsumer -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • foreach

      @Beta default void foreach(com.landawn.abacus.condition.Condition cond, Consumer<com.landawn.abacus.util.NoCachingNoUpdating.DisposableObjArray> rowConsumer) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      foreach in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      cond -
      rowConsumer -
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • update

      default int update(String propName, Object propValue, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      update in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      propName -
      propValue -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • update

      int update(Map<String,Object> updateProps, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Description copied from interface: Dao
      Update all the records found by specified cond with all the properties from specified updateProps.
      Specified by:
      update in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      updateProps -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • update

      default int update(T entity, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Update all the records found by specified cond with the properties from specified entity.
      Specified by:
      update in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      entity -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • update

      int update(T entity, Collection<String> propNamesToUpdate, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Update all the records found by specified cond with specified propNamesToUpdate from specified entity.
      Specified by:
      update in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      entity -
      propNamesToUpdate -
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • upsert

      default T upsert(T entity, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Execute add and return the added entity if the record doesn't, otherwise, update is executed and updated db record is returned.
      Specified by:
      upsert in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      entity -
      cond - to verify if the record exists or not.
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF

    • delete

      int delete(com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException
      Specified by:
      delete in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
      Parameters:
      cond -
      Returns:
      Throws:
      com.landawn.abacus.exception.UncheckedSQLException - the unchecked SQL exception
      See Also:
      • ConditionFactory
      • ConditionFactory.CF