Package com.landawn.abacus.jdbc.dao

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

Type Parameters:

T -

SB - SQLBuilder used to generate sql scripts. Only can be SQLBuilder.PSC/PAC/PLC

TD -

All Superinterfaces:

CrudDao<T,Long,SB,TD>, Dao<T,SB,TD>

All Known Subinterfaces:

NoUpdateCrudDaoL<T,SB,TD>, ReadOnlyCrudDaoL<T,SB,TD>, UncheckedCrudDaoL<T,SB,TD>, UncheckedNoUpdateCrudDaoL<T,SB,TD>, UncheckedReadOnlyCrudDaoL<T,SB,TD>

@Beta
public interface CrudDaoL<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends CrudDaoL<T,SB,TD>>
extends CrudDao<T,Long,SB,TD>

See Also:

• ConditionFactory
• ConditionFactory.CF

Method Summary

Modifier and Type	Method	Description
default int	deleteById(long id)
default boolean	exists(long id)
default com.landawn.abacus.util.u.Optional<T>	get(long id)
default com.landawn.abacus.util.u.Optional<T>	get(long id, Collection<String> selectPropNames)
default T	gett(long id)
default T	gett(long id, Collection<String> selectPropNames)
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.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<V> targetValueClass, String singleSelectPropName, long id)
default <V> com.landawn.abacus.util.u.Nullable<V>	queryForSingleResult(Class<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<V> targetValueClass, String singleSelectPropName, long id)
default <V> com.landawn.abacus.util.u.Nullable<V>	queryForUniqueResult(Class<V> targetValueClass, String singleSelectPropName, long id)
default int	update(String propName, Object propValue, long id)
default int	update(Map<String,Object> updateProps, long id)

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

batchDelete, batchDelete, batchDeleteByIds, batchDeleteByIds, batchGet, batchGet, batchGet, batchGet, batchInsert, batchInsert, batchInsert, batchInsert, batchInsert, batchInsert, batchRefresh, batchRefresh, batchRefresh, batchRefresh, batchUpdate, batchUpdate, batchUpdate, batchUpdate, batchUpsert, batchUpsert, count, delete, deleteById, exists, generateId, get, get, gett, gett, idExtractor, insert, insert, insert, notExists, queryForBoolean, queryForByte, queryForChar, queryForDate, queryForDouble, queryForFloat, queryForInt, queryForLong, queryForShort, queryForSingleNonNull, queryForSingleResult, queryForString, queryForTime, queryForTimestamp, queryForUniqueNonNull, queryForUniqueResult, refresh, refresh, update, update, update, update, upsert, upsert

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

asyncCall, asyncCall, asyncExecutor, asyncRun, asyncRun, batchSave, batchSave, batchSave, batchSave, batchSave, batchSave, count, dataSource, delete, executor, 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, 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, query, query, query, query, query, query, queryForBoolean, queryForByte, queryForChar, queryForDate, queryForDouble, queryForFloat, queryForInt, queryForLong, queryForShort, queryForSingleNonNull, queryForSingleResult, queryForString, queryForTime, queryForTimestamp, queryForUniqueNonNull, queryForUniqueResult, save, save, save, sqlMapper, stream, stream, stream, stream, stream, stream, stream, stream, stream, stream, stream, stream, stream, targetEntityClass, update, update, update, update

Method Details

queryForBoolean

default com.landawn.abacus.util.u.OptionalBoolean queryForBoolean(String singleSelectPropName,
 long id)
                                                           throws SQLException

Throws:

SQLException

queryForChar

default com.landawn.abacus.util.u.OptionalChar queryForChar(String singleSelectPropName,
 long id)
                                                     throws SQLException

Throws:

SQLException

queryForByte

default com.landawn.abacus.util.u.OptionalByte queryForByte(String singleSelectPropName,
 long id)
                                                     throws SQLException

Throws:

SQLException

queryForShort

default com.landawn.abacus.util.u.OptionalShort queryForShort(String singleSelectPropName,
 long id)
                                                       throws SQLException

Throws:

SQLException

queryForInt

default com.landawn.abacus.util.u.OptionalInt queryForInt(String singleSelectPropName,
 long id)
                                                   throws SQLException

Throws:

SQLException

queryForLong

default com.landawn.abacus.util.u.OptionalLong queryForLong(String singleSelectPropName,
 long id)
                                                     throws SQLException

Throws:

SQLException

queryForFloat

default com.landawn.abacus.util.u.OptionalFloat queryForFloat(String singleSelectPropName,
 long id)
                                                       throws SQLException

Throws:

SQLException

queryForDouble

default com.landawn.abacus.util.u.OptionalDouble queryForDouble(String singleSelectPropName,
 long id)
                                                         throws SQLException

Throws:

SQLException

queryForString

default com.landawn.abacus.util.u.Nullable<String> queryForString(String singleSelectPropName,
 long id)
                                                           throws SQLException

Throws:

SQLException

queryForDate

default com.landawn.abacus.util.u.Nullable<Date> queryForDate(String singleSelectPropName,
 long id)
                                                       throws SQLException

Throws:

SQLException

queryForTime

default com.landawn.abacus.util.u.Nullable<Time> queryForTime(String singleSelectPropName,
 long id)
                                                       throws SQLException

Throws:

SQLException

queryForTimestamp

default com.landawn.abacus.util.u.Nullable<Timestamp> queryForTimestamp(String singleSelectPropName,
 long id)
                                                                 throws SQLException

Throws:

SQLException

queryForSingleResult

default <V> com.landawn.abacus.util.u.Nullable<V> queryForSingleResult(Class<V> targetValueClass,
 String singleSelectPropName,
 long id)
                                                                throws SQLException

Throws:

SQLException

queryForSingleNonNull

default <V> com.landawn.abacus.util.u.Optional<V> queryForSingleNonNull(Class<V> targetValueClass,
 String singleSelectPropName,
 long id)
                                                                 throws SQLException

Throws:

SQLException

queryForUniqueResult

default <V> com.landawn.abacus.util.u.Nullable<V> queryForUniqueResult(Class<V> targetValueClass,
 String singleSelectPropName,
 long id)
                                                                throws com.landawn.abacus.exception.DuplicatedResultException,
SQLException

Throws:

com.landawn.abacus.exception.DuplicatedResultException

SQLException

queryForUniqueNonNull

default <V> com.landawn.abacus.util.u.Optional<V> queryForUniqueNonNull(Class<V> targetValueClass,
 String singleSelectPropName,
 long id)
                                                                 throws com.landawn.abacus.exception.DuplicatedResultException,
SQLException

Throws:

com.landawn.abacus.exception.DuplicatedResultException

SQLException

get

default com.landawn.abacus.util.u.Optional<T> get(long id)
                                           throws SQLException

Throws:

SQLException

get

default com.landawn.abacus.util.u.Optional<T> get(long id,
 Collection<String> selectPropNames)
                                           throws SQLException

Throws:

SQLException

gett

default T gett(long id)
        throws SQLException

Throws:

SQLException

gett

default T gett(long id,
 Collection<String> selectPropNames)
        throws SQLException

Throws:

SQLException

exists

default boolean exists(long id)
                throws SQLException

Throws:

SQLException

notExists

@Beta
default boolean notExists(long id)
                   throws SQLException

Throws:

SQLException

update

default int update(String propName,
 Object propValue,
 long id)
            throws SQLException

Throws:

SQLException

update

default int update(Map<String,Object> updateProps,
 long id)
            throws SQLException

Throws:

SQLException

deleteById

default int deleteById(long id)
                throws SQLException

Throws:

SQLException