Package com.landawn.abacus.jdbc
package com.landawn.abacus.jdbc
-
ClassDescriptionPerformance 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 backedPreparedStatement/CallableStatement
will be closed by default after any execution methods(which will trigger the backedPreparedStatement/CallableStatement
to be executed, for example: get/query/queryForInt/Long/../findFirst/findOnlyOne/list/execute/...).Supports global lock by db table.Supports global sequence by db table.A sample, just a sample, not a general configuration required.The Enum FetchDirection.The Enum IsolationLevel.Jdbc.BiParametersSetter<QS,T> The Interface BiParametersSetter.The Interface BiResultExtractor.The Interface BiRowConsumer.Generally, the result should be filtered in database side by SQL scripts.The Interface BiRowMapper.Jdbc.Handler<P>The Interface ParametersSetter.The Interface ResultExtractor.Don't useRowConsumer
inAbstractPreparedQuery.forEach(RowConsumer)
or any place where multiple records will be consumed by it, if column labels/count are used inJdbc.RowConsumer.accept(ResultSet)
.Generally, the result should be filtered in database side by SQL scripts.Don't useRowMapper
inAbstractPreparedQuery.list(RowMapper)
or any place where multiple records will be retrieved by it, if column labels/count are used inJdbc.RowMapper.apply(ResultSet)
.Jdbc.TriParametersSetter<QS,T> 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 backedPreparedStatement/CallableStatement
will be closed by default after any execution methods(which will trigger the backedPreparedStatement/CallableStatement
to be executed, for example: get/query/queryForInt/Long/../findFirst/findOnlyOne/list/execute/...).The backedPreparedStatement/CallableStatement
will be closed by default after any execution methods(which will trigger the backedPreparedStatement/CallableStatement
to be executed, for example: get/query/queryForInt/Long/../findFirst/findOnlyOne/list/execute/...).The backedPreparedStatement/CallableStatement
will be closed by default after any execution methods(which will trigger the backedPreparedStatement/CallableStatement
to be executed, for example: get/query/queryForInt/Long/../findFirst/findOnlyOne/list/execute/...).SQLExecutor is a simple sql/jdbc utility class.DO NOT CLOSE the connection manually.The Enum Action.The Enum Status.