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 beSQLBuilder.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 TypeMethodDescriptiondefault 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, 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
(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>
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
(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
void
void
save
(T entityToSave, Collection<String> propNamesToSave) default int
int
Update all the records found by specifiedcond
with all the properties from specifiedupdateProps
.default int
Update all the records found by specifiedcond
with the properties from specifiedentity
.int
update
(T entity, Collection<String> propNamesToUpdate, com.landawn.abacus.condition.Condition cond) Update all the records found by specifiedcond
with specifiedpropNamesToUpdate
from specifiedentity
.default T
Executeadd
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
-
save
void save(T entityToSave, Collection<String> propNamesToSave) throws com.landawn.abacus.exception.UncheckedSQLException -
save
-
batchSave
default void batchSave(Collection<? extends T> entitiesToSave) throws com.landawn.abacus.exception.UncheckedSQLException Insert the specified entities to database by batch. -
batchSave
void batchSave(Collection<? extends T> entitiesToSave, int batchSize) throws com.landawn.abacus.exception.UncheckedSQLException Insert the specified entities to database by batch. -
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. -
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. -
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. -
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. -
exists
boolean exists(com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException -
notExists
@Beta default boolean notExists(com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
notExists
in interfaceDao<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 -
findFirst
com.landawn.abacus.util.u.Optional<T> findFirst(com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException -
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 -
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 -
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 interfaceDao<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 specifiedselectPropNames
isnull
.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 interfaceDao<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 specifiedselectPropNames
isnull
.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 interfaceDao<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 specifiedselectPropNames
isnull
.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 interfaceDao<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 specifiedid
(orcondition
).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 interfaceDao<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 specifiedid
(orcondition
).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 interfaceDao<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 specifiedid
(orcondition
).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 interfaceDao<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 specifiedselectPropNames
isnull
.cond
-- Returns:
- Throws:
com.landawn.abacus.exception.DuplicatedResultException
- if more than one record found by the specifiedid
(orcondition
).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 interfaceDao<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 specifiedselectPropNames
isnull
.cond
-rowMapper
-- Returns:
- Throws:
com.landawn.abacus.exception.DuplicatedResultException
- if more than one record found by the specifiedid
(orcondition
).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 interfaceDao<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 specifiedselectPropNames
isnull
.cond
-rowMapper
-- Returns:
- Throws:
com.landawn.abacus.exception.DuplicatedResultException
- if more than one record found by the specifiedid
(orcondition
).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 interfaceDao<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 interfaceDao<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 interfaceDao<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 interfaceDao<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 interfaceDao<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 interfaceDao<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 interfaceDao<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 interfaceDao<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 interfaceDao<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 interfaceDao<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 interfaceDao<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 interfaceDao<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 interfaceDao<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 interfaceDao<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 specifiedid
(orcondition
).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 interfaceDao<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 specifiedid
(orcondition
).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 interfaceDao<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 exceptioncom.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 -
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 interfaceDao<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 specifiedselectPropNames
isnull
.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 interfaceDao<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedDao<T, SB, TD>> - Parameters:
cond
-resultExtrator
- Don't save/returnResultSet
. 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 interfaceDao<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 specifiedselectPropNames
isnull
.cond
-resultExtrator
- Don't save/returnResultSet
. 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 interfaceDao<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedDao<T, SB, TD>> - Parameters:
cond
-resultExtrator
- Don't save/returnResultSet
. 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 interfaceDao<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 specifiedselectPropNames
isnull
.cond
-resultExtrator
- Don't save/returnResultSet
. 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
<R> List<R> list(com.landawn.abacus.condition.Condition cond, Jdbc.RowMapper<R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException -
list
<R> List<R> list(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowMapper<R> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException -
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 interfaceDao<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 interfaceDao<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 interfaceDao<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 specifiedselectPropNames
isnull
.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 interfaceDao<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 specifiedselectPropNames
isnull
.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 interfaceDao<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 specifiedselectPropNames
isnull
.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 interfaceDao<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 specifiedselectPropNames
isnull
.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 interfaceDao<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 specifiedselectPropNames
isnull
.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 interfaceDao<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 interfaceDao<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 interfaceDao<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 -
forEach
void forEach(com.landawn.abacus.condition.Condition cond, Jdbc.BiRowConsumer rowConsumer) throws com.landawn.abacus.exception.UncheckedSQLException -
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 interfaceDao<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 interfaceDao<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 interfaceDao<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 interfaceDao<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 interfaceDao<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 interfaceDao<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 -
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 -
update
default int update(String propName, Object propValue, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
update
in interfaceDao<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.UncheckedSQLExceptionDescription copied from interface:Dao
Update all the records found by specifiedcond
with all the properties from specifiedupdateProps
. -
update
default int update(T entity, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException Update all the records found by specifiedcond
with the properties from specifiedentity
. -
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 specifiedcond
with specifiedpropNamesToUpdate
from specifiedentity
. -
upsert
default T upsert(T entity, com.landawn.abacus.condition.Condition cond) throws com.landawn.abacus.exception.UncheckedSQLException Executeadd
and return the added entity if the record doesn't, otherwise,update
is executed and updated db record is returned.- Specified by:
upsert
in interfaceDao<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
-