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<R> rowMapper)
<R> com.landawn.abacus.util.u.Optional<R>	findFirst(com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<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<R> rowMapper)
<R> com.landawn.abacus.util.u.Optional<R>	findFirst(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<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<R> rowMapper)
<R> com.landawn.abacus.util.u.Optional<R>	findOnlyOne(com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<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<R> rowMapper)
<R> com.landawn.abacus.util.u.Optional<R>	findOnlyOne(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<R> rowMapper)
default void	foreach(com.landawn.abacus.condition.Condition cond, com.landawn.abacus.util.function.Consumer<com.landawn.abacus.util.NoCachingNoUpdating.DisposableObjArray> rowConsumer)
default void	foreach(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, com.landawn.abacus.util.function.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<R> rowMapper)
<R> List<R>	list(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<R> rowMapper)
<R> List<R>	list(com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter, Jdbc.RowMapper<R> rowMapper)
<R> List<R>	list(com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<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<R> rowMapper)
default <R> List<R>	list(String singleSelectPropName, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<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<R> rowMapper)
<R> List<R>	list(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<R> rowMapper)
<R> List<R>	list(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter, Jdbc.RowMapper<R> rowMapper)
<R> List<R>	list(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<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<R> resultExtrator)
<R> R	query(com.landawn.abacus.condition.Condition cond, Jdbc.ResultExtractor<R> resultExtrator)
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<R> resultExtrator)
<R> R	query(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.ResultExtractor<R> resultExtrator)
com.landawn.abacus.util.u.OptionalBoolean	queryForBoolean(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for boolean.
com.landawn.abacus.util.u.OptionalByte	queryForByte(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for byte.
com.landawn.abacus.util.u.OptionalChar	queryForChar(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for char.
com.landawn.abacus.util.u.Nullable<Date>	queryForDate(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for date.
com.landawn.abacus.util.u.OptionalDouble	queryForDouble(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for double.
com.landawn.abacus.util.u.OptionalFloat	queryForFloat(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for float.
com.landawn.abacus.util.u.OptionalInt	queryForInt(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for int.
com.landawn.abacus.util.u.OptionalLong	queryForLong(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for long.
com.landawn.abacus.util.u.OptionalShort	queryForShort(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for short.
<V> com.landawn.abacus.util.u.Optional<V>	queryForSingleNonNull(Class<V> targetValueClass, String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for single non null.
<V> com.landawn.abacus.util.u.Nullable<V>	queryForSingleResult(Class<V> targetValueClass, String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for single result.
com.landawn.abacus.util.u.Nullable<String>	queryForString(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for string.
com.landawn.abacus.util.u.Nullable<Time>	queryForTime(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for time.
com.landawn.abacus.util.u.Nullable<Timestamp>	queryForTimestamp(String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for timestamp.
<V> com.landawn.abacus.util.u.Optional<V>	queryForUniqueNonNull(Class<V> targetValueClass, String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for unique non null.
<V> com.landawn.abacus.util.u.Nullable<V>	queryForUniqueResult(Class<V> targetValueClass, String singleSelectPropName, com.landawn.abacus.condition.Condition cond)	Query for unique result.
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:

• CrudDao.batchInsert(Collection)

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:

• CrudDao.batchInsert(Collection)

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:

• CrudDao.batchInsert(Collection)

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:

• CrudDao.batchInsert(Collection)

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:

• CrudDao.batchInsert(Collection)

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:

• CrudDao.batchInsert(Collection)

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:

• AbstractPreparedQuery.exists()

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.notExists()

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<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>>

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<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>>

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<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>>

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<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>>

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<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>>

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<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>>

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<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>>

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<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>>

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

Query for boolean.

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 - the unchecked SQL exception

See Also:

• ConditionFactory
• ConditionFactory.CF

queryForChar

com.landawn.abacus.util.u.OptionalChar queryForChar(String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                             throws com.landawn.abacus.exception.UncheckedSQLException

Query for char.

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 - the unchecked SQL exception

See Also:

• ConditionFactory
• ConditionFactory.CF

queryForByte

com.landawn.abacus.util.u.OptionalByte queryForByte(String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                             throws com.landawn.abacus.exception.UncheckedSQLException

Query for byte.

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 - the unchecked SQL exception

See Also:

• ConditionFactory
• ConditionFactory.CF

queryForShort

com.landawn.abacus.util.u.OptionalShort queryForShort(String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                               throws com.landawn.abacus.exception.UncheckedSQLException

Query for short.

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 - the unchecked SQL exception

See Also:

• ConditionFactory
• ConditionFactory.CF

queryForInt

com.landawn.abacus.util.u.OptionalInt queryForInt(String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                           throws com.landawn.abacus.exception.UncheckedSQLException

Query for int.

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 - the unchecked SQL exception

See Also:

• ConditionFactory
• ConditionFactory.CF

queryForLong

com.landawn.abacus.util.u.OptionalLong queryForLong(String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                             throws com.landawn.abacus.exception.UncheckedSQLException

Query for long.

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 - the unchecked SQL exception

See Also:

• ConditionFactory
• ConditionFactory.CF

queryForFloat

com.landawn.abacus.util.u.OptionalFloat queryForFloat(String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                               throws com.landawn.abacus.exception.UncheckedSQLException

Query for float.

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 - the unchecked SQL exception

See Also:

• ConditionFactory
• ConditionFactory.CF

queryForDouble

com.landawn.abacus.util.u.OptionalDouble queryForDouble(String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                                 throws com.landawn.abacus.exception.UncheckedSQLException

Query for double.

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 - the unchecked SQL exception

See Also:

• ConditionFactory
• ConditionFactory.CF

queryForString

com.landawn.abacus.util.u.Nullable<String> queryForString(String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                                   throws com.landawn.abacus.exception.UncheckedSQLException

Query for string.

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 - the unchecked SQL exception

See Also:

• ConditionFactory
• ConditionFactory.CF

queryForDate

com.landawn.abacus.util.u.Nullable<Date> queryForDate(String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                               throws com.landawn.abacus.exception.UncheckedSQLException

Query for date.

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 - the unchecked SQL exception

See Also:

• ConditionFactory
• ConditionFactory.CF

queryForTime

com.landawn.abacus.util.u.Nullable<Time> queryForTime(String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                               throws com.landawn.abacus.exception.UncheckedSQLException

Query for time.

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 - the unchecked SQL exception

See Also:

• ConditionFactory
• ConditionFactory.CF

queryForTimestamp

com.landawn.abacus.util.u.Nullable<Timestamp> queryForTimestamp(String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                                         throws com.landawn.abacus.exception.UncheckedSQLException

Query for timestamp.

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 - the unchecked SQL exception

See Also:

• ConditionFactory
• ConditionFactory.CF

queryForSingleResult

<V> com.landawn.abacus.util.u.Nullable<V> queryForSingleResult(Class<V> targetValueClass,
 String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                                        throws com.landawn.abacus.exception.UncheckedSQLException

Query for single result.

Specified by:

queryForSingleResult 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 - the unchecked SQL exception

See Also:

• ConditionFactory
• ConditionFactory.CF

queryForSingleNonNull

<V> com.landawn.abacus.util.u.Optional<V> queryForSingleNonNull(Class<V> targetValueClass,
 String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                                         throws com.landawn.abacus.exception.UncheckedSQLException

Query for single non null.

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.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

queryForUniqueResult

<V> com.landawn.abacus.util.u.Nullable<V> queryForUniqueResult(Class<V> targetValueClass,
 String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                                        throws com.landawn.abacus.exception.DuplicatedResultException,
com.landawn.abacus.exception.UncheckedSQLException

Query for unique result.

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 - the unchecked SQL exception

See Also:

• ConditionFactory
• ConditionFactory.CF

queryForUniqueNonNull

<V> com.landawn.abacus.util.u.Optional<V> queryForUniqueNonNull(Class<V> targetValueClass,
 String singleSelectPropName,
 com.landawn.abacus.condition.Condition cond)
                                                         throws com.landawn.abacus.exception.DuplicatedResultException,
com.landawn.abacus.exception.UncheckedSQLException

Query for unique non null.

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.UncheckedSQLException - the unchecked SQL exception

com.landawn.abacus.exception.DuplicatedResultException

See Also:

• ConditionFactory
• ConditionFactory.CF

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<R> resultExtrator)
     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 -

resultExtrator - 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<R> resultExtrator)
     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 -

resultExtrator - 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<R> resultExtrator)
     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 -

resultExtrator - 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<R> resultExtrator)
     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 -

resultExtrator - 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<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>>

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<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>>

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<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>>

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<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>>

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<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>>

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<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>>

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<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>>

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<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>>

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>>

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<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>>

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<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>>

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,
 com.landawn.abacus.util.function.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,
 com.landawn.abacus.util.function.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 -

cond -

propNamesToUpdate -

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