All Classes and Interfaces
Class
Description
Performance Tips:
Avoid unnecessary/repeated database calls.
Only fetch the columns you need or update the columns you want.
Index is the key point in a lot of database performance issues.
The backed
The backed
PreparedStatement/CallableStatement
will be closed by default
after any execution methods(which will trigger the backed PreparedStatement/CallableStatement
to be executed, for example: get/query/queryForInt/Long/../findFirst/findOnlyOne/list/execute/...).The Interface Bind.
The Interface BindList.
Mostly, it's used for static tables.
The Interface Call.
The backed
PreparedStatement/CallableStatement
will be closed by default
after any execution methods(which will trigger the backed PreparedStatement/CallableStatement
to be executed, for example: get/query/queryForInt/Long/../findFirst/findOnlyOne/list/execute/...).The Interface CrudDao.
CrudJoinEntityHelper<T,ID,SB extends com.landawn.abacus.util.SQLBuilder,TD extends CrudDao<T,ID,SB,TD>>
Performance Tips:
Avoid unnecessary/repeated database calls.
Only fetch the columns you need or update the columns you want.
Index is the key point in a lot of database performance issues.
This interface is designed to share/manager SQL queries by Java APIs/methods with static parameter types and return type, while hiding the SQL scripts.
This interface is designed to share/manager SQL queries by Java APIs/methods with static parameter types and return type, while hiding the SQL scripts.
Supports global lock by db table.
Supports global sequence by db table.
Replace the parts defined with format
{part}
in the sql annotated to the method.Defines a named attribute as a comma-separated
String
from the elements of the annotated array or Collection
argument.The Interface Delete.
The Enum FetchDirection.
The Interface Insert.
The Enum IsolationLevel.
The Interface BiParametersSetter.
The Interface BiResultExtractor.
The Interface BiRowConsumer.
Generally, the result should be filtered in database side by SQL scripts.
The Interface BiRowMapper.
The Interface ParametersSetter.
The Interface ResultExtractor.
Don't use
RowConsumer
in AbstractQuery.forEach(RowConsumer)
or any place where multiple records will be consumed by it, if column labels/count are used in Jdbc.RowConsumer.accept(ResultSet)
.Generally, the result should be filtered in database side by SQL scripts.
Don't use
RowMapper
in AbstractQuery.list(RowMapper)
or any place where multiple records will be retrieved by it, if column labels/count are used in Jdbc.RowMapper.apply(ResultSet)
.The Interface TriParametersSetter.
Performance Tips:
Avoid unnecessary/repeated database calls.
Only fetch the columns you need or update the columns you want.
Index is the key point in a lot of database performance issues.
The result will be merged by
keyName
and mapped to map
.For example:
The backed
PreparedStatement/CallableStatement
will be closed by default
after any execution methods(which will trigger the backed PreparedStatement/CallableStatement
to be executed, for example: get/query/queryForInt/Long/../findFirst/findOnlyOne/list/execute/...).Annotated methods in
By default,
Dao
for:
No Handler
is applied to non-db Operation
No sql/performance
log is applied to non-db Operation
No Transaction
annotation is applied to non-db Operation
By default,
targetEntityClass/dataSource/sqlMapper/executor/asyncExecutor/prepareQuery/prepareNamedQuery/prepareCallableQuery
methods in Dao
are annotated with NonDBOperation
.NoUpdateCrudDao<T,ID,SB extends com.landawn.abacus.util.SQLBuilder,TD extends NoUpdateCrudDao<T,ID,SB,TD>>
TODO
NoUpdateCrudDaoL<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends NoUpdateCrudDaoL<T,SB,TD>>
TODO
Deprecated.
won't be implemented.
Deprecated.
won't & should not be implemented.
The backed
PreparedStatement/CallableStatement
will be closed by default
after any execution methods(which will trigger the backed PreparedStatement/CallableStatement
to be executed, for example: get/query/queryForInt/Long/../findFirst/findOnlyOne/list/execute/...).ReadOnlyCrudDao<T,ID,SB extends com.landawn.abacus.util.SQLBuilder,TD extends ReadOnlyCrudDao<T,ID,SB,TD>>
TODO
ReadOnlyCrudDaoL<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends ReadOnlyCrudDaoL<T,SB,TD>>
ReadOnlyCrudJoinEntityHelper<T,ID,SB extends com.landawn.abacus.util.SQLBuilder,TD extends CrudDao<T,ID,SB,TD>>
ReadOnlyCrudJoinEntityHelperL<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends CrudDaoL<T,SB,TD>>
TODO
The Interface Select.
SQLExecutor is a simple sql/jdbc utility class.
It's only for methods with default implementation in
Dao
interfaces.DO NOT CLOSE the connection manually.
The Enum Action.
The Enum Status.
It's for transaction started in
Dao
methods.UncheckedCrudDao<T,ID,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedCrudDao<T,ID,SB,TD>>
The Interface CrudDao.
UncheckedCrudDaoL<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedCrudDaoL<T,SB,TD>>
UncheckedCrudJoinEntityHelper<T,ID,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedCrudDao<T,ID,SB,TD>>
UncheckedCrudJoinEntityHelperL<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedCrudDaoL<T,SB,TD>>
UncheckedJoinEntityHelper<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
UncheckedNoUpdateCrudDao<T,ID,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedNoUpdateCrudDao<T,ID,SB,TD>>
TODO
UncheckedNoUpdateCrudDaoL<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedNoUpdateCrudDaoL<T,SB,TD>>
UncheckedNoUpdateDao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedNoUpdateDao<T,SB,TD>>
TODO
UncheckedReadOnlyCrudDao<T,ID,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedReadOnlyCrudDao<T,ID,SB,TD>>
TODO
UncheckedReadOnlyCrudDaoL<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedReadOnlyCrudDaoL<T,SB,TD>>
UncheckedReadOnlyCrudJoinEntityHelper<T,ID,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedCrudDao<T,ID,SB,TD>>
UncheckedReadOnlyCrudJoinEntityHelperL<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedCrudDaoL<T,SB,TD>>
UncheckedReadOnlyDao<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedReadOnlyDao<T,SB,TD>>
TODO
UncheckedReadOnlyJoinEntityHelper<T,SB extends com.landawn.abacus.util.SQLBuilder,TD extends UncheckedDao<T,SB,TD>>
The Interface Update.