JdbcUtil.PreparedCallableQuery (abacus API Documentation)

java.lang.Object
- com.landawn.abacus.util.JdbcUtil.PreparedCallableQuery

All Implemented Interfaces:

java.lang.AutoCloseable

Enclosing class:

JdbcUtil
```
public static class JdbcUtil.PreparedCallableQuery
extends java.lang.Object
```
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/list/execute/...). except the 'closeAfterExecution' flag is set to false by calling #closeAfterExecution(false).
Generally, don't cache or reuse the instance of this class, except the 'closeAfterExecution' flag is set to false by calling #closeAfterExecution(false).
The ResultSet returned by query will always be closed after execution, even 'closeAfterExecution' flag is set to false.
Remember: parameter/column index in PreparedStatement/ResultSet starts from 1, not 0.

Author:

haiyangl

See Also:

com.landawn.abacus.annotation.ReadOnly}, com.landawn.abacus.annotation.ReadOnlyId}, com.landawn.abacus.annotation.NonUpdatable}, com.landawn.abacus.annotation.Transient}, com.landawn.abacus.annotation.Table}, com.landawn.abacus.annotation.Column}, http://docs.oracle.com/javase/8/docs/api/java/sql/Connection.html, http://docs.oracle.com/javase/8/docs/api/java/sql/Statement.html, http://docs.oracle.com/javase/8/docs/api/java/sql/PreparedStatement.html, http://docs.oracle.com/javase/8/docs/api/java/sql/ResultSet.html

Method Summary

All Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`Q`	`addBatch()`
`boolean`	`allMatch(JdbcUtil.BiRowFilter recordFilter)`
`boolean`	`allMatch(JdbcUtil.RowFilter recordFilter)`
`boolean`	`anyMatch(JdbcUtil.BiRowFilter recordFilter)`
`boolean`	`anyMatch(JdbcUtil.RowFilter recordFilter)`
`ContinuableFuture<java.lang.Void>`	`asyncAccept(Try.Consumer<Q,java.sql.SQLException> action)` Deprecated. `asyncExecutor.call(() -> JdbcUtil.prepareQuery(query)...query/update/execute(...)` is recommended.
`ContinuableFuture<java.lang.Void>`	`asyncAccept(Try.Consumer<Q,java.sql.SQLException> action, java.util.concurrent.Executor executor)` Deprecated. `asyncExecutor.call(() -> JdbcUtil.prepareQuery(query)...query/update/execute(...)` is recommended.
`<R> ContinuableFuture<R>`	`asyncApply(Try.Function<Q,R,java.sql.SQLException> func)` Deprecated. `asyncExecutor.call(() -> JdbcUtil.prepareQuery(query)...query/update/execute(...)` is recommended.
`<R> ContinuableFuture<R>`	`asyncApply(Try.Function<Q,R,java.sql.SQLException> func, java.util.concurrent.Executor executor)` Deprecated. `asyncExecutor.call(() -> JdbcUtil.prepareQuery(query)...query/update/execute(...)` is recommended.
`<ID> java.util.List<ID>`	`batchInsert()` Returns the generated key if it exists.
`<T,ID> java.util.List<ID>`	`batchInsert(java.util.Collection<T> batchParameters, JdbcUtil.BiParametersSetter<? super Q,? super T> parametersSetter)` All will be done in one batch.
`<T,ID> java.util.List<ID>`	`batchInsert(java.util.Iterator<T> batchParameters, JdbcUtil.BiParametersSetter<? super Q,? super T> parametersSetter)` All will be done in one batch.
`<ID> java.util.List<ID>`	`batchInsert(JdbcUtil.BiRowMapper<ID> autoGeneratedKeyExtractor)`
`<ID> java.util.List<ID>`	`batchInsert(JdbcUtil.RowMapper<ID> autoGeneratedKeyExtractor)`
`int[]`	`batchUpdate()`
`<T> int`	`batchUpdate(java.util.Collection<T> batchParameters, JdbcUtil.BiParametersSetter<? super Q,? super T> parametersSetter)` All will be done in one batch.
`<T> int`	`batchUpdate(java.util.Iterator<T> batchParameters, JdbcUtil.BiParametersSetter<? super Q,? super T> parametersSetter)` All will be done in one batch.
`<R1> u.Optional<R1>`	`call(JdbcUtil.ResultExtractor<R1> resultExtrator1)`
`<R1,R2> Tuple.Tuple2<u.Optional<R1>,u.Optional<R2>>`	`call(JdbcUtil.ResultExtractor<R1> resultExtrator1, JdbcUtil.ResultExtractor<R2> resultExtrator2)`
`<R1,R2,R3> Tuple.Tuple3<u.Optional<R1>,u.Optional<R2>,u.Optional<R3>>`	`call(JdbcUtil.ResultExtractor<R1> resultExtrator1, JdbcUtil.ResultExtractor<R2> resultExtrator2, JdbcUtil.ResultExtractor<R3> resultExtrator3)`
`<R1,R2,R3,R4> Tuple.Tuple4<u.Optional<R1>,u.Optional<R2>,u.Optional<R3>,u.Optional<R4>>`	`call(JdbcUtil.ResultExtractor<R1> resultExtrator1, JdbcUtil.ResultExtractor<R2> resultExtrator2, JdbcUtil.ResultExtractor<R3> resultExtrator3, JdbcUtil.ResultExtractor<R4> resultExtrator4)`
`<R1,R2,R3,R4,R5> Tuple.Tuple5<u.Optional<R1>,u.Optional<R2>,u.Optional<R3>,u.Optional<R4>,u.Optional<R5>>`	`call(JdbcUtil.ResultExtractor<R1> resultExtrator1, JdbcUtil.ResultExtractor<R2> resultExtrator2, JdbcUtil.ResultExtractor<R3> resultExtrator3, JdbcUtil.ResultExtractor<R4> resultExtrator4, JdbcUtil.ResultExtractor<R5> resultExtrator5)`
`void`	`close()`
`boolean`	`closeAfterExecution()`
`Q`	`closeAfterExecution(boolean closeAfterExecution)`
`int`	`count()` Deprecated. may be misused and it's inefficient.
`int`	`count(JdbcUtil.BiRowFilter recordFilter)`
`int`	`count(JdbcUtil.RowFilter recordFilter)`
`boolean`	`execute()`
`void`	`executeThenAccept(Try.BiConsumer<java.lang.Boolean,? super S,java.sql.SQLException> consumer)`
`void`	`executeThenAccept(Try.Consumer<? super S,java.sql.SQLException> consumer)`
`<R> R`	`executeThenApply(Try.BiFunction<java.lang.Boolean,? super S,? extends R,java.sql.SQLException> getter)`
`<R> R`	`executeThenApply(Try.Function<? super S,? extends R,java.sql.SQLException> getter)`
`boolean`	`exists()` Note: using `select 1 from ...`, not `select count(*) from ...`.
`<T> u.Optional<T>`	`findFirst(java.lang.Class<T> targetClass)`
`<T> u.Optional<T>`	`findFirst(JdbcUtil.BiRowFilter recordFilter, JdbcUtil.BiRowMapper<T> rowMapper)`
`<T> u.Optional<T>`	`findFirst(JdbcUtil.BiRowMapper<T> rowMapper)`
`<T> u.Optional<T>`	`findFirst(JdbcUtil.RowFilter recordFilter, JdbcUtil.RowMapper<T> rowMapper)`
`<T> u.Optional<T>`	`findFirst(JdbcUtil.RowMapper<T> rowMapper)`
`void`	`forEach(JdbcUtil.BiRowConsumer rowConsumer)`
`void`	`forEach(JdbcUtil.BiRowFilter recordFilter, JdbcUtil.BiRowConsumer rowConsumer)`
`void`	`forEach(JdbcUtil.RowConsumer rowConsumer)`
`void`	`forEach(JdbcUtil.RowFilter recordFilter, JdbcUtil.RowConsumer rowConsumer)`
`<T> u.Optional<T>`	`get(java.lang.Class<T> targetClass)`
`<T> u.Optional<T>`	`get(JdbcUtil.BiRowMapper<T> rowMapper)`
`<T> u.Optional<T>`	`get(JdbcUtil.RowMapper<T> rowMapper)`
`<T> T`	`gett(java.lang.Class<T> targetClass)`
`<T> T`	`gett(JdbcUtil.BiRowMapper<T> rowMapper)`
`<T> T`	`gett(JdbcUtil.RowMapper<T> rowMapper)`
`void`	`ifExists(JdbcUtil.BiRowConsumer rowConsumer)`
`void`	`ifExists(JdbcUtil.RowConsumer rowConsumer)`
`void`	`ifExistsOrElse(JdbcUtil.BiRowConsumer rowConsumer, Try.Runnable<java.sql.SQLException> orElseAction)`
`void`	`ifExistsOrElse(JdbcUtil.RowConsumer rowConsumer, Try.Runnable<java.sql.SQLException> orElseAction)`
`<ID> u.Optional<ID>`	`insert()` Returns the generated key if it exists.
`<ID> u.Optional<ID>`	`insert(JdbcUtil.BiRowMapper<ID> autoGeneratedKeyExtractor)`
`<ID> u.Optional<ID>`	`insert(JdbcUtil.RowMapper<ID> autoGeneratedKeyExtractor)`
`long[]`	`largeBatchUpdate()`
`long`	`largeUpate()`
`<T> java.util.List<T>`	`list(java.lang.Class<T> targetClass)`
`<T> java.util.List<T>`	`list(java.lang.Class<T> targetClass, int maxResult)`
`<T> java.util.List<T>`	`list(JdbcUtil.BiRowFilter recordFilter, JdbcUtil.BiRowMapper<T> rowMapper)`
`<T> java.util.List<T>`	`list(JdbcUtil.BiRowFilter recordFilter, JdbcUtil.BiRowMapper<T> rowMapper, int maxResult)`
`<T> java.util.List<T>`	`list(JdbcUtil.BiRowMapper<T> rowMapper)`
`<T> java.util.List<T>`	`list(JdbcUtil.BiRowMapper<T> rowMapper, int maxResult)`
`<T> java.util.List<T>`	`list(JdbcUtil.RowFilter recordFilter, JdbcUtil.RowMapper<T> rowMapper)`
`<T> java.util.List<T>`	`list(JdbcUtil.RowFilter recordFilter, JdbcUtil.RowMapper<T> rowMapper, int maxResult)`
`<T> java.util.List<T>`	`list(JdbcUtil.RowMapper<T> rowMapper)`
`<T> java.util.List<T>`	`list(JdbcUtil.RowMapper<T> rowMapper, int maxResult)`
`boolean`	`noneMatch(JdbcUtil.BiRowFilter recordFilter)`
`boolean`	`noneMatch(JdbcUtil.RowFilter recordFilter)`
`Q`	`onClose(java.lang.Runnable closeHandler)`
`DataSet`	`query()`
`<R> R`	`query(JdbcUtil.BiResultExtractor<R> resultExtrator)`
`<R> R`	`query(JdbcUtil.ResultExtractor<R> resultExtrator)`
`u.Nullable<java.math.BigDecimal>`	`queryBigDecimal()`
`u.OptionalBoolean`	`queryForBoolean()`
`u.OptionalByte`	`queryForByte()`
`u.OptionalChar`	`queryForChar()`
`u.Nullable<java.sql.Date>`	`queryForDate()`
`u.OptionalDouble`	`queryForDouble()`
`u.OptionalFloat`	`queryForFloat()`
`u.OptionalInt`	`queryForInt()`
`u.OptionalLong`	`queryForLong()`
`u.OptionalShort`	`queryForShort()`
`<V> u.Optional<V>`	`queryForSingleNonNull(java.lang.Class<V> targetClass)` Returns an `Optional` describing the value in the first row/column if it exists, otherwise return an empty `Optional`.
`<V> u.Nullable<V>`	`queryForSingleResult(java.lang.Class<V> targetClass)` Returns a `Nullable` describing the value in the first row/column if it exists, otherwise return an empty `Nullable`.
`u.Nullable<java.lang.String>`	`queryForString()`
`u.Nullable<java.sql.Time>`	`queryForTime()`
`u.Nullable<java.sql.Timestamp>`	`queryForTimestamp()`
`<V> u.Optional<V>`	`queryForUniqueNonNull(java.lang.Class<V> targetClass)` Returns an `Optional` describing the value in the first row/column if it exists, otherwise return an empty `Optional`.
`<V> u.Nullable<V>`	`queryForUniqueResult(java.lang.Class<V> targetClass)` Returns a `Nullable` describing the value in the first row/column if it exists, otherwise return an empty `Nullable`.
`JdbcUtil.PreparedCallableQuery`	`registerOutParameter(int parameterIndex, int sqlType)`
`JdbcUtil.PreparedCallableQuery`	`registerOutParameter(int parameterIndex, int sqlType, int scale)`
`JdbcUtil.PreparedCallableQuery`	`registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName)`
`JdbcUtil.PreparedCallableQuery`	`registerOutParameter(int parameterIndex, java.sql.SQLType sqlType)`
`JdbcUtil.PreparedCallableQuery`	`registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, int scale)`
`JdbcUtil.PreparedCallableQuery`	`registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, java.lang.String typeName)`
`JdbcUtil.PreparedCallableQuery`	`registerOutParameter(java.lang.String parameterName, int sqlType)`
`JdbcUtil.PreparedCallableQuery`	`registerOutParameter(java.lang.String parameterName, int sqlType, int scale)`
`JdbcUtil.PreparedCallableQuery`	`registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName)`
`JdbcUtil.PreparedCallableQuery`	`registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType)`
`JdbcUtil.PreparedCallableQuery`	`registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, int scale)`
`JdbcUtil.PreparedCallableQuery`	`registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, java.lang.String typeName)`
`JdbcUtil.PreparedCallableQuery`	`registerOutParameters(JdbcUtil.ParametersSetter<? super java.sql.CallableStatement> register)`
`<T> JdbcUtil.PreparedCallableQuery`	`registerOutParameters(T parameter, JdbcUtil.BiParametersSetter<? super T,? super java.sql.CallableStatement> register)`
`Q`	`setArray(int parameterIndex, java.sql.Array x)`
`Q`	`setAsciiStream(int parameterIndex, java.io.InputStream inputStream)`
`Q`	`setAsciiStream(int parameterIndex, java.io.InputStream inputStream, long length)`
`JdbcUtil.PreparedCallableQuery`	`setAsciiStream(java.lang.String parameterName, java.io.InputStream inputStream)`
`JdbcUtil.PreparedCallableQuery`	`setAsciiStream(java.lang.String parameterName, java.io.InputStream inputStream, long length)`
`Q`	`setBigDecimal(int parameterIndex, java.math.BigDecimal x)`
`JdbcUtil.PreparedCallableQuery`	`setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x)`
`Q`	`setBinaryStream(int parameterIndex, java.io.InputStream inputStream)`
`Q`	`setBinaryStream(int parameterIndex, java.io.InputStream inputStream, long length)`
`JdbcUtil.PreparedCallableQuery`	`setBinaryStream(java.lang.String parameterName, java.io.InputStream inputStream)`
`JdbcUtil.PreparedCallableQuery`	`setBinaryStream(java.lang.String parameterName, java.io.InputStream inputStream, long length)`
`Q`	`setBlob(int parameterIndex, java.sql.Blob x)`
`Q`	`setBlob(int parameterIndex, java.io.InputStream inputStream)`
`Q`	`setBlob(int parameterIndex, java.io.InputStream inputStream, long length)`
`JdbcUtil.PreparedCallableQuery`	`setBlob(java.lang.String parameterName, java.sql.Blob x)`
`JdbcUtil.PreparedCallableQuery`	`setBlob(java.lang.String parameterName, java.io.InputStream inputStream)`
`JdbcUtil.PreparedCallableQuery`	`setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length)`
`Q`	`setBoolean(int parameterIndex, boolean x)`
`Q`	`setBoolean(int parameterIndex, java.lang.Boolean x)`
`JdbcUtil.PreparedCallableQuery`	`setBoolean(java.lang.String parameterName, boolean x)`
`JdbcUtil.PreparedCallableQuery`	`setBoolean(java.lang.String parameterName, java.lang.Boolean x)`
`Q`	`setByte(int parameterIndex, byte x)`
`Q`	`setByte(int parameterIndex, java.lang.Byte x)`
`JdbcUtil.PreparedCallableQuery`	`setByte(java.lang.String parameterName, byte x)`
`JdbcUtil.PreparedCallableQuery`	`setByte(java.lang.String parameterName, java.lang.Byte x)`
`Q`	`setBytes(int parameterIndex, byte[] x)`
`JdbcUtil.PreparedCallableQuery`	`setBytes(java.lang.String parameterName, byte[] x)`
`Q`	`setCharacterStream(int parameterIndex, java.io.Reader reader)`
`Q`	`setCharacterStream(int parameterIndex, java.io.Reader reader, long length)`
`JdbcUtil.PreparedCallableQuery`	`setCharacterStream(java.lang.String parameterName, java.io.Reader reader)`
`JdbcUtil.PreparedCallableQuery`	`setCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length)`
`Q`	`setClob(int parameterIndex, java.sql.Clob x)`
`Q`	`setClob(int parameterIndex, java.io.Reader reader)`
`Q`	`setClob(int parameterIndex, java.io.Reader reader, long length)`
`JdbcUtil.PreparedCallableQuery`	`setClob(java.lang.String parameterName, java.sql.Clob x)`
`JdbcUtil.PreparedCallableQuery`	`setClob(java.lang.String parameterName, java.io.Reader reader)`
`JdbcUtil.PreparedCallableQuery`	`setClob(java.lang.String parameterName, java.io.Reader reader, long length)`
`Q`	`setDate(int parameterIndex, java.sql.Date x)`
`Q`	`setDate(int parameterIndex, java.util.Date x)`
`JdbcUtil.PreparedCallableQuery`	`setDate(java.lang.String parameterName, java.sql.Date x)`
`JdbcUtil.PreparedCallableQuery`	`setDate(java.lang.String parameterName, java.util.Date x)`
`Q`	`setDouble(int parameterIndex, double x)`
`Q`	`setDouble(int parameterIndex, java.lang.Double x)`
`JdbcUtil.PreparedCallableQuery`	`setDouble(java.lang.String parameterName, double x)`
`JdbcUtil.PreparedCallableQuery`	`setDouble(java.lang.String parameterName, java.lang.Double x)`
`Q`	`setFetchDirection(JdbcUtil.FetchDirection direction)`
`Q`	`setFetchSize(int rows)`
`Q`	`setFloat(int parameterIndex, float x)`
`Q`	`setFloat(int parameterIndex, java.lang.Float x)`
`JdbcUtil.PreparedCallableQuery`	`setFloat(java.lang.String parameterName, float x)`
`JdbcUtil.PreparedCallableQuery`	`setFloat(java.lang.String parameterName, java.lang.Float x)`
`Q`	`setInt(int parameterIndex, int x)`
`Q`	`setInt(int parameterIndex, java.lang.Integer x)`
`JdbcUtil.PreparedCallableQuery`	`setInt(java.lang.String parameterName, int x)`
`JdbcUtil.PreparedCallableQuery`	`setInt(java.lang.String parameterName, java.lang.Integer x)`
`Q`	`setLargeMaxRows(long max)`
`Q`	`setLong(int parameterIndex, long x)`
`Q`	`setLong(int parameterIndex, java.lang.Long x)`
`JdbcUtil.PreparedCallableQuery`	`setLong(java.lang.String parameterName, long x)`
`JdbcUtil.PreparedCallableQuery`	`setLong(java.lang.String parameterName, java.lang.Long x)`
`Q`	`setMaxFieldSize(int max)`
`Q`	`setMaxRows(int max)`
`Q`	`setNCharacterStream(int parameterIndex, java.io.Reader reader)`
`Q`	`setNCharacterStream(int parameterIndex, java.io.Reader reader, long length)`
`JdbcUtil.PreparedCallableQuery`	`setNCharacterStream(java.lang.String parameterName, java.io.Reader reader)`
`JdbcUtil.PreparedCallableQuery`	`setNCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length)`
`Q`	`setNClob(int parameterIndex, java.sql.NClob x)`
`Q`	`setNClob(int parameterIndex, java.io.Reader reader)`
`Q`	`setNClob(int parameterIndex, java.io.Reader reader, long length)`
`JdbcUtil.PreparedCallableQuery`	`setNClob(java.lang.String parameterName, java.sql.NClob x)`
`JdbcUtil.PreparedCallableQuery`	`setNClob(java.lang.String parameterName, java.io.Reader reader)`
`JdbcUtil.PreparedCallableQuery`	`setNClob(java.lang.String parameterName, java.io.Reader reader, long length)`
`Q`	`setNull(int parameterIndex, int sqlType)`
`Q`	`setNull(int parameterIndex, int sqlType, java.lang.String typeName)`
`JdbcUtil.PreparedCallableQuery`	`setNull(java.lang.String parameterName, int sqlType)`
`JdbcUtil.PreparedCallableQuery`	`setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName)`
`Q`	`setObject(int parameterIndex, java.lang.Object x)`
`Q`	`setObject(int parameterIndex, java.lang.Object x, int sqlType)`
`Q`	`setObject(int parameterIndex, java.lang.Object x, int sqlType, int scaleOrLength)`
`Q`	`setObject(int parameterIndex, java.lang.Object x, java.sql.SQLType sqlType)`
`Q`	`setObject(int parameterIndex, java.lang.Object x, java.sql.SQLType sqlType, int scaleOrLength)`
`JdbcUtil.PreparedCallableQuery`	`setObject(java.lang.String parameterName, java.lang.Object x)`
`JdbcUtil.PreparedCallableQuery`	`setObject(java.lang.String parameterName, java.lang.Object x, int sqlType)`
`JdbcUtil.PreparedCallableQuery`	`setObject(java.lang.String parameterName, java.lang.Object x, int sqlType, int scaleOrLength)`
`Q`	`setParameters(int startParameterIndex, java.util.Collection<?> parameters)`
`<T> Q`	`setParameters(int startParameterIndex, java.util.Collection<? extends T> parameters, java.lang.Class<T> type)`
`Q`	`setParameters(int startParameterIndex, java.lang.Object param1, java.lang.Object param2, java.lang.Object param3)`
`Q`	`setParameters(int startParameterIndex, java.lang.Object param1, java.lang.Object param2, java.lang.Object param3, java.lang.Object param4)`
`Q`	`setParameters(int startParameterIndex, java.lang.Object param1, java.lang.Object param2, java.lang.Object param3, java.lang.Object param4, java.lang.Object param5)`
`Q`	`setParameters(int startParameterIndex, java.lang.Object param1, java.lang.Object param2, java.lang.Object param3, java.lang.Object param4, java.lang.Object param5, java.lang.Object param6)`
`Q`	`setParameters(int startParameterIndex, java.lang.Object param1, java.lang.Object param2, java.lang.Object param3, java.lang.Object param4, java.lang.Object param5, java.lang.Object param6, java.lang.Object param7)`
`Q`	`setParameters(int startParameterIndex, java.lang.Object param1, java.lang.Object param2, java.lang.Object param3, java.lang.Object param4, java.lang.Object param5, java.lang.Object param6, java.lang.Object param7, java.lang.Object param8)`
`Q`	`setParameters(int startParameterIndex, java.lang.Object param1, java.lang.Object param2, java.lang.Object param3, java.lang.Object param4, java.lang.Object param5, java.lang.Object param6, java.lang.Object param7, java.lang.Object param8, java.lang.Object param9)`
`Q`	`setParameters(int startParameterIndex, java.lang.String param1, java.lang.String param2)`
`Q`	`setParameters(int startParameterIndex, java.lang.String param1, java.lang.String param2, java.lang.String param3)`
`Q`	`setParameters(int startParameterIndex, java.lang.String param1, java.lang.String param2, java.lang.String param3, java.lang.String param4)`
`Q`	`setParameters(int startParameterIndex, java.lang.String param1, java.lang.String param2, java.lang.String param3, java.lang.String param4, java.lang.String param5)`
`Q`	`setParameters(JdbcUtil.ParametersSetter<? super S> paramSetter)`
`JdbcUtil.PreparedCallableQuery`	`setParameters(java.util.List<java.lang.String> parameterNames, java.lang.Object entity)`
`JdbcUtil.PreparedCallableQuery`	`setParameters(java.util.Map<java.lang.String,java.lang.Object> parameters)`
`<T> Q`	`setParameters(T parameter, JdbcUtil.BiParametersSetter<? super S,? super T> paramSetter)`
`Q`	`setQueryTimeout(int seconds)`
`Q`	`setRef(int parameterIndex, java.sql.Ref x)`
`Q`	`setRowId(int parameterIndex, java.sql.RowId x)`
`JdbcUtil.PreparedCallableQuery`	`setRowId(java.lang.String parameterName, java.sql.RowId x)`
`Q`	`setShort(int parameterIndex, short x)`
`Q`	`setShort(int parameterIndex, java.lang.Short x)`
`JdbcUtil.PreparedCallableQuery`	`setShort(java.lang.String parameterName, short x)`
`JdbcUtil.PreparedCallableQuery`	`setShort(java.lang.String parameterName, java.lang.Short x)`
`Q`	`setSQLXML(int parameterIndex, java.sql.SQLXML x)`
`JdbcUtil.PreparedCallableQuery`	`setSQLXML(java.lang.String parameterName, java.sql.SQLXML x)`
`Q`	`setString(int parameterIndex, java.lang.String x)`
`JdbcUtil.PreparedCallableQuery`	`setString(java.lang.String parameterName, java.lang.String x)`
`Q`	`setTime(int parameterIndex, java.util.Date x)`
`Q`	`setTime(int parameterIndex, java.sql.Time x)`
`JdbcUtil.PreparedCallableQuery`	`setTime(java.lang.String parameterName, java.util.Date x)`
`JdbcUtil.PreparedCallableQuery`	`setTime(java.lang.String parameterName, java.sql.Time x)`
`Q`	`setTimestamp(int parameterIndex, java.util.Date x)`
`Q`	`setTimestamp(int parameterIndex, java.sql.Timestamp x)`
`JdbcUtil.PreparedCallableQuery`	`setTimestamp(java.lang.String parameterName, java.util.Date x)`
`JdbcUtil.PreparedCallableQuery`	`setTimestamp(java.lang.String parameterName, java.sql.Timestamp x)`
`Q`	`settParameters(JdbcUtil.ParametersSetter<? super Q> paramSetter)`
`<T> Q`	`settParameters(T parameter, JdbcUtil.BiParametersSetter<? super Q,? super T> paramSetter)`
`Q`	`setURL(int parameterIndex, java.net.URL x)`
`JdbcUtil.PreparedCallableQuery`	`setURL(java.lang.String parameterName, java.net.URL x)`
`<T> com.landawn.abacus.util.ExceptionalStream<T,java.sql.SQLException>`	`stream(java.lang.Class<T> targetClass)`
`<T> com.landawn.abacus.util.ExceptionalStream<T,java.sql.SQLException>`	`stream(JdbcUtil.BiRowMapper<T> rowMapper)`
`<T> com.landawn.abacus.util.ExceptionalStream<T,java.sql.SQLException>`	`stream(JdbcUtil.RowMapper<T> rowMapper)`
`int`	`update()`

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

setNull

public JdbcUtil.PreparedCallableQuery setNull(java.lang.String parameterName,
                                              int sqlType)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setNull

public JdbcUtil.PreparedCallableQuery setNull(java.lang.String parameterName,
                                              int sqlType,
                                              java.lang.String typeName)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setBoolean

public JdbcUtil.PreparedCallableQuery setBoolean(java.lang.String parameterName,
                                                 boolean x)
                                          throws java.sql.SQLException

Throws:: java.sql.SQLException

setBoolean

public JdbcUtil.PreparedCallableQuery setBoolean(java.lang.String parameterName,
                                                 java.lang.Boolean x)
                                          throws java.sql.SQLException

Throws:: java.sql.SQLException

setByte

public JdbcUtil.PreparedCallableQuery setByte(java.lang.String parameterName,
                                              byte x)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setByte

public JdbcUtil.PreparedCallableQuery setByte(java.lang.String parameterName,
                                              java.lang.Byte x)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setShort

public JdbcUtil.PreparedCallableQuery setShort(java.lang.String parameterName,
                                               short x)
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

setShort

public JdbcUtil.PreparedCallableQuery setShort(java.lang.String parameterName,
                                               java.lang.Short x)
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

setInt

public JdbcUtil.PreparedCallableQuery setInt(java.lang.String parameterName,
                                             int x)
                                      throws java.sql.SQLException

Throws:: java.sql.SQLException

setInt

public JdbcUtil.PreparedCallableQuery setInt(java.lang.String parameterName,
                                             java.lang.Integer x)
                                      throws java.sql.SQLException

Throws:: java.sql.SQLException

setLong

public JdbcUtil.PreparedCallableQuery setLong(java.lang.String parameterName,
                                              long x)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setLong

public JdbcUtil.PreparedCallableQuery setLong(java.lang.String parameterName,
                                              java.lang.Long x)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setFloat

public JdbcUtil.PreparedCallableQuery setFloat(java.lang.String parameterName,
                                               float x)
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

setFloat

public JdbcUtil.PreparedCallableQuery setFloat(java.lang.String parameterName,
                                               java.lang.Float x)
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

setDouble

public JdbcUtil.PreparedCallableQuery setDouble(java.lang.String parameterName,
                                                double x)
                                         throws java.sql.SQLException

Throws:: java.sql.SQLException

setDouble

public JdbcUtil.PreparedCallableQuery setDouble(java.lang.String parameterName,
                                                java.lang.Double x)
                                         throws java.sql.SQLException

Throws:: java.sql.SQLException

setBigDecimal

public JdbcUtil.PreparedCallableQuery setBigDecimal(java.lang.String parameterName,
                                                    java.math.BigDecimal x)
                                             throws java.sql.SQLException

Throws:: java.sql.SQLException

setString

public JdbcUtil.PreparedCallableQuery setString(java.lang.String parameterName,
                                                java.lang.String x)
                                         throws java.sql.SQLException

Throws:: java.sql.SQLException

setDate

public JdbcUtil.PreparedCallableQuery setDate(java.lang.String parameterName,
                                              java.sql.Date x)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setDate

public JdbcUtil.PreparedCallableQuery setDate(java.lang.String parameterName,
                                              java.util.Date x)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setTime

public JdbcUtil.PreparedCallableQuery setTime(java.lang.String parameterName,
                                              java.sql.Time x)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setTime

public JdbcUtil.PreparedCallableQuery setTime(java.lang.String parameterName,
                                              java.util.Date x)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setTimestamp

public JdbcUtil.PreparedCallableQuery setTimestamp(java.lang.String parameterName,
                                                   java.sql.Timestamp x)
                                            throws java.sql.SQLException

Throws:: java.sql.SQLException

setTimestamp

public JdbcUtil.PreparedCallableQuery setTimestamp(java.lang.String parameterName,
                                                   java.util.Date x)
                                            throws java.sql.SQLException

Throws:: java.sql.SQLException

setBytes

public JdbcUtil.PreparedCallableQuery setBytes(java.lang.String parameterName,
                                               byte[] x)
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

setAsciiStream

public JdbcUtil.PreparedCallableQuery setAsciiStream(java.lang.String parameterName,
                                                     java.io.InputStream inputStream)
                                              throws java.sql.SQLException

Throws:: java.sql.SQLException

setAsciiStream

public JdbcUtil.PreparedCallableQuery setAsciiStream(java.lang.String parameterName,
                                                     java.io.InputStream inputStream,
                                                     long length)
                                              throws java.sql.SQLException

Throws:: java.sql.SQLException

setBinaryStream

public JdbcUtil.PreparedCallableQuery setBinaryStream(java.lang.String parameterName,
                                                      java.io.InputStream inputStream)
                                               throws java.sql.SQLException

Throws:: java.sql.SQLException

setBinaryStream

public JdbcUtil.PreparedCallableQuery setBinaryStream(java.lang.String parameterName,
                                                      java.io.InputStream inputStream,
                                                      long length)
                                               throws java.sql.SQLException

Throws:: java.sql.SQLException

setCharacterStream

public JdbcUtil.PreparedCallableQuery setCharacterStream(java.lang.String parameterName,
                                                         java.io.Reader reader)
                                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

setCharacterStream

public JdbcUtil.PreparedCallableQuery setCharacterStream(java.lang.String parameterName,
                                                         java.io.Reader reader,
                                                         long length)
                                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

setNCharacterStream

public JdbcUtil.PreparedCallableQuery setNCharacterStream(java.lang.String parameterName,
                                                          java.io.Reader reader)
                                                   throws java.sql.SQLException

Throws:: java.sql.SQLException

setNCharacterStream

public JdbcUtil.PreparedCallableQuery setNCharacterStream(java.lang.String parameterName,
                                                          java.io.Reader reader,
                                                          long length)
                                                   throws java.sql.SQLException

Throws:: java.sql.SQLException

setBlob

public JdbcUtil.PreparedCallableQuery setBlob(java.lang.String parameterName,
                                              java.sql.Blob x)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setBlob

public JdbcUtil.PreparedCallableQuery setBlob(java.lang.String parameterName,
                                              java.io.InputStream inputStream)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setBlob

public JdbcUtil.PreparedCallableQuery setBlob(java.lang.String parameterName,
                                              java.io.InputStream inputStream,
                                              long length)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setClob

public JdbcUtil.PreparedCallableQuery setClob(java.lang.String parameterName,
                                              java.sql.Clob x)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setClob

public JdbcUtil.PreparedCallableQuery setClob(java.lang.String parameterName,
                                              java.io.Reader reader)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setClob

public JdbcUtil.PreparedCallableQuery setClob(java.lang.String parameterName,
                                              java.io.Reader reader,
                                              long length)
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

setNClob

public JdbcUtil.PreparedCallableQuery setNClob(java.lang.String parameterName,
                                               java.sql.NClob x)
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

setNClob

public JdbcUtil.PreparedCallableQuery setNClob(java.lang.String parameterName,
                                               java.io.Reader reader)
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

setNClob

public JdbcUtil.PreparedCallableQuery setNClob(java.lang.String parameterName,
                                               java.io.Reader reader,
                                               long length)
                                        throws java.sql.SQLException

Throws:: java.sql.SQLException

setURL

public JdbcUtil.PreparedCallableQuery setURL(java.lang.String parameterName,
                                             java.net.URL x)
                                      throws java.sql.SQLException

Parameters:: parameterName -; x -
Returns:
Throws:: java.sql.SQLException

setSQLXML

public JdbcUtil.PreparedCallableQuery setSQLXML(java.lang.String parameterName,
                                                java.sql.SQLXML x)
                                         throws java.sql.SQLException

Parameters:: parameterName -; x -
Returns:
Throws:: java.sql.SQLException

setRowId

public JdbcUtil.PreparedCallableQuery setRowId(java.lang.String parameterName,
                                               java.sql.RowId x)
                                        throws java.sql.SQLException

Parameters:: parameterName -; x -
Returns:
Throws:: java.sql.SQLException

setObject

public JdbcUtil.PreparedCallableQuery setObject(java.lang.String parameterName,
                                                java.lang.Object x)
                                         throws java.sql.SQLException

Throws:: java.sql.SQLException

setObject

public JdbcUtil.PreparedCallableQuery setObject(java.lang.String parameterName,
                                                java.lang.Object x,
                                                int sqlType)
                                         throws java.sql.SQLException

Throws:: java.sql.SQLException

setObject

public JdbcUtil.PreparedCallableQuery setObject(java.lang.String parameterName,
                                                java.lang.Object x,
                                                int sqlType,
                                                int scaleOrLength)
                                         throws java.sql.SQLException

Throws:: java.sql.SQLException

setParameters

public JdbcUtil.PreparedCallableQuery setParameters(java.util.Map<java.lang.String,java.lang.Object> parameters)
                                             throws java.sql.SQLException

Throws:: java.sql.SQLException

setParameters
```
public JdbcUtil.PreparedCallableQuery setParameters(java.util.List<java.lang.String> parameterNames,
                                                    java.lang.Object entity)
                                             throws java.sql.SQLException
```
Parameters:

parameterNames -

entity -

Returns:

Throws:

java.sql.SQLException

See Also:

ClassUtil#getPropNameList(Class)}, ClassUtil#getPropNameListExclusively(Class, Set)}, ClassUtil#getPropNameListExclusively(Class, Collection)}, JdbcUtil#getNamedParameters(String)}

registerOutParameter

public JdbcUtil.PreparedCallableQuery registerOutParameter(int parameterIndex,
                                                           int sqlType)
                                                    throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; sqlType -
Returns:
Throws:: java.sql.SQLException

registerOutParameter

public JdbcUtil.PreparedCallableQuery registerOutParameter(int parameterIndex,
                                                           int sqlType,
                                                           int scale)
                                                    throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; sqlType -; scale -
Returns:
Throws:: java.sql.SQLException

registerOutParameter

public JdbcUtil.PreparedCallableQuery registerOutParameter(int parameterIndex,
                                                           int sqlType,
                                                           java.lang.String typeName)
                                                    throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; sqlType -; typeName -
Returns:
Throws:: java.sql.SQLException

registerOutParameter

public JdbcUtil.PreparedCallableQuery registerOutParameter(java.lang.String parameterName,
                                                           int sqlType)
                                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

registerOutParameter

public JdbcUtil.PreparedCallableQuery registerOutParameter(java.lang.String parameterName,
                                                           int sqlType,
                                                           int scale)
                                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

registerOutParameter

public JdbcUtil.PreparedCallableQuery registerOutParameter(java.lang.String parameterName,
                                                           int sqlType,
                                                           java.lang.String typeName)
                                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

registerOutParameter

public JdbcUtil.PreparedCallableQuery registerOutParameter(int parameterIndex,
                                                           java.sql.SQLType sqlType)
                                                    throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; sqlType -
Returns:
Throws:: java.sql.SQLException

registerOutParameter

public JdbcUtil.PreparedCallableQuery registerOutParameter(int parameterIndex,
                                                           java.sql.SQLType sqlType,
                                                           int scale)
                                                    throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; sqlType -; scale -
Returns:
Throws:: java.sql.SQLException

registerOutParameter

public JdbcUtil.PreparedCallableQuery registerOutParameter(int parameterIndex,
                                                           java.sql.SQLType sqlType,
                                                           java.lang.String typeName)
                                                    throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; sqlType -; typeName -
Returns:
Throws:: java.sql.SQLException

registerOutParameter

public JdbcUtil.PreparedCallableQuery registerOutParameter(java.lang.String parameterName,
                                                           java.sql.SQLType sqlType)
                                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

registerOutParameter

public JdbcUtil.PreparedCallableQuery registerOutParameter(java.lang.String parameterName,
                                                           java.sql.SQLType sqlType,
                                                           int scale)
                                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

registerOutParameter

public JdbcUtil.PreparedCallableQuery registerOutParameter(java.lang.String parameterName,
                                                           java.sql.SQLType sqlType,
                                                           java.lang.String typeName)
                                                    throws java.sql.SQLException

Throws:: java.sql.SQLException

registerOutParameters

public JdbcUtil.PreparedCallableQuery registerOutParameters(JdbcUtil.ParametersSetter<? super java.sql.CallableStatement> register)
                                                     throws java.sql.SQLException

Throws:: java.sql.SQLException

registerOutParameters

public <T> JdbcUtil.PreparedCallableQuery registerOutParameters(T parameter,
                                                                JdbcUtil.BiParametersSetter<? super T,? super java.sql.CallableStatement> register)
                                                         throws java.sql.SQLException

Throws:: java.sql.SQLException

call

public <R1> u.Optional<R1> call(JdbcUtil.ResultExtractor<R1> resultExtrator1)
                         throws java.sql.SQLException

Throws:: java.sql.SQLException

call

public <R1,R2> Tuple.Tuple2<u.Optional<R1>,u.Optional<R2>> call(JdbcUtil.ResultExtractor<R1> resultExtrator1,
                                                                JdbcUtil.ResultExtractor<R2> resultExtrator2)
                                                         throws java.sql.SQLException

Throws:: java.sql.SQLException

call

public <R1,R2,R3> Tuple.Tuple3<u.Optional<R1>,u.Optional<R2>,u.Optional<R3>> call(JdbcUtil.ResultExtractor<R1> resultExtrator1,
                                                                                  JdbcUtil.ResultExtractor<R2> resultExtrator2,
                                                                                  JdbcUtil.ResultExtractor<R3> resultExtrator3)
                                                                           throws java.sql.SQLException

Throws:: java.sql.SQLException

call

public <R1,R2,R3,R4> Tuple.Tuple4<u.Optional<R1>,u.Optional<R2>,u.Optional<R3>,u.Optional<R4>> call(JdbcUtil.ResultExtractor<R1> resultExtrator1,
                                                                                                    JdbcUtil.ResultExtractor<R2> resultExtrator2,
                                                                                                    JdbcUtil.ResultExtractor<R3> resultExtrator3,
                                                                                                    JdbcUtil.ResultExtractor<R4> resultExtrator4)
                                                                                             throws java.sql.SQLException

Throws:: java.sql.SQLException

call

public <R1,R2,R3,R4,R5> Tuple.Tuple5<u.Optional<R1>,u.Optional<R2>,u.Optional<R3>,u.Optional<R4>,u.Optional<R5>> call(JdbcUtil.ResultExtractor<R1> resultExtrator1,
                                                                                                                      JdbcUtil.ResultExtractor<R2> resultExtrator2,
                                                                                                                      JdbcUtil.ResultExtractor<R3> resultExtrator3,
                                                                                                                      JdbcUtil.ResultExtractor<R4> resultExtrator4,
                                                                                                                      JdbcUtil.ResultExtractor<R5> resultExtrator5)
                                                                                                               throws java.sql.SQLException

Throws:: java.sql.SQLException

closeAfterExecution

public Q closeAfterExecution(boolean closeAfterExecution)

closeAfterExecution
```
public boolean closeAfterExecution()
```

onClose
```
public Q onClose(java.lang.Runnable closeHandler)
```
Parameters:

closeHandler - A task to execute after this Query is closed

Returns:

setNull

public Q setNull(int parameterIndex,
                 int sqlType)
          throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; sqlType -
Returns:
Throws:: java.sql.SQLException

setNull

public Q setNull(int parameterIndex,
                 int sqlType,
                 java.lang.String typeName)
          throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; sqlType -; typeName -
Returns:
Throws:: java.sql.SQLException

setBoolean

public Q setBoolean(int parameterIndex,
                    boolean x)
             throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setBoolean

public Q setBoolean(int parameterIndex,
                    java.lang.Boolean x)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

setByte

public Q setByte(int parameterIndex,
                 byte x)
          throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setByte

public Q setByte(int parameterIndex,
                 java.lang.Byte x)
          throws java.sql.SQLException

Throws:: java.sql.SQLException

setShort

public Q setShort(int parameterIndex,
                  short x)
           throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setShort

public Q setShort(int parameterIndex,
                  java.lang.Short x)
           throws java.sql.SQLException

Throws:: java.sql.SQLException

setInt

public Q setInt(int parameterIndex,
                int x)
         throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setInt

public Q setInt(int parameterIndex,
                java.lang.Integer x)
         throws java.sql.SQLException

Throws:: java.sql.SQLException

setLong

public Q setLong(int parameterIndex,
                 long x)
          throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setLong

public Q setLong(int parameterIndex,
                 java.lang.Long x)
          throws java.sql.SQLException

Throws:: java.sql.SQLException

setFloat

public Q setFloat(int parameterIndex,
                  float x)
           throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setFloat

public Q setFloat(int parameterIndex,
                  java.lang.Float x)
           throws java.sql.SQLException

Throws:: java.sql.SQLException

setDouble

public Q setDouble(int parameterIndex,
                   double x)
            throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setDouble

public Q setDouble(int parameterIndex,
                   java.lang.Double x)
            throws java.sql.SQLException

Throws:: java.sql.SQLException

setBigDecimal

public Q setBigDecimal(int parameterIndex,
                       java.math.BigDecimal x)
                throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setString

public Q setString(int parameterIndex,
                   java.lang.String x)
            throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setDate

public Q setDate(int parameterIndex,
                 java.sql.Date x)
          throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setDate

public Q setDate(int parameterIndex,
                 java.util.Date x)
          throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setTime

public Q setTime(int parameterIndex,
                 java.sql.Time x)
          throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setTime

public Q setTime(int parameterIndex,
                 java.util.Date x)
          throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setTimestamp

public Q setTimestamp(int parameterIndex,
                      java.sql.Timestamp x)
               throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setTimestamp

public Q setTimestamp(int parameterIndex,
                      java.util.Date x)
               throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setBytes

public Q setBytes(int parameterIndex,
                  byte[] x)
           throws java.sql.SQLException

Throws:: java.sql.SQLException

setAsciiStream

public Q setAsciiStream(int parameterIndex,
                        java.io.InputStream inputStream)
                 throws java.sql.SQLException

Throws:: java.sql.SQLException

setAsciiStream

public Q setAsciiStream(int parameterIndex,
                        java.io.InputStream inputStream,
                        long length)
                 throws java.sql.SQLException

Throws:: java.sql.SQLException

setBinaryStream

public Q setBinaryStream(int parameterIndex,
                         java.io.InputStream inputStream)
                  throws java.sql.SQLException

Throws:: java.sql.SQLException

setBinaryStream

public Q setBinaryStream(int parameterIndex,
                         java.io.InputStream inputStream,
                         long length)
                  throws java.sql.SQLException

Throws:: java.sql.SQLException

setCharacterStream

public Q setCharacterStream(int parameterIndex,
                            java.io.Reader reader)
                     throws java.sql.SQLException

Throws:: java.sql.SQLException

setCharacterStream

public Q setCharacterStream(int parameterIndex,
                            java.io.Reader reader,
                            long length)
                     throws java.sql.SQLException

Throws:: java.sql.SQLException

setNCharacterStream

public Q setNCharacterStream(int parameterIndex,
                             java.io.Reader reader)
                      throws java.sql.SQLException

Throws:: java.sql.SQLException

setNCharacterStream

public Q setNCharacterStream(int parameterIndex,
                             java.io.Reader reader,
                             long length)
                      throws java.sql.SQLException

Throws:: java.sql.SQLException

setBlob

public Q setBlob(int parameterIndex,
                 java.sql.Blob x)
          throws java.sql.SQLException

Throws:: java.sql.SQLException

setBlob

public Q setBlob(int parameterIndex,
                 java.io.InputStream inputStream)
          throws java.sql.SQLException

Throws:: java.sql.SQLException

setBlob

public Q setBlob(int parameterIndex,
                 java.io.InputStream inputStream,
                 long length)
          throws java.sql.SQLException

Throws:: java.sql.SQLException

setClob

public Q setClob(int parameterIndex,
                 java.sql.Clob x)
          throws java.sql.SQLException

Throws:: java.sql.SQLException

setClob

public Q setClob(int parameterIndex,
                 java.io.Reader reader)
          throws java.sql.SQLException

Throws:: java.sql.SQLException

setClob

public Q setClob(int parameterIndex,
                 java.io.Reader reader,
                 long length)
          throws java.sql.SQLException

Throws:: java.sql.SQLException

setNClob

public Q setNClob(int parameterIndex,
                  java.sql.NClob x)
           throws java.sql.SQLException

Throws:: java.sql.SQLException

setNClob

public Q setNClob(int parameterIndex,
                  java.io.Reader reader)
           throws java.sql.SQLException

Throws:: java.sql.SQLException

setNClob

public Q setNClob(int parameterIndex,
                  java.io.Reader reader,
                  long length)
           throws java.sql.SQLException

Throws:: java.sql.SQLException

setURL

public Q setURL(int parameterIndex,
                java.net.URL x)
         throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; parameterIndex -; x -
Returns:
Throws:: java.sql.SQLException

setArray

public Q setArray(int parameterIndex,
                  java.sql.Array x)
           throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; parameterIndex -; x -
Returns:
Throws:: java.sql.SQLException

setSQLXML

public Q setSQLXML(int parameterIndex,
                   java.sql.SQLXML x)
            throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; parameterIndex -; x -
Returns:
Throws:: java.sql.SQLException

setRef

public Q setRef(int parameterIndex,
                java.sql.Ref x)
         throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; parameterIndex -; x -
Returns:
Throws:: java.sql.SQLException

setRowId

public Q setRowId(int parameterIndex,
                  java.sql.RowId x)
           throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; parameterIndex -; x -
Returns:
Throws:: java.sql.SQLException

setObject

public Q setObject(int parameterIndex,
                   java.lang.Object x)
            throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -
Returns:
Throws:: java.sql.SQLException

setObject

public Q setObject(int parameterIndex,
                   java.lang.Object x,
                   int sqlType)
            throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -; sqlType -
Returns:
Throws:: java.sql.SQLException

setObject

public Q setObject(int parameterIndex,
                   java.lang.Object x,
                   int sqlType,
                   int scaleOrLength)
            throws java.sql.SQLException

Parameters:: parameterIndex - starts from 1, not 0.; x -; sqlType -; scaleOrLength -
Returns:
Throws:: java.sql.SQLException

setObject

public Q setObject(int parameterIndex,
                   java.lang.Object x,
                   java.sql.SQLType sqlType)
            throws java.sql.SQLException

Parameters:: startParameterIndex -; x -; sqlType -
Returns:
Throws:: java.sql.SQLException

setObject

public Q setObject(int parameterIndex,
                   java.lang.Object x,
                   java.sql.SQLType sqlType,
                   int scaleOrLength)
            throws java.sql.SQLException

Throws:: java.sql.SQLException

setParameters

public Q setParameters(int startParameterIndex,
                       java.lang.String param1,
                       java.lang.String param2)
                throws java.sql.SQLException

Parameters:: startParameterIndex -; param1 -; param2 -
Returns:
Throws:: java.sql.SQLException

setParameters

public Q setParameters(int startParameterIndex,
                       java.lang.String param1,
                       java.lang.String param2,
                       java.lang.String param3)
                throws java.sql.SQLException

Parameters:: startParameterIndex -; param1 -; param2 -; param3 -
Returns:
Throws:: java.sql.SQLException

setParameters

public Q setParameters(int startParameterIndex,
                       java.lang.String param1,
                       java.lang.String param2,
                       java.lang.String param3,
                       java.lang.String param4)
                throws java.sql.SQLException

Parameters:: startParameterIndex -; param1 -; param2 -; param3 -; param4 -
Returns:
Throws:: java.sql.SQLException

setParameters

public Q setParameters(int startParameterIndex,
                       java.lang.String param1,
                       java.lang.String param2,
                       java.lang.String param3,
                       java.lang.String param4,
                       java.lang.String param5)
                throws java.sql.SQLException

Parameters:: startParameterIndex -; param1 -; param2 -; param3 -; param4 -; param5 -
Returns:
Throws:: java.sql.SQLException

setParameters

public Q setParameters(int startParameterIndex,
                       java.lang.Object param1,
                       java.lang.Object param2,
                       java.lang.Object param3)
                throws java.sql.SQLException

Parameters:: startParameterIndex -; param1 -; param2 -; param3 -
Returns:
Throws:: java.sql.SQLException

setParameters

public Q setParameters(int startParameterIndex,
                       java.lang.Object param1,
                       java.lang.Object param2,
                       java.lang.Object param3,
                       java.lang.Object param4)
                throws java.sql.SQLException

Parameters:: startParameterIndex -; param1 -; param2 -; param3 -; param4 -
Returns:
Throws:: java.sql.SQLException

setParameters

public Q setParameters(int startParameterIndex,
                       java.lang.Object param1,
                       java.lang.Object param2,
                       java.lang.Object param3,
                       java.lang.Object param4,
                       java.lang.Object param5)
                throws java.sql.SQLException

Parameters:: startParameterIndex -; param1 -; param2 -; param3 -; param4 -; param5 -
Returns:
Throws:: java.sql.SQLException

setParameters

public Q setParameters(int startParameterIndex,
                       java.lang.Object param1,
                       java.lang.Object param2,
                       java.lang.Object param3,
                       java.lang.Object param4,
                       java.lang.Object param5,
                       java.lang.Object param6)
                throws java.sql.SQLException

Parameters:: startParameterIndex -; param1 -; param2 -; param3 -; param4 -; param5 -; param6 -
Returns:
Throws:: java.sql.SQLException

setParameters

public Q setParameters(int startParameterIndex,
                       java.lang.Object param1,
                       java.lang.Object param2,
                       java.lang.Object param3,
                       java.lang.Object param4,
                       java.lang.Object param5,
                       java.lang.Object param6,
                       java.lang.Object param7)
                throws java.sql.SQLException

Parameters:: startParameterIndex -; param1 -; param2 -; param3 -; param4 -; param5 -; param6 -; param7 -
Returns:
Throws:: java.sql.SQLException

setParameters

public Q setParameters(int startParameterIndex,
                       java.lang.Object param1,
                       java.lang.Object param2,
                       java.lang.Object param3,
                       java.lang.Object param4,
                       java.lang.Object param5,
                       java.lang.Object param6,
                       java.lang.Object param7,
                       java.lang.Object param8)
                throws java.sql.SQLException

Parameters:: startParameterIndex -; param1 -; param2 -; param3 -; param4 -; param5 -; param6 -; param7 -; param8 -
Returns:
Throws:: java.sql.SQLException

setParameters

public Q setParameters(int startParameterIndex,
                       java.lang.Object param1,
                       java.lang.Object param2,
                       java.lang.Object param3,
                       java.lang.Object param4,
                       java.lang.Object param5,
                       java.lang.Object param6,
                       java.lang.Object param7,
                       java.lang.Object param8,
                       java.lang.Object param9)
                throws java.sql.SQLException

Parameters:: startParameterIndex -; param1 -; param2 -; param3 -; param4 -; param5 -; param6 -; param7 -; param8 -; param9 -
Returns:
Throws:: java.sql.SQLException

setParameters

public Q setParameters(int startParameterIndex,
                       java.util.Collection<?> parameters)
                throws java.lang.IllegalArgumentException,
                       java.sql.SQLException

Parameters:: startParameterIndex -; parameters -
Returns:
Throws:: java.lang.IllegalArgumentException - if specified parameters or type is null.; java.sql.SQLException

setParameters

public <T> Q setParameters(int startParameterIndex,
                           java.util.Collection<? extends T> parameters,
                           java.lang.Class<T> type)
                    throws java.lang.IllegalArgumentException,
                           java.sql.SQLException

Parameters:: startParameterIndex -; parameters -; type -
Returns:
Throws:: java.lang.IllegalArgumentException - if specified parameters or type is null.; java.sql.SQLException

setParameters

public Q setParameters(JdbcUtil.ParametersSetter<? super S> paramSetter)
                throws java.sql.SQLException

Parameters:: paramSetter -
Returns:
Throws:: java.sql.SQLException

setParameters

public <T> Q setParameters(T parameter,
                           JdbcUtil.BiParametersSetter<? super S,? super T> paramSetter)
                    throws java.sql.SQLException

Parameters:: paramSetter -
Returns:
Throws:: java.sql.SQLException

settParameters

public Q settParameters(JdbcUtil.ParametersSetter<? super Q> paramSetter)
                 throws java.sql.SQLException

Parameters:: paramSetter -
Returns:
Throws:: java.sql.SQLException

settParameters

public <T> Q settParameters(T parameter,
                            JdbcUtil.BiParametersSetter<? super Q,? super T> paramSetter)
                     throws java.sql.SQLException

Parameters:: paramSetter -
Returns:
Throws:: java.sql.SQLException

addBatch

public Q addBatch()
           throws java.sql.SQLException

Throws:: java.sql.SQLException

setFetchDirection
```
public Q setFetchDirection(JdbcUtil.FetchDirection direction)
                    throws java.sql.SQLException
```
Parameters:

direction - one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN

Returns:

Throws:

java.sql.SQLException

See Also:

java.sql.Statement#setFetchDirection(int)}

setFetchSize

public Q setFetchSize(int rows)
               throws java.sql.SQLException

Throws:: java.sql.SQLException

setMaxRows

public Q setMaxRows(int max)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

setLargeMaxRows

public Q setLargeMaxRows(long max)
                  throws java.sql.SQLException

Throws:: java.sql.SQLException

setMaxFieldSize

public Q setMaxFieldSize(int max)
                  throws java.sql.SQLException

Throws:: java.sql.SQLException

setQueryTimeout

public Q setQueryTimeout(int seconds)
                  throws java.sql.SQLException

Throws:: java.sql.SQLException

queryForBoolean

public u.OptionalBoolean queryForBoolean()
                                  throws java.sql.SQLException

Throws:: java.sql.SQLException

queryForChar

public u.OptionalChar queryForChar()
                            throws java.sql.SQLException

Throws:: java.sql.SQLException

queryForByte

public u.OptionalByte queryForByte()
                            throws java.sql.SQLException

Throws:: java.sql.SQLException

queryForShort

public u.OptionalShort queryForShort()
                              throws java.sql.SQLException

Throws:: java.sql.SQLException

queryForInt

public u.OptionalInt queryForInt()
                          throws java.sql.SQLException

Throws:: java.sql.SQLException

queryForLong

public u.OptionalLong queryForLong()
                            throws java.sql.SQLException

Throws:: java.sql.SQLException

queryForFloat

public u.OptionalFloat queryForFloat()
                              throws java.sql.SQLException

Throws:: java.sql.SQLException

queryForDouble

public u.OptionalDouble queryForDouble()
                                throws java.sql.SQLException

Throws:: java.sql.SQLException

queryForString

public u.Nullable<java.lang.String> queryForString()
                                            throws java.sql.SQLException

Throws:: java.sql.SQLException

queryBigDecimal

public u.Nullable<java.math.BigDecimal> queryBigDecimal()
                                                 throws java.sql.SQLException

Throws:: java.sql.SQLException

queryForDate

public u.Nullable<java.sql.Date> queryForDate()
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

queryForTime

public u.Nullable<java.sql.Time> queryForTime()
                                       throws java.sql.SQLException

Throws:: java.sql.SQLException

queryForTimestamp

public u.Nullable<java.sql.Timestamp> queryForTimestamp()
                                                 throws java.sql.SQLException

Throws:: java.sql.SQLException

queryForSingleResult
```
public <V> u.Nullable<V> queryForSingleResult(java.lang.Class<V> targetClass)
                                       throws java.sql.SQLException
```
Returns a Nullable describing the value in the first row/column if it exists, otherwise return an empty Nullable.

Parameters:

targetClass -

Returns:

Throws:

java.sql.SQLException

queryForSingleNonNull
```
public <V> u.Optional<V> queryForSingleNonNull(java.lang.Class<V> targetClass)
                                        throws java.sql.SQLException
```
Returns an Optional describing the value in the first row/column if it exists, otherwise return an empty Optional.

Parameters:

targetClass -

Returns:

Throws:

java.sql.SQLException

queryForUniqueResult
```
public <V> u.Nullable<V> queryForUniqueResult(java.lang.Class<V> targetClass)
                                       throws DuplicatedResultException,
                                              java.sql.SQLException
```
Returns a Nullable describing the value in the first row/column if it exists, otherwise return an empty Nullable. And throws DuplicatedResultException if more than one record found.

Parameters:

targetClass -

Returns:

Throws:

DuplicatedResultException - if more than one record found.

java.sql.SQLException

queryForUniqueNonNull
```
public <V> u.Optional<V> queryForUniqueNonNull(java.lang.Class<V> targetClass)
                                        throws DuplicatedResultException,
                                               java.sql.SQLException
```
Returns an Optional describing the value in the first row/column if it exists, otherwise return an empty Optional. And throws DuplicatedResultException if more than one record found.

Parameters:

targetClass -

Returns:

Throws:

DuplicatedResultException - if more than one record found.

java.sql.SQLException

query

public DataSet query()
              throws java.sql.SQLException

Throws:: java.sql.SQLException

query

public <R> R query(JdbcUtil.ResultExtractor<R> resultExtrator)
            throws java.sql.SQLException

Throws:: java.sql.SQLException

query

public <R> R query(JdbcUtil.BiResultExtractor<R> resultExtrator)
            throws java.sql.SQLException

Throws:: java.sql.SQLException

get

public <T> u.Optional<T> get(java.lang.Class<T> targetClass)
                      throws DuplicatedResultException,
                             java.sql.SQLException

Parameters:: targetClass -
Returns:
Throws:: DuplicatedResultException - If there are more than one record found by the query; java.sql.SQLException

get

public <T> u.Optional<T> get(JdbcUtil.RowMapper<T> rowMapper)
                      throws DuplicatedResultException,
                             java.sql.SQLException

Parameters:: rowMapper -
Returns:
Throws:: DuplicatedResultException - If there are more than one record found by the query; java.sql.SQLException

get

public <T> u.Optional<T> get(JdbcUtil.BiRowMapper<T> rowMapper)
                      throws DuplicatedResultException,
                             java.sql.SQLException

Parameters:: rowMapper -
Returns:
Throws:: DuplicatedResultException - If there are more than one record found by the query; java.sql.SQLException

gett
```
public <T> T gett(java.lang.Class<T> targetClass)
           throws DuplicatedResultException,
                  java.sql.SQLException
```
Parameters:

targetClass -

Returns:

Throws:

DuplicatedResultException - If there are more than one record found by the query

java.sql.SQLException

gett

public <T> T gett(JdbcUtil.RowMapper<T> rowMapper)
           throws DuplicatedResultException,
                  java.sql.SQLException

Parameters:: rowMapper -
Returns:
Throws:: DuplicatedResultException - If there are more than one record found by the query; java.sql.SQLException

gett

public <T> T gett(JdbcUtil.BiRowMapper<T> rowMapper)
           throws DuplicatedResultException,
                  java.sql.SQLException

Parameters:: rowMapper -
Returns:
Throws:: DuplicatedResultException - If there are more than one record found by the query; java.sql.SQLException

findFirst

public <T> u.Optional<T> findFirst(java.lang.Class<T> targetClass)
                            throws java.sql.SQLException

Parameters:: targetClass -
Returns:
Throws:: java.sql.SQLException

findFirst

public <T> u.Optional<T> findFirst(JdbcUtil.RowMapper<T> rowMapper)
                            throws java.sql.SQLException

Throws:: java.sql.SQLException

findFirst

public <T> u.Optional<T> findFirst(JdbcUtil.RowFilter recordFilter,
                                   JdbcUtil.RowMapper<T> rowMapper)
                            throws java.sql.SQLException

Throws:: java.sql.SQLException

findFirst

public <T> u.Optional<T> findFirst(JdbcUtil.BiRowMapper<T> rowMapper)
                            throws java.sql.SQLException

Throws:: java.sql.SQLException

findFirst

public <T> u.Optional<T> findFirst(JdbcUtil.BiRowFilter recordFilter,
                                   JdbcUtil.BiRowMapper<T> rowMapper)
                            throws java.sql.SQLException

Throws:: java.sql.SQLException

list

public <T> java.util.List<T> list(java.lang.Class<T> targetClass)
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

list

public <T> java.util.List<T> list(java.lang.Class<T> targetClass,
                                  int maxResult)
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

list

public <T> java.util.List<T> list(JdbcUtil.RowMapper<T> rowMapper)
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

list

public <T> java.util.List<T> list(JdbcUtil.RowMapper<T> rowMapper,
                                  int maxResult)
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

list

public <T> java.util.List<T> list(JdbcUtil.RowFilter recordFilter,
                                  JdbcUtil.RowMapper<T> rowMapper)
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

list

public <T> java.util.List<T> list(JdbcUtil.RowFilter recordFilter,
                                  JdbcUtil.RowMapper<T> rowMapper,
                                  int maxResult)
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

list

public <T> java.util.List<T> list(JdbcUtil.BiRowMapper<T> rowMapper)
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

list

public <T> java.util.List<T> list(JdbcUtil.BiRowMapper<T> rowMapper,
                                  int maxResult)
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

list

public <T> java.util.List<T> list(JdbcUtil.BiRowFilter recordFilter,
                                  JdbcUtil.BiRowMapper<T> rowMapper)
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

list

public <T> java.util.List<T> list(JdbcUtil.BiRowFilter recordFilter,
                                  JdbcUtil.BiRowMapper<T> rowMapper,
                                  int maxResult)
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

stream

public <T> com.landawn.abacus.util.ExceptionalStream<T,java.sql.SQLException> stream(java.lang.Class<T> targetClass)
                                                                              throws java.sql.SQLException

Throws:: java.sql.SQLException

stream

public <T> com.landawn.abacus.util.ExceptionalStream<T,java.sql.SQLException> stream(JdbcUtil.RowMapper<T> rowMapper)
                                                                              throws java.sql.SQLException

Throws:: java.sql.SQLException

stream

public <T> com.landawn.abacus.util.ExceptionalStream<T,java.sql.SQLException> stream(JdbcUtil.BiRowMapper<T> rowMapper)
                                                                              throws java.sql.SQLException

Throws:: java.sql.SQLException

exists
```
public boolean exists()
               throws java.sql.SQLException
```
Note: using select 1 from ..., not select count(*) from ....

Returns:

Throws:

java.sql.SQLException

ifExists

public void ifExists(JdbcUtil.RowConsumer rowConsumer)
              throws java.sql.SQLException

Throws:: java.sql.SQLException

ifExists

public void ifExists(JdbcUtil.BiRowConsumer rowConsumer)
              throws java.sql.SQLException

Throws:: java.sql.SQLException

ifExistsOrElse

public void ifExistsOrElse(JdbcUtil.RowConsumer rowConsumer,
                           Try.Runnable<java.sql.SQLException> orElseAction)
                    throws java.sql.SQLException

Parameters:: rowConsumer -; orElseAction -
Throws:: java.sql.SQLException

ifExistsOrElse

public void ifExistsOrElse(JdbcUtil.BiRowConsumer rowConsumer,
                           Try.Runnable<java.sql.SQLException> orElseAction)
                    throws java.sql.SQLException

Parameters:: rowConsumer -; orElseAction -
Throws:: java.sql.SQLException

count
```
@Deprecated
public int count()
                       throws java.sql.SQLException
```
Deprecated. may be misused and it's inefficient.

Note: using select count(*) from ...

Returns:

Throws:

java.sql.SQLException

count

public int count(JdbcUtil.RowFilter recordFilter)
          throws java.sql.SQLException

Throws:: java.sql.SQLException

count

public int count(JdbcUtil.BiRowFilter recordFilter)
          throws java.sql.SQLException

Throws:: java.sql.SQLException

anyMatch

public boolean anyMatch(JdbcUtil.RowFilter recordFilter)
                 throws java.sql.SQLException

Throws:: java.sql.SQLException

anyMatch

public boolean anyMatch(JdbcUtil.BiRowFilter recordFilter)
                 throws java.sql.SQLException

Throws:: java.sql.SQLException

allMatch

public boolean allMatch(JdbcUtil.RowFilter recordFilter)
                 throws java.sql.SQLException

Throws:: java.sql.SQLException

allMatch

public boolean allMatch(JdbcUtil.BiRowFilter recordFilter)
                 throws java.sql.SQLException

Throws:: java.sql.SQLException

noneMatch

public boolean noneMatch(JdbcUtil.RowFilter recordFilter)
                  throws java.sql.SQLException

Throws:: java.sql.SQLException

noneMatch

public boolean noneMatch(JdbcUtil.BiRowFilter recordFilter)
                  throws java.sql.SQLException

Throws:: java.sql.SQLException

forEach

public void forEach(JdbcUtil.RowConsumer rowConsumer)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

forEach

public void forEach(JdbcUtil.RowFilter recordFilter,
                    JdbcUtil.RowConsumer rowConsumer)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

forEach

public void forEach(JdbcUtil.BiRowConsumer rowConsumer)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

forEach

public void forEach(JdbcUtil.BiRowFilter recordFilter,
                    JdbcUtil.BiRowConsumer rowConsumer)
             throws java.sql.SQLException

Throws:: java.sql.SQLException

insert

public <ID> u.Optional<ID> insert()
                           throws java.sql.SQLException

Returns the generated key if it exists.

Returns:
Throws:: java.sql.SQLException

insert

public <ID> u.Optional<ID> insert(JdbcUtil.RowMapper<ID> autoGeneratedKeyExtractor)
                           throws java.sql.SQLException

Parameters:: keyExtractor -
Returns:
Throws:: java.sql.SQLException

insert

public <ID> u.Optional<ID> insert(JdbcUtil.BiRowMapper<ID> autoGeneratedKeyExtractor)
                           throws java.sql.SQLException

Throws:: java.sql.SQLException

batchInsert

public <ID> java.util.List<ID> batchInsert()
                                    throws java.sql.SQLException

Returns the generated key if it exists.

Returns:
Throws:: java.sql.SQLException

batchInsert

public <ID> java.util.List<ID> batchInsert(JdbcUtil.RowMapper<ID> autoGeneratedKeyExtractor)
                                    throws java.sql.SQLException

Parameters:: autoGeneratedKeyExtractor -
Returns:
Throws:: java.sql.SQLException

batchInsert

public <ID> java.util.List<ID> batchInsert(JdbcUtil.BiRowMapper<ID> autoGeneratedKeyExtractor)
                                    throws java.sql.SQLException

Parameters:: autoGeneratedKeyExtractor -
Returns:
Throws:: java.sql.SQLException

batchInsert

public <T,ID> java.util.List<ID> batchInsert(java.util.Collection<T> batchParameters,
                                             JdbcUtil.BiParametersSetter<? super Q,? super T> parametersSetter)
                                      throws java.sql.SQLException

All will be done in one batch. Exception may occur if the size of batchParameters is too big.

Parameters:: batchParameters -; parametersSetter -
Returns:
Throws:: java.sql.SQLException

batchInsert

public <T,ID> java.util.List<ID> batchInsert(java.util.Iterator<T> batchParameters,
                                             JdbcUtil.BiParametersSetter<? super Q,? super T> parametersSetter)
                                      throws java.sql.SQLException

All will be done in one batch. Exception may occur if the size of batchParameters is too big.

Parameters:: batchParameters -; parametersSetter -
Returns:
Throws:: java.sql.SQLException

update

public int update()
           throws java.sql.SQLException

Throws:: java.sql.SQLException

batchUpdate

public int[] batchUpdate()
                  throws java.sql.SQLException

Throws:: java.sql.SQLException

largeUpate

public long largeUpate()
                throws java.sql.SQLException

Throws:: java.sql.SQLException

largeBatchUpdate

public long[] largeBatchUpdate()
                        throws java.sql.SQLException

Throws:: java.sql.SQLException

batchUpdate

public <T> int batchUpdate(java.util.Collection<T> batchParameters,
                           JdbcUtil.BiParametersSetter<? super Q,? super T> parametersSetter)
                    throws java.sql.SQLException

All will be done in one batch. Exception may occur if the size of batchParameters is too big.

Parameters:: batchParameters -; parametersSetter -
Returns:
Throws:: java.sql.SQLException

batchUpdate

public <T> int batchUpdate(java.util.Iterator<T> batchParameters,
                           JdbcUtil.BiParametersSetter<? super Q,? super T> parametersSetter)
                    throws java.sql.SQLException

All will be done in one batch. Exception may occur if the size of batchParameters is too big.

Parameters:: batchParameters -; parametersSetter -
Returns:
Throws:: java.sql.SQLException

execute

public boolean execute()
                throws java.sql.SQLException

Throws:: java.sql.SQLException

executeThenApply

public <R> R executeThenApply(Try.Function<? super S,? extends R,java.sql.SQLException> getter)
                       throws java.sql.SQLException

Throws:: java.sql.SQLException

executeThenApply

public <R> R executeThenApply(Try.BiFunction<java.lang.Boolean,? super S,? extends R,java.sql.SQLException> getter)
                       throws java.sql.SQLException

Throws:: java.sql.SQLException

executeThenAccept

public void executeThenAccept(Try.Consumer<? super S,java.sql.SQLException> consumer)
                       throws java.sql.SQLException

Throws:: java.sql.SQLException

executeThenAccept

public void executeThenAccept(Try.BiConsumer<java.lang.Boolean,? super S,java.sql.SQLException> consumer)
                       throws java.sql.SQLException

Throws:: java.sql.SQLException

asyncApply
```
@Deprecated
public <R> ContinuableFuture<R> asyncApply(Try.Function<Q,R,java.sql.SQLException> func)
```
Deprecated. asyncExecutor.call(() -> JdbcUtil.prepareQuery(query)...query/update/execute(...) is recommended.

Parameters:

func -

Returns:

asyncApply

@Deprecated
public <R> ContinuableFuture<R> asyncApply(Try.Function<Q,R,java.sql.SQLException> func,
                                                        java.util.concurrent.Executor executor)

Deprecated. asyncExecutor.call(() -> JdbcUtil.prepareQuery(query)...query/update/execute(...) is recommended.

Parameters:: func -; executor -
Returns:

asyncAccept
```
@Deprecated
public ContinuableFuture<java.lang.Void> asyncAccept(Try.Consumer<Q,java.sql.SQLException> action)
```
Deprecated. asyncExecutor.call(() -> JdbcUtil.prepareQuery(query)...query/update/execute(...) is recommended.

Parameters:

action -

Returns:

asyncAccept

@Deprecated
public ContinuableFuture<java.lang.Void> asyncAccept(Try.Consumer<Q,java.sql.SQLException> action,
                                                                  java.util.concurrent.Executor executor)

Deprecated. asyncExecutor.call(() -> JdbcUtil.prepareQuery(query)...query/update/execute(...) is recommended.

Parameters:: action -; executor -
Returns:

close
```
public void close()
```
Specified by:

close in interface java.lang.AutoCloseable

Class JdbcUtil.PreparedCallableQuery

Method Summary

Methods inherited from class java.lang.Object

Method Detail

setNull

setNull

setBoolean

setBoolean

setByte

setByte

setShort

setShort

setInt

setInt

setLong

setLong

setFloat

setFloat

setDouble

setDouble

setBigDecimal

setString

setDate

setDate

setTime

setTime

setTimestamp

setTimestamp

setBytes

setAsciiStream

setAsciiStream

setBinaryStream

setBinaryStream

setCharacterStream

setCharacterStream

setNCharacterStream

setNCharacterStream

setBlob

setBlob

setBlob

setClob

setClob

setClob

setNClob

setNClob

setNClob

setURL

setSQLXML

setRowId

setObject

setObject

setObject

setParameters

setParameters

registerOutParameter

registerOutParameter

registerOutParameter

registerOutParameter

registerOutParameter

registerOutParameter

registerOutParameter

registerOutParameter

registerOutParameter

registerOutParameter

registerOutParameter

registerOutParameter

registerOutParameters

registerOutParameters

call

call

call

call

call

closeAfterExecution

closeAfterExecution

onClose

setNull

setNull

setBoolean

setBoolean