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/CallableStatementwill be closed by default after any execution methods(which will trigger the backedPreparedStatement/CallableStatementto be executed, for example: get/query/queryForInt/Long/../findFirst/findOnlyOne/list/execute/...).The backedPreparedStatement/CallableStatementwill be closed by default after any execution methods(which will trigger the backedPreparedStatement/CallableStatementto 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 useRowConsumerinAbstractQuery.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 useRowMapperinAbstractQuery.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/CallableStatementwill be closed by default after any execution methods(which will trigger the backedPreparedStatement/CallableStatementto be executed, for example: get/query/queryForInt/Long/../findFirst/findOnlyOne/list/execute/...).Deprecated.won't and should not be implemented.The backedPreparedStatement/CallableStatementwill be closed by default after any execution methods(which will trigger the backedPreparedStatement/CallableStatementto 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.