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 boolean	allMatch(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowFilter rowFilter)
default boolean	allMatch(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter)
default boolean	anyMatch(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowFilter rowFilter)
default boolean	anyMatch(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter)
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	noneMatch(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.BiRowFilter rowFilter)
default boolean	noneMatch(Collection<String> selectPropNames, com.landawn.abacus.condition.Condition cond, Jdbc.RowFilter rowFilter)
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:

• 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

anyMatch

@Beta
default boolean anyMatch(Collection<String> selectPropNames,
 com.landawn.abacus.condition.Condition cond,
 Jdbc.RowFilter rowFilter)
                  throws com.landawn.abacus.exception.UncheckedSQLException

Specified by:

anyMatch in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>

Parameters:

selectPropNames -

cond -

rowFilter -

Returns:

Throws:

com.landawn.abacus.exception.UncheckedSQLException

anyMatch

@Beta
default boolean anyMatch(Collection<String> selectPropNames,
 com.landawn.abacus.condition.Condition cond,
 Jdbc.BiRowFilter rowFilter)
                  throws com.landawn.abacus.exception.UncheckedSQLException

Specified by:

anyMatch in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>

Parameters:

selectPropNames -

cond -

rowFilter -

Returns:

Throws:

com.landawn.abacus.exception.UncheckedSQLException

allMatch

@Beta
default boolean allMatch(Collection<String> selectPropNames,
 com.landawn.abacus.condition.Condition cond,
 Jdbc.RowFilter rowFilter)
                  throws com.landawn.abacus.exception.UncheckedSQLException

Specified by:

allMatch in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>

Parameters:

selectPropNames -

cond -

rowFilter -

Returns:

Throws:

com.landawn.abacus.exception.UncheckedSQLException

allMatch

@Beta
default boolean allMatch(Collection<String> selectPropNames,
 com.landawn.abacus.condition.Condition cond,
 Jdbc.BiRowFilter rowFilter)
                  throws com.landawn.abacus.exception.UncheckedSQLException

Specified by:

allMatch in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>

Parameters:

selectPropNames -

cond -

rowFilter -

Returns:

Throws:

com.landawn.abacus.exception.UncheckedSQLException

noneMatch

@Beta
default boolean noneMatch(Collection<String> selectPropNames,
 com.landawn.abacus.condition.Condition cond,
 Jdbc.RowFilter rowFilter)
                   throws com.landawn.abacus.exception.UncheckedSQLException

Specified by:

noneMatch in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>

Parameters:

selectPropNames -

cond -

rowFilter -

Returns:

Throws:

com.landawn.abacus.exception.UncheckedSQLException

noneMatch

@Beta
default boolean noneMatch(Collection<String> selectPropNames,
 com.landawn.abacus.condition.Condition cond,
 Jdbc.BiRowFilter rowFilter)
                   throws com.landawn.abacus.exception.UncheckedSQLException

Specified by:

noneMatch in interface Dao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>

Parameters:

selectPropNames -

cond -

rowFilter -

Returns:

Throws:

com.landawn.abacus.exception.UncheckedSQLException

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForBoolean()

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForChar()

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForByte()

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForShort()

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForInt()

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForLong()

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForFloat()

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForDouble()

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForString()

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForDate()

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForTime()

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForTimestamp()

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForBytes()

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForSingleResult(Class)

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForSingleNonNull(Class)

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForSingleNonNull(Class)

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForUniqueResult(Class)

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForUniqueNonNull(Class)

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:

• ConditionFactory
• ConditionFactory.CF
• AbstractPreparedQuery.queryForUniqueNonNull(Class)

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