Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
/*
* Copyright (c) 2019, Haiyang Li.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.landawn.abacus.jdbc;
import java.io.InputStream;
import java.io.Reader;
import java.lang.reflect.Method;
import java.lang.reflect.Modifier;
import java.math.BigDecimal;
import java.math.BigInteger;
import java.net.URL;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.SQLType;
import java.sql.Timestamp;
import java.sql.Types;
import java.time.Instant;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.time.OffsetDateTime;
import java.time.ZonedDateTime;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Collection;
import java.util.HashSet;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Objects;
import java.util.Set;
import java.util.concurrent.Executor;
import java.util.function.Consumer;
import java.util.function.Predicate;
import com.landawn.abacus.annotation.Beta;
import com.landawn.abacus.annotation.LazyEvaluation;
import com.landawn.abacus.exception.DuplicatedResultException;
import com.landawn.abacus.jdbc.Jdbc.BiResultExtractor;
import com.landawn.abacus.jdbc.Jdbc.ResultExtractor;
import com.landawn.abacus.jdbc.Jdbc.RowConsumer;
import com.landawn.abacus.logging.Logger;
import com.landawn.abacus.logging.LoggerFactory;
import com.landawn.abacus.type.Type;
import com.landawn.abacus.type.TypeFactory;
import com.landawn.abacus.util.CheckedStream;
import com.landawn.abacus.util.ClassUtil;
import com.landawn.abacus.util.ContinuableFuture;
import com.landawn.abacus.util.DataSet;
import com.landawn.abacus.util.N;
import com.landawn.abacus.util.NoCachingNoUpdating.DisposableObjArray;
import com.landawn.abacus.util.Strings;
import com.landawn.abacus.util.Throwables;
import com.landawn.abacus.util.Tuple;
import com.landawn.abacus.util.Tuple.Tuple2;
import com.landawn.abacus.util.Tuple.Tuple3;
import com.landawn.abacus.util.u.Nullable;
import com.landawn.abacus.util.u.Optional;
import com.landawn.abacus.util.u.OptionalBoolean;
import com.landawn.abacus.util.u.OptionalByte;
import com.landawn.abacus.util.u.OptionalChar;
import com.landawn.abacus.util.u.OptionalDouble;
import com.landawn.abacus.util.u.OptionalFloat;
import com.landawn.abacus.util.u.OptionalInt;
import com.landawn.abacus.util.u.OptionalLong;
import com.landawn.abacus.util.u.OptionalShort;
/**
* Performance Tips:
*
Avoid unnecessary/repeated database calls.
*
Only fetch the columns you need or update the columns you want.
*
Index is the key point in a lot of database performance issues.
*
*
*
* The backed {@code PreparedStatement/CallableStatement} will be closed by default
* after any execution methods(which will trigger the backed {@code PreparedStatement/CallableStatement} to be executed, for example: get/query/queryForInt/Long/../findFirst/findOnlyOne/list/execute/...).
* except the {@code 'closeAfterExecution'} flag is set to {@code false} by calling {@code #closeAfterExecution(false)}.
*
*
* Generally, don't cache or reuse the instance of this class,
* except the {@code 'closeAfterExecution'} flag is set to {@code false} by calling {@code #closeAfterExecution(false)}.
*
*
* Remember: parameter/column index in {@code PreparedStatement/ResultSet} starts from 1, not 0.
*
* @param
* @param
*
* @see Connection
* @see Statement
* @see PreparedStatement
* @see ResultSet
*/
@SuppressWarnings("java:S1192")
public abstract class AbstractQuery> implements AutoCloseable {
static final Logger logger = LoggerFactory.getLogger(AbstractQuery.class);
static final Set> stmtParameterClasses = new HashSet<>();
static {
final Method[] methods = PreparedStatement.class.getDeclaredMethods();
for (final Method m : methods) {
if (Modifier.isPublic(m.getModifiers()) && m.getName().startsWith("set") && m.getParameterCount() == 2
&& m.getParameterTypes()[0].equals(int.class)) {
stmtParameterClasses.add(m.getParameterTypes()[1]);
}
}
final List> primitiveTypes = N.asList(boolean.class, char.class, byte.class, short.class, int.class, long.class, float.class, double.class);
for (final Class cls : primitiveTypes) {
stmtParameterClasses.add(cls);
stmtParameterClasses.add(ClassUtil.wrap(cls));
stmtParameterClasses.add(N.newArray(cls, 0).getClass());
stmtParameterClasses.add(N.newArray(ClassUtil.wrap(cls), 0).getClass());
}
stmtParameterClasses.remove(Object.class);
}
@SuppressWarnings("rawtypes")
static final Throwables.BiConsumer defaultAddBatchAction = (q, s) -> s.addBatch();
Throwables.BiConsumer addBatchAction = defaultAddBatchAction;
final Stmt stmt;
boolean isFetchDirectionSet = false;
boolean isBatch = false;
boolean isCloseAfterExecution = true;
boolean isClosed = false;
Runnable closeHandler;
AbstractQuery(final Stmt stmt) {
this.stmt = stmt;
}
// /**
// * It's designed to void try-catch.
// * This method should be called immediately after {@code JdbcUtil#prepareCallableQuery/SQLExecutor#prepareQuery}.
// *
// * @return
// */
// public Try tried() {
// assertNotClosed();
//
// return Try.of((Q) this);
// }
/**
* Sets the flag to close the statement after execution.
*
* @param closeAfterExecution If {@code true}, the statement will be closed after execution. Default is {@code true}.
* @return The current instance of the query.
* @throws IllegalStateException If the query is already closed.
*/
public This closeAfterExecution(final boolean closeAfterExecution) throws IllegalStateException {
assertNotClosed();
isCloseAfterExecution = closeAfterExecution;
return (This) this;
}
boolean isCloseAfterExecution() {
return isCloseAfterExecution;
}
/**
* Registers a task to be executed when this query is closed.
*
* @param closeHandler A task to execute after this {@code Query} is closed.
* @return The current instance of the query.
* @throws IllegalArgumentException If the provided closeHandler is {@code null}.
* @throws IllegalStateException If this query is already closed.
*/
@SuppressWarnings("hiding")
public This onClose(final Runnable closeHandler) throws IllegalArgumentException, IllegalStateException {
checkArgNotNull(closeHandler, s.closeHandler);
assertNotClosed();
if (this.closeHandler == null) {
this.closeHandler = closeHandler;
} else {
final Runnable tmp = this.closeHandler;
this.closeHandler = () -> {
try {
tmp.run();
} finally {
closeHandler.run();
}
};
}
return (This) this;
}
/**
* Sets {@code null} value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set to {@code null}, starting from 1.
* @param sqlType The SQL type code defined in {@link java.sql.Types}.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setNull(final int parameterIndex, final int sqlType) throws SQLException {
stmt.setNull(parameterIndex, sqlType);
return (This) this;
}
/**
* Sets {@code null} value for the specified parameter index with a specified SQL type and type name.
*
* @param parameterIndex The index of the parameter to set to {@code null}, starting from 1.
* @param sqlType The SQL type code defined in {@link java.sql.Types}.
* @param typeName The SQL type name.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setNull(final int parameterIndex, final int sqlType, final String typeName) throws SQLException {
stmt.setNull(parameterIndex, sqlType, typeName);
return (This) this;
}
/**
* Sets the boolean value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The boolean value to set.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setBoolean(final int parameterIndex, final boolean x) throws SQLException {
stmt.setBoolean(parameterIndex, x);
return (This) this;
}
/**
* Sets the boolean value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The boolean value to set, or {@code null} to set the parameter to SQL {@code NULL}.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setBoolean(final int parameterIndex, final Boolean x) throws SQLException {
if (x == null) {
stmt.setNull(parameterIndex, java.sql.Types.BOOLEAN);
} else {
stmt.setBoolean(parameterIndex, x);
}
return (This) this;
}
/**
* Sets the byte value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The byte value to set.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setByte(final int parameterIndex, final byte x) throws SQLException {
stmt.setByte(parameterIndex, x);
return (This) this;
}
/**
* Sets the byte value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The byte value to set, or {@code null} to set the parameter to SQL {@code NULL}.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setByte(final int parameterIndex, final Byte x) throws SQLException {
if (x == null) {
stmt.setNull(parameterIndex, java.sql.Types.TINYINT);
} else {
stmt.setByte(parameterIndex, x);
}
return (This) this;
}
/**
* Sets the byte value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The byte value to set, or {@code null} to use the default value.
* @param defaultValueForNull The default byte value to set if {@code x} is {@code null}.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setByte(final int parameterIndex, final Byte x, final byte defaultValueForNull) throws SQLException {
if (x == null) {
stmt.setByte(parameterIndex, defaultValueForNull);
} else {
stmt.setByte(parameterIndex, x);
}
return (This) this;
}
/**
* Sets the short value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The short value to set.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setShort(final int parameterIndex, final short x) throws SQLException {
stmt.setShort(parameterIndex, x);
return (This) this;
}
/**
* Sets the short value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The short value to set, or {@code null} to set the parameter to SQL {@code NULL}.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setShort(final int parameterIndex, final Short x) throws SQLException {
if (x == null) {
stmt.setNull(parameterIndex, java.sql.Types.SMALLINT);
} else {
stmt.setShort(parameterIndex, x);
}
return (This) this;
}
/**
* Sets the short value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The short value to set, or {@code null} to use the default value.
* @param defaultValueForNull The default short value to set if {@code x} is {@code null}.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setShort(final int parameterIndex, final Short x, final short defaultValueForNull) throws SQLException {
if (x == null) {
stmt.setShort(parameterIndex, defaultValueForNull);
} else {
stmt.setShort(parameterIndex, x);
}
return (This) this;
}
/**
* Sets the integer value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The integer value to set.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setInt(final int parameterIndex, final int x) throws SQLException {
stmt.setInt(parameterIndex, x);
return (This) this;
}
/**
* Sets the integer value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The integer value to set, or {@code null} to set the parameter to SQL {@code NULL}.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setInt(final int parameterIndex, final Integer x) throws SQLException {
if (x == null) {
stmt.setNull(parameterIndex, java.sql.Types.INTEGER);
} else {
stmt.setInt(parameterIndex, x);
}
return (This) this;
}
/**
* Sets the integer value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The integer value to set, or {@code null} to use the default value.
* @param defaultValueForNull The default integer value to set if {@code x} is {@code null}.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This setInt(final int parameterIndex, final Integer x, final int defaultValueForNull) throws SQLException {
if (x == null) {
stmt.setInt(parameterIndex, defaultValueForNull);
} else {
stmt.setInt(parameterIndex, x);
}
return (This) this;
}
// /**
// * Sets the int.
// *
// * @param parameterIndex
// * @param x
// * @return
// * @throws SQLException
// */
// @Beta
// public This setInt(final int parameterIndex, final String x) throws SQLException {
// if (Strings.isEmpty(x)) {
// stmt.setNull(parameterIndex, java.sql.Types.INTEGER);
// } else {
// boolean noException = false;
//
// try {
// stmt.setInt(parameterIndex, Numbers.toInt(x));
// noException = true;
// } finally {
// if (!noException) {
// close();
// }
// }
// }
//
// return (This) this;
// }
/**
* Sets the integer value for the specified parameter index using a character.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The character value to set as an integer.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
* @deprecated Generally, {@code char} should be saved as {@code String} in the database.
* @see #setString(int, char)
*/
@Deprecated
@Beta
public This setInt(final int parameterIndex, final char x) throws SQLException {
stmt.setInt(parameterIndex, x);
return (This) this;
}
/**
* Sets the integer value for the specified parameter index using a Character.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The Character value to set as an integer, or {@code null} to set the parameter to SQL {@code NULL}.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
* @deprecated Generally, {@code char} should be saved as {@code String} in the database.
* @see #setString(int, Character)
*/
@Deprecated
@Beta
public This setInt(final int parameterIndex, final Character x) throws SQLException {
if (x == null) {
stmt.setNull(parameterIndex, java.sql.Types.INTEGER);
} else {
stmt.setInt(parameterIndex, x);
}
return (This) this;
}
/**
* Sets the long value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The long value to set.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setLong(final int parameterIndex, final long x) throws SQLException {
stmt.setLong(parameterIndex, x);
return (This) this;
}
/**
* Sets the long value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The long value to set, or {@code null} to set the parameter to SQL {@code NULL}.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setLong(final int parameterIndex, final Long x) throws SQLException {
if (x == null) {
stmt.setNull(parameterIndex, java.sql.Types.BIGINT);
} else {
stmt.setLong(parameterIndex, x);
}
return (This) this;
}
/**
* Sets the long value for the specified parameter index.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The long value to set, or {@code null} to use the default value.
* @param defaultValueForNull The default long value to set if {@code x} is {@code null}.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This setLong(final int parameterIndex, final Long x, final long defaultValueForNull) throws SQLException {
if (x == null) {
stmt.setLong(parameterIndex, defaultValueForNull);
} else {
stmt.setLong(parameterIndex, x);
}
return (This) this;
}
// /**
// * Sets the long.
// *
// * @param parameterIndex
// * @param x
// * @return
// * @throws SQLException
// */
// @Beta
// public This setLong(final int parameterIndex, final String x) throws SQLException {
// if (Strings.isEmpty(x)) {
// stmt.setNull(parameterIndex, java.sql.Types.BIGINT);
// } else {
// boolean noException = false;
//
// try {
// stmt.setLong(parameterIndex, Numbers.toLong(x));
// noException = true;
// } finally {
// if (!noException) {
// close();
// }
// }
// }
//
// return (This) this;
// }
/**
* Sets the long value for the specified parameter index using a BigInteger.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The BigInteger value to set, or {@code null} to set the parameter to SQL {@code NULL}.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setLong(final int parameterIndex, final BigInteger x) throws SQLException {
if (x == null) {
stmt.setNull(parameterIndex, java.sql.Types.BIGINT);
} else {
boolean noException = false;
try {
stmt.setLong(parameterIndex, x.longValueExact());
noException = true;
} finally {
if (!noException) {
close();
}
}
}
return (This) this;
}
/**
* Sets the float.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setFloat(final int parameterIndex, final float x) throws SQLException {
stmt.setFloat(parameterIndex, x);
return (This) this;
}
/**
* Sets the float.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setFloat(final int parameterIndex, final Float x) throws SQLException {
if (x == null) {
stmt.setNull(parameterIndex, java.sql.Types.FLOAT);
} else {
stmt.setFloat(parameterIndex, x);
}
return (This) this;
}
/**
* Sets the float.
*
* @param parameterIndex
* @param x
* @param defaultValueForNull
* @return
* @throws SQLException
*/
public This setFloat(final int parameterIndex, final Float x, final float defaultValueForNull) throws SQLException {
if (x == null) {
stmt.setFloat(parameterIndex, defaultValueForNull);
} else {
stmt.setFloat(parameterIndex, x);
}
return (This) this;
}
// /**
// * Sets the float.
// *
// * @param parameterIndex
// * @param x
// * @return
// * @throws SQLException
// */
// public This setFloat(final int parameterIndex, final String x) throws SQLException {
// if (Strings.isEmpty(x)) {
// stmt.setNull(parameterIndex, java.sql.Types.FLOAT);
// } else {
// boolean noException = false;
//
// try {
// stmt.setFloat(parameterIndex, Numbers.toFloat(x));
// noException = true;
// } finally {
// if (!noException) {
// close();
// }
// }
//
// }
//
// return (This) this;
// }
/**
* Sets the double.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setDouble(final int parameterIndex, final double x) throws SQLException {
stmt.setDouble(parameterIndex, x);
return (This) this;
}
/**
* Sets the double.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setDouble(final int parameterIndex, final Double x) throws SQLException {
if (x == null) {
stmt.setNull(parameterIndex, java.sql.Types.DOUBLE);
} else {
stmt.setDouble(parameterIndex, x);
}
return (This) this;
}
/**
* Sets the double.
*
* @param parameterIndex
* @param x
* @param defaultValueForNull
* @return
* @throws SQLException
*/
public This setDouble(final int parameterIndex, final Double x, final double defaultValueForNull) throws SQLException {
if (x == null) {
stmt.setDouble(parameterIndex, defaultValueForNull);
} else {
stmt.setDouble(parameterIndex, x);
}
return (This) this;
}
// /**
// * Sets the double.
// *
// * @param parameterIndex
// * @param x
// * @return
// * @throws SQLException
// */
// public This setDouble(final int parameterIndex, final String x) throws SQLException {
// if (Strings.isEmpty(x)) {
// stmt.setNull(parameterIndex, java.sql.Types.DOUBLE);
// } else {
// boolean noException = false;
//
// try {
// stmt.setDouble(parameterIndex, Numbers.toDouble(x));
// noException = true;
// } finally {
// if (!noException) {
// close();
// }
// }
//
// }
//
// return (This) this;
// }
/**
* Sets the big decimal.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setBigDecimal(final int parameterIndex, final BigDecimal x) throws SQLException {
stmt.setBigDecimal(parameterIndex, x);
return (This) this;
}
/**
* Sets the BigInteger.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setBigDecimal(final int parameterIndex, final BigInteger x) throws SQLException {
if (x == null) {
stmt.setNull(parameterIndex, Types.DECIMAL);
} else {
stmt.setBigDecimal(parameterIndex, new BigDecimal(x));
}
return (This) this;
}
/**
* Sets the BigInteger value for the specified parameter index as a String. It's same as {@code setString(int, BigInteger)}.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The BigInteger value to set, or {@code null} to set the parameter to SQL {@code NULL}.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
* @see #setString(int, BigInteger)
*/
@Beta
public This setBigIntegerAsString(final int parameterIndex, final BigInteger x) throws SQLException {
return setString(parameterIndex, x);
}
/**
* Sets the string.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setString(final int parameterIndex, final String x) throws SQLException {
stmt.setString(parameterIndex, x);
return (This) this;
}
/**
* Sets the string.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setString(final int parameterIndex, final CharSequence x) throws SQLException {
stmt.setString(parameterIndex, x == null ? null : x.toString());
return (This) this;
}
/**
*
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setString(final int parameterIndex, final char x) throws SQLException {
stmt.setString(parameterIndex, String.valueOf(x));
return (This) this;
}
/**
* Sets the String.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setString(final int parameterIndex, final Character x) throws SQLException {
stmt.setString(parameterIndex, x == null ? null : String.valueOf(x));
return (This) this;
}
/**
* Sets the BigInteger value for the specified parameter index as a String. It's same as {@code setBigIntegerAsString(int, BigInteger)}.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The BigInteger value to set, or {@code null} to set the parameter to SQL {@code NULL}.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
* @see #setBigIntegerAsString(int, BigInteger)
*/
@Beta
public This setString(final int parameterIndex, final BigInteger x) throws SQLException {
if (x == null) {
stmt.setNull(parameterIndex, Types.VARCHAR);
} else {
stmt.setString(parameterIndex, x.toString(10));
}
return (This) this;
}
/**
* Sets the String.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setNString(final int parameterIndex, final String x) throws SQLException {
stmt.setNString(parameterIndex, x);
return (This) this;
}
/**
* Sets the String.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setNString(final int parameterIndex, final CharSequence x) throws SQLException {
stmt.setNString(parameterIndex, x == null ? null : x.toString());
return (This) this;
}
/**
* Sets the date.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setDate(final int parameterIndex, final java.sql.Date x) throws SQLException {
stmt.setDate(parameterIndex, x);
return (This) this;
}
/**
* Sets the date.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setDate(final int parameterIndex, final java.util.Date x) throws SQLException {
stmt.setDate(parameterIndex, x == null ? null : x instanceof java.sql.Date ? (java.sql.Date) x : new java.sql.Date(x.getTime()));
return (This) this;
}
/**
* Sets the date.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @param cal
* @return
* @throws SQLException
*/
public This setDate(final int parameterIndex, final java.sql.Date x, final Calendar cal) throws SQLException {
stmt.setDate(parameterIndex, x, cal);
return (This) this;
}
/**
* Sets the date.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setDate(final int parameterIndex, final LocalDate x) throws SQLException {
stmt.setDate(parameterIndex, x == null ? null : java.sql.Date.valueOf(x));
return (This) this;
}
/**
* Sets the time.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setTime(final int parameterIndex, final java.sql.Time x) throws SQLException {
stmt.setTime(parameterIndex, x);
return (This) this;
}
/**
* Sets the time.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setTime(final int parameterIndex, final java.util.Date x) throws SQLException {
stmt.setTime(parameterIndex, x == null ? null : x instanceof java.sql.Time ? (java.sql.Time) x : new java.sql.Time(x.getTime()));
return (This) this;
}
/**
* Sets the time.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @param cal
* @return
* @throws SQLException
*/
public This setTime(final int parameterIndex, final java.sql.Time x, final Calendar cal) throws SQLException {
stmt.setTime(parameterIndex, x, cal);
return (This) this;
}
/**
* Sets the time.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setTime(final int parameterIndex, final LocalTime x) throws SQLException {
stmt.setTime(parameterIndex, x == null ? null : java.sql.Time.valueOf(x));
return (This) this;
}
/**
* Sets the timestamp.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setTimestamp(final int parameterIndex, final java.sql.Timestamp x) throws SQLException {
stmt.setTimestamp(parameterIndex, x);
return (This) this;
}
/**
* Sets the timestamp.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setTimestamp(final int parameterIndex, final java.util.Date x) throws SQLException {
stmt.setTimestamp(parameterIndex, x == null ? null : x instanceof java.sql.Timestamp ? (java.sql.Timestamp) x : new java.sql.Timestamp(x.getTime()));
return (This) this;
}
/**
* Sets the timestamp.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @param cal
* @return
* @throws SQLException
*/
public This setTimestamp(final int parameterIndex, final java.sql.Timestamp x, final Calendar cal) throws SQLException {
stmt.setTimestamp(parameterIndex, x, cal);
return (This) this;
}
/**
* Sets the timestamp.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setTimestamp(final int parameterIndex, final LocalDateTime x) throws SQLException {
stmt.setTimestamp(parameterIndex, x == null ? null : Timestamp.valueOf(x));
return (This) this;
}
/**
* Sets the timestamp.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setTimestamp(final int parameterIndex, final ZonedDateTime x) throws SQLException {
stmt.setTimestamp(parameterIndex, x == null ? null : Timestamp.from(x.toInstant()));
return (This) this;
}
/**
* Sets the timestamp.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setTimestamp(final int parameterIndex, final OffsetDateTime x) throws SQLException {
stmt.setTimestamp(parameterIndex, x == null ? null : Timestamp.from(x.toInstant()));
return (This) this;
}
/**
* Sets the timestamp.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setTimestamp(final int parameterIndex, final Instant x) throws SQLException {
stmt.setTimestamp(parameterIndex, x == null ? null : Timestamp.from(x));
return (This) this;
}
/**
* Sets the bytes.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setBytes(final int parameterIndex, final byte[] x) throws SQLException {
stmt.setBytes(parameterIndex, x);
return (This) this;
}
/**
* Sets the ascii stream.
*
* @param parameterIndex
* @param inputStream
* @return
* @throws SQLException
*/
public This setAsciiStream(final int parameterIndex, final InputStream inputStream) throws SQLException {
stmt.setAsciiStream(parameterIndex, inputStream);
return (This) this;
}
/**
* Sets the ascii stream.
*
* @param parameterIndex
* @param inputStream
* @param length
* @return
* @throws SQLException
*/
public This setAsciiStream(final int parameterIndex, final InputStream inputStream, final int length) throws SQLException {
stmt.setAsciiStream(parameterIndex, inputStream, length);
return (This) this;
}
/**
* Sets the ascii stream.
*
* @param parameterIndex
* @param inputStream
* @param length
* @return
* @throws SQLException
*/
public This setAsciiStream(final int parameterIndex, final InputStream inputStream, final long length) throws SQLException {
stmt.setAsciiStream(parameterIndex, inputStream, length);
return (This) this;
}
/**
* Sets the binary stream.
*
* @param parameterIndex
* @param inputStream
* @return
* @throws SQLException
*/
public This setBinaryStream(final int parameterIndex, final InputStream inputStream) throws SQLException {
stmt.setBinaryStream(parameterIndex, inputStream);
return (This) this;
}
/**
* Sets the binary stream.
*
* @param parameterIndex
* @param inputStream
* @param length
* @return
* @throws SQLException
*/
public This setBinaryStream(final int parameterIndex, final InputStream inputStream, final int length) throws SQLException {
stmt.setBinaryStream(parameterIndex, inputStream, length);
return (This) this;
}
/**
* Sets the binary stream.
*
* @param parameterIndex
* @param inputStream
* @param length
* @return
* @throws SQLException
*/
public This setBinaryStream(final int parameterIndex, final InputStream inputStream, final long length) throws SQLException {
stmt.setBinaryStream(parameterIndex, inputStream, length);
return (This) this;
}
/**
* Sets the character stream.
*
* @param parameterIndex
* @param reader
* @return
* @throws SQLException
*/
public This setCharacterStream(final int parameterIndex, final Reader reader) throws SQLException {
stmt.setCharacterStream(parameterIndex, reader);
return (This) this;
}
/**
* Sets the character stream.
*
* @param parameterIndex
* @param reader
* @param length
* @return
* @throws SQLException
*/
public This setCharacterStream(final int parameterIndex, final Reader reader, final int length) throws SQLException {
stmt.setCharacterStream(parameterIndex, reader, length);
return (This) this;
}
/**
* Sets the character stream.
*
* @param parameterIndex
* @param reader
* @param length
* @return
* @throws SQLException
*/
public This setCharacterStream(final int parameterIndex, final Reader reader, final long length) throws SQLException {
stmt.setCharacterStream(parameterIndex, reader, length);
return (This) this;
}
/**
* Sets the N character stream.
*
* @param parameterIndex
* @param reader
* @return
* @throws SQLException
*/
public This setNCharacterStream(final int parameterIndex, final Reader reader) throws SQLException {
stmt.setNCharacterStream(parameterIndex, reader);
return (This) this;
}
/**
* Sets the N character stream.
*
* @param parameterIndex
* @param reader
* @param length
* @return
* @throws SQLException
*/
public This setNCharacterStream(final int parameterIndex, final Reader reader, final long length) throws SQLException {
stmt.setNCharacterStream(parameterIndex, reader, length);
return (This) this;
}
/**
* Sets the blob.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setBlob(final int parameterIndex, final java.sql.Blob x) throws SQLException {
stmt.setBlob(parameterIndex, x);
return (This) this;
}
/**
* Sets the blob.
*
* @param parameterIndex
* @param inputStream
* @return
* @throws SQLException
*/
public This setBlob(final int parameterIndex, final InputStream inputStream) throws SQLException {
stmt.setBlob(parameterIndex, inputStream);
return (This) this;
}
/**
* Sets the blob.
*
* @param parameterIndex
* @param inputStream
* @param length
* @return
* @throws SQLException
*/
public This setBlob(final int parameterIndex, final InputStream inputStream, final long length) throws SQLException {
stmt.setBlob(parameterIndex, inputStream, length);
return (This) this;
}
/**
* Sets the clob.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setClob(final int parameterIndex, final java.sql.Clob x) throws SQLException {
stmt.setClob(parameterIndex, x);
return (This) this;
}
/**
* Sets the clob.
*
* @param parameterIndex
* @param reader
* @return
* @throws SQLException
*/
public This setClob(final int parameterIndex, final Reader reader) throws SQLException {
stmt.setClob(parameterIndex, reader);
return (This) this;
}
/**
* Sets the clob.
*
* @param parameterIndex
* @param reader
* @param length
* @return
* @throws SQLException
*/
public This setClob(final int parameterIndex, final Reader reader, final long length) throws SQLException {
stmt.setClob(parameterIndex, reader, length);
return (This) this;
}
/**
* Sets the N clob.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setNClob(final int parameterIndex, final java.sql.NClob x) throws SQLException {
stmt.setNClob(parameterIndex, x);
return (This) this;
}
/**
* Sets the N clob.
*
* @param parameterIndex
* @param reader
* @return
* @throws SQLException
*/
public This setNClob(final int parameterIndex, final Reader reader) throws SQLException {
stmt.setNClob(parameterIndex, reader);
return (This) this;
}
/**
* Sets the N clob.
*
* @param parameterIndex
* @param reader
* @param length
* @return
* @throws SQLException
*/
public This setNClob(final int parameterIndex, final Reader reader, final long length) throws SQLException {
stmt.setNClob(parameterIndex, reader, length);
return (This) this;
}
/**
* Sets the URL.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setURL(final int parameterIndex, final URL x) throws SQLException {
stmt.setURL(parameterIndex, x);
return (This) this;
}
/**
* Sets the array.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setArray(final int parameterIndex, final java.sql.Array x) throws SQLException {
stmt.setArray(parameterIndex, x);
return (This) this;
}
/**
* Sets the SQLXML.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setSQLXML(final int parameterIndex, final java.sql.SQLXML x) throws SQLException {
stmt.setSQLXML(parameterIndex, x);
return (This) this;
}
/**
* Sets the ref.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setRef(final int parameterIndex, final java.sql.Ref x) throws SQLException {
stmt.setRef(parameterIndex, x);
return (This) this;
}
/**
* Sets the row id.
*
* @param parameterIndex
* @param x
* @return
* @throws SQLException
*/
public This setRowId(final int parameterIndex, final java.sql.RowId x) throws SQLException {
stmt.setRowId(parameterIndex, x);
return (This) this;
}
/**
* Sets the object.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @return
* @throws SQLException
*/
public This setObject(final int parameterIndex, final Object x) throws SQLException {
if (x == null) {
stmt.setObject(parameterIndex, x);
} else {
N.typeOf(x.getClass()).set(stmt, parameterIndex, x);
}
return (This) this;
}
/**
* Sets the object.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @param sqlType
* @return
* @throws SQLException
* @see java.sql.Types
*/
public This setObject(final int parameterIndex, final Object x, final int sqlType) throws SQLException {
stmt.setObject(parameterIndex, x, sqlType);
return (This) this;
}
/**
* Sets the object.
*
* @param parameterIndex starts from 1, not 0.
* @param x
* @param sqlType
* @param scaleOrLength
* @return
* @throws SQLException
* @see java.sql.Types
*/
public This setObject(final int parameterIndex, final Object x, final int sqlType, final int scaleOrLength) throws SQLException {
stmt.setObject(parameterIndex, x, sqlType, scaleOrLength);
return (This) this;
}
/**
* Sets the object.
*
* @param parameterIndex
* @param x
* @param sqlType
* @return
* @throws SQLException
*/
public This setObject(final int parameterIndex, final Object x, final SQLType sqlType) throws SQLException {
stmt.setObject(parameterIndex, x, sqlType);
return (This) this;
}
/**
* Sets the object for the specified parameter index using the provided SQL type and scale or length.
*
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The object to set.
* @param sqlType The SQL type of the object.
* @param scaleOrLength The scale or length of the object.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
public This setObject(final int parameterIndex, final Object x, final SQLType sqlType, final int scaleOrLength) throws SQLException {
stmt.setObject(parameterIndex, x, sqlType, scaleOrLength);
return (This) this;
}
/**
* Sets the object for the specified parameter index using the provided type.
*
* @param The type of the object to set.
* @param parameterIndex The index of the parameter to set, starting from 1.
* @param x The object to set.
* @param type The type of the object.
* @return The current instance of the query.
* @throws IllegalArgumentException If the provided type is invalid.
* @throws SQLException If a database access error occurs.
*/
public This setObject(final int parameterIndex, final T x, final Type type) throws IllegalArgumentException, SQLException {
type.set(stmt, parameterIndex, x);
return (This) this;
}
// public This setParameter(final Jdbc.ParametersSetter paramSetter) throws SQLException {
// checkArgNotNull(paramSetter, "paramsSetter");
//
// boolean noException = false;
//
// try {
// paramSetter.accept(stmt);
//
// noException = true;
// } finally {
// if (!noException) {
// close();
// }
// }
//
// return (This) this;
// }
//
// public This setParameter(final T parameter, final Jdbc.BiParametersSetter paramSetter) throws SQLException {
// checkArgNotNull(paramSetter, "paramsSetter");
//
// boolean noException = false;
//
// try {
// paramSetter.accept(stmt, parameter);
//
// noException = true;
// } finally {
// if (!noException) {
// close();
// }
// }
//
// return (This) this;
// }
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param param1 The first parameter to set.
* @param param2 The second parameter to set.
* @return The current instance of the query.
* @throws IllegalArgumentException If an illegal argument is provided.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final String param1, final String param2) throws SQLException {
stmt.setString(1, param1);
stmt.setString(2, param2);
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param param1 The first parameter to set.
* @param param2 The second parameter to set.
* @param param3 The third parameter to set.
* @return The current instance of the query.
* @throws IllegalArgumentException If an illegal argument is provided.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final String param1, final String param2, final String param3) throws SQLException {
stmt.setString(1, param1);
stmt.setString(2, param2);
stmt.setString(3, param3);
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param param1 The first parameter to set.
* @param param2 The second parameter to set.
* @param param3 The third parameter to set.
* @param param4 The fourth parameter to set.
* @return The current instance of the query.
* @throws IllegalArgumentException If an illegal argument is provided.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final String param1, final String param2, final String param3, final String param4) throws SQLException {
stmt.setString(1, param1);
stmt.setString(2, param2);
stmt.setString(3, param3);
stmt.setString(4, param4);
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param param1 The first parameter to set.
* @param param2 The second parameter to set.
* @param param3 The third parameter to set.
* @param param4 The fourth parameter to set.
* @param param5 The fifth parameter to set.
* @return The current instance of the query.
* @throws IllegalArgumentException If an illegal argument is provided.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final String param1, final String param2, final String param3, final String param4, final String param5) throws SQLException {
stmt.setString(1, param1);
stmt.setString(2, param2);
stmt.setString(3, param3);
stmt.setString(4, param4);
stmt.setString(5, param5);
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param param1 The first parameter to set.
* @param param2 The second parameter to set.
* @param param3 The third parameter to set.
* @param param4 The fourth parameter to set.
* @param param5 The fifth parameter to set.
* @param param6 The sixth parameter to set.
* @return The current instance of the query.
* @throws IllegalArgumentException If an illegal argument is provided.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final String param1, final String param2, final String param3, final String param4, final String param5, final String param6)
throws SQLException {
stmt.setString(1, param1);
stmt.setString(2, param2);
stmt.setString(3, param3);
stmt.setString(4, param4);
stmt.setString(5, param5);
stmt.setString(6, param6);
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param param1 The first parameter to set.
* @param param2 The second parameter to set.
* @param param3 The third parameter to set.
* @param param4 The fourth parameter to set.
* @param param5 The fifth parameter to set.
* @param param6 The sixth parameter to set.
* @param param7 The seventh parameter to set.
* @return The current instance of the query.
* @throws IllegalArgumentException If an illegal argument is provided.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final String param1, final String param2, final String param3, final String param4, final String param5, final String param6,
final String param7) throws SQLException {
stmt.setString(1, param1);
stmt.setString(2, param2);
stmt.setString(3, param3);
stmt.setString(4, param4);
stmt.setString(5, param5);
stmt.setString(6, param6);
stmt.setString(7, param7);
return (This) this;
}
// /**
// * Sets the parameters.
// *
// * @param param1
// * @param param2
// * @return
// * @throws SQLException
// * @deprecated to void error: java ambiguous method call with other {@code setParameters} methods
// */
// @Deprecated
// public This setParameters(final Object param1, final Object param2) throws SQLException {
// setObject(1, param1);
// setObject(2, param2);
//
// return (This) this;
// }
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param param1 The first parameter to set.
* @param param2 The second parameter to set.
* @param param3 The third parameter to set.
* @return The current instance of the query.
* @throws IllegalArgumentException If an illegal argument is provided.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final Object param1, final Object param2, final Object param3) throws SQLException {
setObject(1, param1);
setObject(2, param2);
setObject(3, param3);
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param param1 The first parameter to set.
* @param param2 The second parameter to set.
* @param param3 The third parameter to set.
* @param param4 The fourth parameter to set.
* @return The current instance of the query.
* @throws IllegalArgumentException If an illegal argument is provided.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final Object param1, final Object param2, final Object param3, final Object param4) throws SQLException {
setObject(1, param1);
setObject(2, param2);
setObject(3, param3);
setObject(4, param4);
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param param1 The first parameter to set.
* @param param2 The second parameter to set.
* @param param3 The third parameter to set.
* @param param4 The fourth parameter to set.
* @param param5 The fifth parameter to set.
* @return The current instance of the query.
* @throws IllegalArgumentException If an illegal argument is provided.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final Object param1, final Object param2, final Object param3, final Object param4, final Object param5) throws SQLException {
setObject(1, param1);
setObject(2, param2);
setObject(3, param3);
setObject(4, param4);
setObject(5, param5);
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param param1 The first parameter to set.
* @param param2 The second parameter to set.
* @param param3 The third parameter to set.
* @param param4 The fourth parameter to set.
* @param param5 The fifth parameter to set.
* @param param6 The sixth parameter to set.
* @return The current instance of the query.
* @throws IllegalArgumentException If an illegal argument is provided.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final Object param1, final Object param2, final Object param3, final Object param4, final Object param5, final Object param6)
throws SQLException {
setObject(1, param1);
setObject(2, param2);
setObject(3, param3);
setObject(4, param4);
setObject(5, param5);
setObject(6, param6);
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param param1 The first parameter to set.
* @param param2 The second parameter to set.
* @param param3 The third parameter to set.
* @param param4 The fourth parameter to set.
* @param param5 The fifth parameter to set.
* @param param6 The sixth parameter to set.
* @param param7 The seventh parameter to set.
* @return The current instance of the query.
* @throws IllegalArgumentException If an illegal argument is provided.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final Object param1, final Object param2, final Object param3, final Object param4, final Object param5, final Object param6,
final Object param7) throws SQLException {
setObject(1, param1);
setObject(2, param2);
setObject(3, param3);
setObject(4, param4);
setObject(5, param5);
setObject(6, param6);
setObject(7, param7);
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param param1 The first parameter to set.
* @param param2 The second parameter to set.
* @param param3 The third parameter to set.
* @param param4 The fourth parameter to set.
* @param param5 The fifth parameter to set.
* @param param6 The sixth parameter to set.
* @param param7 The seventh parameter to set.
* @param param8 The eighth parameter to set.
* @return The current instance of the query.
* @throws IllegalArgumentException If an illegal argument is provided.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final Object param1, final Object param2, final Object param3, final Object param4, final Object param5, final Object param6,
final Object param7, final Object param8) throws SQLException {
setObject(1, param1);
setObject(2, param2);
setObject(3, param3);
setObject(4, param4);
setObject(5, param5);
setObject(6, param6);
setObject(7, param7);
setObject(8, param8);
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param param1 The first parameter to set.
* @param param2 The second parameter to set.
* @param param3 The third parameter to set.
* @param param4 The fourth parameter to set.
* @param param5 The fifth parameter to set.
* @param param6 The sixth parameter to set.
* @param param7 The seventh parameter to set.
* @param param8 The eighth parameter to set.
* @param param9 The ninth parameter to set.
* @return The current instance of the query.
* @throws IllegalArgumentException If an illegal argument is provided.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final Object param1, final Object param2, final Object param3, final Object param4, final Object param5, final Object param6,
final Object param7, final Object param8, final Object param9) throws IllegalArgumentException, SQLException {
setObject(1, param1);
setObject(2, param2);
setObject(3, param3);
setObject(4, param4);
setObject(5, param5);
setObject(6, param6);
setObject(7, param7);
setObject(8, param8);
setObject(9, param9);
return (This) this;
}
// public This setParameters(final T parameters, final Throwables.TriConsumer paramsSetter)
// throws SQLException {
// checkArgNotNull(paramsSetter, "paramsSetter");
//
// boolean noException = false;
//
// try {
// paramsSetter.accept((This) this, stmt, parameters);
//
// noException = true;
// } finally {
// if (noException == false) {
// close();
// }
// }
//
// return (This) this;
// }
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param parameters The array of parameters to set.
* @return The current instance of the query.
* @throws IllegalArgumentException if specified {@code parameters} is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final int[] parameters) throws IllegalArgumentException, SQLException {
return settParameters(1, parameters);
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param parameters The array of parameters to set.
* @return The current instance of the query.
* @throws IllegalArgumentException if specified {@code parameters} is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final long[] parameters) throws IllegalArgumentException, SQLException {
return settParameters(1, parameters);
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param parameters The array of parameters to set.
* @return The current instance of the query.
* @throws IllegalArgumentException if specified {@code parameters} is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final String[] parameters) throws IllegalArgumentException, SQLException {
return settParameters(1, parameters);
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param parameters The array of parameters to set.
* @return The current instance of the query.
* @throws IllegalArgumentException if specified {@code parameters} is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final T[] parameters) throws IllegalArgumentException, SQLException {
return settParameters(1, parameters);
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param parameters The array of parameters to set.
* @return The current instance of the query.
* @throws IllegalArgumentException if specified {@code parameters} is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final Collection parameters) throws IllegalArgumentException, SQLException {
return settParameters(1, parameters);
}
/**
* Sets the parameters for the prepared statement starting from index {@code 1}.
*
* @param parameters The array of parameters to set.
* @return The current instance of the query.
* @throws IllegalArgumentException if specified {@code parameters} or {@code type} is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final Collection parameters, final Class type) throws IllegalArgumentException, SQLException {
return settParameters(1, parameters, type);
}
/**
* Sets the parameters for the prepared statement using the provided parameters setter.
*
* @param paramsSetter The parameters setter to set the parameters.
* @return The current instance of the query.
* @throws IllegalArgumentException If the provided parameters setter is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final Jdbc.ParametersSetter paramsSetter) throws IllegalArgumentException, SQLException {
checkArgNotNull(paramsSetter, s.paramsSetter);
boolean noException = false;
try {
paramsSetter.accept(stmt);
noException = true;
} finally {
if (!noException) {
close();
}
}
return (This) this;
}
// /**
// *
// * @param paramsSetter
// * @return
// * @throws SQLException
// */
// public This setParameters(final BiParametersSetter paramsSetter) throws SQLException {
// checkArgNotNull(paramsSetter, "paramsSetter");
//
// boolean noException = false;
//
// try {
// paramsSetter.accept((This) this, stmt);
//
// noException = true;
// } finally {
// if (noException == false) {
// close();
// }
// }
//
// return (This) this;
// }
/**
* Sets the parameters for the prepared statement using the provided parameters setter.
*
* @param The type of the parameters.
* @param parameters The parameters to set.
* @param paramsSetter The parameters setter to set the parameters.
* @return The current instance of the query.
* @throws IllegalArgumentException If the provided parameters setter is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public This setParameters(final T parameters, final Jdbc.BiParametersSetter paramsSetter)
throws IllegalArgumentException, SQLException {
checkArgNotNull(paramsSetter, s.paramsSetter);
boolean noException = false;
try {
paramsSetter.accept(stmt, parameters);
noException = true;
} finally {
if (!noException) {
close();
}
}
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from the specified index.
*
* @param startParameterIndex The starting index for the parameters.
* @param parameters The array of integer parameters to set.
* @return The current instance of the query.
* @throws IllegalArgumentException if specified {@code parameters} is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public This settParameters(int startParameterIndex, final int[] parameters) throws IllegalArgumentException, SQLException {
checkArgNotNull(parameters, s.parameters);
for (final int param : parameters) {
stmt.setInt(startParameterIndex++, param);
}
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from the specified index.
*
* @param startParameterIndex The starting index for the parameters.
* @param parameters The array of integer parameters to set.
* @return The current instance of the query.
* @throws IllegalArgumentException if specified {@code parameters} is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public This settParameters(int startParameterIndex, final long[] parameters) throws IllegalArgumentException, SQLException {
checkArgNotNull(parameters, s.parameters);
for (final long param : parameters) {
stmt.setLong(startParameterIndex++, param);
}
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from the specified index.
*
* @param startParameterIndex The starting index for the parameters.
* @param parameters The array of integer parameters to set.
* @return The current instance of the query.
* @throws IllegalArgumentException if specified {@code parameters} is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public This settParameters(int startParameterIndex, final String[] parameters) throws IllegalArgumentException, SQLException {
checkArgNotNull(parameters, s.parameters);
for (final String param : parameters) {
stmt.setString(startParameterIndex++, param);
}
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from the specified index.
*
* @param startParameterIndex The starting index for the parameters.
* @param parameters The array of integer parameters to set.
* @return The current instance of the query.
* @throws IllegalArgumentException if specified {@code parameters} is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public This settParameters(int startParameterIndex, final T[] parameters) throws IllegalArgumentException, SQLException {
checkArgNotNull(parameters, s.parameters);
final Class componentType = parameters.getClass().getComponentType();
if (stmtParameterClasses.contains(componentType)) {
final Type eleType = N.typeOf(componentType);
for (final T param : parameters) {
eleType.set(stmt, startParameterIndex++, param);
}
} else {
for (final Object param : parameters) {
setObject(startParameterIndex++, param);
}
}
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from the specified index.
*
* @param startParameterIndex The starting index for the parameters.
* @param parameters The array of integer parameters to set.
* @return The current instance of the query.
* @throws IllegalArgumentException if specified {@code parameters} is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public This settParameters(int startParameterIndex, final Collection parameters) throws IllegalArgumentException, SQLException {
checkArgNotNull(parameters, s.parameters);
for (final Object param : parameters) {
setObject(startParameterIndex++, param);
}
return (This) this;
}
/**
* Sets the parameters for the prepared statement starting from the specified index.
*
* @param startParameterIndex The starting index for the parameters.
* @param parameters The array of integer parameters to set.
* @return The current instance of the query.
* @throws IllegalArgumentException if specified {@code parameters} or {@code type} is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public This settParameters(int startParameterIndex, final Collection parameters, final Class type)
throws IllegalArgumentException, SQLException {
checkArgNotNull(parameters, s.parameters);
checkArgNotNull(type, s.type);
final Type eleType = N.typeOf(type);
for (final T param : parameters) {
eleType.set(stmt, startParameterIndex++, param);
}
return (This) this;
}
// /**
// *
// * @param paramsSetter
// * @return
// * @throws SQLException
// */
// public This setParameters(final BiParametersSetter paramsSetter) throws SQLException {
// checkArgNotNull(paramsSetter, "paramsSetter");
//
// boolean noException = false;
//
// try {
// paramsSetter.accept((This) this, stmt);
//
// noException = true;
// } finally {
// if (noException == false) {
// close();
// }
// }
//
// return (This) this;
// }
// public This setParameters(final T parameters, final Throwables.TriConsumer paramsSetter)
// throws SQLException {
// checkArgNotNull(paramsSetter, "paramsSetter");
//
// boolean noException = false;
//
// try {
// paramsSetter.accept((This) this, stmt, parameters);
//
// noException = true;
// } finally {
// if (noException == false) {
// close();
// }
// }
//
// return (This) this;
// }
/**
* Sets the parameters for the prepared statement using the provided parameters setter.
*
* @param paramsSetter The parameters setter to set the parameters.
* @return The current instance of the query.
* @throws IllegalArgumentException If the provided parameters setter is {@code null}.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This settParameters(final Jdbc.ParametersSetter paramsSetter) throws IllegalArgumentException, SQLException {
checkArgNotNull(paramsSetter, s.paramsSetter);
boolean noException = false;
try {
paramsSetter.accept((This) this);
noException = true;
} finally {
if (!noException) {
close();
}
}
return (This) this;
}
/**
* Sets the parameters for the prepared statement using the provided parameters setter.
*
* @param The type of the parameters.
* @param parameters The parameters to set.
* @param paramsSetter The parameters setter to set the parameters.
* @return The current instance of the query.
* @throws IllegalArgumentException If the provided parameters setter is {@code null}.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This settParameters(final T parameters, final Jdbc.BiParametersSetter paramsSetter)
throws IllegalArgumentException, SQLException {
checkArgNotNull(paramsSetter, s.paramsSetter);
boolean noException = false;
try {
paramsSetter.accept((This) this, parameters);
noException = true;
} finally {
if (!noException) {
close();
}
}
return (This) this;
}
/**
* Sets {@code null} value with the specified SQL type to multiple parameter positions in the prepared statement.
*
* @param sqlType The SQL type to set, as defined in {@link java.sql.Types}.
* @param parameterIndices The indices of the parameters to set the SQL type for.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
* @see java.sql.Types
* @deprecated
*/
@Deprecated
@Beta
public This setNullForMultiPositions(final int sqlType, final int... parameterIndices) throws SQLException {
checkParameterIndices(parameterIndices);
for (final int parameterIndex : parameterIndices) {
setNull(parameterIndex, sqlType);
}
return (This) this;
}
/**
* Sets the specified boolean value to multiple parameter positions in the prepared statement.
*
* @param parameterValue The boolean value to set.
* @param parameterIndices The indices of the parameters to set the boolean value for.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This setBooleanForMultiPositions(final Boolean parameterValue, final int... parameterIndices) throws SQLException {
checkParameterIndices(parameterIndices);
for (final int parameterIndex : parameterIndices) {
setBoolean(parameterIndex, parameterValue);
}
return (This) this;
}
/**
* Sets the specified value to multiple parameter positions in the prepared statement.
*
* @param parameterValue The value to set.
* @param parameterIndices The indices of the parameters to set the specified value for.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This setIntForMultiPositions(final Integer parameterValue, final int... parameterIndices) throws SQLException {
checkParameterIndices(parameterIndices);
for (final int parameterIndex : parameterIndices) {
setInt(parameterIndex, parameterValue);
}
return (This) this;
}
// /**
// * Note: The reason for giving name: {@code setIntegerForMultiPositions}, not {@code setIntForMultiPositions} is because of error: The method setIntForMultiPositions(int, int[]) is ambiguous for the type.
// *
// * @param parameterValue
// * @param parameterIndices
// * @return
// * @throws SQLException
// */
// @Beta
// public This setIntegerForMultiPositions(final Integer parameterValue, final int... parameterIndices) throws SQLException {
// checkParameterIndices(parameterIndices);
//
// for (int parameterIndex : parameterIndices) {
// setInt(parameterIndex, parameterValue);
// }
//
// return (This) this;
// }
// ambiguous
// /**
// *
// *
// * @param parameterValue
// * @param parameterIndices
// * @return
// * @throws SQLException
// */
// @Beta
// public This setLongForMultiPositions(final long parameterValue, final int... parameterIndices) throws SQLException {
// checkParameterIndices(parameterIndices);
//
// for (int parameterIndex : parameterIndices) {
// setLong(parameterIndex, parameterValue);
// }
//
// return (This) this;
// }
/**
* Sets the specified value to multiple parameter positions in the prepared statement.
*
* @param parameterValue The value to set.
* @param parameterIndices The indices of the parameters to set the specified value for.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This setLongForMultiPositions(final Long parameterValue, final int... parameterIndices) throws SQLException {
checkParameterIndices(parameterIndices);
for (final int parameterIndex : parameterIndices) {
setLong(parameterIndex, parameterValue);
}
return (This) this;
}
// /**
// *
// *
// * @param parameterValue
// * @param parameterIndices
// * @return
// * @throws SQLException
// */
// @Beta
// public This setDoubleForMultiPositions(final double parameterValue, final int... parameterIndices) throws SQLException {
// checkParameterIndices(parameterIndices);
//
// for (int parameterIndex : parameterIndices) {
// setDouble(parameterIndex, parameterValue);
// }
//
// return (This) this;
// }
/**
* Sets the specified value to multiple parameter positions in the prepared statement.
*
* @param parameterValue The value to set.
* @param parameterIndices The indices of the parameters to set the specified value for.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This setDoubleForMultiPositions(final Double parameterValue, final int... parameterIndices) throws SQLException {
checkParameterIndices(parameterIndices);
for (final int parameterIndex : parameterIndices) {
setDouble(parameterIndex, parameterValue);
}
return (This) this;
}
/**
* Sets the specified value to multiple parameter positions in the prepared statement.
*
* @param parameterValue The value to set.
* @param parameterIndices The indices of the parameters to set the specified value for.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This setStringForMultiPositions(final String parameterValue, final int... parameterIndices) throws SQLException {
checkParameterIndices(parameterIndices);
for (final int parameterIndex : parameterIndices) {
setString(parameterIndex, parameterValue);
}
return (This) this;
}
/**
* Sets the specified value to multiple parameter positions in the prepared statement.
*
* @param parameterValue The value to set.
* @param parameterIndices The indices of the parameters to set the specified value for.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This setDateForMultiPositions(final java.sql.Date parameterValue, final int... parameterIndices) throws SQLException {
checkParameterIndices(parameterIndices);
for (final int parameterIndex : parameterIndices) {
setDate(parameterIndex, parameterValue);
}
return (This) this;
}
/**
* Sets the specified value to multiple parameter positions in the prepared statement.
*
* @param parameterValue The value to set.
* @param parameterIndices The indices of the parameters to set the specified value for.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This setDateForMultiPositions(final java.util.Date parameterValue, final int... parameterIndices) throws SQLException {
checkParameterIndices(parameterIndices);
for (final int parameterIndex : parameterIndices) {
setDate(parameterIndex, parameterValue);
}
return (This) this;
}
/**
* Sets the specified value to multiple parameter positions in the prepared statement.
*
* @param parameterValue The value to set.
* @param parameterIndices The indices of the parameters to set the specified value for.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This setTimeForMultiPositions(final java.sql.Time parameterValue, final int... parameterIndices) throws SQLException {
checkParameterIndices(parameterIndices);
for (final int parameterIndex : parameterIndices) {
setTime(parameterIndex, parameterValue);
}
return (This) this;
}
/**
* Sets the specified value to multiple parameter positions in the prepared statement.
*
* @param parameterValue The value to set.
* @param parameterIndices The indices of the parameters to set the specified value for.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This setTimeForMultiPositions(final java.util.Date parameterValue, final int... parameterIndices) throws SQLException {
checkParameterIndices(parameterIndices);
for (final int parameterIndex : parameterIndices) {
setTime(parameterIndex, parameterValue);
}
return (This) this;
}
/**
* Sets the specified value to multiple parameter positions in the prepared statement.
*
* @param parameterValue The value to set.
* @param parameterIndices The indices of the parameters to set the specified value for.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This setTimestampForMultiPositions(final java.sql.Timestamp parameterValue, final int... parameterIndices) throws SQLException {
checkParameterIndices(parameterIndices);
for (final int parameterIndex : parameterIndices) {
setTimestamp(parameterIndex, parameterValue);
}
return (This) this;
}
/**
* Sets the specified value to multiple parameter positions in the prepared statement.
*
* @param parameterValue The value to set.
* @param parameterIndices The indices of the parameters to set the specified value for.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This setTimestampForMultiPositions(final java.util.Date parameterValue, final int... parameterIndices) throws SQLException {
checkParameterIndices(parameterIndices);
for (final int parameterIndex : parameterIndices) {
setTimestamp(parameterIndex, parameterValue);
}
return (This) this;
}
/**
* Sets the specified value to multiple parameter positions in the prepared statement.
*
* @param parameterValue The value to set.
* @param parameterIndices The indices of the parameters to set the specified value for.
* @return The current instance of the query.
* @throws SQLException If a database access error occurs.
*/
@Beta
public This setObjectForMultiPositions(final Object parameterValue, final int... parameterIndices) throws SQLException {
checkParameterIndices(parameterIndices);
for (final int parameterIndex : parameterIndices) {
setObject(parameterIndex, parameterValue);
}
return (This) this;
}
private void checkParameterIndices(final int... parameterIndices) {
checkArg(N.notEmpty(parameterIndices), "'parameterIndices' can't be null or empty");
for (final int parameterIndex : parameterIndices) {
if (parameterIndex <= 0) {
checkArg(parameterIndex > 0, "'parameterIndices' must all be positive. It can't be: " + N.toString(parameterIndices));
}
}
}
// /**
// * @param
// * @param batchParameters
// * @param parametersSetter
// * @return
// * @throws SQLException
// */
// Q setBatchParameters(final Collection batchParameters, BiParametersSetter parametersSetter) throws SQLException {
// return setBatchParameters(batchParameters.iterator(), parametersSetter);
// }
//
// /**
// *
// * @param
// * @param batchParameters
// * @param parametersSetter
// * @return
// * @throws SQLException
// */
// Q setBatchParameters(final Iterator batchParameters, BiParametersSetter parametersSetter) throws SQLException {
// checkArgNotNull(batchParameters, "batchParameters");
// checkArgNotNull(parametersSetter, "parametersSetter");
//
// boolean noException = false;
//
// try {
// if (isBatch) {
// stmt.clearBatch();
// }
//
// final Iterator iter = batchParameters;
//
// while (iter.hasNext()) {
// parametersSetter.accept((Q) this, iter.next());
// addBatch();
// isBatch = true;
// }
//
// noException = true;
// } finally {
// if (noException == false) {
// close();
// }
// }
//
// return (Q) this;
// }
/**
* Adds a batch of parameters to the statement for batch execution.
*
* @param batchParameters a collection of batch parameters to be added
* @return this instance for method chaining
* @throws IllegalArgumentException if the batch parameters are null
* @throws SQLException if a database access error occurs
*/
@Beta
public This addBatchParameters(final Collection batchParameters) throws IllegalArgumentException, SQLException {
checkArgNotNull(batchParameters, s.batchParameters);
if (N.isEmpty(batchParameters)) {
return (This) this;
}
return addBatchParameters(batchParameters.iterator());
}
/**
* Adds a batch of parameters to the statement for batch execution.
*
* @param the type of the batch parameters
* @param batchParameters a collection of batch parameters to be added
* @param type the class type of the batch parameters
* @return this instance for method chaining
* @throws IllegalArgumentException if the batch parameters or type is null
* @throws SQLException if a database access error occurs
*/
@Beta
public This addBatchParameters(final Collection batchParameters, final Class type) throws IllegalArgumentException, SQLException {
checkArgNotNull(batchParameters, s.batchParameters);
checkArgNotNull(type, s.type);
if (N.isEmpty(batchParameters)) {
return (This) this;
}
return addBatchParameters(batchParameters.iterator(), type);
}
/**
* Adds a batch of parameters to the statement for batch execution.
*
* @param batchParameters an iterator over the batch parameters to be added
* @return this instance for method chaining
* @throws IllegalArgumentException if the batch parameters are null
* @throws SQLException if a database access error occurs
*/
@Beta
@SuppressWarnings("rawtypes")
public This addBatchParameters(final Iterator batchParameters) throws IllegalArgumentException, SQLException {
checkArgNotNull(batchParameters, s.batchParameters);
final Iterator iter = batchParameters;
boolean noException = false;
try {
if (!iter.hasNext()) {
return (This) this;
}
final Object first = iter.next();
if (first instanceof Collection) {
setParameters((Collection) first);
addBatch();
while (iter.hasNext()) {
setParameters((Collection) iter.next());
addBatch();
}
} else if (first instanceof Object[]) {
setParameters((Object[]) first);
addBatch();
while (iter.hasNext()) {
setParameters((Object[]) iter.next());
addBatch();
}
} else {
stmt.setObject(1, first);
addBatch();
while (iter.hasNext()) {
stmt.setObject(1, iter.next());
addBatch();
}
}
noException = true;
} finally {
if (!noException) {
close();
}
}
return (This) this;
}
/**
* Adds a batch of parameters to the statement for batch execution.
*
* @param the type of the batch parameters
* @param batchParameters an iterator over the batch parameters to be added
* @param type the class type of the batch parameters
* @return this instance for method chaining
* @throws IllegalArgumentException if the batch parameters or type is null
* @throws SQLException if a database access error occurs
*/
@Beta
public This addBatchParameters(final Iterator batchParameters, final Class type) throws IllegalArgumentException, SQLException {
checkArgNotNull(batchParameters, s.batchParameters);
checkArgNotNull(type, s.type);
final Iterator iter = batchParameters;
final Type setter = N.typeOf(type);
boolean noException = false;
try {
if (!iter.hasNext()) {
return (This) this;
}
while (iter.hasNext()) {
setter.set(stmt, 1, iter.next());
addBatch();
}
noException = true;
} finally {
if (!noException) {
close();
}
}
return (This) this;
}
// /**
// *
// * @param batchParameters
// * @return
// * @throws SQLException
// */
// public Q addSingleBatchParameters(final Collection batchParameters) throws SQLException {
// checkArgNotNull(batchParameters, "batchParameters");
//
// if (N.isEmpty(batchParameters)) {
// return (Q) this;
// }
//
// boolean noException = false;
//
// try {
// for (Object obj : batchParameters) {
// setObject(1, obj);
//
// addBatch();
// }
//
// isBatch = batchParameters.size() > 0;
//
// noException = true;
// } finally {
// if (noException == false) {
// close();
// }
// }
//
// return (Q) this;
// }
//
// /**
// *
// * @param batchParameters
// * @return
// * @throws SQLException
// */
// public Q addSingleBatchParameters(final Iterator batchParameters) throws SQLException {
// checkArgNotNull(batchParameters, "batchParameters");
//
// return addSingleBatchParameters(Iterators.toList(batchParameters));
// }
/**
* Adds a batch of parameters to the statement for batch execution.
*
* @param the type of the batch parameters
* @param batchParameters a collection of batch parameters to be added
* @param parametersSetter a function to set the parameters on the statement
* @return this instance for method chaining
* @throws IllegalArgumentException if the batch parameters or parameters setter is null
* @throws SQLException if a database access error occurs
*/
@Beta
public This addBatchParameters(final Collection batchParameters, final Jdbc.BiParametersSetter parametersSetter)
throws SQLException {
checkArgNotNull(batchParameters, s.batchParameters);
checkArgNotNull(parametersSetter, s.parametersSetter);
return addBatchParameters(batchParameters.iterator(), parametersSetter);
}
/**
* Adds a batch of parameters to the statement for batch execution.
*
* @param the type of the batch parameters
* @param batchParameters an iterator over the batch parameters to be added
* @param parametersSetter a function to set the parameters on the statement
* @return this instance for method chaining
* @throws IllegalArgumentException if the batch parameters or parameters setter is null
* @throws SQLException if a database access error occurs
*/
@Beta
public This addBatchParameters(final Iterator batchParameters, final Jdbc.BiParametersSetter parametersSetter)
throws SQLException {
checkArgNotNull(batchParameters, s.batchParameters);
checkArgNotNull(parametersSetter, s.parametersSetter);
final This it = (This) this;
boolean noException = false;
try {
final Iterator iter = batchParameters;
while (iter.hasNext()) {
parametersSetter.accept(it, iter.next());
addBatch();
}
noException = true;
} finally {
if (!noException) {
close();
}
}
return it;
}
// /**
// * @param
// * @param batchParameters
// * @param parametersSetter
// * @return
// * @throws SQLException
// */
// @Beta
// public This addBatchParametters(final Collection batchParameters, BiParametersSetter parametersSetter) throws SQLException {
// checkArgNotNull(batchParameters, "batchParameters");
// checkArgNotNull(parametersSetter, "parametersSetter");
//
// return addBatchParametters(batchParameters.iterator(), parametersSetter);
// }
//
// /**
// *
// * @param
// * @param batchParameters
// * @param parametersSetter
// * @return
// * @throws SQLException
// */
// @Beta
// public This addBatchParametters(final Iterator batchParameters, BiParametersSetter parametersSetter) throws SQLException {
// checkArgNotNull(batchParameters, "batchParameters");
// checkArgNotNull(parametersSetter, "parametersSetter");
//
// boolean noException = false;
//
// try {
// final Iterator iter = batchParameters;
//
// while (iter.hasNext()) {
// parametersSetter.accept(stmt, iter.next());
// addBatch();
// isBatch = true;
// }
//
// noException = true;
// } finally {
// if (noException == false) {
// close();
// }
// }
//
// return (This) this;
// }
/**
* Adds a batch of parameters to the statement for batch execution.
*
* @param the type of the batch parameters
* @param batchParameters a collection of batch parameters to be added
* @return this instance for method chaining
* @throws IllegalArgumentException if the batch parameters are null
* @throws SQLException if a database access error occurs
*/
@Beta
public This addBatchParameters(final Collection batchParameters,
final Throwables.TriConsumer parametersSetter)
throws IllegalArgumentException, SQLException {
checkArgNotNull(batchParameters, s.batchParameters);
checkArgNotNull(parametersSetter, s.parametersSetter);
return addBatchParameters(batchParameters.iterator(), parametersSetter);
}
/**
* Adds a batch of parameters to the statement for batch execution.
*
* @param the type of the batch parameters
* @param batchParameters an iterator over the batch parameters to be added
* @param parametersSetter a function to set the parameters on the statement
* @return this instance for method chaining
* @throws IllegalArgumentException if the batch parameters or parameters setter is null
* @throws SQLException if a database access error occurs
*/
@Beta
public This addBatchParameters(final Iterator batchParameters,
final Throwables.TriConsumer parametersSetter)
throws IllegalArgumentException, SQLException {
checkArgNotNull(batchParameters, s.batchParameters);
checkArgNotNull(parametersSetter, s.parametersSetter);
final This it = (This) this;
boolean noException = false;
try {
final Iterator iter = batchParameters;
while (iter.hasNext()) {
parametersSetter.accept(it, stmt, iter.next());
addBatch();
}
noException = true;
} finally {
if (!noException) {
close();
}
}
return it;
}
// /**
// * @param
// * @param batchParameters
// * @param parametersSetter
// * @return
// * @throws SQLException
// * @deprecated replaced by {@code addBatchParametters}
// */
// @Deprecated
// @Beta
// public Q addBatchParameters2(final Collection batchParameters, BiParametersSetter parametersSetter) throws SQLException {
// return addBatchParametters(batchParameters, parametersSetter);
// }
//
// /**
// *
// * @param
// * @param batchParameters
// * @param parametersSetter
// * @return
// * @throws SQLException
// * @deprecated replaced by {@code addBatchParametters}
// */
// @Deprecated
// @Beta
// public Q addBatchParameters2(final Iterator batchParameters, BiParametersSetter parametersSetter) throws SQLException {
// return addBatchParametters(batchParameters, parametersSetter);
// }
/**
* Adds the current set of parameters to the batch of commands for this statement.
*
* @return this instance for method chaining
* @throws SQLException if a database access error occurs or this method is called on a closed statement
* @see java.sql.Statement#addBatch()
*/
public This addBatch() throws SQLException {
addBatchAction.accept((This) this, stmt);
isBatch = true;
return (This) this;
}
This configAddBatchAction(final Throwables.BiConsumer addBatchAction) {
this.addBatchAction = addBatchAction;
return (This) this;
}
int defaultFetchDirection = -1;
int defaultFetchSize = -1;
int defaultQueryTimeout = -1;
int defaultMaxFieldSize = -1;
/**
* Sets the fetch direction.
*
* @param direction one of {@code ResultSet.FETCH_FORWARD},
* {@code ResultSet.FETCH_REVERSE}, or {@code ResultSet.FETCH_UNKNOWN}
* @return
* @throws SQLException
* @see {@link java.sql.Statement#setFetchDirection(int)}
*/
public This setFetchDirection(final FetchDirection direction) throws SQLException {
defaultFetchDirection = stmt.getFetchDirection();
stmt.setFetchDirection(direction.intValue);
isFetchDirectionSet = true;
return (This) this;
}
/**
*
* @return
* @throws SQLException
* @see {@link #setFetchDirection(FetchDirection)}
*/
public This setFetchDirectionToForward() throws SQLException {
return setFetchDirection(FetchDirection.FORWARD);
}
/**
* Sets the fetch size.
*
* @param fetchSize the number of rows to fetch
* @return
* @throws SQLException
* @see {@link java.sql.Statement#setFetchSize(int)}
*/
public This setFetchSize(final int fetchSize) throws SQLException {
defaultFetchSize = stmt.getFetchSize();
stmt.setFetchSize(fetchSize);
return (This) this;
}
/**
* Sets the max field size.
*
* @param max
* @return
* @throws SQLException
* @see {@link java.sql.Statement#setMaxFieldSize(int)}
*/
public This setMaxFieldSize(final int max) throws SQLException {
defaultMaxFieldSize = stmt.getMaxFieldSize();
stmt.setMaxFieldSize(max);
return (This) this;
}
/**
* Sets the max rows.
*
* @param max
* @return
* @throws SQLException
* @see {@link java.sql.Statement#setMaxRows(int)}
*/
public This setMaxRows(final int max) throws SQLException {
stmt.setMaxRows(max);
return (This) this;
}
/**
* Sets the large max rows.
*
* @param max
* @return
* @throws SQLException
* @see {@link java.sql.Statement#setLargeMaxRows(long)}
*/
public This setLargeMaxRows(final long max) throws SQLException {
stmt.setLargeMaxRows(max);
return (This) this;
}
/**
* Sets the query timeout.
*
* @param seconds
* @return
* @throws SQLException
* @see {@link java.sql.Statement#setQueryTimeout(int)}
*/
public This setQueryTimeout(final int seconds) throws SQLException {
defaultQueryTimeout = stmt.getQueryTimeout();
stmt.setQueryTimeout(seconds);
return (This) this;
}
/**
* Configure this {@code PreparedQuery/Statement} by {@code stmtSetter}.
*
*
*
* @param stmtSetter
* @return
* @throws IllegalArgumentException
* @throws SQLException
*/
@Beta
public This configStmt(final Throwables.BiConsumer stmtSetter)
throws IllegalArgumentException, SQLException {
checkArgNotNull(stmtSetter, s.stmtSetter);
boolean noException = false;
try {
stmtSetter.accept((This) this, stmt);
noException = true;
} finally {
if (!noException) {
close();
}
}
return (This) this;
}
int getFetchSize() throws SQLException {
return stmt.getFetchSize();
}
int getFetchDirection() throws SQLException {
return stmt.getFetchDirection();
}
/**
* Returns an {@code OptionalBoolean} describing the value in the first row/column if it exists, otherwise return an empty {@code OptionalBoolean}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public OptionalBoolean queryForBoolean() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? OptionalBoolean.of(rs.getBoolean(1)) : OptionalBoolean.empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
static final Type charType = TypeFactory.getType(char.class);
/**
* Returns an {@code OptionalChar} describing the value in the first row/column if it exists, otherwise return an empty {@code OptionalChar}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public OptionalChar queryForChar() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
if (rs.next()) {
return OptionalChar.of(charType.get(rs, 1));
} else {
return OptionalChar.empty();
}
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns an {@code OptionalByte} describing the value in the first row/column if it exists, otherwise return an empty {@code OptionalByte}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public OptionalByte queryForByte() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? OptionalByte.of(rs.getByte(1)) : OptionalByte.empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns an {@code OptionalShort} describing the value in the first row/column if it exists, otherwise return an empty {@code OptionalShort}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public OptionalShort queryForShort() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? OptionalShort.of(rs.getShort(1)) : OptionalShort.empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns an {@code OptionalInt} describing the value in the first row/column if it exists, otherwise return an empty {@code OptionalInt}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public OptionalInt queryForInt() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? OptionalInt.of(rs.getInt(1)) : OptionalInt.empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns an {@code OptionalLong} describing the value in the first row/column if it exists, otherwise return an empty {@code OptionalLong}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public OptionalLong queryForLong() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? OptionalLong.of(rs.getLong(1)) : OptionalLong.empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns an {@code OptionalFloat} describing the value in the first row/column if it exists, otherwise return an empty {@code OptionalFloat}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public OptionalFloat queryForFloat() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? OptionalFloat.of(rs.getFloat(1)) : OptionalFloat.empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns an {@code OptionalDouble} describing the value in the first row/column if it exists, otherwise return an empty {@code OptionalDouble}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public OptionalDouble queryForDouble() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? OptionalDouble.of(rs.getDouble(1)) : OptionalDouble.empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public Nullable queryForString() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Nullable.of(rs.getString(1)) : Nullable. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
private static final Type BIG_INTEGER_TYPE = Type.of(BigInteger.class);
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
@Beta
public Nullable queryForBigInteger() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Nullable.of(BIG_INTEGER_TYPE.get(rs, 1)) : Nullable. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
@Beta
public Nullable queryForBigDecimal() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Nullable.of(rs.getBigDecimal(1)) : Nullable. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public Nullable queryForDate() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Nullable.of(rs.getDate(1)) : Nullable. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public Nullable queryForTime() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Nullable.of(rs.getTime(1)) : Nullable. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public Nullable queryForTimestamp() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Nullable.of(rs.getTimestamp(1)) : Nullable. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
*
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public Nullable queryForBytes() throws IllegalStateException, SQLException {
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Nullable.of(rs.getBytes(1)) : Nullable. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
*
* @param the value type
* @param targetType
* @return
* @throws IllegalArgumentException
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public Nullable queryForSingleResult(final Class targetType) throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(targetType, s.targetType);
assertNotClosed();
return queryForSingleResult(Type.of(targetType));
}
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
*
* @param
* @param targetType
* @return
* @throws IllegalArgumentException
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public Nullable queryForSingleResult(final Type targetType) throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(targetType, s.targetType);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Nullable.of(targetType.get(rs, 1)) : Nullable. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns an {@code Optional} describing the value in the first row/column if it exists, otherwise return an empty {@code Optional}.
*
* @param the value type
* @param targetType
* @return
* @throws IllegalArgumentException
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public Optional queryForSingleNonNull(final Class targetType) throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(targetType, s.targetType);
assertNotClosed();
return queryForSingleNonNull(Type.of(targetType));
}
/**
* Returns an {@code Optional} describing the value in the first row/column if it exists, otherwise return an empty {@code Optional}.
*
* @param
* @param targetType
* @return
* @throws IllegalArgumentException
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public Optional queryForSingleNonNull(final Type targetType) throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(targetType, s.targetType);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return rs.next() ? Optional.of(targetType.get(rs, 1)) : Optional. empty();
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
*
* @param the value type
* @param targetType
* @return
* @throws IllegalArgumentException
* @throws IllegalStateException if this is closed
* @throws DuplicatedResultException if more than one record found by the specified {@code id} (or {@code condition}).
* @throws SQLException
*/
public Nullable queryForUniqueResult(final Class targetType)
throws IllegalArgumentException, IllegalStateException, DuplicatedResultException, SQLException {
checkArgNotNull(targetType, s.targetType);
assertNotClosed();
return queryForUniqueResult(Type.of(targetType));
}
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
*
* @param
* @param targetType
* @return
* @throws IllegalArgumentException
* @throws IllegalStateException if this is closed
* @throws DuplicatedResultException if more than one record found by the specified {@code id} (or {@code condition}).
* @throws SQLException
*/
public Nullable queryForUniqueResult(final Type targetType)
throws IllegalArgumentException, IllegalStateException, DuplicatedResultException, SQLException {
checkArgNotNull(targetType, s.targetType);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
final Nullable result = rs.next() ? Nullable.of(targetType.get(rs, 1)) : Nullable. empty();
if (result.isPresent() && rs.next()) {
throw new DuplicatedResultException(
"At least two results found: " + Strings.concat(result.get(), ", ", N.convert(JdbcUtil.getColumnValue(rs, 1), targetType)));
}
return result;
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Returns an {@code Optional} describing the value in the first row/column if it exists, otherwise return an empty {@code Optional}.
*
* @param the value type
* @param targetType
* @return
* @throws IllegalArgumentException
* @throws IllegalStateException if this is closed
* @throws DuplicatedResultException if more than one record found by the specified {@code id} (or {@code condition}).
* @throws SQLException
*/
public Optional queryForUniqueNonNull(final Class targetType)
throws IllegalArgumentException, IllegalStateException, DuplicatedResultException, SQLException {
checkArgNotNull(targetType, s.targetType);
assertNotClosed();
return queryForUniqueNonNull(Type.of(targetType));
}
/**
* Returns an {@code Optional} describing the value in the first row/column if it exists, otherwise return an empty {@code Optional}.
*
* @param the value type
* @param targetType
* @return
* @throws IllegalArgumentException
* @throws IllegalStateException if this is closed
* @throws DuplicatedResultException if more than one record found by the specified {@code id} (or {@code condition}).
* @throws SQLException
*/
public Optional queryForUniqueNonNull(final Type targetType)
throws IllegalArgumentException, IllegalStateException, DuplicatedResultException, SQLException {
checkArgNotNull(targetType, s.targetType);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
final Optional result = rs.next() ? Optional.of(targetType.get(rs, 1)) : Optional. empty();
if (result.isPresent() && rs.next()) {
throw new DuplicatedResultException(
"At least two results found: " + Strings.concat(result.get(), ", ", N.convert(JdbcUtil.getColumnValue(rs, 1), targetType)));
}
return result;
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
* @param rs
* @param targetType
* @param
* @return
* @throws SQLException
*/
private static T getRow(final ResultSet rs, final Class targetType) throws SQLException {
final List columnLabels = JdbcUtil.getColumnLabelList(rs);
return Jdbc.BiRowMapper.to(targetType).apply(rs, columnLabels);
}
/**
* Retrieves the first {@code ResultSet}.
*
* @return A {@code DataSet} containing the results of the query.
* @throws SQLException If a database access error occurs.
*/
public DataSet query() throws SQLException {
return query(Jdbc.ResultExtractor.TO_DATA_SET);
}
/**
* Retrieves the first {@code ResultSet} and maps it to a {@code DataSet} using the specified entity class.
*
* @param entityClass The class used to map the fields from the columns in the result set.
* @return A {@code DataSet} containing the results of the query.
* @throws SQLException If a database access error occurs.
* @see Jdbc.ResultExtractor#toDataSet(Class)
*/
public DataSet query(final Class entityClass) throws SQLException {
return query(Jdbc.ResultExtractor.toDataSet(entityClass));
}
/**
* Executes the query and extracts the result using the provided {@code ResultExtractor}.
*
* @param The type of the result.
* @param resultExtractor The extractor used to process the {@code ResultSet} and produce the result. Don't save/return {@code ResultSet}. It will be closed after this call.
* @return The result extracted from the {@code ResultSet}.
* @throws IllegalArgumentException If the provided {@code resultExtractor} is {@code null}.
* @throws IllegalStateException If the query is executed on a closed statement.
* @throws SQLException If a database access error occurs.
*/
public R query(final Jdbc.ResultExtractor resultExtractor) throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(resultExtractor, s.resultExtractor);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return JdbcUtil.checkNotResultSet(resultExtractor.apply(rs));
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Executes the query and extracts the result using the provided {@code BiResultExtractor}.
*
* @param The type of the result.
* @param resultExtractor The extractor used to process the {@code ResultSet} and produce the result. Don't save/return {@code ResultSet}. It will be closed after this call.
* @return The result extracted from the {@code ResultSet}.
* @throws IllegalArgumentException If the provided {@code resultExtractor} is {@code null}.
* @throws IllegalStateException If the query is executed on a closed statement.
* @throws SQLException If a database access error occurs.
*/
public R query(final Jdbc.BiResultExtractor resultExtractor) throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(resultExtractor, s.resultExtractor);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
return JdbcUtil.checkNotResultSet(resultExtractor.apply(rs, JdbcUtil.getColumnLabelList(rs)));
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Retrieves at most two {@code ResultSets}.
*
* @param The type of the result extracted from the first {@code ResultSet}.
* @param The type of the result extracted from the second {@code ResultSet}.
* @param resultExtractor1 The extractor used to process the first {@code ResultSet} and produce the result. Don't save/return {@code ResultSet}. It will be closed after this call.
* @param resultExtractor2 The extractor used to process the second {@code ResultSet} and produce the result. Don't save/return {@code ResultSet}. It will be closed after this call.
* @return A {@code Tuple2} containing the results extracted from the first two {@code ResultSets}.
* @throws IllegalArgumentException If any of the provided {@code resultExtractor} is {@code null}.
* @throws IllegalStateException If the query is executed on a closed statement.
* @throws SQLException If a database access error occurs.
*/
@Beta
public Tuple2 query2Resultsets(final Jdbc.BiResultExtractor resultExtractor1,
final Jdbc.BiResultExtractor resultExtractor2) throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(resultExtractor1, s.resultExtractor1);
checkArgNotNull(resultExtractor2, s.resultExtractor2);
assertNotClosed();
Throwables.Iterator iter = null;
try {
final boolean isResultSet = JdbcUtil.execute(stmt);
iter = JdbcUtil.iterateAllResultSets(stmt, isResultSet);
R1 result1 = null;
R2 result2 = null;
if (iter.hasNext()) {
result1 = JdbcUtil.extractAndCloseResultSet(iter.next(), resultExtractor1);
}
if (iter.hasNext()) {
result2 = JdbcUtil.extractAndCloseResultSet(iter.next(), resultExtractor2);
}
return Tuple.of(result1, result2);
} finally {
try {
if (iter != null) {
iter.close();
}
} finally {
closeAfterExecutionIfAllowed();
}
}
}
/**
* Retrieves at most three {@code ResultSets}.
*
* @param The type of the result extracted from the first {@code ResultSet}.
* @param The type of the result extracted from the second {@code ResultSet}.
* @param The type of the result extracted from the third {@code ResultSet}.
* @param resultExtractor1 The extractor used to process the first {@code ResultSet} and produce the result. Don't save/return {@code ResultSet}. It will be closed after this call.
* @param resultExtractor2 The extractor used to process the second {@code ResultSet} and produce the result. Don't save/return {@code ResultSet}. It will be closed after this call.
* @param resultExtractor3 The extractor used to process the third {@code ResultSet} and produce the result. Don't save/return {@code ResultSet}. It will be closed after this call.
* @return A {@code Tuple3} containing the results extracted from the first three {@code ResultSets}.
* @throws IllegalArgumentException If any of the provided {@code resultExtractor} is {@code null}.
* @throws IllegalStateException If the query is executed on a closed statement.
* @throws SQLException If a database access error occurs.
*/
@Beta
public Tuple3 query3Resultsets(final Jdbc.BiResultExtractor resultExtractor1,
final Jdbc.BiResultExtractor resultExtractor2, final Jdbc.BiResultExtractor resultExtractor3)
throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(resultExtractor1, s.resultExtractor1);
checkArgNotNull(resultExtractor2, s.resultExtractor2);
checkArgNotNull(resultExtractor3, s.resultExtractor3);
assertNotClosed();
Throwables.Iterator iter = null;
try {
final boolean isResultSet = JdbcUtil.execute(stmt);
iter = JdbcUtil.iterateAllResultSets(stmt, isResultSet);
R1 result1 = null;
R2 result2 = null;
R3 result3 = null;
if (iter.hasNext()) {
result1 = JdbcUtil.extractAndCloseResultSet(iter.next(), resultExtractor1);
}
if (iter.hasNext()) {
result2 = JdbcUtil.extractAndCloseResultSet(iter.next(), resultExtractor2);
}
if (iter.hasNext()) {
result3 = JdbcUtil.extractAndCloseResultSet(iter.next(), resultExtractor3);
}
return Tuple.of(result1, result2, result3);
} finally {
try {
if (iter != null) {
iter.close();
}
} finally {
closeAfterExecutionIfAllowed();
}
}
}
/**
* Retrieves all the {@code ResultSets}.
*
* @return a list of {@code DataSet} extracted from all {@code ResultSets} returned by the executed procedure and a list of {@code Out Parameters}.
* @throws SQLException If a database access error occurs.
*/
public List queryAllResultsets() throws SQLException {
return queryAllResultsets(ResultExtractor.TO_DATA_SET);
}
/**
* Retrieves all the {@code ResultSets}.
*
* @param The type of the result extracted from each {@code ResultSet}.
* @param resultExtractor The extractor used to process each {@code ResultSet} and produce the result. Don't save/return {@code ResultSet}. It will be closed after this call.
* @return A list of {@code R} extracted from all {@code ResultSets} returned by the executed procedure and a list of {@code Out Parameters}.
* @throws IllegalArgumentException If the provided {@code resultExtractor} is {@code null}.
* @throws IllegalStateException If the query is executed on a closed statement.
* @throws SQLException If a database access error occurs.
*/
public List queryAllResultsets(final Jdbc.ResultExtractor resultExtractor)
throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(resultExtractor, s.resultExtractor);
assertNotClosed();
Throwables.Iterator iter = null;
try {
final boolean isResultSet = JdbcUtil.execute(stmt);
iter = JdbcUtil.iterateAllResultSets(stmt, isResultSet);
final List result = new ArrayList<>();
while (iter.hasNext()) {
result.add(JdbcUtil.extractAndCloseResultSet(iter.next(), resultExtractor));
}
return result;
} finally {
try {
if (iter != null) {
iter.close();
}
} finally {
closeAfterExecutionIfAllowed();
}
}
}
/**
* Retrieves all the {@code BiResultExtractor}.
*
* @param The type of the result extracted from each {@code ResultSet}.
* @param resultExtractor The extractor used to process each {@code ResultSet} and produce the result. Don't save/return {@code ResultSet}. It will be closed after this call.
* @return A list of {@code R} extracted from all {@code ResultSets} returned by the executed procedure and a list of {@code Out Parameters}.
* @throws IllegalArgumentException If the provided {@code resultExtractor} is {@code null}.
* @throws IllegalStateException If the query is executed on a closed statement.
* @throws SQLException If a database access error occurs.
*/
public List queryAllResultsets(final Jdbc.BiResultExtractor resultExtractor)
throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(resultExtractor, s.resultExtractor);
assertNotClosed();
Throwables.Iterator iter = null;
try {
final boolean isResultSet = JdbcUtil.execute(stmt);
iter = JdbcUtil.iterateAllResultSets(stmt, isResultSet);
final List result = new ArrayList<>();
while (iter.hasNext()) {
result.add(JdbcUtil.extractAndCloseResultSet(iter.next(), resultExtractor));
}
return result;
} finally {
try {
if (iter != null) {
iter.close();
}
} finally {
closeAfterExecutionIfAllowed();
}
}
}
/**
* Executes a query and applies a function to the resulting {@code DataSet}.
*
* @param The type of the result produced by the function.
* @param The type of exception that the function might throw.
* @param func The function to apply to the {@code DataSet} resulting from the query.
* @return The result produced by applying the function to the {@code DataSet}.
* @throws SQLException If a database access error occurs.
* @throws E If the function throws an exception.
*/
@Beta
public R queryThenApply(final Throwables.Function func) throws SQLException, E {
return func.apply(query());
}
/**
* Executes a query and applies a function to the resulting {@code DataSet}, using the specified entity class to fetch fields from columns.
*
* @param The type of the result produced by the function.
* @param The type of exception that the function might throw.
* @param entityClass The class used to fetch fields from columns.
* @param func The function to apply to the {@code DataSet} resulting from the query.
* @return The result produced by applying the function to the {@code DataSet}.
* @throws SQLException If a database access error occurs.
* @throws E If the function throws an exception.
* @see Jdbc.ResultExtractor#toDataSet(Class)
*/
@Beta
public R queryThenApply(final Class entityClass, final Throwables.Function func)
throws SQLException, E {
return func.apply(query(entityClass));
}
/**
* Executes a query and applies a consumer action to the resulting {@code DataSet}.
*
* @param The type of exception that the consumer action might throw.
* @param action The consumer action to apply to the {@code DataSet} resulting from the query.
* @throws SQLException If a database access error occurs.
* @throws E If the consumer action throws an exception.
*/
@Beta
public void queryThenAccept(final Throwables.Consumer action) throws SQLException, E {
action.accept(query());
}
/**
* Executes a query and applies a consumer action to the resulting {@code DataSet}, using the specified entity class to fetch fields from columns.
*
* @param The type of exception that the consumer action might throw.
* @param entityClass The class used to fetch fields from columns.
* @param action The consumer action to apply to the {@code DataSet} resulting from the query.
* @throws SQLException If a database access error occurs.
* @throws E If the consumer action throws an exception.
* @see Jdbc.ResultExtractor#toDataSet(Class)
*/
@Beta
public void queryThenAccept(final Class entityClass, final Throwables.Consumer action) throws SQLException, E {
action.accept(query(entityClass));
}
// /**
// *
// * @param
// * @param targetType
// * @return
// * @throws DuplicatedResultException If More than one record found by the query
// * @throws SQLException
// * @deprecated replaced by {@code findOnlyOne}.
// */
// @Deprecated
// public Optional get(final Class targetType) throws DuplicatedResultException, SQLException {
// return Optional.ofNullable(gett(targetType));
// }
//
// /**
// *
// * @param
// * @param rowMapper
// * @return
// * @throws DuplicatedResultException If More than one record found by the query
// * @throws SQLException
// * @throws IllegalArgumentException if {@code rowMapper} returns {@code null} for the found record.
// * @deprecated replaced by {@code findOnlyOne}.
// */
// @Deprecated
// public Optional get(Jdbc.RowMapper rowMapper) throws DuplicatedResultException, SQLException, IllegalArgumentException {
// return Optional.ofNullable(gett(rowMapper));
// }
//
// /**
// *
// * @param
// * @param rowMapper
// * @return
// * @throws DuplicatedResultException If More than one record found by the query
// * @throws SQLException
// * @throws IllegalArgumentException if {@code rowMapper} returns {@code null} for the found record.
// * @deprecated replaced by {@code findOnlyOne}.
// */
// @Deprecated
// public Optional get(Jdbc.BiRowMapper rowMapper) throws DuplicatedResultException, SQLException, IllegalArgumentException {
// return Optional.ofNullable(gett(rowMapper));
// }
//
// /**
// *
// * @param
// * @param targetType
// * @return
// * @throws DuplicatedResultException If More than one record found by the query
// * @throws SQLException
// * @deprecated replaced by {@code findOnlyOneOrNull}.
// */
// @Deprecated
// public T gett(final Class targetType) throws DuplicatedResultException, SQLException {
// return findOnlyOneOrNull(targetType);
// }
//
// /**
// *
// * @param
// * @param rowMapper
// * @return
// * @throws DuplicatedResultException If More than one record found by the query
// * @throws SQLException
// * @throws IllegalArgumentException if {@code rowMapper} returns {@code null} for the found record.
// * @deprecated replaced by {@code findOnlyOneOrNull}.
// */
// @Deprecated
// public T gett(Jdbc.RowMapper rowMapper) throws DuplicatedResultException, SQLException, IllegalArgumentException {
// return findOnlyOneOrNull(rowMapper);
// }
//
// /**
// *
// * @param
// * @param rowMapper
// * @return
// * @throws DuplicatedResultException If More than one record found by the query
// * @throws SQLException
// * @throws IllegalArgumentException if {@code rowMapper} returns {@code null} for the found record.
// * @deprecated replaced by {@code findOnlyOneOrNull}.
// */
// @Deprecated
// public T gett(Jdbc.BiRowMapper rowMapper) throws DuplicatedResultException, SQLException, IllegalArgumentException {
// return findOnlyOneOrNull(rowMapper);
// }
/**
* Executes a query and returns an {@code Optional} containing a map of column names to values if exactly one record is found.
*
* @return An {@code Optional} containing a map of column names to values if exactly one record is found, otherwise an empty {@code Optional}.
* @throws DuplicatedResultException If more than one record is found by the query.
* @throws SQLException If a database access error occurs.
*/
public Optional> findOnlyOne() throws DuplicatedResultException, SQLException {
return findOnlyOne(Jdbc.BiRowMapper.TO_MAP);
}
/**
* Executes a query and returns an {@code Optional} containing a single result of the specified type if exactly one record is found.
*
* @param The type of the result object.
* @param targetType The class of the result object.
* @return An {@code Optional} containing the result object if exactly one record is found, otherwise an empty {@code Optional}.
* @throws DuplicatedResultException If more than one record is found by the query.
* @throws SQLException If a database access error occurs.
*/
public Optional findOnlyOne(final Class targetType) throws DuplicatedResultException, SQLException {
return Optional.ofNullable(findOnlyOneOrNull(targetType));
}
/**
* Executes a query and returns an {@code Optional} containing a single result extracted by the specified {@code RowMapper} if exactly one record is found.
*
* @param The type of the result object.
* @param rowMapper The {@code RowMapper} used to map the result set to the result object.
* @return An {@code Optional} containing the result object if exactly one record is found, otherwise an empty {@code Optional}.
* @throws IllegalArgumentException If the {@code rowMapper} returns {@code null} for the found record.
* @throws DuplicatedResultException If more than one record is found by the query.
* @throws SQLException If a database access error occurs.
*/
public Optional findOnlyOne(final Jdbc.RowMapper rowMapper) throws DuplicatedResultException, SQLException, IllegalArgumentException {
return Optional.ofNullable(findOnlyOneOrNull(rowMapper));
}
/**
* Executes a query and returns an {@code Optional} containing a single result extracted by the specified {@code BiRowMapper} if exactly one record is found.
*
* @param The type of the result object.
* @param rowMapper The {@code BiRowMapper} used to map the result set to the result object.
* @return An {@code Optional} containing the result object if exactly one record is found, otherwise an empty {@code Optional}.
* @throws IllegalArgumentException If the {@code rowMapper} returns {@code null} for the found record.
* @throws DuplicatedResultException If more than one record is found by the query.
* @throws SQLException If a database access error occurs.
*/
public Optional findOnlyOne(final Jdbc.BiRowMapper rowMapper) throws DuplicatedResultException, SQLException, IllegalArgumentException {
return Optional.ofNullable(findOnlyOneOrNull(rowMapper));
}
/**
* Executes a query and returns a single result as a {@code Map} if exactly one record is found.
*
* @return A {@code Map} containing the result if exactly one record is found, otherwise {@code null}.
* @throws DuplicatedResultException If more than one record is found by the query.
* @throws SQLException If a database access error occurs.
*/
public Map findOnlyOneOrNull() throws DuplicatedResultException, SQLException {
return findOnlyOneOrNull(Jdbc.BiRowMapper.TO_MAP);
}
/**
* Executes a query and returns a single result of the specified type if exactly one record is found.
*
* @param The type of the result object.
* @param targetType The class of the result type.
* @return The result object if exactly one record is found, otherwise {@code null}.
* @throws IllegalArgumentException If the target type is invalid.
* @throws IllegalStateException If this query is closed.
* @throws DuplicatedResultException If more than one record is found by the query.
* @throws SQLException If a database access error occurs.
*/
public T findOnlyOneOrNull(final Class targetType)
throws IllegalArgumentException, IllegalStateException, DuplicatedResultException, SQLException {
checkArgNotNull(targetType, s.targetType);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
if (rs.next()) {
final T result = Objects.requireNonNull(getRow(rs, targetType));
if (rs.next()) {
throw new DuplicatedResultException("More than one record found by the query");
}
return result;
} else {
return null;
}
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Executes a query and returns a single result extracted by the specified {@code RowMapper} if exactly one record is found.
*
* @param The type of the result object.
* @param rowMapper The {@code RowMapper} used to map the result set to the result object.
* @return The result object if exactly one record is found, otherwise {@code null}.
* @throws IllegalArgumentException If the {@code rowMapper} returns {@code null} for the found record.
* @throws IllegalStateException If this query is closed.
* @throws DuplicatedResultException If more than one record is found by the query.
* @throws SQLException If a database access error occurs.
*/
public T findOnlyOneOrNull(final Jdbc.RowMapper rowMapper)
throws IllegalStateException, DuplicatedResultException, SQLException, IllegalArgumentException {
checkArgNotNull(rowMapper, s.rowMapper);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
if (rs.next()) {
final T result = Objects.requireNonNull(rowMapper.apply(rs));
if (rs.next()) {
throw new DuplicatedResultException("More than one record found by the query");
}
return result;
} else {
return null;
}
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Executes a query and returns a single result extracted by the specified {@code BiRowMapper} if exactly one record is found.
*
* @param The type of the result object.
* @param rowMapper The {@code BiRowMapper} used to map the result set to the result object.
* @return The result object if exactly one record is found, otherwise {@code null}.
* @throws IllegalArgumentException If the {@code rowMapper} returns {@code null} for the found record.
* @throws IllegalStateException If this query is closed.
* @throws DuplicatedResultException If more than one record is found by the query.
* @throws SQLException If a database access error occurs.
*/
public T findOnlyOneOrNull(final Jdbc.BiRowMapper rowMapper)
throws IllegalStateException, DuplicatedResultException, SQLException, IllegalArgumentException {
checkArgNotNull(rowMapper, s.rowMapper);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
if (rs.next()) {
final T result = Objects.requireNonNull(rowMapper.apply(rs, JdbcUtil.getColumnLabelList(rs)));
if (rs.next()) {
throw new DuplicatedResultException("More than one record found by the query");
}
return result;
} else {
return null;
}
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Executes a query and returns the first result as an {@code Optional} containing a {@code Map}.
*
* @return An {@code Optional} containing the first result as a {@code Map}, or an empty {@code Optional} if no result is found.
* @throws SQLException If a database access error occurs.
*/
public Optional> findFirst() throws SQLException {
return findFirst(Jdbc.BiRowMapper.TO_MAP);
}
/**
* Executes a query and returns the first result as an {@code Optional} containing an object of the specified type.
*
* @param The type of the result object.
* @param targetType The class of the result object.
* @return An {@code Optional} containing the first result as an object of the specified type, or an empty {@code Optional} if no result is found.
* @throws SQLException If a database access error occurs.
*/
public Optional findFirst(final Class targetType) throws SQLException {
return Optional.ofNullable(findFirstOrNull(targetType));
}
/**
* Executes a query and returns the first result as an {@code Optional} containing an object extracted by the specified {@code RowMapper}.
*
* @param The type of the result object.
* @param rowMapper The {@code RowMapper} used to map the result set to an object.
* @return An {@code Optional} containing the first result as an object mapped by the specified {@code RowMapper}, or an empty {@code Optional} if no result is found.
* @throws IllegalArgumentException If {@code rowMapper} is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public Optional findFirst(final Jdbc.RowMapper rowMapper) throws IllegalArgumentException, SQLException {
return Optional.ofNullable(findFirstOrNull(rowMapper));
}
/**
* Executes a query with the specified {@code RowFilter} and {@code RowMapper}, and returns the first result as an {@code Optional}.
*
* @param The type of the result object.
* @param rowFilter The {@code RowFilter} used to filter the rows in the result set.
* @param rowMapper The {@code RowMapper} used to map the result set to an object.
* @return An {@code Optional} containing the first result as an object mapped by the specified {@code RowMapper}, or an empty {@code Optional} if no result is found.
* @throws SQLException If a database access error occurs.
* @throws IllegalArgumentException If {@code rowMapper} is {@code null}.
* @deprecated Use {@code stream(RowFilter, RowMapper).first()} instead.
*/
@Deprecated
public Optional findFirst(final Jdbc.RowFilter rowFilter, final Jdbc.RowMapper rowMapper)
throws IllegalArgumentException, SQLException {
return Optional.ofNullable(findFirstOrNull(rowFilter, rowMapper));
}
/**
* Executes a query and returns the first result as an {@code Optional} containing an object extracted by the specified {@code BiRowMapper}.
*
* @param The type of the result object.
* @param rowMapper The {@code BiRowMapper} used to map the result set to an object.
* @return An {@code Optional} containing the first result as an object mapped by the specified {@code BiRowMapper}, or an empty {@code Optional} if no result is found.
* @throws IllegalArgumentException If {@code rowMapper} is {@code null}.
* @throws SQLException If a database access error occurs.
*/
public Optional findFirst(final Jdbc.BiRowMapper rowMapper) throws IllegalArgumentException, SQLException {
return Optional.ofNullable(findFirstOrNull(rowMapper));
}
/**
* Executes a query with the specified {@code BiRowFilter} and {@code BiRowMapper}, and returns the first result as an {@code Optional}.
*
* @param The type of the result object.
* @param rowFilter The {@code BiRowFilter} used to filter the rows in the result set.
* @param rowMapper The {@code BiRowMapper} used to map the result set to an object.
* @return An {@code Optional} containing the first result as an object mapped by the specified {@code BiRowMapper}, or an empty {@code Optional} if no result is found.
* @throws IllegalArgumentException If {@code rowMapper} is {@code null}.
* @throws SQLException If a database access error occurs.
* @deprecated Use {@code stream(BiRowFilter, BiRowMapper).first()} instead.
*/
@Deprecated
public Optional findFirst(final Jdbc.BiRowFilter rowFilter, final Jdbc.BiRowMapper rowMapper)
throws IllegalArgumentException, SQLException {
return Optional.ofNullable(findFirstOrNull(rowFilter, rowMapper));
}
/**
* Executes a query and returns the first result as a {@code Map}.
*
* @return A {@code Map} containing the first result, or {@code null} if no result is found.
* @throws SQLException If a database access error occurs.
*/
public Map findFirstOrNull() throws SQLException {
return findFirstOrNull(Jdbc.BiRowMapper.TO_MAP);
}
/**
*
*
* @param
* @param targetType
* @return
* @throws IllegalArgumentException
* @throws IllegalStateException if this is closed
* @throws SQLException
*/
public T findFirstOrNull(final Class targetType) throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(targetType, s.targetType);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
if (rs.next()) {
return Objects.requireNonNull(getRow(rs, targetType));
}
return null;
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
*
* @param
* @param rowMapper
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
* @throws IllegalArgumentException if {@code rowMapper} returns {@code null} for the found record.
*/
public T findFirstOrNull(final Jdbc.RowMapper rowMapper) throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(rowMapper, s.rowMapper);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
if (rs.next()) {
return Objects.requireNonNull(rowMapper.apply(rs));
}
return null;
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
*
* @param
* @param rowFilter
* @param rowMapper
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
* @throws IllegalArgumentException if {@code rowMapper} returns {@code null} for the found record.
* @deprecated Use {@code stream(RowFilter, RowMapper).first()} instead.
*/
@Deprecated
public T findFirstOrNull(final Jdbc.RowFilter rowFilter, final Jdbc.RowMapper rowMapper)
throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(rowFilter, s.rowFilter);
checkArgNotNull(rowMapper, s.rowMapper);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
while (rs.next()) {
if (rowFilter.test(rs)) {
return Objects.requireNonNull(rowMapper.apply(rs));
}
}
return null;
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
*
* @param
* @param rowMapper
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
* @throws IllegalArgumentException if {@code rowMapper} returns {@code null} for the found record.
*/
public T findFirstOrNull(final Jdbc.BiRowMapper rowMapper) throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(rowMapper, s.rowMapper);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
if (rs.next()) {
return Objects.requireNonNull(rowMapper.apply(rs, JdbcUtil.getColumnLabelList(rs)));
} else {
return null;
}
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
*
*
* @param
* @param rowFilter
* @param rowMapper
* @return
* @throws IllegalStateException if this is closed
* @throws SQLException
* @throws IllegalArgumentException if {@code rowMapper} returns {@code null} for the found record.
* @deprecated Use {@code stream(BiRowFilter, BiRowMapper).first()} instead.
*/
@Deprecated
public T findFirstOrNull(final Jdbc.BiRowFilter rowFilter, final Jdbc.BiRowMapper rowMapper)
throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(rowFilter, s.rowFilter);
checkArgNotNull(rowMapper, s.rowMapper);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
final List columnLabels = JdbcUtil.getColumnLabelList(rs);
while (rs.next()) {
if (rowFilter.test(rs, columnLabels)) {
return Objects.requireNonNull(rowMapper.apply(rs, columnLabels));
}
}
return null;
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Lists the rows in the first {@code ResultSet}.
*
* @return A list of maps, where each map represents a row with column labels as keys and column values as values.
* @throws SQLException If a database access error occurs.
*/
public List> list() throws SQLException {
return list(Jdbc.BiRowMapper.TO_MAP);
}
/**
* Lists the rows in the first {@code ResultSet} and maps them to the specified target type.
*
* @param The type of the result object.
* @param targetType The class of the type to map the rows to.
* @return A list of objects of the specified type, where each object represents a row in the result set.
* @throws SQLException If a database access error occurs.
*/
public List list(final Class targetType) throws SQLException {
return list(Jdbc.BiRowMapper.to(targetType));
}
/**
* Lists the rows in the first {@code ResultSet}.
*
* @param
* @param targetType
* @param maxResult
* @return
* @throws SQLException
* @deprecated the result size should be limited in database server side by sql scripts.
*/
@Deprecated
public List list(final Class targetType, final int maxResult) throws SQLException {
return list(Jdbc.BiRowMapper.to(targetType), maxResult);
}
/**
* Lists the rows in the first {@code ResultSet} using the provided row mapper.
*
* @param The type of the result object.
* @param rowMapper The row mapper to map each row of the {@code ResultSet} to an object.
* @return A list of objects of the specified type, where each object represents a row in the result set.
* @throws SQLException If a database access error occurs.
*/
public List list(final Jdbc.RowMapper rowMapper) throws SQLException {
return list(rowMapper, Integer.MAX_VALUE);
}
/**
* Lists the rows in the first {@code ResultSet}.
*
* @param
* @param rowMapper
* @param maxResult
* @return
* @throws SQLException
* @deprecated the result size should be limited in database server side by sql scripts.
*/
@Deprecated
public List list(final Jdbc.RowMapper rowMapper, final int maxResult) throws SQLException {
return list(Jdbc.RowFilter.ALWAYS_TRUE, rowMapper, maxResult);
}
/**
* Lists the rows in the first {@code ResultSet} that match the specified row filter and maps them using the provided row mapper.
*
* @param The type of the result object.
* @param rowFilter The filter to apply to each row of the {@code ResultSet}.
* @param rowMapper The row mapper to map each row of the {@code ResultSet} to an object.
* @return A list of objects of the specified type, where each object represents a row in the result set.
* @throws SQLException If a database access error occurs.
*/
public List list(final Jdbc.RowFilter rowFilter, final Jdbc.RowMapper rowMapper) throws SQLException {
return list(rowFilter, rowMapper, Integer.MAX_VALUE);
}
/**
* Lists the rows in the first {@code ResultSet} that match the specified row filter and maps them using the provided row mapper.
*
* @param The type of the result object.
* @param rowFilter The filter to apply to each row of the {@code ResultSet}.
* @param rowMapper The row mapper to map each row of the {@code ResultSet} to an object.
* @param maxResult The maximum number of results to return.
* @return A list of objects of the specified type, where each object represents a row in the result set.
* @throws IllegalArgumentException If the row filter or row mapper is invalid.
* @throws IllegalStateException If this is closed.
* @throws SQLException If a database access error occurs.
*/
public List list(final Jdbc.RowFilter rowFilter, final Jdbc.RowMapper rowMapper, int maxResult)
throws IllegalArgumentException, IllegalStateException, SQLException {
checkArgNotNull(rowFilter, s.rowFilter);
checkArgNotNull(rowMapper, s.rowMapper);
checkArg(maxResult >= 0, "'maxResult' can' be negative: " + maxResult);
assertNotClosed();
try (ResultSet rs = executeQuery()) {
final List result = new ArrayList<>();
while (maxResult > 0 && rs.next()) {
if (rowFilter.test(rs)) {
result.add(rowMapper.apply(rs));
maxResult--;
}
}
return result;
} finally {
closeAfterExecutionIfAllowed();
}
}
/**
* Lists the rows in the first {@code ResultSet} and maps them using the provided row mapper.
*
* @param The type of the result object.
* @param rowMapper The row mapper to map each row of the {@code ResultSet} to an object.
* @return A list of objects of the specified type, where each object represents a row in the result set.
* @throws SQLException If a database access error occurs.
*/
public List list(final Jdbc.BiRowMapper rowMapper) throws SQLException {
return list(rowMapper, Integer.MAX_VALUE);
}
/**
* Lists the rows in the first {@code ResultSet}.
*
* @param
* @param rowMapper
* @param maxResult
* @return
* @throws SQLException
* @deprecated the result size should be limited in database server side by sql scripts.
*/
@Deprecated
public List list(final Jdbc.BiRowMapper rowMapper, final int maxResult) throws SQLException {
return list(Jdbc.BiRowFilter.ALWAYS_TRUE, rowMapper, maxResult);
}
/**
* Lists the rows in the first {@code ResultSet} that match the specified row filter and maps them using the provided row mapper.
*
* @param The type of the result object.
* @param rowFilter The filter to apply to each row of the {@code ResultSet}.
* @param rowMapper The row mapper to map each row of the {@code ResultSet} to an object.
* @return A list of objects of the specified type, where each object represents a row in the result set.
* @throws SQLException If a database access error occurs.
*/
public List list(final Jdbc.BiRowFilter rowFilter, final Jdbc.BiRowMapper rowMapper) throws SQLException {
return list(rowFilter, rowMapper, Integer.MAX_VALUE);
}
/**
* Lists the rows in the first {@code ResultSet} that match the specified row filter and maps them using the provided row mapper.
*
* @param The type of the result object.
* @param rowFilter The filter to apply to each row of the {@code ResultSet}.
* @param rowMapper The row mapper to map each row of the {@code ResultSet} to an object.
* @param maxResult The maximum number of results to return.
* @return A list of objects of the specified type, where each object represents a row in the result set.
* @throws IllegalArgumentException If the row filter or row mapper is invalid.
* @throws IllegalStateException If this is closed.
* @throws SQLException If a database access error occurs.
*/
public List
