Uses of Interface
com.landawn.abacus.jdbc.SQLExecutor.StatementSetter
Packages that use SQLExecutor.StatementSetter
-
Uses of SQLExecutor.StatementSetter in com.landawn.abacus.jdbc
Fields in com.landawn.abacus.jdbc declared as SQLExecutor.StatementSetterModifier and TypeFieldDescriptionstatic final SQLExecutor.StatementSetter
SQLExecutor.StatementSetter.DEFAULT
Methods in com.landawn.abacus.jdbc that return SQLExecutor.StatementSetterModifier and TypeMethodDescriptionstatic SQLExecutor.StatementSetter
SQLExecutor.StatementSetter.create
(com.landawn.abacus.util.Throwables.BiConsumer<NamedQuery, Object[], SQLException> stmtSetter) static SQLExecutor.StatementSetter
SQLExecutor.StatementSetter.create
(com.landawn.abacus.util.Throwables.Consumer<PreparedStatement, SQLException> stmtSetter) Methods in com.landawn.abacus.jdbc with parameters of type SQLExecutor.StatementSetterModifier and TypeMethodDescription<ID> List<ID>
SQLExecutor.batchInsert
(String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.BiRowMapper<ID> autoGeneratedKeyExtractor, JdbcSettings jdbcSettings, List<?> parametersList) <ID> List<ID>
SQLExecutor.batchInsert
(String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, List<?> parametersList) <ID> List<ID>
SQLExecutor.batchInsert
(String sql, SQLExecutor.StatementSetter statementSetter, List<?> parametersList) <ID> List<ID>
SQLExecutor.batchInsert
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.BiRowMapper<ID> autoGeneratedKeyExtractor, JdbcSettings jdbcSettings, List<?> parametersList) <ID> List<ID>
SQLExecutor.batchInsert
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, List<?> parametersList) <ID> List<ID>
SQLExecutor.batchInsert
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, List<?> parametersList) int
SQLExecutor.batchUpdate
(String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, List<?> parametersList) int
SQLExecutor.batchUpdate
(String sql, SQLExecutor.StatementSetter statementSetter, List<?> parametersList) int
SQLExecutor.batchUpdate
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, List<?> parametersList) int
SQLExecutor.batchUpdate
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, List<?> parametersList) final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.findFirst
(Class<T> targetClass, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.findFirst
(Class<T> targetClass, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.findFirst
(Class<T> targetClass, Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) Just fetch the result in the 1st row.final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.findFirst
(Class<T> targetClass, Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.findFirst
(String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.RowMapper<T> rowMapper, JdbcSettings jdbcSettings, Object... parameters) final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.findFirst
(String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.RowMapper<T> rowMapper, Object... parameters) final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.findFirst
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.RowMapper<T> rowMapper, JdbcSettings jdbcSettings, Object... parameters) Remember to addlimit
condition if big result will be returned by the query.final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.findFirst
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.RowMapper<T> rowMapper, Object... parameters) final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.get
(Class<T> targetClass, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.get
(Class<T> targetClass, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.get
(Class<T> targetClass, Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.get
(Class<T> targetClass, Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.get
(String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.RowMapper<T> rowMapper, JdbcSettings jdbcSettings, Object... parameters) final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.get
(String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.RowMapper<T> rowMapper, Object... parameters) final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.get
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.RowMapper<T> rowMapper, JdbcSettings jdbcSettings, Object... parameters) final <T> com.landawn.abacus.util.u.Optional<T>
SQLExecutor.get
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.RowMapper<T> rowMapper, Object... parameters) final <T> T
SQLExecutor.gett
(Class<T> targetClass, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) final <T> T
SQLExecutor.gett
(Class<T> targetClass, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) final <T> T
SQLExecutor.gett
(Class<T> targetClass, Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) final <T> T
SQLExecutor.gett
(Class<T> targetClass, Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) final <T> T
SQLExecutor.gett
(String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.RowMapper<T> rowMapper, JdbcSettings jdbcSettings, Object... parameters) final <T> T
SQLExecutor.gett
(String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.RowMapper<T> rowMapper, Object... parameters) final <T> T
SQLExecutor.gett
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.RowMapper<T> rowMapper, JdbcSettings jdbcSettings, Object... parameters) final <T> T
SQLExecutor.gett
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.RowMapper<T> rowMapper, Object... parameters) final <ID> ID
SQLExecutor.insert
(String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.BiRowMapper<ID> autoGeneratedKeyExtractor, JdbcSettings jdbcSettings, Object... parameters) final <ID> ID
SQLExecutor.insert
(String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) final <ID> ID
SQLExecutor.insert
(String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) final <ID> ID
SQLExecutor.insert
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.BiRowMapper<ID> autoGeneratedKeyExtractor, JdbcSettings jdbcSettings, Object... parameters) final <ID> ID
SQLExecutor.insert
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) final <ID> ID
SQLExecutor.insert
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) final <T> List<T>
SQLExecutor.list
(Class<T> targetClass, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) final <T> List<T>
SQLExecutor.list
(Class<T> targetClass, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) final <T> List<T>
SQLExecutor.list
(Class<T> targetClass, Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) final <T> List<T>
SQLExecutor.list
(Class<T> targetClass, Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) final <T> List<T>
SQLExecutor.list
(String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.BiRowMapper<T> rowMapper, JdbcSettings jdbcSettings, Object... parameters) final <T> List<T>
SQLExecutor.list
(String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.BiRowMapper<T> rowMapper, Object... parameters) final <T> List<T>
SQLExecutor.list
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.BiRowMapper<T> rowMapper, JdbcSettings jdbcSettings, Object... parameters) final <T> List<T>
SQLExecutor.list
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.BiRowMapper<T> rowMapper, Object... parameters) final <T> List<T>
SQLExecutor.listAll
(Class<T> targetClass, List<String> sqls, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) Execute the query in one or more data sources specified byjdbcSettings
and merge the results.final <T> List<T>
SQLExecutor.listAll
(List<String> sqls, SQLExecutor.StatementSetter statementSetter, Jdbc.BiRowMapper<T> rowMapper, JdbcSettings jdbcSettings, Object... parameters) Execute one or more queries in one or more data sources specified byjdbcSettings
and merge the results.final <T> T
SQLExecutor.query
(String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.ResultExtractor<T> resultExtractor, JdbcSettings jdbcSettings, Object... parameters) Remember to close theResultSet
,Statement
andConnection
if the return typeT
isResultSet
orRowIterator
.final <T> T
SQLExecutor.query
(String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.ResultExtractor<T> resultExtractor, Object... parameters) final com.landawn.abacus.util.DataSet
SQLExecutor.query
(String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) final com.landawn.abacus.util.DataSet
SQLExecutor.query
(String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) final <T> T
SQLExecutor.query
(Connection inputConn, String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.ResultExtractor<T> resultExtractor, JdbcSettings jdbcSettings, Object... parameters) Remember to close theResultSet
,Statement
andConnection
if the return typeT
isResultSet
orRowIterator
.final <T> T
SQLExecutor.query
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.ResultExtractor<T> resultExtractor, Object... parameters) final com.landawn.abacus.util.DataSet
SQLExecutor.query
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) final com.landawn.abacus.util.DataSet
SQLExecutor.query
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) final com.landawn.abacus.util.DataSet
SQLExecutor.queryAll
(List<String> sqls, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) Execute one or more queries in one or more data sources specified byjdbcSettings
and merge the results.final <V> com.landawn.abacus.util.u.Nullable<V>
SQLExecutor.queryForSingleResult
(Class<V> targetClass, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) Query for single result.final <V> com.landawn.abacus.util.u.Nullable<V>
SQLExecutor.queryForSingleResult
(Class<V> targetClass, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) Query for single result.final <V> com.landawn.abacus.util.u.Nullable<V>
SQLExecutor.queryForSingleResult
(Class<V> targetClass, Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) Returns aNullable
describing the value in the first row/column if it exists, otherwise return an emptyNullable
.final <V> com.landawn.abacus.util.u.Nullable<V>
SQLExecutor.queryForSingleResult
(Class<V> targetClass, Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) Query for single result.final <V> com.landawn.abacus.util.u.Nullable<V>
SQLExecutor.queryForUniqueResult
(Class<V> targetClass, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) Query for unique result.final <V> com.landawn.abacus.util.u.Nullable<V>
SQLExecutor.queryForUniqueResult
(Class<V> targetClass, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) Query for unique result.final <V> com.landawn.abacus.util.u.Nullable<V>
SQLExecutor.queryForUniqueResult
(Class<V> targetClass, Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) Returns aNullable
describing the value in the first row/column if it exists, otherwise return an emptyNullable
.final <V> com.landawn.abacus.util.u.Nullable<V>
SQLExecutor.queryForUniqueResult
(Class<V> targetClass, Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) Query for unique result.final <T> com.landawn.abacus.util.stream.Stream<T>
SQLExecutor.stream
(Class<T> targetClass, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) Lazy execution, lazy fetching.final <T> com.landawn.abacus.util.stream.Stream<T>
SQLExecutor.stream
(Class<T> targetClass, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) Lazy execution, lazy fetching.final <T> com.landawn.abacus.util.stream.Stream<T>
SQLExecutor.stream
(String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.BiRowMapper<T> rowMapper, JdbcSettings jdbcSettings, Object... parameters) Lazy execution, lazy fetching.final <T> com.landawn.abacus.util.stream.Stream<T>
SQLExecutor.stream
(String sql, SQLExecutor.StatementSetter statementSetter, Jdbc.BiRowMapper<T> rowMapper, Object... parameters) Lazy execution, lazy fetching.final <T> com.landawn.abacus.util.stream.Stream<T>
SQLExecutor.streamAll
(Class<T> targetClass, List<String> sqls, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) Lazy execution, lazy fetching.final <T> com.landawn.abacus.util.stream.Stream<T>
SQLExecutor.streamAll
(List<String> sqls, SQLExecutor.StatementSetter statementSetter, Jdbc.BiRowMapper<T> rowMapper, JdbcSettings jdbcSettings, Object... parameters) Lazy execution, lazy fetching.final int
SQLExecutor.update
(String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) final int
SQLExecutor.update
(String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters) final int
SQLExecutor.update
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, JdbcSettings jdbcSettings, Object... parameters) final int
SQLExecutor.update
(Connection conn, String sql, SQLExecutor.StatementSetter statementSetter, Object... parameters)