Package com.landawn.abacus.jdbc.dao
Interface UncheckedCrudDaoL<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedCrudDaoL<T,SB,TD>>
- Type Parameters:
T
-SB
-SQLBuilder
used to generate sql scripts. Only can beSQLBuilder.PSC/PAC/PLC
TD
-
- All Superinterfaces:
CrudDao<T,
,Long, SB, TD> CrudDaoL<T,
,SB, TD> Dao<T,
,SB, TD> UncheckedCrudDao<T,
,Long, SB, TD> UncheckedDao<T,
SB, TD>
- All Known Subinterfaces:
UncheckedNoUpdateCrudDaoL<T,
,SB, TD> UncheckedReadOnlyCrudDaoL<T,
SB, TD>
@Beta
public interface UncheckedCrudDaoL<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedCrudDaoL<T,SB,TD>>
extends UncheckedCrudDao<T,Long,SB,TD>, CrudDaoL<T,SB,TD>
-
Method Summary
Modifier and TypeMethodDescriptiondefault int
deleteById
(long id) default boolean
exists
(long id) default com.landawn.abacus.util.u.Optional<T>
get
(long id) Returns the record found by the specifiedid
or an emptyOptional
if no record is found.default com.landawn.abacus.util.u.Optional<T>
get
(long id, Collection<String> selectPropNames) Returns the record found by the specifiedid
or an emptyOptional
if no record is found.default T
gett
(long id) Returns the record found by the specifiedid
ornull
if no record is found.default T
gett
(long id, Collection<String> selectPropNames) Returns the record found by the specifiedid
ornull
if no record is found.default boolean
notExists
(long id) default com.landawn.abacus.util.u.OptionalBoolean
queryForBoolean
(String singleSelectPropName, long id) default com.landawn.abacus.util.u.OptionalByte
queryForByte
(String singleSelectPropName, long id) default com.landawn.abacus.util.u.Nullable<byte[]>
queryForBytes
(String singleSelectPropName, long id) default com.landawn.abacus.util.u.OptionalChar
queryForChar
(String singleSelectPropName, long id) default com.landawn.abacus.util.u.Nullable<Date>
queryForDate
(String singleSelectPropName, long id) default com.landawn.abacus.util.u.OptionalDouble
queryForDouble
(String singleSelectPropName, long id) default com.landawn.abacus.util.u.OptionalFloat
queryForFloat
(String singleSelectPropName, long id) default com.landawn.abacus.util.u.OptionalInt
queryForInt
(String singleSelectPropName, long id) default com.landawn.abacus.util.u.OptionalLong
queryForLong
(String singleSelectPropName, long id) default com.landawn.abacus.util.u.OptionalShort
queryForShort
(String singleSelectPropName, long id) default <V> com.landawn.abacus.util.u.Optional<V>
queryForSingleNonNull
(Class<? extends V> targetValueClass, String singleSelectPropName, long id) default <V> com.landawn.abacus.util.u.Optional<V>
queryForSingleNonNull
(String singleSelectPropName, long id, Jdbc.RowMapper<? extends V> rowMapper) default <V> com.landawn.abacus.util.u.Nullable<V>
queryForSingleResult
(Class<? extends V> targetValueClass, String singleSelectPropName, long id) default com.landawn.abacus.util.u.Nullable<String>
queryForString
(String singleSelectPropName, long id) default com.landawn.abacus.util.u.Nullable<Time>
queryForTime
(String singleSelectPropName, long id) default com.landawn.abacus.util.u.Nullable<Timestamp>
queryForTimestamp
(String singleSelectPropName, long id) default <V> com.landawn.abacus.util.u.Optional<V>
queryForUniqueNonNull
(Class<? extends V> targetValueClass, String singleSelectPropName, long id) default <V> com.landawn.abacus.util.u.Optional<V>
queryForUniqueNonNull
(String singleSelectPropName, long id, Jdbc.RowMapper<? extends V> rowMapper) default <V> com.landawn.abacus.util.u.Nullable<V>
queryForUniqueResult
(Class<? extends V> targetValueClass, String singleSelectPropName, long id) default int
default int
Methods inherited from interface com.landawn.abacus.jdbc.dao.CrudDao
idExtractor, upsert
Methods inherited from interface com.landawn.abacus.jdbc.dao.Dao
asyncCall, asyncCall, asyncExecutor, asyncRun, asyncRun, dataSource, executor, paginate, paginate, paginate, paginate, paginate, paginate, 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, targetTableName
Methods inherited from interface com.landawn.abacus.jdbc.dao.UncheckedCrudDao
batchDelete, batchDelete, batchDeleteByIds, batchDeleteByIds, batchGet, batchGet, batchGet, batchGet, batchInsert, batchInsert, batchInsert, batchInsert, batchInsert, batchInsert, batchRefresh, batchRefresh, batchRefresh, batchRefresh, batchUpdate, batchUpdate, batchUpdate, batchUpdate, batchUpsert, batchUpsert, batchUpsert, batchUpsert, count, delete, deleteById, exists, generateId, get, get, gett, gett, insert, insert, insert, notExists, queryForBoolean, queryForByte, queryForBytes, queryForChar, queryForDate, queryForDouble, queryForFloat, queryForInt, queryForLong, queryForShort, queryForSingleNonNull, queryForSingleNonNull, queryForSingleResult, queryForString, queryForTime, queryForTimestamp, queryForUniqueNonNull, queryForUniqueNonNull, queryForUniqueResult, refresh, refresh, update, update, update, update, upsert, upsert, upsert
Methods inherited from interface com.landawn.abacus.jdbc.dao.UncheckedDao
batchSave, batchSave, batchSave, batchSave, batchSave, batchSave, count, delete, exists, findFirst, findFirst, findFirst, findFirst, findFirst, findFirst, findOnlyOne, findOnlyOne, findOnlyOne, findOnlyOne, findOnlyOne, findOnlyOne, foreach, foreach, forEach, forEach, forEach, forEach, forEach, forEach, forEach, forEach, list, list, list, list, list, list, list, list, list, list, list, list, list, notExists, query, query, query, query, query, query, queryForBoolean, queryForByte, queryForBytes, queryForChar, queryForDate, queryForDouble, queryForFloat, queryForInt, queryForLong, queryForShort, queryForSingleNonNull, queryForSingleNonNull, queryForSingleResult, queryForString, queryForTime, queryForTimestamp, queryForUniqueNonNull, queryForUniqueNonNull, queryForUniqueResult, save, save, save, update, update, update, update
-
Method Details
-
queryForBoolean
default com.landawn.abacus.util.u.OptionalBoolean queryForBoolean(String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForBoolean
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Parameters:
singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForChar
default com.landawn.abacus.util.u.OptionalChar queryForChar(String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForChar
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Parameters:
singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForByte
default com.landawn.abacus.util.u.OptionalByte queryForByte(String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForByte
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Parameters:
singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForShort
default com.landawn.abacus.util.u.OptionalShort queryForShort(String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForShort
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Parameters:
singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForInt
default com.landawn.abacus.util.u.OptionalInt queryForInt(String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForInt
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Parameters:
singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForLong
default com.landawn.abacus.util.u.OptionalLong queryForLong(String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForLong
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Parameters:
singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForFloat
default com.landawn.abacus.util.u.OptionalFloat queryForFloat(String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForFloat
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Parameters:
singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForDouble
default com.landawn.abacus.util.u.OptionalDouble queryForDouble(String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForDouble
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Parameters:
singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForString
default com.landawn.abacus.util.u.Nullable<String> queryForString(String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForString
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Parameters:
singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForDate
default com.landawn.abacus.util.u.Nullable<Date> queryForDate(String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForDate
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Parameters:
singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForTime
default com.landawn.abacus.util.u.Nullable<Time> queryForTime(String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForTime
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Parameters:
singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForTimestamp
default com.landawn.abacus.util.u.Nullable<Timestamp> queryForTimestamp(String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForTimestamp
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Parameters:
singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForBytes
default com.landawn.abacus.util.u.Nullable<byte[]> queryForBytes(String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForBytes
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Parameters:
singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForSingleResult
default <V> com.landawn.abacus.util.u.Nullable<V> queryForSingleResult(Class<? extends V> targetValueClass, String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForSingleResult
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Type Parameters:
V
-- Parameters:
targetValueClass
-singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForSingleNonNull
default <V> com.landawn.abacus.util.u.Optional<V> queryForSingleNonNull(Class<? extends V> targetValueClass, String singleSelectPropName, long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForSingleNonNull
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Type Parameters:
V
-- Parameters:
targetValueClass
-singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForSingleNonNull
default <V> com.landawn.abacus.util.u.Optional<V> queryForSingleNonNull(String singleSelectPropName, long id, Jdbc.RowMapper<? extends V> rowMapper) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForSingleNonNull
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Type Parameters:
V
-- Parameters:
singleSelectPropName
-id
-rowMapper
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-
queryForUniqueResult
default <V> com.landawn.abacus.util.u.Nullable<V> queryForUniqueResult(Class<? extends V> targetValueClass, String singleSelectPropName, long id) throws com.landawn.abacus.exception.DuplicatedResultException, com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForUniqueResult
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Type Parameters:
V
-- Parameters:
targetValueClass
-singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.DuplicatedResultException
com.landawn.abacus.exception.UncheckedSQLException
-
queryForUniqueNonNull
default <V> com.landawn.abacus.util.u.Optional<V> queryForUniqueNonNull(Class<? extends V> targetValueClass, String singleSelectPropName, long id) throws com.landawn.abacus.exception.DuplicatedResultException, com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForUniqueNonNull
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Type Parameters:
V
-- Parameters:
targetValueClass
-singleSelectPropName
-id
-- Returns:
- Throws:
com.landawn.abacus.exception.DuplicatedResultException
com.landawn.abacus.exception.UncheckedSQLException
-
queryForUniqueNonNull
default <V> com.landawn.abacus.util.u.Optional<V> queryForUniqueNonNull(String singleSelectPropName, long id, Jdbc.RowMapper<? extends V> rowMapper) throws com.landawn.abacus.exception.DuplicatedResultException, com.landawn.abacus.exception.UncheckedSQLException - Specified by:
queryForUniqueNonNull
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Type Parameters:
V
-- Parameters:
singleSelectPropName
-id
-rowMapper
-- Returns:
- Throws:
com.landawn.abacus.exception.DuplicatedResultException
com.landawn.abacus.exception.UncheckedSQLException
-
get
default com.landawn.abacus.util.u.Optional<T> get(long id) throws com.landawn.abacus.exception.UncheckedSQLException Description copied from interface:CrudDaoL
Returns the record found by the specifiedid
or an emptyOptional
if no record is found. -
get
default com.landawn.abacus.util.u.Optional<T> get(long id, Collection<String> selectPropNames) throws com.landawn.abacus.exception.UncheckedSQLException Description copied from interface:CrudDaoL
Returns the record found by the specifiedid
or an emptyOptional
if no record is found. -
gett
Description copied from interface:CrudDaoL
Returns the record found by the specifiedid
ornull
if no record is found. -
gett
default T gett(long id, Collection<String> selectPropNames) throws com.landawn.abacus.exception.UncheckedSQLException Description copied from interface:CrudDaoL
Returns the record found by the specifiedid
ornull
if no record is found. -
exists
default boolean exists(long id) throws com.landawn.abacus.exception.UncheckedSQLException -
notExists
@Beta default boolean notExists(long id) throws com.landawn.abacus.exception.UncheckedSQLException -
update
-
update
-
deleteById
default int deleteById(long id) throws com.landawn.abacus.exception.UncheckedSQLException - Specified by:
deleteById
in interfaceCrudDaoL<T,
SB extends com.landawn.abacus.util.SQLBuilder, TD extends UncheckedCrudDaoL<T, SB, TD>> - Parameters:
id
-- Returns:
- Throws:
com.landawn.abacus.exception.UncheckedSQLException
-